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_MouldRepairOutBillController.cs | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs index f8ad64e..e6cf109 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs @@ -59,12 +59,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairOutBillList " + sWhere, "h_v_Sc_MouldRepairOutBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairOutBillList order by 鏃ユ湡 desc" + sWhere, "h_v_Sc_MouldRepairOutBillList"); } else { string sql1 = "select * from h_v_Sc_MouldRepairOutBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairOutBillList"); } @@ -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; @@ -129,7 +129,7 @@ objJsonResult.data = null; return objJsonResult; } - bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); + bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); if (IsDete) { objJsonResult.code = "1"; -- Gitblit v1.9.1