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