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