From 91d579fd968b97ad8bb629fab576f4e936da6581 Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期三, 03 十一月 2021 16:01:46 +0800
Subject: [PATCH] 工序出站汇报不良品列表，入库功能增加入库前判断；在制品报表，增加递入过滤条件
---
WorkM/流转卡管理/MES_StationOutBillList_Bad.cs | 31 ++++++++++++++++++++++++++++++-
1 files changed, 30 insertions(+), 1 deletions(-)
diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs"
index 1912471..189f440 100644
--- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs"
+++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationOutBillList_Bad.cs"
@@ -622,7 +622,8 @@
int HKeepCol = Fun_GetCol("K3淇濈");
int HSecManagerCol = Fun_GetCol("K3楠屾敹");
int HDeptCol = Fun_GetCol("K3閮ㄩ棬");
- DAL.ClsKf_ProductInBill oClsKf_ProductInBill ;
+ DAL.ClsKf_ProductInBill oClsKf_ProductInBill;
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
//鑾峰彇绯荤粺鍙傛暟
Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
if (oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo) == false)
@@ -639,6 +640,34 @@
MessageBox.Show("浼氳鏈熼棿鏈夐敊璇紒 " + DBUtility.ClsPub.sExeReturnInfo);
return;
}
+ string sHInterID = "";
+ for (int i = 0; i < grdMain.SelectedRows.Count; i++)
+ {
+ sHInterID = sHInterID + "," + DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
+ }
+ if (sHInterID=="")
+ {
+ MessageBox.Show("娌℃湁閫変腑鐨勫崟鎹槑缁嗚锛岃鍏堥�夋嫨瑕佸叆搴撶殑鍗曟嵁锛�", "鎻愮ず");
+ return;
+ }
+ else
+ {
+ DataSet DS = oCn.RunProcReturn("exec h_p_MES_StationOutBillList_Bad_PreProductIn '" + sHInterID + "'", "h_p_MES_StationOutBillList_Bad_PreProductIn", ref DBUtility.ClsPub.sExeReturnInfo);
+ if (DS == null || DS.Tables[0].Rows.Count == 0)
+ {
+ MessageBox.Show("鍏ュ簱鍓嶅垽鏂け璐ワ紒", "鎻愮ず");
+ return;
+ }
+ else
+ {
+ if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1")
+ {
+ MessageBox.Show(DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]));
+ return;
+ }
+ }
+ }
+
Int64 n = 0;
//寰幆 閫変腑琛�
for (int i = 0; i < grdMain.SelectedRows.Count; i++)
--
Gitblit v1.9.1