From aa35db32857d9b3f424a8ef06c922fe65ac96210 Mon Sep 17 00:00:00 2001 From: wyb <1qaz@123> Date: 星期三, 26 五月 2021 17:32:37 +0800 Subject: [PATCH] 增加 生产资源 、计量单位、货币设置CRUD逻辑实现 --- 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