From 9d36af31f3646a9ece38f17fcde31f1320d767ec Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期二, 24 六月 2025 13:29:09 +0800
Subject: [PATCH] 增加采购退货
---
frmMain.cs | 36 +++++++++++++++++++++++++++++-------
1 files changed, 29 insertions(+), 7 deletions(-)
diff --git a/frmMain.cs b/frmMain.cs
index 82538e0..38944f9 100644
--- a/frmMain.cs
+++ b/frmMain.cs
@@ -163,11 +163,14 @@
'TB_ERPTOMES_GDRK',
'TB_ERPTOMES_WCK',
'TB_ERPTOMES_CGDH',
- 'TB_ERPTOME_KHWL') then 2
+ 'TB_ERPTOME_KHWL',
+ 'TB_ERPTOMES_XSTH',
+ 'TB_ERPTOMES_CGTH') then 2
when task_name in ('TB_MESTOERP_WGRK',
'TB_MESTOERP_WWRK',
'TB_MESTOERP_QTRK',
'TB_MESTOERP_CPRK',
+ 'TB_MESTOERP_SLTZ',
'TB_MESTOERP_CGRK',
'TB_MESTOERP_XSCK',
'TB_MESTOERP_DD',
@@ -181,10 +184,17 @@
'TB_MESTOERP_SLSH',
'TB_MESTOERP_SCDDXD',
'TB_MESTOERP_WLQDBB',
- 'TB_MESTOERP_TransferIn'
+ 'TB_MESTOERP_TransferIn',
+ 'TB_MESTOERP_WLQDBBV2',
+ 'TB_MESTOERP_WWDDXD',
+ 'TB_MESTOERP_WWCG',
+ 'TB_MESTOERP_WWLL',
+ 'TB_MESTOERP_XSTH',
+ 'TB_MESTOERP_CGTL'
) 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
@@ -222,11 +232,14 @@
'TB_ERPTOMES_GDRK',
'TB_ERPTOMES_WCK',
'TB_ERPTOMES_CGDH',
- 'TB_ERPTOME_KHWL') then 2
+ 'TB_ERPTOME_KHWL',
+ 'TB_ERPTOMES_XSTH',
+ 'TB_ERPTOMES_CGTH') then 2
when task_name in ('TB_MESTOERP_WGRK',
'TB_MESTOERP_WWRK',
'TB_MESTOERP_QTRK',
'TB_MESTOERP_CPRK',
+ 'TB_MESTOERP_SLTZ',
'TB_MESTOERP_CGRK',
'TB_MESTOERP_XSCK',
'TB_MESTOERP_DD',
@@ -238,13 +251,19 @@
'TB_MESTOERP_SLSH',
'TB_MESTOERP_SCDDXD',
'TB_MESTOERP_WLQDBB',
- 'TB_MESTOERP_TransferIn') then 3
+ 'TB_MESTOERP_WLQDBBV2',
+ 'TB_MESTOERP_TransferIn',
+ 'TB_MESTOERP_WWDDXD',
+ 'TB_MESTOERP_WWCG',
+ 'TB_MESTOERP_XSTH',
+ 'TB_MESTOERP_CGTL') then 3
else 4 end gp,*
- from SYSDEC WITH(nolock) where states='FAIL' and retry_times<1 and CREATE_TIME>'2024-06-14 13:13:34' AND descript IN ('楂樺啿鐗╂枡鍙樻洿','鐗╂枡淇℃伅琛�','浠撳簱淇℃伅琛�','閮ㄩ棬淇℃伅琛�','鍛樺伐淇℃伅琛�','鐢熶骇鎶曟枡鍗�','閮ㄩ棬淇℃伅琛�','棰嗘枡鍗�','鎴愬搧鍏ュ簱鍗�','閲囪喘鍏ュ簱鍗�','鐢熶骇璁㈠崟涓嬭揪','鐗╂枡瀹㈡埛瀵瑰簲琛�','閲囪喘璁㈠崟','鍙戣揣閫氱煡鍗�','閿�鍞嚭搴撳崟','鍒嗘璋冨叆鍗�','鐢熶骇棰嗘枡鍗�','鐢熶骇閫�鏂欏崟','鐢熶骇琛ユ枡鍗�','渚涘簲鍟嗕俊鎭〃')
+ from SYSDEC WITH(nolock) where states='FAIL' and retry_times<1 and CREATE_TIME>'2024-06-14 13:13:34' AND descript IN ('鐢ㄦ枡娓呭崟鍙樻洿','楂樺啿鐗╂枡鍙樻洿','鐗╂枡淇℃伅琛�','浠撳簱淇℃伅琛�','閮ㄩ棬淇℃伅琛�','鍛樺伐淇℃伅琛�','鐢熶骇鎶曟枡鍗�','閮ㄩ棬淇℃伅琛�','棰嗘枡鍗�','鎴愬搧鍏ュ簱鍗�','閲囪喘鍏ュ簱鍗�','鐢熶骇璁㈠崟涓嬭揪','鐗╂枡瀹㈡埛瀵瑰簲琛�','閲囪喘璁㈠崟','鍙戣揣閫氱煡鍗�','閿�鍞嚭搴撳崟','鍒嗘璋冨叆鍗�','鐢熶骇棰嗘枡鍗�','鐢熶骇閫�鏂欏崟','鐢熶骇琛ユ枡鍗�','渚涘簲鍟嗕俊鎭〃','濮斿璁㈠崟涓嬭揪','濮斿涓嬫帹閲囪喘')
and task_name not in ('TB_MESTOERP_WGRK',
'TB_MESTOERP_WWRK',
'TB_MESTOERP_QTRK',
'TB_MESTOERP_CPRK',
+ 'TB_MESTOERP_SLTZ',
'TB_MESTOERP_CGRK',
'TB_MESTOERP_XSCK',
'TB_MESTOERP_DD',
@@ -255,7 +274,10 @@
'TB_MESTOERP_GDRK',
'TB_MESTOERP_SLSH',
'TB_MESTOERP_WLQDBB',
- 'TB_MESTOERP_TransferIn')
+ 'TB_MESTOERP_WLQDBBV2',
+ 'TB_MESTOERP_TransferIn',
+ 'TB_MESTOERP_WWDDXD',
+ 'TB_MESTOERP_WWCG')
)
select rtrim(gp)+'-'+rtrim(rank() over(partition by gp order by data)) gcp,* from cte
--
Gitblit v1.9.3