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 FrmYQ005_Load(object sender, EventArgs e)
{
this.ClearQueryCondition();
DataTable db = new DataTable();
//医院编码
string sql = " select YYMC,YYBM from ysxt_YyBM order by YYBM ";
db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
comboBox1.DataSource = db;
comboBox1.DisplayMember = "YYMC";
comboBox1.ValueMember = "YYBM";
comboBox1.Text = "";
comboBox4.Text = "托管药库订单";
}
private void frmFilter2_Load(object sender, EventArgs e)
{
this.ClearQueryCondition();
DataTable db = new DataTable();
//医院编码
string sql = " select YYMC,YYBM from ysxt_YyBM ";
db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
comboBox1.DataSource = db;
comboBox1.DisplayMember = "YYMC";
comboBox1.ValueMember = "YYBM";
comboBox1.Text = "";
//for (int i = 0; i < db.Rows.Count; i++)
//{
// DataRow row = db.Rows[i];
// this.comboBox1.Items.Add(row["vt_name"].ToString() + "|" + row["vt_ID"].ToString());
//}
//药品剂型
sql = @" select ypjxmc,ypjxbm from ysxt_ypjx";
db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
comboBox2.DataSource = db;
comboBox2.DisplayMember = "ypjxmc";
comboBox2.ValueMember = "ypjxbm";
comboBox2.Text = "";
//采购模式
sql = @" select cgmc,cgbm from ysxt_cgms";
db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
comboBox3.DataSource = db;
comboBox3.DisplayMember = "cgmc";
comboBox3.ValueMember = "cgbm";
comboBox3.Text = "";
//订单处理状态
sql = @" select mc,bm from ysxt_ddclzt";
db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
comboBox7.DataSource = db;
comboBox7.DisplayMember = "mc";
comboBox7.ValueMember = "bm";
comboBox7.Text = "";
}
public static bool GetPass(string caccid, string ddate)
{
string sql = "";
DateTime dt1 = DateTime.Now;
DateTime dt2 = Convert.ToDateTime(ddate);
TimeSpan span = dt1.Subtract(dt2);
int dayDiff = span.Days + 1;
if (dayDiff >= 30)
{
sql = @" update UA_Account_Ex set cFinKind='2' where cAcc_Id='" + caccid + "'";
SqlAccess.ExecuteSql(sql, Program.ConnectionString);
}
sql = @" select cFinKind from UA_Account_Ex where cAcc_Id='" + caccid + "'";
string result = ClsSystem.gnvl(SqlAccess.ExecuteScalar(sql, Program.ConnectionString), "");
if (result == "2")
{
return(true);
}
return(false);
}
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 btnexport_Click(object sender, EventArgs e)
{
try
{
string strSQL = "";
string BWB = "人民币";
string JHDH = "";
string JHDH_old = "";
this.Cursor = Cursors.WaitCursor;
U8Login.clsLogin u8Login = null;
u8Login = APIinterface.GetU8Login();
if (u8Login == null)
{
MessageBox.Show("登陆错误：U8登陆失败,检查是否配置正确", "提示", MessageBoxButtons.OK);
return;
}
cxdb.DefaultView.Sort = "JHDH ASC";
DataTable dt = cxdb.DefaultView.ToTable();
string strMsg = "";
string ddh = "";
string result = "";
int count = 0;
string YYBM = "";
string pdbm = "";
string pdbm_O = "";
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
count = 0;
//if (ClsSystem.gnvl(this.dgv2.Rows[j].Cells["check"].Value, "").ToUpper() == "TRUE")
//{
JHDH = ClsSystem.gnvl(dt.Rows[j]["JHDH"], "");
YYBM = ClsSystem.gnvl(dt.Rows[j]["YYBM"], "");
pdbm = YYBM + "-" + JHDH;
if (pdbm != pdbm_O)
{
count = Convert.ToInt16(SqlAccess.ExecuteScalar(" select count(ID) from so_somain with(nolock) where cdefine14 ='" + pdbm + "'", Program.ConnectionString));
if (count < 1)
{
strMsg = APIinterface.InSO(u8Login, BWB, dt, j);
if (strMsg.IndexOf("错误") > 0)
{
MessageBox.Show(strMsg, "提示", MessageBoxButtons.OK);
this.Cursor = Cursors.Default;
return;
}
else
{
ddh = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select csocode from SO_SOMain with(nolock) where ID =" + strMsg, Program.ConnectionString), "");
result = result + ddh + ",";
}
}
//else
//{
// MessageBox.Show("计划单号:" + JHDH + "已经生成销售订单", "提示", MessageBoxButtons.OK);
// return;
//}
}
// }
pdbm_O = YYBM + "-" + JHDH;
}
}
this.Cursor = Cursors.Default;
if (result != "")
{
MessageBox.Show("生成销售订单成功:" + result, "提示", MessageBoxButtons.OK);
return;
}
else
{
MessageBox.Show("无销售订单成功", "提示", MessageBoxButtons.OK);
return;
}
}
catch (Exception ex)
{
MessageBox.Show("生成失败", "提示", MessageBoxButtons.OK);
this.Cursor = Cursors.Default;
return;
}
}
/// <summary>
/// 生成保存dgv的语句
/// </summary>
/// <param name="dgv"></param>
/// <param name="tbName">表名</param>
/// <param name="conn">连接</param>
/// <returns></returns>
public static string GetUpdateStr(DataGridView dgv, string tbName, SqlConnection conn)
{
string strPKName = dgv.Columns[0].Name;
string strPKCode = "";
//SqlCommand sqlcmd = null;
string strSql = "";
string strInsert = "insert into " + tbName + " (";
//生成插入语句前半部分
for (int i = 1; i < dgv.ColumnCount; i++)
{
if (Convert.ToString(dgv.Columns[i].DataPropertyName) == "")
{
continue;
}
strInsert += dgv.Columns[i].Name + ",";
}
strInsert = strInsert.Substring(0, strInsert.Length - 1);
strInsert = strInsert + ") values (";
for (int i = 0; i < dgv.Rows.Count; i++)
{
strPKCode = Convert.ToString(dgv.Rows[i].Cells[strPKName].Value);
//strPKCode = dgv.Rows[i].Cells[strPKName].Value == null ? null : dgv.Rows[i].Cells[strPKName].Value.ToString();
//sqlcmd = new SqlCommand(string.Format("select {0} from {1} where {2} = '{3}'", strPKName, tbName, strPKName, strPKCode), conn);
//object o = sqlcmd.ExecuteScalar();
//if (o != null && o != System.DBNull.Value && o.ToString() != "")//update
if (Convert.ToInt32(SqlAccess.ExecuteScalar("select " + strPKName + " from " + tbName + " where " + strPKName + " = N'" + strPKCode + "'", conn)) > 0)
{
strSql = strSql + string.Format("update {0} set ", tbName);
for (int j = 1; j < dgv.ColumnCount; j++)
{
if (Convert.ToString(dgv.Columns[j].DataPropertyName) == "")
{
continue;
}
strSql = strSql + dgv.Columns[j].Name + " = " + Public.SqlParm(dgv.Rows[i].Cells[j].Value) + ",";
}
strSql = strSql.Substring(0, strSql.Length - 1);
strSql = strSql + string.Format(" where {0} = N'{1}'\n", strPKName, strPKCode);
}
else//insert
{
strSql = strSql + strInsert;
for (int j = 1; j < dgv.ColumnCount; j++)
{
if (Convert.ToString(dgv.Columns[j].DataPropertyName) == "")
{
continue;
}
strSql = strSql + Public.SqlParm(dgv.Rows[i].Cells[j].Value) + ",";
}
strSql = strSql.Substring(0, strSql.Length - 1);
strSql = strSql + ")\n";
}
}
//判断一下删除的
DataTable dt = SqlAccess.ExecuteSqlDataTable("select " + strPKName + " from " + tbName, conn);
for (int i = 0; i < dt.Rows.Count; i++)
{
strPKCode = Convert.ToString(dt.Rows[i][strPKName]);
if (Public.FindDgvRow(dgv, new string[] { strPKName }, new string[] { strPKCode }, 0, dgv.Rows.Count) == -1)
{
strSql += "delete from " + tbName + " where " + strPKName + " = " + Public.SqlParm(strPKCode) + "\n";
}
}
return(strSql);
}
public static DataTable CheckDataTable(DataTable dt, string tableName, string cHeadKey, string cFlag)
{
// WriteLog.writeLog("校验开始" + DateTime.Now + "tableName" + tableName);
dt.Columns.Add("Flag");//标识
// string cValue = "";
DataTable dtcompare = null;
Hashtable htCompare = new Hashtable();
string cBodyKey = "";
try
{
dtcompare = SqlAccess.ExecuteSqlDataTable(" select distinct cdefine28 from " + tableName + " with(nolock) where cdefine28 like'" + cHeadKey + "%'", ufconnstr_111);
if (dtcompare != null && dtcompare.Rows.Count > 0)
{
foreach (DataRow dr in dtcompare.Rows)
{
htCompare.Add(dr[0].ToString(), "");
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Flag"] = "0";
}
return(dt);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
//判断
cBodyKey = ClsSystem.gnvl(dt.Rows[i]["SERIALKEY"], "");
if (htCompare.ContainsKey(cHeadKey + dt.Rows[i]["SERIALKEY"]))
{
dt.Rows[i]["Flag"] = "1";
// dt.Rows[i]["cFlag"] = "1";
}
else
{
dt.Rows[i]["Flag"] = "0";
}
}
DataView rowfilter1 = new DataView(dt);
rowfilter1.RowFilter = "Flag = '" + cFlag + "'";
rowfilter1.RowStateFilter = DataViewRowState.CurrentRows;
DataTable dts = rowfilter1.ToTable();
return(dts);
}
catch (Exception ex)
{
MessageBox.Show("具体原因是：\n" + ex.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(dt);
}
finally
{
// WriteLog.writeLog("校验结束" + DateTime.Now + "tableName" + tableName);
}
// dt.Columns.Add("Flag");//标识
//// string cValue = "";
// DataTable dt = null;
// string cBodyKey = "";
// try
// {
// dt = new DataTable();
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// //判断
// if (i == 0)
// {
// }
// cBodyKey = ClsSystem.gnvl(dt.Rows[i]["SERIALKEY"], "");
// cValue = ClsSystem.gnvl(SqlAccess.ExecuteScalar(" select cdefine28 from " + tableName + " with(nolock) where cdefine28='" + cHeadKey + cBodyKey + "'", ufconnstr_111), "");
// // dt = ClsSystem.gnvl(SqlAccess.ExecuteSqlDataTable(" select cdefine28 from " + tableName + " with(nolock) where cdefine28 like'" + cHeadKey + "%'", ufconnstr_111), "");
// if (cValue != "")
// {
// dt.Rows[i]["Flag"] = "1";
// // dt.Rows[i]["cFlag"] = "1";
// }
// else
// {
// dt.Rows[i]["Flag"] = "0";
// }
// }
// DataView rowfilter1 = new DataView(dt);
// rowfilter1.RowFilter = "Flag = '" + cFlag + "'";
// rowfilter1.RowStateFilter = DataViewRowState.CurrentRows;
// DataTable dts = rowfilter1.ToTable();
// return dts;
// }
// catch (Exception ex)
// {
// MessageBox.Show("具体原因是：\n" + ex.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return dt;
// }
// finally
// {
// }
}
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;
}
private void btnexport_Click(object sender, EventArgs e)
{
try
{
string strSQL = "";
string BWB = "人民币";
this.Cursor = Cursors.WaitCursor;
U8Login.clsLogin u8Login = null;
u8Login = APIinterface.GetU8Login();
if (u8Login == null)
{
MessageBox.Show("登陆错误：U8登陆失败,检查是否配置正确", "提示", MessageBoxButtons.OK);
return;
}
//cxdb.DefaultView.Sort = "JHDH ASC";
//DataTable dt = cxdb.DefaultView.ToTable();
string strMsg = "";
string ddh = "";
string result = "";
int count = 0;
string YYBM = "";
string DDMXBH = "";
string PSDBM = "";
string sql = "";
string strrq = "";
string strsj = "";
string pdbm = "";
string pdbm_O = "";
string DDTJRQ = "";
DataTable dt = new DataTable();
dt = cxdb;
if (dt.Rows.Count > 0)
{
dt.Columns.Add("Uflag");
for (int i = 0; i < dt.Rows.Count; i++)
{
if (ClsSystem.gnvl(this.dgv2.Rows[i].Cells["check"].Value, "").ToUpper() == "TRUE")
{
YYBM = ClsSystem.gnvl(dt.Rows[i]["YYBM"], "");
PSDBM = ClsSystem.gnvl(dt.Rows[i]["PSDBM"], "");
DDMXBH = ClsSystem.gnvl(dt.Rows[i]["DDMXBH"], "");
sql = @" select count(autoid) from SO_SODetails sd with(nolock) left join so_somain so with(nolock) on sd.id=so.id " +
" where so.cdefine11='" + YYBM + "' and sd.cdefine32='" + PSDBM + "' and sd.cdefine29='" + DDMXBH + "'";
count = Convert.ToInt16(SqlAccess.ExecuteScalar(sql, Program.ConnectionString));
if (count < 1)
{
dt.Rows[i]["Uflag"] = "1";
}
strrq = ClsSystem.gnvl(Public.GetInfo("/", ClsSystem.gnvl(dt.Rows[i]["DDTJRQ"], ""), 1), "");
strsj = ClsSystem.gnvl(Public.GetInfo("/", ClsSystem.gnvl(dt.Rows[i]["DDTJRQ"], ""), 2), "");
dt.Rows[i]["DDTJRQ"] = strrq + strsj;
}
}
dt.DefaultView.Sort = "YYBM ASC,PSDBM ASC,DDTJRQ ASC";
DataTable db = dt.DefaultView.ToTable();
DataView rowfilter = new DataView(db);
rowfilter.RowFilter = "Uflag= '1'";
rowfilter.RowStateFilter = DataViewRowState.CurrentRows;
DataTable dts = rowfilter.ToTable();
for (int j = 0; j < dts.Rows.Count; j++)
{
YYBM = ClsSystem.gnvl(dts.Rows[j]["YYBM"], "");
PSDBM = ClsSystem.gnvl(dts.Rows[j]["PSDBM"], "");
DDTJRQ = ClsSystem.gnvl(dts.Rows[j]["DDTJRQ"], "");
pdbm = YYBM + "-" + PSDBM + "-" + DDTJRQ;
if (pdbm != pdbm_O)
{
strMsg = APIinterface.InSO(u8Login, BWB, dts, j);
if (strMsg.IndexOf("错误") > 0)
{
MessageBox.Show(strMsg, "提示", MessageBoxButtons.OK);
this.Cursor = Cursors.Default;
return;
}
else
{
ddh = ClsSystem.gnvl(SqlAccess.ExecuteScalar("select csocode from SO_SOMain with(nolock) where ID =" + strMsg, Program.ConnectionString), "");
result = result + ddh + ",";
}
}
pdbm_O = YYBM + "-" + PSDBM + "-" + DDTJRQ;
}
}
this.Cursor = Cursors.Default;
if (result != "")
{
MessageBox.Show("生成销售订单成功:" + result, "提示", MessageBoxButtons.OK);
return;
}
else
{
MessageBox.Show("无销售订单", "提示", MessageBoxButtons.OK);
return;
}
}
catch (Exception ex)
{
MessageBox.Show("生成失败", "提示", MessageBoxButtons.OK);
this.Cursor = Cursors.Default;
return;
}
}
/// <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 sql = "";
try
{
sql = @"select inv.cinvcode,inv.cInvName,inv.cCurrencyName,inv.cEnglishName,ex.cidefine8,
inv.cInvStd,inv.cEnterprise ,ex.cidefine1,ex.cidefine2,inv.cFile ,ex.cidefine3,c.cComUnitName, ex.cidefine4
from Inventory inv join Inventory_extradefine ex on inv.cinvcode=ex.cInvCode
join ComputationUnit c on c.cComunitCode=inv.cCAComUnitCode
where isnull(inv.cInvDefine10,'')='' order by inv.cinvcode";
this.Cursor = Cursors.WaitCursor;
if (dgv2.Rows.Count > 0)
{
dgv2.Rows.Clear();
}
DataTable db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
if (db.Rows.Count > 0)
{
for (int i = 0; i < db.Rows.Count; i++)
{
dgv2.Rows.Add();
dgv2.Rows[i].Cells["cinvcode"].Value = ClsSystem.gnvl(db.Rows[i]["cinvcode"], "");
dgv2.Rows[i].Cells["cInvName"].Value = ClsSystem.gnvl(db.Rows[i]["cInvName"], "");
dgv2.Rows[i].Cells["cidefine1"].Value = ClsSystem.gnvl(db.Rows[i]["cidefine1"], "");
dgv2.Rows[i].Cells["cCurrencyName"].Value = ClsSystem.gnvl(db.Rows[i]["cCurrencyName"], "");
dgv2.Rows[i].Cells["cEnglishName"].Value = ClsSystem.gnvl(db.Rows[i]["cEnglishName"], "");
dgv2.Rows[i].Cells["cidefine8"].Value = ClsSystem.gnvl(db.Rows[i]["cidefine8"], "");
dgv2.Rows[i].Cells["cInvStd"].Value = ClsSystem.gnvl(db.Rows[i]["cInvStd"], "");
dgv2.Rows[i].Cells["cEnterprise"].Value = ClsSystem.gnvl(db.Rows[i]["cEnterprise"], "");
dgv2.Rows[i].Cells["cidefine2"].Value = ClsSystem.gnvl(db.Rows[i]["cidefine2"], "");
dgv2.Rows[i].Cells["cFile"].Value = ClsSystem.gnvl(db.Rows[i]["cFile"], "");
dgv2.Rows[i].Cells["cidefine3"].Value = ClsSystem.gnvl(db.Rows[i]["cidefine3"], "");
dgv2.Rows[i].Cells["cComUnitName"].Value = ClsSystem.gnvl(db.Rows[i]["cComUnitName"], "");
dgv2.Rows[i].Cells["cidefine4"].Value = ClsSystem.gnvl(db.Rows[i]["cidefine4"], "");
}
}
this.Cursor = Cursors.Default;
// MessageBox.Show("未上传的存货查询完成", "提示", MessageBoxButtons.OK);
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MessageBox.Show(ex.Message.ToString(), "错误", MessageBoxButtons.OK);
throw;
}
}
private void button6_Click(object sender, EventArgs e)
{
string sql = "";
try
{
// sql = @"select inv.cinvcode,inv.cInvName,inv.cCurrencyName,inv.cEnglishName,ex.cidefine8,
// inv.cInvStd,inv.cEnterprise ,ex.cidefine1,ex.cidefine2,inv.cFile ,ex.cidefine3,c.cComUnitName, ex.cidefine4
// from Inventory inv join Inventory_extradefine ex on inv.cinvcode=ex.cInvCode
// join ComputationUnit c on c.cComunitCode=inv.cCAComUnitCode
// where isnull(inv.cInvDefine10,'')='' order by inv.cinvcode";
sql = @"select top 100 inv.cinvcode ,inv.cinvname, iex.cidefine1,com.cComUnitName , sum( case when isnull(bgspstop,0) =1 or isnull(bstopflag,0) =1 then 0 else ISNULL(iQuantity,0)-isnull(fStopQuantity,0) - ISNULL(fOutQuantity,0) end) AS fAvailQtty
from CurrentStock csk join inventory inv on inv.cinvcode=csk.cinvcode
left join Inventory_extradefine iex on iex.cinvcode=inv.cinvcode
left join ComputationUnit com on com.cComUnitCode=inv.cComUnitCode
where isnull(iex.cidefine1,'')<>''
group by inv.cinvcode ,inv.cinvname,iex.cidefine1 ,com.cComUnitName
having sum( case when isnull(bgspstop,0) =1 or isnull(bstopflag,0) =1 then 0 else ISNULL(iQuantity,0)-isnull(fStopQuantity,0) - ISNULL(fOutQuantity,0) end) <>0 ";
this.Cursor = Cursors.WaitCursor;
if (dgv2.Rows.Count > 0)
{
dgv2.Rows.Clear();
}
DataTable db = SqlAccess.ExecuteSqlDataTable(sql, Program.ConnectionString);
if (db.Rows.Count > 0)
{
for (int i = 0; i < db.Rows.Count; i++)
{
dgv2.Rows.Add();
dgv2.Rows[i].Cells["cinvcode"].Value = ClsSystem.gnvl(db.Rows[i]["cinvcode"], "");
dgv2.Rows[i].Cells["cInvName"].Value = ClsSystem.gnvl(db.Rows[i]["cInvName"], "");
dgv2.Rows[i].Cells["ZXSPBM"].Value = ClsSystem.gnvl(db.Rows[i]["cidefine1"], "");
dgv2.Rows[i].Cells["SPLX"].Value = "药品";
dgv2.Rows[i].Cells["KCSL"].Value = ClsSystem.gnvl(db.Rows[i]["fAvailQtty"], "");
dgv2.Rows[i].Cells["KCDW"].Value = ClsSystem.gnvl(db.Rows[i]["cComUnitName"], "");
}
}
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 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);
}