From 99cc85c6c883041416b725b3e8c7964cb8b0fbf1 Mon Sep 17 00:00:00 2001 From: 仲国强 <519541279@qq.com> Date: 星期一, 30 八月 2021 17:19:45 +0800 Subject: [PATCH] 质量汇报扫码 --- 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