From e64578d5a5e827675052dac38214f4c893ed0cc2 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期五, 17 五月 2024 17:15:35 +0800 Subject: [PATCH] 采购管理,销售管理,仓库管理增加日期间隔 方案 --- WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs | 6 ++---- 1 files changed, 2 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs b/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs index 98e3b7f..8281cd6 100644 --- a/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs +++ b/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs @@ -59,10 +59,8 @@ //鍙嶅簭鍒楀寲浼犻�掔殑鍊� CallGoodsBackRequest com = JsonConvert.DeserializeObject<CallGoodsBackRequest>(sWhere.ToString()); - oCN.RunProc($"exec h_p_JIT_BackGoodsRequestBillList_Query '{com.HBeginDate}','{com.HEndDate.AddDays(1).AddSeconds(-1)}','{com.HBillNo}','{com.MaterialNumber}'," + - $"'{com.MaterialName}','{com.MaterialModel}','{com.HDeptName}','{com.ProcMul}','{com.Hmaker}','{com.HOrgID}'"); - - ds = oCN.RunProcReturn("select * from ##h_p_JIT_BackGoodsRequestBillList_Query where 1=1 " + com.Arbitrarily + "", "##h_p_JIT_BackGoodsRequestBillList_Query"); + ds = oCN.RunProcReturn($"exec h_p_JIT_BackGoodsRequestBillList_Query '{com.HBeginDate}','{com.HEndDate.AddDays(1).AddSeconds(-1)}','{com.HBillNo}','{com.MaterialNumber}'," + + $"'{com.MaterialName}','{com.MaterialModel}','{com.HDeptName}','{com.ProcMul}','{com.Hmaker}','{com.HOrgID}'", "h_p_JIT_BackGoodsRequestBillList_Query"); objJsonResult.code = "1"; objJsonResult.count = 1; -- Gitblit v1.9.1