private void btnexport_Click(object sender, EventArgs e)
{
string xmlData = "";
string resultXMl = "";
string sql = "";
this.Cursor = Cursors.WaitCursor;
if (dgv2.Rows.Count > 0)
{
for (int i = 0; i < dgv2.Rows.Count; i++)
{
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 + "<CZLX>1</CZLX> ";
xmlData = xmlData + "<SPLX>1</SPLX> ";
xmlData = xmlData + "<YPLX>1</YPLX> ";
xmlData = xmlData + "<TYM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cCurrencyName"].Value, "") + "</TYM> ";
xmlData = xmlData + "<CPM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cInvName"].Value, "") + "</CPM> ";
xmlData = xmlData + "<YWM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cEnglishName"].Value, "") + "</YWM> ";
xmlData = xmlData + "<SPM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cInvName"].Value, "") + "</SPM> ";
xmlData = xmlData + "<YPSPTXM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cidefine8"].Value, "") + "</YPSPTXM> ";
xmlData = xmlData + "<YPJX>1</YPJX> ";
xmlData = xmlData + "<GG>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cInvStd"].Value, "") + "</GG> ";
xmlData = xmlData + "<SCQYMC>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cEnterprise"].Value, "") + "</SCQYMC> ";
xmlData = xmlData + "<CPLB>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cInvStd"].Value, "") + "</CPLB> ";
xmlData = xmlData + "<YPBWM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cidefine2"].Value, "") + "</YPBWM> ";
xmlData = xmlData + "<YPPZWH>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cFile"].Value, "") + "</YPPZWH> ";
xmlData = xmlData + "<BZCZ>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cidefine3"].Value, "") + "</BZCZ> ";
xmlData = xmlData + "<BZDW>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cComUnitName"].Value, "") + "</BZDW> ";
xmlData = xmlData + "<CGYYDW>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cComUnitName"].Value, "") + "</CGYYDW> ";
xmlData = xmlData + "<BZSL>1</BZSL> ";
xmlData = xmlData + "<BZFS>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cidefine4"].Value, "") + "</BZFS> ";
xmlData = xmlData + "<TZMS>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cComUnitName"].Value, "") + "</TZMS> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "</XMLDATA>";
resultXMl = SendMessage.SetMessage("YQ001", xmlData);
string result = SendMessage.ReadXMl(resultXMl, "HEAD", "ZTCLJG");
if (result == "00000")
{
sql = @" update inventory set cInvDefine10='00000' where cinvcode='" + ClsSystem.gnvl(dgv2.Rows[i].Cells["cinvcode"].Value, "") + "'";
SqlAccess.ExecuteSql(sql, Program.ConnectionString);
}
dgv2.Rows[i].Cells["resultXMl"].Value = ClsSystem.gnvl(result, "");
}
}
this.Cursor = Cursors.Default;
}
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
if (isTrue)
{
string xmlData = "";
string resultXMl = "";
if (ClsSystem.gnvl(comboBox1.Text, "") == "")
{
MessageBox.Show("医院没有选择", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox1.Focus();
return;
}
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>" + comboBox1.SelectedValue.ToString() + "</YYBM> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "</XMLDATA>";
// MessageBox.Show(xmlData);
// DataSet ds = SendMessage.QuryData("YQ017", xmlData);
DataSet ds = new DataSet();
string resultXml = SendMessage.SetMessage("YQ017", xmlData);
// MessageBox.Show(resultXml);
string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG");
if (result == "00000")
{
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
}
if (ds.Tables.Count > 3)
// if (ds != null && ClsSystem.gnvl(ds.Tables[0].Rows[0]["ZTCLJG"], "") == "00000")
{
DataTable db = ds.Tables[3];
cxdb = ds.Tables[3];
if (db.Rows.Count > 0)
{
comboBox5.DataSource = db;
comboBox5.DisplayMember = "PSDMC";
comboBox5.ValueMember = "PSDBM";
comboBox5.Text = "";
}
}
else
{
result = SendMessage.ReadXMl(resultXml, "HEAD", "CWXX");
MessageBox.Show(result, "错误", MessageBoxButtons.OK);
}
}
isTrue = false;
}
private void button1_Click(object sender, EventArgs e)
{
string xmlData = "";
string resultXMl = "";
string sql = "";
decimal CGSL = 0;
this.Cursor = Cursors.WaitCursor;
if (ClsSystem.gnvl(comboBox1.Text, "") == "")
{
MessageBox.Show("医院没有选择", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox1.Focus();
return;
}
if (ClsSystem.gnvl(comboBox4.Text, "") == "")
{
MessageBox.Show("订单类型", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox4.Focus();
return;
}
if (ClsSystem.gnvl(comboBox5.Text, "") == "")
{
MessageBox.Show("配送点编码", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox5.Focus();
return;
}
if (dgv2.Rows.Count < 1)
{
MessageBox.Show("表体无数据", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (dgv2.Rows.Count > 0)
{
for (int i = 0; i < dgv2.Rows.Count; i++)
{
if (dgv2.Rows[i].IsNewRow)
{
continue;
}
//CGSL += int.Parse(ClsSystem.gnvl(this.dgv2.Rows[i].Cells["CGSL"].Value, ""));
CGSL++;//商品品种数目
}
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>" + ClsSystem.gnvl(comboBox1.SelectedValue.ToString(), "") + "</YYBM> ";
xmlData = xmlData + "<PSDBM>" + ClsSystem.gnvl(comboBox5.SelectedValue.ToString(), "") + "</PSDBM> ";
xmlData = xmlData + "<DDLX>" + ClsSystem.gnvl((comboBox4.SelectedIndex + 1).ToString(), "") + "</DDLX> ";
xmlData = xmlData + "<DDBH>" + ClsSystem.gnvl(textBox1.Text, "") + "</DDBH> ";
xmlData = xmlData + "<SPSL>" + CGSL + "</SPSL> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "</XMLDATA>";
string resultXml = SendMessage.SetMessage("YQ006", xmlData);
string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG");
if (result == "00000")
{
MessageBox.Show("确认成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
else
{
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;
}
this.Cursor = Cursors.Default;
}
}
private void button6_Click(object sender, EventArgs e)
{
string sql = "";
try
{
dgv2.EndEdit();
sql = BuildSqlSelect();
this.Cursor = Cursors.WaitCursor;
if (dgv2.Rows.Count > 0)
{
dgv2.Rows.Clear();
}
DataSet ds = new DataSet();
if (ClsSystem.gnvl(sql, "") != "")
{
string resultXml = SendMessage.SetMessage("YQ010", sql);
string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG");
if (result == "00000")
{
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
result = "";
result = SendMessage.ReadXMl(resultXml, "MAIN", "JLS");
if (Public.GetNum(result) > 0)
{
DataTable db = ds.Tables[3];
//dt.DefaultView.Sort = "JHDH ASC";
//DataTable db = dt.DefaultView.ToTable();
cxdb = db;
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["DDMXBH"].Value = ClsSystem.gnvl(db.Rows[i]["DDMXBH"], "");
dgv2.Rows[i].Cells["JHDH"].Value = ClsSystem.gnvl(db.Rows[i]["JHDH"], "");
dgv2.Rows[i].Cells["YQBM"].Value = ClsSystem.gnvl(db.Rows[i]["YQBM"], "");
dgv2.Rows[i].Cells["YYBM"].Value = ClsSystem.gnvl(db.Rows[i]["YYBM"], "");
dgv2.Rows[i].Cells["YYMC"].Value = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cus.cCusName from Customer_extradefine ex join Customer cus on cus.cCusCode=ex.cCusCode where ex.ccdefine1='" + ClsSystem.gnvl(db.Rows[i]["YYBM"], "") + "'", Program.ConnectionString), "");
dgv2.Rows[i].Cells["PSDBM"].Value = ClsSystem.gnvl(db.Rows[i]["PSDBM"], "");
dgv2.Rows[i].Cells["PSDZ"].Value = ClsSystem.gnvl(db.Rows[i]["PSDZ"], "");
dgv2.Rows[i].Cells["CGLX"].Value = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select cgmc from ysxt_CGMS with(nolock) where cgbm='" + ClsSystem.gnvl(db.Rows[i]["CGLX"], "") + "'", Program.ConnectionString), "");
if (ClsSystem.gnvl(db.Rows[i]["DDLX"], "") == "1")
{
dgv2.Rows[i].Cells["DDLX"].Value = "医院自行订单";
}
else
{
dgv2.Rows[i].Cells["DDLX"].Value = "托管药库订单";
}
if (ClsSystem.gnvl(db.Rows[i]["SPLX"], "") == "1")
{
dgv2.Rows[i].Cells["SPLX"].Value = "药品类";
}
else if (ClsSystem.gnvl(db.Rows[i]["SPLX"], "") == "2")
{
dgv2.Rows[i].Cells["SPLX"].Value = "医用耗材器械类";
}
else
{
dgv2.Rows[i].Cells["SPLX"].Value = "其他";
}
dgv2.Rows[i].Cells["YPLX"].Value = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select ypjxmc from ysxt_Ypjx with(nolock) where ypjxbm='" + ClsSystem.gnvl(db.Rows[i]["YPLX"], "") + "'", Program.ConnectionString), "");
dgv2.Rows[i].Cells["ZXSPBM"].Value = ClsSystem.gnvl(db.Rows[i]["ZXSPBM"], "");
dgv2.Rows[i].Cells["CPM"].Value = ClsSystem.gnvl(db.Rows[i]["CPM"], "");
dgv2.Rows[i].Cells["YPJX"].Value = ClsSystem.gnvl(db.Rows[i]["YPJX"], "");
dgv2.Rows[i].Cells["CFGG"].Value = ClsSystem.gnvl(db.Rows[i]["CFGG"], "");
dgv2.Rows[i].Cells["YYDWMC"].Value = ClsSystem.gnvl(db.Rows[i]["YYDWMC"], "");
dgv2.Rows[i].Cells["BZNHSL"].Value = ClsSystem.gnvl(db.Rows[i]["BZNHSL"], "");
dgv2.Rows[i].Cells["SCQYMC"].Value = ClsSystem.gnvl(db.Rows[i]["SCQYMC"], "");
dgv2.Rows[i].Cells["CGJLDW"].Value = ClsSystem.gnvl(db.Rows[i]["CGJLDW"], "");
dgv2.Rows[i].Cells["CGSL"].Value = ClsSystem.gnvl(db.Rows[i]["CGSL"], "");
// dgv2.Rows[i].Cells["DCPSBZ"].Value = ClsSystem.gnvl(db.Rows[i]["DCPSBZ"], "");
if (ClsSystem.gnvl(db.Rows[i]["DDTJFS"], "") == "1")
{
dgv2.Rows[i].Cells["DDTJFS"].Value = "医院填报";
}
else
{
dgv2.Rows[i].Cells["DDTJFS"].Value = "药企代填";
}
dgv2.Rows[i].Cells["DDCLZT"].Value = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select mc from ysxt_ddclzt with(nolock) where bm='" + ClsSystem.gnvl(db.Rows[i]["DDCLZT"], "") + "'", Program.ConnectionString), "");
dgv2.Rows[i].Cells["DDTJRQ"].Value = ClsSystem.gnvl(db.Rows[i]["DDTJRQ"], "");
dgv2.Rows[i].Cells["BZSM"].Value = ClsSystem.gnvl(db.Rows[i]["BZSM"], "");
}
}
}
else
{
MessageBox.Show("未查到订单记录", "错误", MessageBoxButtons.OK);
return;
}
}
else
{
MessageBox.Show("处理结果：" + result + ClsSystem.gnvl(ds.Tables[0].Rows[0]["CWXX"], ""), "错误", MessageBoxButtons.OK);
return;
}
}
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 button4_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 (ClsSystem.gnvl(comboBox1.Text, "") == "")
{
MessageBox.Show("医院没有选择", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox1.Focus();
return;
}
if (ClsSystem.gnvl(comboBox4.Text, "") == "")
{
MessageBox.Show("订单类型", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox4.Focus();
return;
}
if (ClsSystem.gnvl(comboBox5.Text, "") == "")
{
MessageBox.Show("配送点编码", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox5.Focus();
return;
}
if (dgv2.Rows.Count < 1)
{
MessageBox.Show("表体无数据", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (dgv2.Rows.Count > 0)
{
for (int i = 0; i < dgv2.Rows.Count; i++)
{
if (!dgv2.Rows[i].IsNewRow)
{
count++;
}
}
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 + "<CZLX>1</CZLX> ";
//xmlData = xmlData + "<YQBM>ZDYC0001</YQBM> ";
xmlData = xmlData + "<YYBM>" + ClsSystem.gnvl(comboBox1.SelectedValue.ToString(), "") + "</YYBM> ";
xmlData = xmlData + "<PSDBM>" + ClsSystem.gnvl(comboBox5.SelectedValue.ToString(), "") + "</PSDBM> ";
xmlData = xmlData + "<DDLX>" + ClsSystem.gnvl((comboBox4.SelectedIndex + 1).ToString(), "") + "</DDLX> ";
xmlData = xmlData + "<DDBH></DDBH> ";
xmlData = xmlData + "<YYJHDH></YYJHDH> ";
xmlData = xmlData + "<ZWDHRQ>" + Convert.ToDateTime(dateTimePicker1.Value).Year.ToString("0000") +
Convert.ToDateTime(dateTimePicker1.Value).Month.ToString("00") +
Convert.ToDateTime(dateTimePicker1.Value).Day.ToString("00") +
"</ZWDHRQ> ";
xmlData = xmlData + "<JLS>" + count.ToString() + "</JLS> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "<DETAIL>";
for (int i = 0; i < dgv2.Rows.Count; i++)
{
if (dgv2.Rows[i].IsNewRow)
{
continue;
}
//SBVID = ClsSystem.gnvl(this.dgv2.Rows[i].Cells["SBVID"].Value, "");
// dts = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
xmlData = xmlData + "<STRUCT>";
xmlData = xmlData + "<SXH>" + ClsSystem.gnvl(this.dgv2.Rows[i].Cells["xh"].Value, "") + "</SXH> ";
// xmlData = xmlData + "<CGLX>" + Convert.ToDateTime(dgv2.Rows[i].Cells["dDate"].Value).Year.ToString("0000") + Convert.ToDateTime(dgv2.Rows[i].Cells["dDate"].Value).Month.ToString("00") + Convert.ToDateTime(dgv2.Rows[i].Cells["dDate"].Value).Day.ToString("00") + "</CGLX> ";
xmlData = xmlData + "<CGLX>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["CGLX"].Value, "0") + "</CGLX>";
xmlData = xmlData + "<SPLX>" + ClsSystem.gnvl(this.dgv2.Rows[i].Cells["SPLX"].Value, "") + "</SPLX> ";
xmlData = xmlData + "<ZXSPBM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["ZXSPBM"].Value, "") + "</ZXSPBM> ";
xmlData = xmlData + "<CGJLDW>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["CGJLDW"].Value, "") + "</CGJLDW> ";
xmlData = xmlData + "<CGSL>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["CGSL"].Value, "") + "</CGSL> ";
xmlData = xmlData + "<CGDJ>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["CGDJ"].Value, "") + "</CGDJ> ";
xmlData = xmlData + "<YQBM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["YQBM"].Value, "") + "</YQBM> ";
//多次配送标识
xmlData = xmlData + "<DCPSBS>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["DCPSBS"].Value, "") + "</DCPSBS> ";
xmlData = xmlData + "<BZSM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["BZSM"].Value, "") + "</BZSM> ";
xmlData = xmlData + "</STRUCT>";
}
xmlData = xmlData + "</DETAIL>";
xmlData = xmlData + "</XMLDATA>";
DataSet ds = new DataSet();
DataTable db = null;
string DDBH = "";
string DDMXBH = "";
string resultXml = SendMessage.SetMessage("YQ005", xmlData);
string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG");
if (result == "00000")
{
DDBH = SendMessage.ReadXMl(resultXml, "MAIN", "DDBH");
textBox1.Text = DDBH;
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
if (ds.Tables.Count >= 3)
{
db = ds.Tables[3];
for (int j = 0; j < db.Rows.Count; j++)
{
DDMXBH = ClsSystem.gnvl(db.Rows[j]["DDMXBH"], "");
// CLJG = ClsSystem.gnvl(db.Rows[j]["CLJG"], "");
dgv2.Rows[j].Cells["DDMXBH"].Value = DDMXBH;
}
}
}
else
{
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;
}
this.Cursor = Cursors.Default;
}
}
private void button1_Click(object sender, EventArgs e)
{
string xmlData = "";
string sql = "";
string sbvid = "";;
// 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" && ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cdefine25"].Value, "").ToUpper() != "00000")
{
//yybm= ClsSystem.gnvl(dgv1.Rows[i].Cells["cdefine11"].Value, "");
//PSDBM = ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine32"].Value, "");
//if (yybm_O != yybm&&y>0)
//{
// MessageBox.Show("请选择同一客户上传", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
//if (PSDBM_O != PSDBM && y > 0)
//{
// MessageBox.Show("请选择同一医院配送点编码", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
if (ClsSystem.gnvl(ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine34"].Value, ""), "") == "")
{
MessageBox.Show("配送箱数未填入", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (ClsSystem.gnvl(dgv1.Rows[i].Cells["zxlx"].Value, "") == "")
{
MessageBox.Show("装箱类型未填入", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//yybm_O = yybm;
//PSDBM_O = PSDBM;
//y++;
}
}
//if (count < 1)
//{
// MessageBox.Show("请选择配送数据", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
for (int j = 0; j < dgv1.Rows.Count; j++)
{
if (ClsSystem.gnvl(this.dgv1.Rows[j].Cells["check"].Value, "").ToUpper() == "TRUE" && ClsSystem.gnvl(this.dgv1.Rows[j].Cells["cdefine25"].Value, "").ToUpper() != "00000")
{
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 + "<CZLX>1</CZLX> ";
xmlData = xmlData + "<PSDH>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["PSDTM"].Value, "") + "</PSDH> ";
xmlData = xmlData + "<YQBM>ZDYC0001</YQBM> ";
xmlData = xmlData + "<YYBM>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cdefine11"].Value, "") + "</YYBM> ";
xmlData = xmlData + "<PSDBM>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cDefine32"].Value, "") + "</PSDBM> ";
xmlData = xmlData + "<CJRQ>" + DateTime.Today.Year.ToString("0000") + DateTime.Today.Month.ToString("00") + DateTime.Today.Day.ToString("00") + "</CJRQ> ";
xmlData = xmlData + "<SDRQ></SDRQ> ";
xmlData = xmlData + "<ZXS>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cdefine34"].Value, "") + "</ZXS> ";
xmlData = xmlData + "<JLS>1</JLS> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "<DETAIL>";
sbvid = ClsSystem.gnvl(this.dgv1.Rows[j].Cells["sbvid"].Value, "");
// sql = @" select cinvcode,cinvname,cDefine28,iQuantity,cInvDefine3,cDefine29,cDefine30,cBatch ,dMDate ,cExpirationdate ,cSoCode
// from Sales_FHD_w where dlid=" + DLID;
// dts = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
//for (int k = 0; k < dts.Rows.Count; k++)
//{
xmlData = xmlData + "<STRUCT>";
xmlData = xmlData + "<PSDTM>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["PSDTM"].Value, "") + "</PSDTM> ";
if (ClsSystem.gnvl(dgv1.Rows[j].Cells["zxlx"].Value, "") == "整箱")
{
xmlData = xmlData + "<ZXLX>1</ZXLX> ";
}
else
{
xmlData = xmlData + "<ZXLX>2</ZXLX> ";
}
xmlData = xmlData + "<SPLX>1</SPLX> ";
xmlData = xmlData + "<ZXSPBM>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cDefine28"].Value, "") + "</ZXSPBM> ";
xmlData = xmlData + "<SCPH>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cBatch"].Value, "") + "</SCPH> ";
xmlData = xmlData + "<SCRQ>" + Convert.ToDateTime(dgv1.Rows[j].Cells["dMDate"].Value).Year.ToString("0000") + Convert.ToDateTime(dgv1.Rows[j].Cells["dMDate"].Value).Month.ToString("00") + Convert.ToDateTime(dgv1.Rows[j].Cells["dMDate"].Value).Day.ToString("00") + "</SCRQ> ";
xmlData = xmlData + "<YXRQ>" + Convert.ToDateTime(dgv1.Rows[j].Cells["cExpirationdate"].Value).Year.ToString("0000") + Convert.ToDateTime(dgv1.Rows[j].Cells["cExpirationdate"].Value).Month.ToString("00") + Convert.ToDateTime(dgv1.Rows[j].Cells["cExpirationdate"].Value).Day.ToString("00") + "</YXRQ> ";
xmlData = xmlData + "<XSDDH>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["iDLsID"].Value, "") + "</XSDDH> ";
xmlData = xmlData + "<WLPTDDH></WLPTDDH> ";
xmlData = xmlData + "<DDMXBH>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cDefine29"].Value, "") + "</DDMXBH> ";
xmlData = xmlData + "<PSL>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[j].Cells["iNum"].Value), 2), "") + "</PSL> ";
xmlData = xmlData + "<CGJLDW>" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cDefine30"].Value, "") + "</CGJLDW> ";
xmlData = xmlData + "</STRUCT>";
xmlData = xmlData + "</DETAIL>";
xmlData = xmlData + "</XMLDATA>";
string iDLsID = "";
string CLJG = "";
DataSet ds = new DataSet();
DataTable db = new DataTable();
string resultXml = SendMessage.SetMessage("YQ003", xmlData);
string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG");
if (result == "00000")
{
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
//result = "";
//result = SendMessage.ReadXMl(resultXml, "MAIN", "JLS");
//if (Public.GetNum(result) > 0)
//{
if (ds.Tables.Count >= 4)
{
db = ds.Tables[3];
for (int k = 0; k < db.Rows.Count; k++)
{
// PSDH = ClsSystem.gnvl(db.Rows[j]["PSDH"], "");
iDLsID = ClsSystem.gnvl(db.Rows[k]["XSDDH"], "");
CLJG = ClsSystem.gnvl(db.Rows[k]["CLJG"], "");
sql = " update SaleBillVouchs set cdefine25='" + CLJG + "',cDefine23 ='" + ClsSystem.gnvl(dgv1.Rows[j].Cells["zxlx"].Value, "") + "', cDefine34=" + ClsSystem.gnvl(dgv1.Rows[j].Cells["cdefine34"].Value, "") + " where iDLsID =" + iDLsID + "\n";
dgv1.Rows[j].Cells["cdefine25"].Value = CLJG;
}
SqlAccess.ExecuteSql(sql, Program.ConnectionString);
}
else
{
dgv1.Rows[j].Cells["cdefine25"].Value = "错误:未返回明细";
}
}
else
{
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
if (ds.Tables.Count >= 4)
{
db = ds.Tables[3];
}
CLJG = ClsSystem.gnvl(db.Rows[0]["CLJG"], "");
string CLQKMS = ClsSystem.gnvl(db.Rows[0]["CLQKMS"], "");
dgv1.Rows[j].Cells["cdefine25"].Value = "错误编码：" + CLJG + "错误信息:" + CLQKMS;
MessageBox.Show("错误编码：" + CLJG + "错误信息:" + CLQKMS, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
}
this.Cursor = Cursors.Default;
}
/// <summary>
/// 上传发票
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
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;
decimal iInvExchRate = 0;
if (dgv1.Rows.Count > 0)
{
for (int i = 0; i < dgv1.Rows.Count; i++)
{
if (ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cdefine24"].Value, "").ToUpper() == "00000")
{
continue;
}
if (ClsSystem.gnvl(this.dgv1.Rows[i].Cells["check"].Value, "").ToUpper() == "TRUE" &&
ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cdefine24"].Value, "").ToUpper() != "00000")
{
yybm = ClsSystem.gnvl(dgv1.Rows[i].Cells["cdefine11"].Value, "");
SBVID = ClsSystem.gnvl(this.dgv1.Rows[i].Cells["SBVID"].Value, "");
//PSDBM = ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cDefine32"].Value, "");
if (yybm_O != yybm && y > 0)
{
MessageBox.Show("请选择同一客户上传", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//if (SBVID != SBVID_o && y > 0)
//{
// MessageBox.Show("请选择同一发票", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
if (PSDBM_O != PSDBM && y > 0)
{
MessageBox.Show("请选择同一医院配送点编码", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
hsje = hsje + Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iSum"].Value), 4);
yybm_O = yybm;
SBVID_o = SBVID;
PSDBM_O = PSDBM;
y++;
count = i;
}
}
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 + "<CZLX>1</CZLX> ";
xmlData = xmlData + "<YQBM>ZDYC0001</YQBM> ";
xmlData = xmlData + "<YYBM>" + ClsSystem.gnvl(dgv1.Rows[count].Cells["cdefine11"].Value, "") + "</YYBM> ";
xmlData = xmlData + "<PSDBM>" + ClsSystem.gnvl(dgv1.Rows[count].Cells["cDefine32"].Value, "") + "</PSDBM> ";
xmlData = xmlData + "<JLS>" + y.ToString() + "</JLS> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "<DETAIL>";
for (int i = 0; i < dgv1.Rows.Count; i++)
{
WriteU8BVCode(i);
if (ClsSystem.gnvl(this.dgv1.Rows[i].Cells["check"].Value, "").ToUpper() == "TRUE" && ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cDefine24"].Value, "").ToUpper() != "00000")
{
SBVID = ClsSystem.gnvl(this.dgv1.Rows[i].Cells["SBVID"].Value, "");
iInvExchRate = Public.GetNum(dgv1.Rows[i].Cells["iInvExchRate"].Value);
// dts = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
xmlData = xmlData + "<STRUCT>";
xmlData = xmlData + "<FPH>" + ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cSBVCode"].Value, "") + "</FPH> ";
xmlData = xmlData + "<FPRQ>" + Convert.ToDateTime(dgv1.Rows[i].Cells["dDate"].Value).Year.ToString("0000") + Convert.ToDateTime(dgv1.Rows[i].Cells["dDate"].Value).Month.ToString("00") + Convert.ToDateTime(dgv1.Rows[i].Cells["dDate"].Value).Day.ToString("00") + "</FPRQ> ";
xmlData = xmlData + "<FPHSZJE>" + ClsSystem.gnvl(hsje, "0") + "</FPHSZJE>";
xmlData = xmlData + "<DLCGBZ>0</DLCGBZ> ";
xmlData = xmlData + "<FPBZ>" + ClsSystem.gnvl(this.dgv1.Rows[i].Cells["cMemo"].Value, "") + "</FPBZ> ";
xmlData = xmlData + "<GLMXBH>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine29"].Value, "") + "</GLMXBH> ";
xmlData = xmlData + "<XSDDH>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["iDLsID"].Value, "") + "</XSDDH> ";
xmlData = xmlData + "<SPLX>1</SPLX> ";
xmlData = xmlData + "<SFCH>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["bReturnFlag"].Value, "") + "</SFCH> ";
if (ClsSystem.gnvl(dgv1.Rows[i].Cells["bReturnFlag"].Value, "") == "1")
{
xmlData = xmlData + "<GLBZ>0</GLBZ> ";
}
else
{
xmlData = xmlData + "<GLBZ>1</GLBZ> ";
}
xmlData = xmlData + "<WFGLSM></WFGLSM> ";
xmlData = xmlData + "<ZXSPBM>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine28"].Value, "") + "</ZXSPBM> ";
xmlData = xmlData + "<SCPH>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cBatch"].Value, "") + "</SCPH> ";
xmlData = xmlData + "<PZWH>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cFile"].Value, "") + "</PZWH> ";
xmlData = xmlData + "<SPSL>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["iNum"].Value, "") + "</SPSL> ";
xmlData = xmlData + "<CGJLDW>" + ClsSystem.gnvl(dgv1.Rows[i].Cells["cDefine30"].Value, "") + "</CGJLDW> ";
xmlData = xmlData + "<SCRQ>" + Convert.ToDateTime(dgv1.Rows[i].Cells["dMDate"].Value).Year.ToString("0000") + Convert.ToDateTime(dgv1.Rows[i].Cells["dMDate"].Value).Month.ToString("00") + Convert.ToDateTime(dgv1.Rows[i].Cells["dMDate"].Value).Day.ToString("00") + "</SCRQ> ";
xmlData = xmlData + "<YXRQ>" + Convert.ToDateTime(dgv1.Rows[i].Cells["cExpirationdate"].Value).Year.ToString("0000") + Convert.ToDateTime(dgv1.Rows[i].Cells["cExpirationdate"].Value).Month.ToString("00") + Convert.ToDateTime(dgv1.Rows[i].Cells["cExpirationdate"].Value).Day.ToString("00") + "</YXRQ> ";
xmlData = xmlData + "<WSDJ>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iUnitPrice"].Value), 4), "") + "</WSDJ> ";
xmlData = xmlData + "<HSDJ>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iTaxUnitPrice"].Value), 4), "") + "</HSDJ> ";
xmlData = xmlData + "<SL>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iTaxRate"].Value), 4), "") + "</SL> ";
xmlData = xmlData + "<SE>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iTax"].Value), 4), "") + "</SE> ";
xmlData = xmlData + "<WSJE>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iMoney"].Value), 4), "") + "</WSJE> ";
xmlData = xmlData + "<HSJE>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iSum"].Value), 4), "") + "</HSJE> ";
xmlData = xmlData + "<PFJ>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["iQuotedPrice"].Value), 4), "") + "</PFJ> ";
xmlData = xmlData + "<LSJ>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv1.Rows[i].Cells["fRetailPrice"].Value), 4), "") + "</LSJ> ";
xmlData = xmlData + "</STRUCT>";
}
}
xmlData = xmlData + "</DETAIL>";
xmlData = xmlData + "</XMLDATA>";
}
DataSet ds = new DataSet();
DataTable db = null;
string iDLsID = "";
string CLJG = "";
string resultXml = SendMessage.SetMessage("YQ004", xmlData);
string result = SendMessage.ReadXMl(resultXml, "HEAD", "ZTCLJG");
if (result == "00000")
{
try
{
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
if (ds.Tables.Count == 3)
{
db = ds.Tables[2];
for (int j = 0; j < db.Rows.Count; j++)
{
iDLsID = ClsSystem.gnvl(db.Rows[j]["XSDDH"], "");
CLJG = ClsSystem.gnvl(db.Rows[j]["CLJG"], "");
sql = sql + " update SaleBillVouchs set cdefine24='" + CLJG + "' where iDLsID=" + iDLsID + "\n";
}
}
}
catch (Exception ex)
{
}
}
else
{
TextReader tdr = new StringReader(resultXml);
ds.ReadXml(tdr);
string CLQKMS = "";
if (ds.Tables.Count == 3)
{
db = ds.Tables[2];
CLJG = ClsSystem.gnvl(db.Rows[0]["CLJG"], "");
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 + "\n\r" + CLQKMS, "错误", 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;
}
try
{
SqlAccess.ExecuteSql(sql, Program.ConnectionString);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.Cursor = Cursors.Default;
}
}
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 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 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;
}
}
