From 1505f2bf41f2e4c4a92fe087bbf1537432c70cfd Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期五, 24 三月 2023 09:57:44 +0800
Subject: [PATCH] 工序派工；工序进出站
---
WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs | 17 ++++++++++++-----
1 files changed, 12 insertions(+), 5 deletions(-)
diff --git a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
index d8fe2f7..eec616b 100644
--- a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
+++ b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
@@ -167,9 +167,19 @@
string sBillNo = sBillBarCode;
//鎴彇鏉＄爜绫诲瀷
string BillNoType = sBillNo.Substring(0, Math.Min(3, sBillNo.Length));
+ //鎴彇鏉＄爜绫诲瀷2
+ string BillNoType2 = sBillNo.Substring(0, Math.Min(4, sBillNo.Length));
//鎴彇鍐呯爜
string BillNo = sBillNo.Substring(3, Math.Min(sBillNo.Length - 3,sBillNo.Length));
-
+ switch (BillNoType2)
+ {
+ case "GXLZ"://宸ュ簭娴佽浆娲惧伐
+ ds = oCN.RunProcReturn("select * from h_v_Sc_ProcExchSendWorkBill where 娲惧伐鍗曟嵁鍙� = '" + sBillNo + "'", "h_v_Sc_ProcExchSendWorkBill");
+ break;
+ case "GXLX"://娴佽浆鍗�
+ ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 鍗曟嵁鍙�= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
+ break;
+ }
switch (BillNoType)
//寰楀埌淇℃伅
{
@@ -234,10 +244,7 @@
break;
case "WLM"://鐗╂枡鐮�
ds = oCN.RunProcReturn("select * from h_v_Gy_MaterialList where HItemID = '" + BillNo + "'", "h_v_Gy_MaterialList");
- break;
- case "GXL"://娴佽浆鍗�
- ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 鍗曟嵁鍙�= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList");
- break;
+ break;
}
//鍐欏叆淇℃伅
--
Gitblit v1.9.1