From 0c3d07262e46e3efe0b4ea56d905a67c3f30ccd9 Mon Sep 17 00:00:00 2001 From: YL <YL@LAPTOP-SE03PLUR> Date: 星期五, 27 八月 2021 16:46:44 +0800 Subject: [PATCH] nothing --- 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