From 80671ec5eca956171492699780d1a3be9d7906d4 Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期四, 28 十月 2021 13:59:35 +0800
Subject: [PATCH] 条码异常查询模块新增删除按钮：可删除缓存中未上传条码记录
---
SCM/条码打印/WMS_BarCodeStatusQuery.cs | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 51 insertions(+), 1 deletions(-)
diff --git "a/SCM/\346\235\241\347\240\201\346\211\223\345\215\260/WMS_BarCodeStatusQuery.cs" "b/SCM/\346\235\241\347\240\201\346\211\223\345\215\260/WMS_BarCodeStatusQuery.cs"
index 8137422..35b42c4 100644
--- "a/SCM/\346\235\241\347\240\201\346\211\223\345\215\260/WMS_BarCodeStatusQuery.cs"
+++ "b/SCM/\346\235\241\347\240\201\346\211\223\345\215\260/WMS_BarCodeStatusQuery.cs"
@@ -419,9 +419,59 @@
SCM.鍏敤绫�.Xt_BaseBillFun.DataToExcel(this.Text, grdMain);
}
+ private void sc_Click(object sender, EventArgs e)
+ {
+ Sub_DeleteBill();
+ }
+ //鍒犻櫎
+ private void Sub_DeleteBill()
+ {
+ Int64 lngBillKey = 0;
+ string HBarCode = "";
+ if (grdMain.CurrentRow == null)
+ return;
+ if (grdMain.SelectedRows.Count != 1)
+ {
+ MessageBox.Show("涓嶅厑璁稿琛屽垹闄わ紝璇烽噸鏂伴�夋嫨缂撳瓨绫诲瀷涓衡�滅紦瀛樷�濈殑閲嶅鏉＄爜锛�");
+ return;
+ }
+
+ if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("妯″潡绫诲瀷")].Value) == "缂撳瓨"
+ && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("鐘舵��")].Value) == "")
+ {
+ if (MessageBox.Show("纭畾瑕佸垹闄ゆ墍閫夋潯鐮佽褰曪紵鍒犻櫎鍚庝笉鑳芥仮澶嶏紝璇疯皑鎱庢搷浣滐紒", "鎻愮ず", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
+ {
+ lngBillKey = DBUtility.ClsPub.isLong(grdMain.SelectedRows[0].Cells[Fun_GetCol("HitemID")].Value);
+ HBarCode = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("鍗曟嵁绫诲瀷")].Value)+ DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("鍗曟嵁鍙�")].Value)+"锛屾潯鐮侊細"+ DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[0].Cells[Fun_GetCol("鏉″舰鐮�")].Value);
+ if (lngBillKey == 0)
+ return;
+
+ try
+ {
+ string[] sSQLMul = new string[2];
+ sSQLMul[0] = "Delete from KF_PonderationBillMain_Temp where HRelationInterID=0 and HitemID =" + lngBillKey;
+ sSQLMul[1] = "Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','鍒犻櫎缂撳瓨涓紓甯搁噸澶嶆潯鐮侊細" + HBarCode + "','WMS绯荤粺-鏉＄爜寮傚父鏌ヨ妯″潡','" + DBUtility.ClsPub.IPAddress + "','鍒犻櫎'";
+
+ oWeb.getRunProcByMul(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo);
+ MessageBox.Show("缂撳瓨鍒楄〃锛�" + HBarCode + " 璁板綍鍒犻櫎鎴愬姛锛�");
+ Display();
+ }
+ catch (Exception e)
+ {
+ throw (e);
+ }
+ }
+ }
+ else
+ {
+ MessageBox.Show("鍙厑璁稿垹闄ゆā鍧楃被鍨嬩负鈥滅紦瀛樷�濓紝鐘舵�佷笉涓衡�滃凡涓婁紶鈥濇潯鐮佽褰曪紒");
+ return;
+ }
+ }
- }
+
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1