From 6e1fa4b55b1ae533a544b156541e08cb30e57f36 Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期四, 31 十月 2024 08:51:21 +0800 Subject: [PATCH] 1.投料单判断返工符号改为“*” --- frmMain.cs | 16 +++++++++++----- 1 files changed, 11 insertions(+), 5 deletions(-) diff --git a/frmMain.cs b/frmMain.cs index f5d7e0a..693946e 100644 --- a/frmMain.cs +++ b/frmMain.cs @@ -181,10 +181,12 @@ 'TB_MESTOERP_SLSH', 'TB_MESTOERP_SCDDXD', 'TB_MESTOERP_WLQDBB', - 'TB_MESTOERP_TransferIn' + 'TB_MESTOERP_TransferIn', + 'TB_MESTOERP_WWDDXD', + '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 @@ -238,9 +240,11 @@ 'TB_MESTOERP_SLSH', 'TB_MESTOERP_SCDDXD', 'TB_MESTOERP_WLQDBB', - 'TB_MESTOERP_TransferIn') then 3 + 'TB_MESTOERP_TransferIn', + 'TB_MESTOERP_WWDDXD', + 'TB_MESTOERP_WWCG') 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', @@ -255,7 +259,9 @@ 'TB_MESTOERP_GDRK', 'TB_MESTOERP_SLSH', 'TB_MESTOERP_WLQDBB', - 'TB_MESTOERP_TransferIn') + '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