From acb137729948d4e3d5e99864338c203d68993b9d Mon Sep 17 00:00:00 2001 From: 仲国强 <519541279@qq.com> Date: 星期五, 27 八月 2021 16:48:08 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs index df0b009..d576b54 100644 --- a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs +++ b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillController.cs @@ -475,7 +475,11 @@ public static DataSet Sc_MouldConkBookBillList_s(string sWhere) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList ", "h_v_Sc_MouldConkBookBillList"); + if (sWhere != "" || sWhere != null) + { + sWhere = " where 1=1 " + sWhere; + } + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldConkBookBillList "+sWhere+"", "h_v_Sc_MouldConkBookBillList"); } #endregion -- Gitblit v1.9.1