From 067029eebe79b39451f4683e99cf32205a579e6a Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期五, 03 九月 2021 17:06:18 +0800 Subject: [PATCH] update 优化分页工具排序处理 --- ruoyi-common/src/main/java/com/ruoyi/common/utils/PageUtils.java | 34 +++++++++++++++++----------------- 1 files changed, 17 insertions(+), 17 deletions(-) diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/utils/PageUtils.java b/ruoyi-common/src/main/java/com/ruoyi/common/utils/PageUtils.java index 17a12f1..68167df 100644 --- a/ruoyi-common/src/main/java/com/ruoyi/common/utils/PageUtils.java +++ b/ruoyi-common/src/main/java/com/ruoyi/common/utils/PageUtils.java @@ -61,14 +61,8 @@ pageNum = DEFAULT_PAGE_NUM; } PagePlus<T, K> page = new PagePlus<>(pageNum, pageSize); - if (StringUtils.isNotBlank(orderByColumn)) { - String orderBy = SqlUtil.escapeOrderBySql(orderByColumn); - if ("asc".equals(isAsc)) { - page.addOrder(OrderItem.asc(orderBy)); - } else if ("desc".equals(isAsc)) { - page.addOrder(OrderItem.desc(orderBy)); - } - } + OrderItem orderItem = buildOrderItem(orderByColumn, isAsc); + page.addOrder(orderItem); return page; } @@ -89,23 +83,29 @@ if (pageNum <= 0) { pageNum = DEFAULT_PAGE_NUM; } - // 鍏煎鍓嶇鎺掑簭绫诲瀷 - if ("ascending".equals(isAsc)) { - isAsc = "asc"; - } else if ("descending".equals(isAsc)) { - isAsc = "desc"; - } Page<T> page = new Page<>(pageNum, pageSize); + OrderItem orderItem = buildOrderItem(orderByColumn, isAsc); + page.addOrder(orderItem); + return page; + } + + private static OrderItem buildOrderItem(String orderByColumn, String isAsc) { + // 鍏煎鍓嶇鎺掑簭绫诲瀷 + if ("ascending".equals(isAsc)) { + isAsc = "asc"; + } else if ("descending".equals(isAsc)) { + isAsc = "desc"; + } if (StringUtils.isNotBlank(orderByColumn)) { String orderBy = SqlUtil.escapeOrderBySql(orderByColumn); orderBy = StringUtils.toUnderScoreCase(orderBy); if ("asc".equals(isAsc)) { - page.addOrder(OrderItem.asc(orderBy)); + return OrderItem.asc(orderBy); } else if ("desc".equals(isAsc)) { - page.addOrder(OrderItem.desc(orderBy)); + return OrderItem.desc(orderBy); } } - return page; + return null; } public static <T, K> TableDataInfo<K> buildDataInfo(PagePlus<T, K> page) { -- Gitblit v1.9.3