From c058d5c799e122ed77da81dfe37bf877300b9b5d Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 08 十月 2021 17:48:31 +0800 Subject: [PATCH] 测试器具 --- WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs index 226c981..c3efce4 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs @@ -59,12 +59,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldProdInHouseBillList " + sWhere, "h_v_Sc_MouldProdInHouseBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldProdInHouseBillList order by 鏃ユ湡 desc " + sWhere, "h_v_Sc_MouldProdInHouseBillList"); } else { string sql1 = "select * from h_v_Sc_MouldProdInHouseBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList"); } @@ -113,7 +113,7 @@ objJsonResult.data = null; return objJsonResult; } - if (oBill.omodel.HChecker != "") + if (oBill.omodel.HChecker != ""&& oBill.omodel.HChecker !=null) { objJsonResult.code = "0"; objJsonResult.count = 0; -- Gitblit v1.9.1