From 1dcb0e92cd88c4b26e8fe069ac97fedb8ba38023 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 13 九月 2021 17:27:43 +0800 Subject: [PATCH] 设备保养记录单维护和编辑设备保养记录的功能、设备保养计划单的修改完善 --- WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs index c8fe01b..650b243 100644 --- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs @@ -31,12 +31,12 @@ { 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 " + sWhere+ " order by HItemID desc", "h_v_IF_BadReasonList"); } else { - string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1"; + string sql = sql1 + sWhere+ " order by HItemID desc"; ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList"); } if (ds == null || ds.Tables[0].Rows.Count == 0) -- Gitblit v1.9.1