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/SCGL/Sc_PackUnionBillController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/SCGL/Sc_PackUnionBillController.cs b/WebAPI/Controllers/SCGL/Sc_PackUnionBillController.cs index e5d3b30..870499a 100644 --- a/WebAPI/Controllers/SCGL/Sc_PackUnionBillController.cs +++ b/WebAPI/Controllers/SCGL/Sc_PackUnionBillController.cs @@ -56,11 +56,11 @@ int pageSize = limit; if (sWhere == null || sWhere.Equals("")) { - sWhere = " where 1=1"; + sWhere = " where 1=1 order by hmainid desc "; } else { - sWhere = " where 1=1" + sWhere; + sWhere = " where 1=1" + sWhere+ " order by hmainid desc "; } DataSet ds0 = oCn.RunProcReturn("select count(*) CountNum from h_v_PackUnionBillList "+sWhere+"", "h_v_PackUnionBillList"); -- Gitblit v1.9.1