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