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