From 6b317b0899f680d658180bb1b0619c36f7341fef Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 18 六月 2021 10:10:35 +0800
Subject: [PATCH] 生产开工单

---
 WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs
index c8fe01b..aeba8ab 100644
--- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs
@@ -31,11 +31,11 @@
             {
                 if (sWhere == null || sWhere.Equals(""))
                 {
-                    ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere, "h_v_IF_BadReasonList");
+                    ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList where 绂佺敤鏍囪='' " + sWhere, "h_v_IF_BadReasonList");
                 }
                 else
                 {
-                    string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1 ";
+                    string sql1 = "select * from h_v_IF_BadReasonList where 绂佺敤鏍囪='' ";
                     string sql = sql1 + sWhere;
                     ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList");
                 }

--
Gitblit v1.9.1