From d27ce4fecc8eaaf522353f972dc67a5d81b6ea2a Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期六, 21 十二月 2024 09:57:19 +0800
Subject: [PATCH] 1.MESTOERP接口结果校验新增“MES单号唯一检测不通过”判断。--崔
---
HandleData/AE_MES_ERP.cs | 27 ++++++++++++++++++++++-----
1 files changed, 22 insertions(+), 5 deletions(-)
diff --git a/HandleData/AE_MES_ERP.cs b/HandleData/AE_MES_ERP.cs
index abcb346..3a4c58d 100644
--- a/HandleData/AE_MES_ERP.cs
+++ b/HandleData/AE_MES_ERP.cs
@@ -126,9 +126,11 @@
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閲戣澏楂樺啿鐢ㄦ枡鍙樻洿(鍚屾鎺ㄩ��)
+ case "TB_MESTOERP_WLQDBBV2"://MESGCBOM閲戣澏鐢ㄦ枡鍙樻洿(鍚屾鎺ㄩ��)
case "TB_MESTOERP_DD"://MESDD閲戣澏鏉＄爜鍏ュ簱锛堣皟鎷級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_PYPK"://MESPYPK閲戣澏鏉＄爜鍏ュ簱锛堢洏鐩堢洏浜忥級(鍚屾鎺ㄩ��)
case "TB_MESTOERP_LL"://MESLL閲戣澏鏉＄爜鍑哄簱锛堥鏂欏崟锛�(鍚屾鎺ㄩ��)
@@ -1883,11 +1885,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
{
@@ -3147,6 +3159,11 @@
ErrorMsg = res;
return true;
}
+ else if (res.Contains("MES鍗曞彿鍞竴妫�娴嬩笉閫氳繃"))
+ {
+ ErrorMsg = res;
+ return true;
+ }
else
{
ErrorMsg = res;
--
Gitblit v1.9.3