From ab795dcf9b4783682fbb85c37d5c20b2b9006a86 Mon Sep 17 00:00:00 2001
From: heheng <475597332@qq.com>
Date: Wed, 09 Jul 2025 09:49:33 +0800
Subject: [PATCH] 优化改造sql
---
multi-system/src/main/java/com/gkhy/exam/system/service/impl/SysDeptServiceImpl.java | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/SysDeptServiceImpl.java b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/SysDeptServiceImpl.java
index 6b941f5..8f934d1 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/SysDeptServiceImpl.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/SysDeptServiceImpl.java
@@ -19,6 +19,7 @@
import com.gkhy.exam.system.domain.SysDeptManage;
import com.gkhy.exam.system.domain.SysDeptResponsibility;
import com.gkhy.exam.system.domain.SysFunctionalDistribution;
+import com.gkhy.exam.system.domain.req.SysDeptPageReq;
import com.gkhy.exam.system.domain.vo.*;
import com.gkhy.exam.system.mapper.SysDeptMapper;
import com.gkhy.exam.system.mapper.SysDeptResponsibilityMapper;
@@ -60,9 +61,11 @@
,"10.2", "10.3"};
@Override
- public CommonPage selectDeptPageList(SysDept req) {
+ public CommonPage selectDeptPageList(SysDeptPageReq req) {
+
PageUtils.startPage();
- List<DeptVo> deptVos = deptMapper.selectDeptList(req);
+
+ List<DeptVo> deptVos = deptMapper.selectDeptPageList(req);
if (ObjectUtil.isNotEmpty(deptVos)){
for (DeptVo deptVo : deptVos) {
List<CaluseVO1> caluseVO1List = deptVo.getCaluseVO1List();
@@ -72,11 +75,8 @@
}
}
- int i = deptMapper.selectDeptListCount(req);
+
CommonPage<DeptVo> deptVoCommonPage = CommonPage.restPage(deptVos);
- int totalPage = (int) Math.ceil((double) i / deptVoCommonPage.getPageSize());
- deptVoCommonPage.setTotalPage(totalPage);
- deptVoCommonPage.setTotal(Long.valueOf( i));
return deptVoCommonPage;
}
--
Gitblit v1.9.2