From f76084c29964fb0bd45c7fd8da2d1837ae995608 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期五, 29 十一月 2024 13:23:40 +0800 Subject: [PATCH] 多人刷卡开工 保存子表 --- WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs | 17 ++++++++++++++++- 1 files changed, 16 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs index 64fb9c4..b2cc2e5 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs @@ -238,7 +238,22 @@ //寰楀埌淇℃伅 { case "HCX"://鐢熶骇璧勬簮鐮� - ds = oCN.RunProcReturn("select * from h_v_Gy_SourceList where 鏉$爜缂栧彿 = '" + BillNo + "'", "h_v_Gy_SourceList"); + case "htt"://鐢熶骇璧勬簮鐮� + + string sErr = ""; + if (oSystemParameter.ShowBill(ref sErr)) + { + if (oSystemParameter.omodel.WMS_CampanyName == "鏉窞鏂帿灏�") + { + ds = oCN.RunProcReturn(@"select s.HItemID,s.HName 鐢熶骇璧勬簮鍚嶇О,s.HNumber from Gy_EquipFileBillMain a + left join Gy_Source s on a.HSourceID = s.HItemID + where HBarCode = '" + BillNo_PGD + "'", "Gy_EquipFileBillMain"); + } + else { + ds = oCN.RunProcReturn("select * from h_v_Gy_SourceList where 鏉$爜缂栧彿 = '" + BillNo + "'", "h_v_Gy_SourceList"); + } + } + break; case "SBM"://璁惧鐮� ds = oCN.RunProcReturn("select * from h_v_Gy_EquipMentList where HItemID = '" + BillNo + "'", "h_v_Gy_EquipMentList"); -- Gitblit v1.9.1