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 btnexport_Click(object sender, EventArgs e)
{
string xmlData = "";
string resultXMl = "";
string sql = "";
this.Cursor = Cursors.WaitCursor;
if (dgv2.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 + "<KCCBSJ>" + DateTime.Today.Year.ToString("0000") + DateTime.Today.Month.ToString("00") + DateTime.Today.Day.ToString("00") + "/" + DateTime.Today.Hour.ToString("00") + DateTime.Today.Minute.ToString("00") + DateTime.Today.Second.ToString("00") + "/" + "</KCCBSJ> ";
xmlData = xmlData + "<JLS>" + dgv2.Rows.Count.ToString() + "</JLS> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "<DETAIL>";
for (int i = 0; i < dgv2.Rows.Count; i++)
{
xmlData = xmlData + "<STRUCT>";
xmlData = xmlData + "<SPLX>1</SPLX> ";
xmlData = xmlData + "<ZXSPBM>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["ZXSPBM"].Value, "") + "</ZXSPBM> ";
xmlData = xmlData + "<YPKCL>1</YPKCL> ";
xmlData = xmlData + "<KCSL>" + ClsSystem.gnvl(Public.ChinaRound(Public.GetNum(dgv2.Rows[i].Cells["KCSL"].Value), 0), "0") + "</KCSL> ";
xmlData = xmlData + "<KCDW>" + ClsSystem.gnvl(dgv2.Rows[i].Cells["KCDW"].Value, "") + "</KCDW> ";
xmlData = xmlData + "</STRUCT>";
}
xmlData = xmlData + "</DETAIL>";
xmlData = xmlData + "</XMLDATA>";
resultXMl = SendMessage.SetMessage("YQ002", 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 DataSet Qury15(string CXLX, string CXBH)
{
DataSet ds = new DataSet();
try
{
string xmlData = "";
string 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 + "<CXLX>" + CXLX + "</CXLX>";
xmlData = xmlData + "<CXBH>" + CXBH + "</CXBH>";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "</XMLDATA>";
ResultXml = SendMessage.SetMessage("YQ015", xmlData);
TextReader tdr = new StringReader(ResultXml);
ds.ReadXml(tdr);
//if (ds.Tables.Count > 0)
//{
// if (ClsSystem.gnvl(ds.Tables[0].Rows[0]["ZTCLJG"], "") == "00000")
// {
// }
//}
return(ds);
}
catch (Exception ex)
{
return(ds);
throw;
}
}
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 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 + "<FBRQ></FBRQ> ";
xmlData = xmlData + "<YPTBDM>" + textBox1.Text.Trim() + "</YPTBDM> ";
xmlData = xmlData + "</MAIN>";
xmlData = xmlData + "</XMLDATA>";
DataSet ds = SendMessage.QuryData("YQ018", xmlData);
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)
{
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["YPTBDM"].Value = ClsSystem.gnvl(db.Rows[i]["YPTBDM"], "");
dgv2.Rows[i].Cells["PZWH"].Value = ClsSystem.gnvl(db.Rows[i]["PZWH"], "");
dgv2.Rows[i].Cells["BWM"].Value = ClsSystem.gnvl(db.Rows[i]["BWM"], "");
dgv2.Rows[i].Cells["YPTYM"].Value = ClsSystem.gnvl(db.Rows[i]["YPTYM"], "");
dgv2.Rows[i].Cells["JX"].Value = ClsSystem.gnvl(db.Rows[i]["JX"], "");
dgv2.Rows[i].Cells["GG"].Value = ClsSystem.gnvl(db.Rows[i]["GG"], "");
dgv2.Rows[i].Cells["SCQY"].Value = ClsSystem.gnvl(db.Rows[i]["SCQY"], "");
dgv2.Rows[i].Cells["SPM"].Value = ClsSystem.gnvl(db.Rows[i]["SPM"], "");
dgv2.Rows[i].Cells["BZSL"].Value = ClsSystem.gnvl(db.Rows[i]["BZSL"], "");
dgv2.Rows[i].Cells["BZCZ"].Value = ClsSystem.gnvl(db.Rows[i]["BZCZ"], "");
dgv2.Rows[i].Cells["BZFS"].Value = ClsSystem.gnvl(db.Rows[i]["BZFS"], "");
dgv2.Rows[i].Cells["GGBZWZBS"].Value = ClsSystem.gnvl(db.Rows[i]["GGBZWZBS"], "");
dgv2.Rows[i].Cells["JCXXQYRQ"].Value = ClsSystem.gnvl(db.Rows[i]["JCXXQYRQ"], "");
dgv2.Rows[i].Cells["JJDW"].Value = ClsSystem.gnvl(db.Rows[i]["JJDW"], "");
dgv2.Rows[i].Cells["JHJGGZDM"].Value = ClsSystem.gnvl(db.Rows[i]["JHJGGZDM"], "");
dgv2.Rows[i].Cells["JHGZJGJE"].Value = ClsSystem.gnvl(db.Rows[i]["JHGZJGJE"], "");
dgv2.Rows[i].Cells["XSJGGZDM"].Value = ClsSystem.gnvl(db.Rows[i]["XSJGGZDM"], "");
dgv2.Rows[i].Cells["XSGZJGJE"].Value = ClsSystem.gnvl(db.Rows[i]["XSGZJGJE"], "");
dgv2.Rows[i].Cells["WJGZQYRQ"].Value = ClsSystem.gnvl(db.Rows[i]["WJGZQYRQ"], "");
dgv2.Rows[i].Cells["CGFS"].Value = ClsSystem.gnvl(db.Rows[i]["CGFS"], "");
dgv2.Rows[i].Cells["CGZT"].Value = ClsSystem.gnvl(db.Rows[i]["CGZT"], "");
dgv2.Rows[i].Cells["GZYJ"].Value = ClsSystem.gnvl(db.Rows[i]["GZYJ"], "");
dgv2.Rows[i].Cells["YSGZQYRQ"].Value = ClsSystem.gnvl(db.Rows[i]["YSGZQYRQ"], "");
dgv2.Rows[i].Cells["ZSFBRQ"].Value = ClsSystem.gnvl(db.Rows[i]["ZSFBRQ"], "");
}
}
}
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 btnFilter_Click(object sender, EventArgs e)
{
this.strbSQL = new StringBuilder();
if (this.checkBox1.Checked == false && comboBox1.Text.Trim() == "" && comboBox2.Text.Trim() == "" && comboBox3.Text.Trim() == "" && comboBox4.Text.Trim() == "" && comboBox5.Text.Trim() == "" && comboBox6.Text.Trim() == "" && comboBox7.Text.Trim() == "" && this.dtpDJRQ1.Text.Trim() == "" && this.dtpDJRQ2.Text.Trim() == "")
{
MessageBox.Show("请先选择条件", "提示");
return;
}
DateTime dt1 = Convert.ToDateTime(this.dtpDJRQ1.Value.ToShortDateString());
DateTime dt2 = Convert.ToDateTime(this.dtpDJRQ2.Value.ToShortDateString());
TimeSpan span = dt2.Subtract(dt1);
int dayDiff = span.Days + 1;
if (dayDiff >= 60)
{
MessageBox.Show("日期天数不能相差60天以上", "提示");
return;
}
this.strbSQL.Append(@"<?xml version=""1.0"" encoding=""utf-8""?>");
this.strbSQL.Append("<XMLDATA>");
this.strbSQL.Append("<HEAD>");
this.strbSQL.Append("<IP>" + SendMessage.GetIP() + "</IP>");
this.strbSQL.Append("<MAC>" + SendMessage.GetMAC() + "</MAC> ");
this.strbSQL.Append("<BZXX></BZXX> ");
this.strbSQL.Append("</HEAD> ");
this.strbSQL.Append("<MAIN>");
if (this.checkBox1.Checked == false)
{
this.strbSQL.Append("<SFBHZGS>0</SFBHZGS> ");
}
else
{
this.strbSQL.Append("<SFBHZGS>1</SFBHZGS> ");
}
if (this.comboBox1.Text.Trim() != "")
{
this.strbSQL.Append("<YYBM>" + comboBox1.Text + "</YYBM> ");
}
else
{
this.strbSQL.Append("<YYBM></YYBM> ");
}
//if (this.dtpDJRQ1.Checked == true)
//{
this.strbSQL.Append("<QSRQ>" + this.dtpDJRQ1.Value.Year.ToString("0000") + this.dtpDJRQ1.Value.Month.ToString("00") + this.dtpDJRQ1.Value.Day.ToString("00") + "</QSRQ> ");
//}
//else
//{
// this.strbSQL.Append("<QSRQ></QSRQ> ");
//}
//if (this.dtpDJRQ2.Checked == true)
//{
this.strbSQL.Append("<JZRQ>" + this.dtpDJRQ2.Value.Year.ToString("0000") + dtpDJRQ2.Value.Month.ToString("00") + dtpDJRQ2.Value.Day.ToString("00") + "</JZRQ> ");
//}
//else
//{
// this.strbSQL.Append("<JZRQ></JZRQ> ");
//}
if (this.comboBox2.Text.Trim() != "")
{
this.strbSQL.Append("<YPLX>" + comboBox2.Text + "</YPLX> ");
}
else
{
this.strbSQL.Append("<YPLX></YPLX> ");
}
if (this.comboBox3.Text.Trim() != "")
{
this.strbSQL.Append("<CGLX>" + comboBox3.Text + "</CGLX> ");
}
else
{
this.strbSQL.Append("<CGLX></CGLX> ");
}
if (this.comboBox4.Text.Trim() != "")
{
if (comboBox4.Text == "医院自行订单")
{
this.strbSQL.Append("<DDLX>" + YsxtEnum.DDLX.医院自行订单 + "</DDLX> ");
}
else
{
this.strbSQL.Append("<DDLX>" + YsxtEnum.DDLX.托管药库订单 + "</DDLX> ");
}
}
else
{
this.strbSQL.Append("<DDLX></DDLX> ");
}
if (this.comboBox5.Text.Trim() != "")
{
if (comboBox5.Text == "药品类")
{
this.strbSQL.Append("<SPLX>1</SPLX> ");
}
else if (comboBox5.Text == "医用耗材器械类")
{
this.strbSQL.Append("<SPLX>2</SPLX> ");
}
else
{
this.strbSQL.Append("<SPLX>9</SPLX> ");
}
}
else
{
this.strbSQL.Append("<SPLX></SPLX> ");
}
if (this.comboBox6.Text.Trim() != "")
{
if (comboBox6.Text == "医院填报")
{
this.strbSQL.Append("<DDTJFS>1</DDTJFS> ");
}
else
{
this.strbSQL.Append("<DDTJFS>2</DDTJFS> ");
}
}
else
{
this.strbSQL.Append("<DDTJFS></DDTJFS> ");
}
if (this.comboBox7.Text.Trim() != "")
{
this.strbSQL.Append("<DDCLZT>" + comboBox7.Text + "</DDCLZT> ");
}
else
{
this.strbSQL.Append("<DDCLZT></DDCLZT> ");
}
if (this.textBox1.Text.Trim() != "")
{
this.strbSQL.Append("<DDMXBH>" + textBox1.Text + "</DDMXBH> ");
}
else
{
this.strbSQL.Append("<DDMXBH></DDMXBH> ");
}
this.strbSQL.Append("</MAIN> ");
this.strbSQL.Append("</XMLDATA> ");
QueryCondition = strbSQL.ToString();
this.DialogResult = DialogResult.OK;
this.Dispose();
}
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;
}
}
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);
}