From f35e2bfe37af2efa93ee6c8d986379325bdd0e84 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 10 十二月 2024 09:24:29 +0800
Subject: [PATCH] 1.收料通知单
---
frmMain.cs | 5 ++++-
HandleData/AE_MES_ERP.cs | 1 +
2 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/HandleData/AE_MES_ERP.cs b/HandleData/AE_MES_ERP.cs
index 94f0168..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閲戣澏楂樺啿鐢ㄦ枡鍙樻洿(鍚屾鎺ㄩ��)
diff --git a/frmMain.cs b/frmMain.cs
index 693946e..38a4bc2 100644
--- a/frmMain.cs
+++ b/frmMain.cs
@@ -168,6 +168,7 @@
'TB_MESTOERP_WWRK',
'TB_MESTOERP_QTRK',
'TB_MESTOERP_CPRK',
+ 'TB_MESTOERP_SLTZ',
'TB_MESTOERP_CGRK',
'TB_MESTOERP_XSCK',
'TB_MESTOERP_DD',
@@ -186,7 +187,7 @@
'TB_MESTOERP_WWCG'
) then 3
else 4 end gp,*
- from SYSDEC WITH(nolock) where states='NEW' AND descript IN ('楂樺啿鐗╂枡鍙樻洿','鐗╂枡淇℃伅琛�','浠撳簱淇℃伅琛�','閮ㄩ棬淇℃伅琛�','鍛樺伐淇℃伅琛�','閮ㄩ棬淇℃伅琛�','棰嗘枡鍗�','鎴愬搧鍏ュ簱鍗�','閲囪喘鍏ュ簱鍗�','鐢熶骇璁㈠崟涓嬭揪','鐗╂枡瀹㈡埛瀵瑰簲琛�','閲囪喘璁㈠崟','鍙戣揣閫氱煡鍗�','閿�鍞嚭搴撳崟','鐢熶骇棰嗘枡鍗�','鍒嗘璋冨叆鍗�','鐢熶骇閫�鏂欏崟','鐩存帴璋冩嫧鍗�','鐢熶骇琛ユ枡鍗�','濮斿璁㈠崟','鍏朵粬鍏ュ簱鍗�','鍏朵粬鍑哄簱鍗�','渚涘簲鍟嗕俊鎭〃','濮斿璁㈠崟涓嬭揪','濮斿涓嬫帹閲囪喘')
+ from SYSDEC WITH(nolock) where states='NEW' AND descript IN ('楂樺啿鐗╂枡鍙樻洿','鐗╂枡淇℃伅琛�','浠撳簱淇℃伅琛�','閮ㄩ棬淇℃伅琛�','鍛樺伐淇℃伅琛�','閮ㄩ棬淇℃伅琛�','棰嗘枡鍗�','鎴愬搧鍏ュ簱鍗�','閲囪喘鍏ュ簱鍗�','鏀舵枡閫氱煡鍗�','鐢熶骇璁㈠崟涓嬭揪','鐗╂枡瀹㈡埛瀵瑰簲琛�','閲囪喘璁㈠崟','鍙戣揣閫氱煡鍗�','閿�鍞嚭搴撳崟','鐢熶骇棰嗘枡鍗�','鍒嗘璋冨叆鍗�','鐢熶骇閫�鏂欏崟','鐩存帴璋冩嫧鍗�','鐢熶骇琛ユ枡鍗�','濮斿璁㈠崟','鍏朵粬鍏ュ簱鍗�','鍏朵粬鍑哄簱鍗�','渚涘簲鍟嗕俊鎭〃','濮斿璁㈠崟涓嬭揪','濮斿涓嬫帹閲囪喘')
--and task_name='TB_ERPTOMES_CG'
order by create_time
union all
@@ -229,6 +230,7 @@
'TB_MESTOERP_WWRK',
'TB_MESTOERP_QTRK',
'TB_MESTOERP_CPRK',
+ 'TB_MESTOERP_SLTZ',
'TB_MESTOERP_CGRK',
'TB_MESTOERP_XSCK',
'TB_MESTOERP_DD',
@@ -249,6 +251,7 @@
'TB_MESTOERP_WWRK',
'TB_MESTOERP_QTRK',
'TB_MESTOERP_CPRK',
+ 'TB_MESTOERP_SLTZ',
'TB_MESTOERP_CGRK',
'TB_MESTOERP_XSCK',
'TB_MESTOERP_DD',
--
Gitblit v1.9.3