From 872d06b33d8306b826054b044e1b6e58aaacddf0 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 26 十二月 2024 13:24:48 +0800 Subject: [PATCH] 1 --- 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 ffd6a2f..10ac24a 100644 --- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs @@ -46,12 +46,12 @@ if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " order by 涓嶈壇鍘熷洜浠g爜 ", "h_v_IF_BadReasonList"); + ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " ", "h_v_IF_BadReasonList"); } else { string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1"; - string sql = sql1 + sWhere+ " order by 涓嶈壇鍘熷洜浠g爜 "; + string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList"); } -- Gitblit v1.9.1