//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释放
}
}
