From f35e2bfe37af2efa93ee6c8d986379325bdd0e84 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 10 十二月 2024 09:24:29 +0800
Subject: [PATCH] 1.收料通知单
---
HandleData/AE_MES_ERP.cs | 21 ++++++++++++++++-----
1 files changed, 16 insertions(+), 5 deletions(-)
diff --git a/HandleData/AE_MES_ERP.cs b/HandleData/AE_MES_ERP.cs
index abcb346..fb9785a 100644
--- a/HandleData/AE_MES_ERP.cs
+++ b/HandleData/AE_MES_ERP.cs
@@ -126,6 +126,7 @@
case "TB_MESTOERP_WWRK"://MESWWRK閲戣澏鏉＄爜鍏ュ簱锛堝澶栧叆搴擄級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_QTRK"://MESQTRK閲戣澏鏉＄爜鍏ュ簱锛堝叾浠栧叆搴擄級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_CPRK"://MESCPRK閲戣澏鏉＄爜鍏ュ簱锛堜骇鍝佸叆搴擄級(鍚屾鎺ㄩ��)
+ case "TB_MESTOERP_SLTZ"://MESCPRK閲戣澏锛堟敹鏂欓�氱煡鍗曪級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_CGRK"://MESCPRK閲戣澏鏉＄爜鍏ュ簱锛堥噰璐叆搴擄級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_XSCK"://MESCPRK閲戣澏鏉＄爜鍑哄簱锛堥攢鍞嚭搴擄級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_WLQDBB"://MESGCBOM閲戣澏楂樺啿鐢ㄦ枡鍙樻洿(鍚屾鎺ㄩ��)
@@ -1883,11 +1884,21 @@
if (dr.Table.Columns.Contains("CGAORG"))
{
org = "涓藉痉";
-
- string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid);
- _sqlHelper.ExecuteNonQuery(UP);
- dr["NEWERPID"] = "LD"+dr["ERPID"].ToString();
- IDList.Add("LD"+dr["ERPID"].ToString());
+ dr["NEWERPID"] = "LD" + dr["ERPID"].ToString();
+ IDList.Add("LD" + dr["ERPID"].ToString());
+
+ if (dr["CGA0018"].ToString() == "103")
+ {
+ string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid);
+ _sqlHelper.ExecuteNonQuery(UP);
+
+ string SYSDEC = string.Format(@"UPDATE SYSDEC SET STATES='IGNORE' WHERE task_name='TB_ERPTOMES_CG' AND STATES='NEW' AND TASK_ID ='{0}'", rtaskid);
+ _sqlHelper.ExecuteNonQuery(SYSDEC);
+
+ return true;
+ }
+
+
}
else
{
--
Gitblit v1.9.3