From 777db38816776abbe4b864d26a6c0381b75e8f9d Mon Sep 17 00:00:00 2001
From: 杨乐 <yang.le.192@qq.com>
Date: 星期四, 10 二月 2022 16:59:23 +0800
Subject: [PATCH] 修改页码及排序

---
 WebAPI/Controllers/工资管理/Pay_OtherBalBillController.cs |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs"
index 3fa3f10..5eb3289 100644
--- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs"
+++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_OtherBalBillController.cs"
@@ -24,7 +24,7 @@
         public DLL.ClsPay_OtherBalBill BillOld0 = new DLL.ClsPay_OtherBalBill();   //    
 
         /// <summary>
-        /// 杩斿洖宸ヨ祫缁撶畻涓汉鍒楄〃
+        /// 杩斿洖宸ヨ祫缁撶畻涓汉鍒楄〃(鍏朵粬)
         ///鍙傛暟锛歴tring sql銆�
         ///杩斿洖鍊硷細object銆�
         /// </summary>
@@ -63,12 +63,12 @@
         {
             if (sWhere == null || sWhere.Equals(""))
             {
-                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_OtherBalBillList order by 鏃ユ湡 desc", "h_v_Pay_OtherBalBillList");
+                return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Pay_OtherBalBillList order by hmainid desc", "h_v_Pay_OtherBalBillList");
             }
             else
             {
                 string sql1 = "select * from h_v_Pay_OtherBalBillList where 1 = 1 ";
-                string sql = sql1 + sWhere + "order by 鏃ユ湡 desc";
+                string sql = sql1 + sWhere + " order by hmainid desc";
                 return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Pay_OtherBalBillList");
             }
 

--
Gitblit v1.9.1