From 2436c46d344236852b1a5e7bfabc36f97a6f143a Mon Sep 17 00:00:00 2001 From: 沈泽 <211959439@qq.com> Date: 星期四, 14 十月 2021 08:30:32 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs index fd9c40d..3a2c3dd 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs @@ -109,12 +109,12 @@ { if (sWhere == null || sWhere.Equals("")) { - return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList ", "h_v_Sc_MouldOtherOutBillList"); + return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldOtherOutBillList order by 鏃ユ湡 desc", "h_v_Sc_MouldOtherOutBillList"); } else { string sql1 = "select * from h_v_Sc_MouldOtherOutBillList where 1 = 1 "; - string sql = sql1 + sWhere; + string sql = sql1 + sWhere+ "order by 鏃ユ湡 desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldOtherOutBillList"); } @@ -130,8 +130,7 @@ if (string.IsNullOrEmpty(HID)) return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" }; SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - - var dataSet = oCN.RunProcReturn("select top 1 * from where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList"); + var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldOtherOutBillList where hmainid= " + HID + " ", "h_v_Sc_MouldOtherOutBillList"); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄩ��搴撳崟鍙�" }; -- Gitblit v1.9.1