From 230d692df99ab549d2441cde683ee591a26e98c0 Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期三, 01 十二月 2021 14:21:00 +0800
Subject: [PATCH] 修改了奥邦快速生成条码模块选择设备出资料的方法

---
 WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs |   24 ++++++++++++------------
 1 files changed, 12 insertions(+), 12 deletions(-)

diff --git a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
index 1bcf03f..5cc79ae 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");
             }
         }
@@ -184,9 +184,9 @@
         /// </summary>
         /// <param name="msg"></param>
         /// <returns></returns>
-        [Route("Sb_EqpRepairWorkBill/SaveGetEqpRepairWorkBillList")]
+        [Route("Sb_EqpRepairWorkBill/SaveGetEqpRepairWorkBillWebList")]
         [HttpPost]
-        public object SaveGetMouldRepairWorkBillList([FromBody] JObject msg)
+        public object SaveGetEqpRepairWorkBillWebList([FromBody] JObject msg)
         {
             var _value = msg["msg"].ToString();
             string msg1 = _value.ToString();
@@ -879,7 +879,7 @@
         }
         #endregion
 
-        #region[璁惧缁翠慨楠屾敹鍒楄〃缂栬緫鏃惰幏鍙栬〃澶存暟鎹甝
+        #region[璁惧鏁呴殰鐧昏鍒楄〃缂栬緫鏃惰幏鍙栬〃澶存暟鎹甝
         [Route("Sb_EqpRepairWorkBill/Sb_EqpConkBookBillListCheckDetai")]
         [HttpGet]
         public ApiResult<DataSet> Sb_EqpConkBookBillListCheckDetai(string HID)
@@ -894,7 +894,7 @@
         }
         #endregion
 
-        #region[璁惧缁翠慨鍒楄〃缂栬緫鏃惰幏鍙栬〃浣撴暟鎹甝
+        #region[璁惧鏁呴殰鐧昏鍒楄〃缂栬緫鏃惰幏鍙栬〃浣撴暟鎹甝
         [Route("Sb_EqpRepairWorkBill/Sb_EqpConkBookBillListProjectDetai")]
         [HttpGet]
         public object Sb_EqpConkBookBillListProjectDetai(string sqlWhere)
@@ -935,9 +935,9 @@
         }
         #endregion
 
-        #region [璁惧缁翠慨鍗曞垹闄ゅ姛鑳絔
+        #region [璁惧鏁呴殰鐧昏鍗曞垹闄ゅ姛鑳絔
         /// <summary>
-        /// 妯″叿缁翠慨鍗曞垹闄ゅ姛鑳�
+        /// 璁惧鏁呴殰鐧昏鍗曞垹闄ゅ姛鑳�
         /// </summary>
         /// <returns></returns>
         [Route("Sb_EqpRepairWorkBill/DeltetEqpConkBookBill")]

--
Gitblit v1.9.1