From 235926cb04611850fda9ed9507704e3a73fd98fc Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 18 十月 2021 11:06:29 +0800 Subject: [PATCH] 器具管理所有页面列表加上排序 --- WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs index f847731..ac6c55c 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs @@ -69,12 +69,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairChangeBillList " + sWhere, "h_v_Sc_MouldRepairChangeBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairChangeBillList " + sWhere + "order by 鏃ユ湡 desc", "h_v_Sc_MouldRepairChangeBillList"); } else { string sql1 = "select * from h_v_Sc_MouldRepairChangeBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairChangeBillList"); } -- Gitblit v1.9.1