//Get Body public Object GetBody(object url) { MSXML2.XMLHTTP Retrieval = new MSXML2.XMLHTTPClass(); Retrieval.open("Get", url.ToString(), false, null, null); Retrieval.send(); return(Retrieval.responseBody); }
/// <summary> /// 获取远程文件源代码 /// </summary> /// <param name="url">远程url</param> /// <returns></returns> public static string GetRemoteHtmlCode(string Url) { string s = ""; MSXML2.XMLHTTP _xmlhttp = new MSXML2.XMLHTTPClass(); _xmlhttp.open("GET", Url, false, null, null); _xmlhttp.send(""); if (_xmlhttp.readyState == 4) { return(_xmlhttp.responseText); // s = System.Text.Encoding.Default.GetString((byte[])_xmlhttp.responseBody); } return(s); }
private void button3_Click(object sender, EventArgs e) { listBox1.Items.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("<ufinterface sender=\"001\" receiver=\"u8\" roottag=\"storein\" docid=\" \" proc=\"Query \" codeexchanged=\"n \" paginate=\"0\">") .Append("<storein importfile=\"\" exportfile=\"\" code=\"0000000192\" bincrementout=\"n\">") .Append("</storein>") .Append("</ufinterface>"); XmlDocument dom = new XmlDocument(); dom.LoadXml(sb.ToString()); MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST", "http://U8TESTSERVER/U8EAI/import.asp", false, null, null); xmlHttp.send(dom.OuterXml); String responseXml = xmlHttp.responseText; System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 }
/// <summary> /// 查询部门导出数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("<ufinterface sender=\"001\" receiver=\"u8\" roottag=\"department\" docid=\" \" proc=\"Query \" codeexchanged=\"n \">") .Append("<department>") .Append("</department>") .Append("</ufinterface>"); XmlDocument dom = new XmlDocument(); dom.LoadXml(sb.ToString()); MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST", "http://U8TESTSERVER/U8EAI/import.asp", false, null, null); xmlHttp.send(dom.OuterXml); String responseXml = xmlHttp.responseText; MessageBox.Show(responseXml); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 }
private void button1_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("<ufinterface sender=\"001\" receiver=\"u8\" roottag=\"department\" docid=\" \" proc=\"Query\" codeexchanged=\"n \">") .Append("<department importfile=\" \" exportfile=\" \" code=\"011\" bincrementout=\"n \">") .Append("<field display=\"部门编码\" name=\"cDepCode\" operation=\" =\" value=\"1\" logic=\" \" /> ") //查询过滤条件 field节点中的name过滤字段名要与数据库字段名一致 .Append("</department>") .Append("</ufinterface>"); XmlDocument dom = new XmlDocument(); dom.LoadXml(sb.ToString()); MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST", "http://192.168.1.15/U8EAI/import.asp", false, null, null); xmlHttp.send(""); String responseXml = xmlHttp.responseText; string s; moban.parseU8XmlRs(responseXml, out s); MessageBox.Show(s); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 }
private bool DoConnect(string xml, ref string errText) { MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST", EaiAddress, false, null, null);//TODO:地址需要改 xmlHttp.send(xml); String responseXml = xmlHttp.responseText; //…… //处理返回结果 XmlDocument resultDoc = new XmlDocument(); resultDoc.LoadXml(responseXml); var itemNode = resultDoc.SelectSingleNode("ufinterface//item"); var s = ConstCommon.CURRENT_PRODUCTNAME; if (itemNode == null) { errText = "没有收到ERP回执"; PLMEventLog.WriteLog("没有收到ERP回执!", EventLogEntryType.Error); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 return(false); } var succeed = Convert.ToInt32(itemNode.Attributes["succeed"].Value);//成功标识:0:成功;非0:失败; var dsc = itemNode.Attributes["dsc"].Value.ToString(); //var u8key =itemNode.Attributes["u8key"].ToString(); //var proc = itemNode.Attributes["proc"].ToString(); if (succeed != 0) { //errText = responseXml; errText = string.Format("ERP导入失败,原因:{0}", dsc); PLMEventLog.WriteLog(dsc, EventLogEntryType.Error); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 return(false); } System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 return(true); }
private void sendSMS() { string selectSql = "select sendcontent_id,sendcontent_phonenum," +"sendcontent_text from sms_send_content"; string deleteSql = "delete from sms_send_content where sendContent_sucStatus=1"; Database db = DatabaseFactory.CreateDatabase(); DBCommandWrapper dbComSelect = db.GetSqlStringCommandWrapper(selectSql); DBCommandWrapper dbComDelete = db.GetSqlStringCommandWrapper(deleteSql); IDataReader reder; try { reder = db.ExecuteReader(dbComSelect); while(reder.Read()) { string spNumber = string.Empty; string sendMobilePhone = reder[1].ToString(); switch(sendMobilePhone.Substring(2,1)) { case "0": spNumber = "9002733"; break; case "1": spNumber = "9002733"; break; case "2": spNumber = "9002733"; break; case "3": spNumber = "9002733"; break; case "4": spNumber = "9002733"; break; case "5": spNumber = "8002733"; break; case "6": spNumber = "8002733"; break; case "7": spNumber = "8002733"; break; case "8": spNumber = "8002733"; break; case "9": spNumber = "8002733"; break; } string url = "http://202.96.236.81:7783/testDownMsg.asp?" +"UID=sap&psd=0F3E419C71C500FA1FC8&source="+spNumber+"&mobile=" +sendMobilePhone+"&message="+reder[2].ToString(); MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST" , url , false , null , null ); xmlHttp.setRequestHeader( "Accept-Lauguage" , "zh-cn" ); xmlHttp.send( null ); if(xmlHttp.status == 200) { if(xmlHttp.responseText == "0") { string log = DateTime.Now.ToString() + " Successed to Send " +" One Message!"; WriteLog(log,"短信异常"); string updateSql = "update sms_send_content set sendContent_sucStatus=1 where sendcontent_id=" + reder[0].ToString(); DBCommandWrapper dbComUpdate = db.GetSqlStringCommandWrapper(updateSql); db.ExecuteNonQuery(dbComUpdate); } else { string log = DateTime.Now.ToString() + " Failed to Send " +" One Message!Please check the net connection or contact the " +"SP Provider to fix the problem"; WriteLog(log,"短信异常"); } } } db.ExecuteNonQuery(dbComDelete); } catch(Exception ex) { WriteLog(DateTime.Now.ToString()+" "+ex.Message,"短信异常"); } }
private void receiveSMS() { try { string urlMobile = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?" +"UID=sap&psd=0F3E419C71C500FA1FC8&source=8002733&mo_type=0"; string urlUnion = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?" +"UID=sap&psd=0F3E419C71C500FA1FC8&source=9002733&mo_type=0"; //receive reply from mobile MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST" , urlMobile , false , null , null ); xmlHttp.setRequestHeader( "CharSet" , "GB2312" ); xmlHttp.send( null ); if(xmlHttp.status == 200) { System.Text.Encoding gb=System.Text.Encoding.GetEncoding("GB2312"); string replys = gb.GetString((byte[])xmlHttp.responseBody); replys = replys.Substring(0,replys.Length-2); // 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?| if(replys.Length>11) { string[] reply = replys.Split(new char[]{'#'}); foreach(string replyContents in reply) { string[] replyContent = (replyContents.Substring(0,replyContents.Length-2)). Split(new char[]{'?'}); string phoneNum = replyContent[0].Replace("|",""); phoneNum = phoneNum.Replace(">",""); string contentText = replyContent[1].Replace("|",""); string replyTime = replyContent[2].Replace("|",""); string selectSql = "select count(*) from sms_reply_content where " +"replycontent_phonenum='"+phoneNum+"' and replycontent_date" +"='"+replyTime+"'"; Database db = DatabaseFactory.CreateDatabase(); DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql); int count = (int)db.ExecuteScalar(dbCom); if(count==0) { string insertSql = "insert into sms_reply_content(replycontent_phonenum," +"replycontent_text,replycontent_date) values('"+phoneNum+"'," +"'"+contentText+"','"+replyTime+"')"; DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql); db.ExecuteNonQuery(insertSql); } } } } //receive reply from union xmlHttp.open("POST" , urlUnion , false , null , null ); xmlHttp.setRequestHeader( "CharSet" , "GB2312" ); xmlHttp.send( null ); if(xmlHttp.status == 200) { System.Text.Encoding gb=System.Text.Encoding.GetEncoding("GB2312"); string replys = gb.GetString((byte[])xmlHttp.responseBody); replys = replys.Substring(0,replys.Length-2); // 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?| if(replys.Length>11) { string[] reply = replys.Split(new char[]{'#'}); foreach(string replyContents in reply) { string[] replyContent = (replyContents.Substring(0,replyContents.Length-3)). Split(new char[]{'?'}); string phoneNum = replyContent[0].Replace("|",""); phoneNum = phoneNum.Replace(">",""); string contentText = replyContent[1].Replace("|",""); string replyTime = replyContent[2].Replace("|",""); string selectSql = "select count(*) from sms_reply_content where " +"replycontent_phonenum='"+phoneNum+"' and replycontent_date" +"='"+replyTime+"'"; Database db = DatabaseFactory.CreateDatabase(); DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql); int count = (int)db.ExecuteScalar(dbCom); if(count==0) { string insertSql = "insert into sms_reply_content(replycontent_phonenum," +"replycontent_text,replycontent_date) values('"+phoneNum+"'," +"'"+contentText+"','"+replyTime+"')"; DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql); db.ExecuteNonQuery(insertSql); } } } } } catch(Exception ex) { WriteLog(DateTime.Now.ToString()+" "+ex.Message,"短信异常"); } }
private void sendSMS() { string selectSql = "select sendcontent_id,sendcontent_phonenum," + "sendcontent_text from sms_send_content"; string deleteSql = "delete from sms_send_content where sendContent_sucStatus=1"; Database db = DatabaseFactory.CreateDatabase(); DBCommandWrapper dbComSelect = db.GetSqlStringCommandWrapper(selectSql); DBCommandWrapper dbComDelete = db.GetSqlStringCommandWrapper(deleteSql); IDataReader reder; try { reder = db.ExecuteReader(dbComSelect); while (reder.Read()) { string spNumber = string.Empty; string sendMobilePhone = reder[1].ToString(); switch (sendMobilePhone.Substring(2, 1)) { case "0": spNumber = "9002733"; break; case "1": spNumber = "9002733"; break; case "2": spNumber = "9002733"; break; case "3": spNumber = "9002733"; break; case "4": spNumber = "9002733"; break; case "5": spNumber = "8002733"; break; case "6": spNumber = "8002733"; break; case "7": spNumber = "8002733"; break; case "8": spNumber = "8002733"; break; case "9": spNumber = "8002733"; break; } string url = "http://202.96.236.81:7783/testDownMsg.asp?" + "UID=sap&psd=0F3E419C71C500FA1FC8&source=" + spNumber + "&mobile=" + sendMobilePhone + "&message=" + reder[2].ToString(); MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST", url, false, null, null); xmlHttp.setRequestHeader("Accept-Lauguage", "zh-cn"); xmlHttp.send(null); if (xmlHttp.status == 200) { if (xmlHttp.responseText == "0") { string log = DateTime.Now.ToString() + " Successed to Send " + " One Message!"; WriteLog(log, "短信异常"); string updateSql = "update sms_send_content set sendContent_sucStatus=1 where sendcontent_id=" + reder[0].ToString(); DBCommandWrapper dbComUpdate = db.GetSqlStringCommandWrapper(updateSql); db.ExecuteNonQuery(dbComUpdate); } else { string log = DateTime.Now.ToString() + " Failed to Send " + " One Message!Please check the net connection or contact the " + "SP Provider to fix the problem"; WriteLog(log, "短信异常"); } } } db.ExecuteNonQuery(dbComDelete); } catch (Exception ex) { WriteLog(DateTime.Now.ToString() + " " + ex.Message, "短信异常"); } }
private void receiveSMS() { try { string urlMobile = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?" + "UID=sap&psd=0F3E419C71C500FA1FC8&source=8002733&mo_type=0"; string urlUnion = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?" + "UID=sap&psd=0F3E419C71C500FA1FC8&source=9002733&mo_type=0"; //receive reply from mobile MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); xmlHttp.open("POST", urlMobile, false, null, null); xmlHttp.setRequestHeader("CharSet", "GB2312"); xmlHttp.send(null); if (xmlHttp.status == 200) { System.Text.Encoding gb = System.Text.Encoding.GetEncoding("GB2312"); string replys = gb.GetString((byte[])xmlHttp.responseBody); replys = replys.Substring(0, replys.Length - 2); // 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?| if (replys.Length > 11) { string[] reply = replys.Split(new char[] { '#' }); foreach (string replyContents in reply) { string[] replyContent = (replyContents.Substring(0, replyContents.Length - 2)). Split(new char[] { '?' }); string phoneNum = replyContent[0].Replace("|", ""); phoneNum = phoneNum.Replace(">", ""); string contentText = replyContent[1].Replace("|", ""); string replyTime = replyContent[2].Replace("|", ""); string selectSql = "select count(*) from sms_reply_content where " + "replycontent_phonenum='" + phoneNum + "' and replycontent_date" + "='" + replyTime + "'"; Database db = DatabaseFactory.CreateDatabase(); DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql); int count = (int)db.ExecuteScalar(dbCom); if (count == 0) { string insertSql = "insert into sms_reply_content(replycontent_phonenum," + "replycontent_text,replycontent_date) values('" + phoneNum + "'," + "'" + contentText + "','" + replyTime + "')"; DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql); db.ExecuteNonQuery(insertSql); } } } } //receive reply from union xmlHttp.open("POST", urlUnion, false, null, null); xmlHttp.setRequestHeader("CharSet", "GB2312"); xmlHttp.send(null); if (xmlHttp.status == 200) { System.Text.Encoding gb = System.Text.Encoding.GetEncoding("GB2312"); string replys = gb.GetString((byte[])xmlHttp.responseBody); replys = replys.Substring(0, replys.Length - 2); // 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?| if (replys.Length > 11) { string[] reply = replys.Split(new char[] { '#' }); foreach (string replyContents in reply) { string[] replyContent = (replyContents.Substring(0, replyContents.Length - 3)). Split(new char[] { '?' }); string phoneNum = replyContent[0].Replace("|", ""); phoneNum = phoneNum.Replace(">", ""); string contentText = replyContent[1].Replace("|", ""); string replyTime = replyContent[2].Replace("|", ""); string selectSql = "select count(*) from sms_reply_content where " + "replycontent_phonenum='" + phoneNum + "' and replycontent_date" + "='" + replyTime + "'"; Database db = DatabaseFactory.CreateDatabase(); DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql); int count = (int)db.ExecuteScalar(dbCom); if (count == 0) { string insertSql = "insert into sms_reply_content(replycontent_phonenum," + "replycontent_text,replycontent_date) values('" + phoneNum + "'," + "'" + contentText + "','" + replyTime + "')"; DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql); db.ExecuteNonQuery(insertSql); } } } } } catch (Exception ex) { WriteLog(DateTime.Now.ToString() + " " + ex.Message, "短信异常"); } }
private void button4_Click(object sender, EventArgs e) { //U8XML u8XML = new U8XML(); //u8XML.createXml(); //u8XML.headerAdd(); //u8XML.bodyAdd(); //u8XML.saveXml(""); //u8XML.getNodeAttrs("u8xml_ruku.xml", "ufinterface"); //u8XML.GetXml("u8xml_ruku.xml"); //u8XML.GetXmlData("u8xml_ruku.xml", "ufinterface/storein/body/entry"); //u8XML.getNodesVal("u8xml_ruku.xml", "ufinterface/storein/body/entry"); Dictionary <string, string> d1 = moban.clearCloneDictVal(moban.entryMoban);//克隆 //Dictionary<string, string> d1 = new Dictionary<string, string>(moban.entryMoban);//克隆 moban.rootAttr["sender"] = "001"; moban.rootAttr["roottag"] = moban.mobanType; moban.rootAttr["proc"] = "add"; moban.headerDict["code"] = "0000000001"; //单据号 相同单据号时会自动编号,但不能为空 moban.headerDict["date"] = DateTime.Now.ToString(); //单据日期 入库日期 moban.headerDict["receiveflag"] = "1"; //收发标志 入库单-收 1,出库单-发 0 moban.headerDict["vouchtype"] = "10"; //'单据类型 10 产成品入库 moban.headerDict["businesstype"] = "成品入库"; //业务类型 moban.headerDict["source"] = "库存"; //单据来源 采购、销售、库存、存货 moban.headerDict["warehousecode"] = "2"; //仓库编码 moban.headerDict["receivecode"] = "12"; //收发类别编码 moban.headerDict["departmentcode"] = ""; //部门编码 moban.headerDict["personcode"] = ""; //职员编码 业务员 moban.headerDict["handler"] = "范磊"; //经手人 moban.headerDict["maker"] = "范磊"; //制单人 moban.headerDict["memory"] = ""; //备注 moban.headerDict["chandler"] = ""; //审核人 moban.headerDict["auditdate"] = ""; //审核日期 d1["inventorycode"] = "MTVMC"; //存货编码 d1["invname"] = "PVC密度板橱柜吊柜门"; //存货名称 d1["free1"] = "YD01YG0-CG1"; //商品代码 -吉屋用 d1["free2"] = "SF20088-03PCT"; //表面色 -吉屋用 d1["quantity"] = "1"; //数量 d1["cmassunitname"] = "套"; //主记量单位名称 d1["price"] = "999"; //单价 d1["cost"] = "999"; //金额 d1["makedate"] = ""; //生产日期 d1["define30"] = "YD01YG0001"; //订单号 -吉屋用 d1["iexpiratdatecalcu"] = "0"; //有效期推算方式 moban.entryList.Add(d1); XmlDocument dom = moban.combineU8Xml(); dom.Save("入库单mod.xml"); MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass(); try { xmlHttp.open("POST", "http://U8TESTSERVER/U8EAI/import.asp", false, null, null); xmlHttp.send(dom.OuterXml); String responseXml = xmlHttp.responseText; string s; bool suc = moban.parseU8XmlRs(responseXml, out s); if (suc) { MessageBox.Show("导入成功!" + s); } else { MessageBox.Show("导入失败!" + s); } } catch { } finally { System.Runtime.InteropServices.Marshal.FinalReleaseComObject(xmlHttp); //COM释放 } }