private void button6_Click(object sender, EventArgs e) { string xmlData = ""; try { this.Cursor = Cursors.WaitCursor; if (dgv2.Rows.Count > 0) { dgv2.Rows.Clear(); } xmlData = ""; xmlData = xmlData + @"<?xml version=""1.0"" encoding=""utf-8""?>"; xmlData = xmlData + "<XMLDATA>"; xmlData = xmlData + "<HEAD>"; xmlData = xmlData + "<IP>" + SendMessage.GetIP() + "</IP> "; xmlData = xmlData + "<MAC>" + SendMessage.GetMAC() + "</MAC> "; xmlData = xmlData + "<BZXX></BZXX> "; xmlData = xmlData + "</HEAD> "; xmlData = xmlData + "<MAIN>"; xmlData = xmlData + "<YYBM>" + textBox1.Text.Trim() + "</YYBM> "; xmlData = xmlData + "</MAIN>"; xmlData = xmlData + "</XMLDATA>"; // DataSet ds = SendMessage.QuryData("YQ017", xmlData); DataSet ds = new DataSet(); string resultXml = SendMessage.SetMessage("YQ017", xmlData); string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG"); if (result == "00000") { TextReader tdr = new StringReader(resultXml); ds.ReadXml(tdr); } if (ds.Tables.Count > 3) { DataTable db = ds.Tables[3]; cxdb = ds.Tables[3]; if (db.Rows.Count > 0) { for (int i = 0; i < db.Rows.Count; i++) { dgv2.Rows.Add(); dgv2.Rows[i].Cells["SFWJ"].Value = ClsSystem.gnvl(ds.Tables[1].Rows[0]["SFWJ"], ""); dgv2.Rows[i].Cells["JLS"].Value = ClsSystem.gnvl(ds.Tables[1].Rows[0]["JLS"], ""); dgv2.Rows[i].Cells["PSDBM"].Value = ClsSystem.gnvl(db.Rows[i]["PSDBM"], ""); dgv2.Rows[i].Cells["PSDMC"].Value = ClsSystem.gnvl(db.Rows[i]["PSDMC"], ""); dgv2.Rows[i].Cells["PSDZ"].Value = ClsSystem.gnvl(db.Rows[i]["PSDZ"], ""); dgv2.Rows[i].Cells["LXRXM"].Value = ClsSystem.gnvl(db.Rows[i]["LXRXM"], ""); dgv2.Rows[i].Cells["LXDH"].Value = ClsSystem.gnvl(db.Rows[i]["LXDH"], ""); dgv2.Rows[i].Cells["YZBM"].Value = ClsSystem.gnvl(db.Rows[i]["YZBM"], ""); dgv2.Rows[i].Cells["BZXX"].Value = ClsSystem.gnvl(db.Rows[i]["BZXX"], ""); } } } else { MessageBox.Show(ClsSystem.gnvl(ds.Tables[0].Rows[0]["CWXX"], ""), "错误", MessageBoxButtons.OK); } this.Cursor = Cursors.Default; // MessageBox.Show("未上传的存货查询完成", "提示", MessageBoxButtons.OK); } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(ex.Message.ToString(), "错误", MessageBoxButtons.OK); return; } }
private void button1_Click(object sender, EventArgs e) { string xmlData = ""; string resultXMl = ""; string sql = ""; string SBVID = ""; string SBVID_o = ""; string yybm = ""; string yybm_O = ""; string PSDBM = ""; string PSDBM_O = ""; int y = 0; int count = 0; DataTable dts = null; this.Cursor = Cursors.WaitCursor; decimal hsje = 0; if (dgv1.Rows.Count > 0) { if (dgv1.Rows.Count > 0) { xmlData = ""; xmlData = xmlData + @"<?xml version=""1.0"" encoding=""utf-8""?>"; xmlData = xmlData + "<XMLDATA>"; xmlData = xmlData + "<HEAD>"; xmlData = xmlData + "<IP>" + SendMessage.GetIP() + "</IP> "; xmlData = xmlData + "<MAC>" + SendMessage.GetMAC() + "</MAC> "; xmlData = xmlData + "<BZXX></BZXX> "; xmlData = xmlData + "</HEAD> "; xmlData = xmlData + "<MAIN>"; xmlData = xmlData + "<YQBM>ZDYC0001</YQBM> "; xmlData = xmlData + "<YYBM>" + ClsSystem.gnvl(dgv1.Rows[count].Cells["cdefine11"].Value, "") + "</YYBM> "; xmlData = xmlData + "<FPH>" + ClsSystem.gnvl(dgv1.Rows[count].Cells["cSBVCode"].Value, "") + "</FPH> "; xmlData = xmlData + "<FPHSZJE>" + ClsSystem.gnvl(SqlAccess.ExecuteScalar(" select isnull(sum(iSum),0) from SaleBillVouchs where sbvid=" + ClsSystem.gnvl(dgv1.Rows[count].Cells["sbvid"].Value, ""), Program.ConnectionString), "") + "</FPHSZJE> "; xmlData = xmlData + "</MAIN>"; xmlData = xmlData + "</XMLDATA>"; } DataSet ds = new DataSet(); DataTable db = null; string iDLsID = ""; string CLJG = ""; string resultXml = SendMessage.SetMessage("YQ016", xmlData); string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG"); if (result == "00000") { sql = " update SaleBillVouch set cdefine9='" + result + "' where cSBVCode='" + ClsSystem.gnvl(dgv1.Rows[count].Cells["cSBVCode"].Value, "") + "'\n"; } else { //TextReader tdr = new StringReader(resultXml); //ds.ReadXml(tdr); //if (ds.Tables.Count >= 4) //{ // db = ds.Tables[2]; //} //CLJG = ClsSystem.gnvl(db.Rows[0]["CLJG"], ""); //string CLQKMS = ClsSystem.gnvl(db.Rows[0]["CLQKMS"], ""); // dgv1.Rows[i].Cells["cdefine24"].Value = "错误编码:" + CLJG + "错误信息:" + CLQKMS; string CWXX = SendMessage.ReadXMl(resultXml, "HEAD", "CWXX"); MessageBox.Show("错误编码:" + result + "错误信息:" + CWXX, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; //MessageBox.Show("错误编码:" + ClsSystem.gnvl(ds.Tables[0].Rows[0]["ZTCLJG"], "") + "错误信息:" + ClsSystem.gnvl(ds.Tables[0].Rows[0]["CWXX"], ""), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); //return; } SqlAccess.ExecuteSql(sql, Program.ConnectionString); this.Cursor = Cursors.Default; } }
private void button1_Click(object sender, EventArgs e) { string xmlData = ""; string resultXMl = ""; string sql = ""; string sbvid = ""; string yybm = ""; string yybm_O = ""; int y = 0; DataTable dts = null; this.Cursor = Cursors.WaitCursor; if (dgv1.Rows.Count > 0) { for (int i = 0; i < dgv1.Rows.Count; i++) { if (ClsSystem.gnvl(this.dgv1.Rows[i].Cells["check"].Value, "").ToUpper() == "TRUE") { if (ClsSystem.gnvl(dgv1.Rows[i].Cells["cmemo"].Value, "") == "") { MessageBox.Show("终止原因未填入", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine29"].Value, "") == "") { MessageBox.Show("订单明细编号未填入", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } yybm_O = yybm; y++; } } for (int i = 0; i < dgv1.Rows.Count; i++) { if (ClsSystem.gnvl(this.dgv1.Rows[i].Cells["check"].Value, "").ToUpper() == "TRUE") { sbvid = ClsSystem.gnvl(this.dgv1.Rows[i].Cells["sbvid"].Value, ""); xmlData = ""; xmlData = xmlData + @"<?xml version=""1.0"" encoding=""utf-8""?>"; xmlData = xmlData + "<XMLDATA>"; xmlData = xmlData + "<HEAD>"; xmlData = xmlData + "<IP>" + SendMessage.GetIP() + "</IP> "; xmlData = xmlData + "<MAC>" + SendMessage.GetMAC() + "</MAC> "; xmlData = xmlData + "<BZXX></BZXX> "; xmlData = xmlData + "</HEAD> "; xmlData = xmlData + "<MAIN>"; xmlData = xmlData + "<DDMXBH>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine29"].Value, "") + "</DDMXBH> "; xmlData = xmlData + "<ZZYY>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cmemo"].Value, "") + "</ZZYY> "; xmlData = xmlData + "</MAIN>"; xmlData = xmlData + "</XMLDATA>"; string resultXml = SendMessage.SetMessage("YQ013", xmlData); string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG"); if (result == "00000") { dgv1.Rows[i].Cells["result"].Value = result; } else { MessageBox.Show("错误编码:" + result + "错误信息:" + SendMessage.ReadXMl(resultXml, "HEAD", "CWXX"), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } } } this.Cursor = Cursors.Default; }
private string Qury01(string cType) { string xmlData = ""; string ResultXml = ""; string czlx = "1";//新增 string strsql = @"sselect cInvCCode as SPLX ,cInvDefine1 as YPLX, cInvName as tym,'' as CPM, '' as YWM, cInvName as SPM,cInvDefine2 as YPSPTXM, cInvDefine3 as YPJX, cInvStd as GG,cEnterprise as SCQYMC,'' as CPLB,'' as YPBWM,cFile as YPPZWH, '' as BZCZ,'' as BZDW,cPackingType as CGYYDW,'' as BZSL,'' as BZFS,'' as TZMS from inventory where isnull(cInvDefine10,'')<>'' "; DataTable db = SqlAccess.ExecuteSqlDataTable(strsql, conn); if (db.Rows.Count > 0) { for (int i = 0; i < db.Rows.Count; i++) { xmlData = ""; ResultXml = ""; xmlData = @"<?xml version=""1.0"" encoding=""utf-8""?>"; xmlData = xmlData + "<XMLDATA>"; xmlData = xmlData + "<HEAD>"; xmlData = xmlData + "<IP>" + SendMessage.GetIP() + "</IP>"; xmlData = xmlData + "<MAC>" + SendMessage.GetMAC() + "</MAC>"; xmlData = xmlData + "<BZXX/>"; xmlData = xmlData + "</HEAD>"; xmlData = xmlData + "<MAIN>"; xmlData = xmlData + "<CZLX>" + czlx + "</CZLX>"; xmlData = xmlData + "<SPLX>" + ClsSystem.gnvl(db.Rows[i]["SPLX"], "") + "</SPLX>"; xmlData = xmlData + "<YPLX>" + ClsSystem.gnvl(db.Rows[i]["YPLX"], "") + "</YPLX>"; xmlData = xmlData + "<TYM>" + ClsSystem.gnvl(db.Rows[i]["TYM"], "") + "</TYM>"; xmlData = xmlData + "<CPM>" + ClsSystem.gnvl(db.Rows[i]["CPM"], "") + "</CPM>"; xmlData = xmlData + "<YWM>" + ClsSystem.gnvl(db.Rows[i]["YWM"], "") + "</YWM>"; xmlData = xmlData + "<SPM>" + ClsSystem.gnvl(db.Rows[i]["SPM"], "") + "</SPM>"; xmlData = xmlData + "<YPSPTXM>" + ClsSystem.gnvl(db.Rows[i]["YPSPTXM"], "") + "</YPSPTXM>"; xmlData = xmlData + "<YPJX>" + ClsSystem.gnvl(db.Rows[i]["YPJX"], "") + "</YPJX>"; xmlData = xmlData + "<GG>" + ClsSystem.gnvl(db.Rows[i]["GG"], "") + "</GG>"; xmlData = xmlData + "<SCQYMC>" + ClsSystem.gnvl(db.Rows[i]["SCQYMC"], "") + "</SCQYMC>"; xmlData = xmlData + "<CPLB>" + ClsSystem.gnvl(db.Rows[i]["CPLB"], "") + "</CPLB>"; xmlData = xmlData + "<YPBWM>" + ClsSystem.gnvl(db.Rows[i]["YPBWM"], "") + "</YPBWM>"; xmlData = xmlData + "<YPPZWH>" + ClsSystem.gnvl(db.Rows[i]["YPPZWH"], "") + "</YPPZWH>"; xmlData = xmlData + "<BZCZ>" + ClsSystem.gnvl(db.Rows[i]["BZCZ"], "") + "</BZCZ>"; xmlData = xmlData + "<BZDW>" + ClsSystem.gnvl(db.Rows[i]["BZDW"], "") + "</BZDW>"; xmlData = xmlData + "<CGYYDW>" + ClsSystem.gnvl(db.Rows[i]["CGYYDW"], "") + "</CGYYDW>"; xmlData = xmlData + "<BZSL>" + ClsSystem.gnvl(db.Rows[i]["BZSL"], "") + "</BZSL>"; xmlData = xmlData + "<BZFS>" + ClsSystem.gnvl(db.Rows[i]["BZFS"], "") + "</BZFS>"; xmlData = xmlData + "<TZMS>" + ClsSystem.gnvl(db.Rows[i]["TZMS"], "") + "</TZMS>"; xmlData = xmlData + "</MAIN>"; xmlData = xmlData + "</XMLDATA>"; DataSet ds = SendMessage.QuryData(cType, xmlData); if (ds.Tables.Count > 0) { if (ClsSystem.gnvl(ds.Tables[0].Rows[0]["ZTCLJG"], "") == "00000") { xmlData = @"<?xml version=""1.0"" encoding=""utf-8""?>"; xmlData = xmlData + "<XMLDATA>"; xmlData = xmlData + "<HEAD>"; xmlData = xmlData + "<IP>" + SendMessage.GetIP() + "</IP>"; xmlData = xmlData + "<MAC>" + SendMessage.GetMAC() + "</MAC>"; xmlData = xmlData + "<BZXX/>"; xmlData = xmlData + "</HEAD>"; xmlData = xmlData + "<MAIN>"; xmlData = xmlData + "<CXLX>07</CXLX>"; xmlData = xmlData + "<CXBH>" + ClsSystem.gnvl(db.Rows[i]["YPBWM"], "") + "</CXBH>"; xmlData = xmlData + "</MAIN>"; xmlData = xmlData + "</XMLDATA>"; DataSet rds = SendMessage.QuryData("YQ015", xmlData); if (rds.Tables.Count > 0) { if (ClsSystem.gnvl(rds.Tables[0].Rows[0]["ZTCLJG"], "") == "00000") { //strsql = "insert into YS_Interface_Records(cMaker,dDate,cType,cFlag,ExCode,errMsg) values(" // + "'',getdate(),'" + cType + "','成功','" + VouchNO + "','')"; // SqlAccess.ExecuteSql(strsql, conn); } } } } } } return(null); }