From c8d8f25fd2b1a5d5db0a59225ee5c7d6795e6f3e Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期二, 07 十二月 2021 18:50:17 +0800
Subject: [PATCH] 雅琪诺报工台切出页面(走工序)
---
WorkM/流转卡管理/MES_StationOutBillList_Bad.cs | 33 +++++++++++++++++++++++++++++++--
1 files changed, 31 insertions(+), 2 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..1756635 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"
@@ -496,7 +496,7 @@
//LOT鍙�
if (txtHBillNo.Text.Trim() != "")
{
- sFastSQL = sFastSQL + " and 娴佽浆鍗″彿 like '%" + txtHBillNo.Text + "%'";
+ sFastSQL = sFastSQL + " and 宸ュ簭娴佽浆鍗″彿 like '%" + txtHBillNo.Text + "%'";
}
//宸ヤ綔涓績
if (txtHCenterID.Text.Trim() != "")
@@ -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