From ff82f8893c6003b06d9d851ab3d346d318e8087a Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 29 十月 2021 19:48:26 +0800 Subject: [PATCH] 设备档案 --- WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs index 29b5852..990976b 100644 --- a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs +++ b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs @@ -63,12 +63,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere, "h_v_Sb_EquipRepairWorkBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairWorkBillList "+sWhere+ "order by hmainid desc", "h_v_Sb_EquipRepairWorkBillList"); } else { string sql1 = "select * from h_v_Sb_EquipRepairWorkBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairWorkBillList"); } @@ -113,12 +113,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairCheckBillList" + sWhere, "h_v_Sb_EquipRepairCheckBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipRepairCheckBillList" + sWhere+ "order by hmainid desc", "h_v_Sb_EquipRepairCheckBillList"); } else { string sql1 = "select * from h_v_Sb_EquipRepairCheckBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipRepairCheckBillList"); } @@ -163,12 +163,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList" + sWhere, "h_v_Sb_EquipConkBookBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sb_EquipConkBookBillList order by hmainid desc" + sWhere, "h_v_Sb_EquipConkBookBillList"); } else { string sql1 = "select * from h_v_Sb_EquipConkBookBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by hmainid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sb_EquipConkBookBillList"); } } -- Gitblit v1.9.1