<?xml version="1.0" encoding="GB2312" standalone="yes"?>
<Msg Version="4" MsgID="1118732851" Type="TVMonUp" DateTime="2005-06-14 15:07:31" SrcCode="320200N01" DstCode="997777X10" ReplyID="66" >
<Return Type="StreamSimpleQuery" Value="0" Desc="?" >
</Return>
<Stream>
<MediaStream Index="0" url="HTTP://10.40.30.2/playlist/42_0_42AE8233.asx" />
</Stream>
</Msg>
default.aspx.cs代碼:
private void Page_Load(object sender, System.EventArgs e)
{
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//@@ 網站開發:lawdoor
//@@ 頁面設計:lawdoor
//@@ Msn 聯絡:tacit@hotmail.com
//@@ QQ 聯絡:5985880
//@@ 網 站:http://www.cnsdn.com.cn
//@@ 電子郵件:lawdoor@126.com
//@@ 著作權:中軟網[龍脈科技]
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//從系統中取system.xml資訊
XmlDocument United = new XmlDocument();
United.Load("C://WINNT//Config//system.xml");
string Xpath="/Msg/Stream/paths";
//獲得url
XmlNode MStreams =United.SelectSingleNode(Xpath);
string xmlpath=MStreams .Attributes["xmlpath"].InnerText;
DateTime d=DateTime.Now;
string FilePath=""+xmlpath+""+d.ToString("yyyyMMddHHmmss")+".xml";
Request.SaveAs(FilePath,false);
//建立document
XmlDocument Unite = new XmlDocument();
Unite.Load(FilePath);
//定義節點路徑
string Xpath1="/Msg/Stream/MediaStream";
string Xpath2="/Msg";
//獲得url
XmlNode MStream =Unite.SelectSingleNode(Xpath1);
string url=MStream .Attributes["url"].InnerText;
//獲得ReplyID
XmlNode ReplyID =Unite.SelectSingleNode(Xpath2);
string ID=ReplyID .Attributes["ReplyID"].InnerText;
//串連oracle資料庫
string connstring="data source=searches;user id=searches;password=1234";
//執行個體化OracleConnection對象
oracleConnection myConnection = new oracleConnection(connstring);
string sqlStr = "Ins*rt Into down_asx (task_id,asxurl,xmlname,adtime) Values ('"+ID+"','"+url+"','"+FilePath+"','"+d+"')";
oracleCommand myCommand = new oracleCommand(sqlStr, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}