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/mapper/SysDeptMapper.java | 19 +++++++++++++++++--
1 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/mapper/SysDeptMapper.java b/multi-system/src/main/java/com/gkhy/exam/system/mapper/SysDeptMapper.java
index 8b72534..dbbfbf4 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/mapper/SysDeptMapper.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/mapper/SysDeptMapper.java
@@ -2,6 +2,9 @@
import com.gkhy.exam.common.domain.entity.SysDept;
+import com.gkhy.exam.system.domain.SysDeptManage;
+import com.gkhy.exam.system.domain.req.SysDeptPageReq;
+import com.gkhy.exam.system.domain.vo.DeptVo;
import org.apache.ibatis.annotations.Param;
import java.util.List;
@@ -19,7 +22,13 @@
* @param dept 部门信息
* @return 部门信息集合
*/
- public List<SysDept> selectDeptList(SysDept dept);
+ public List<DeptVo> selectDeptList(SysDept dept);
+
+
+ public List<DeptVo> selectDeptPageList(SysDeptPageReq dept);
+
+
+ int selectDeptListCount(SysDept dept);
/**
*
@@ -84,7 +93,7 @@
* @param parentId 父部门ID
* @return 结果
*/
- public SysDept checkDeptNameUnique(@Param("deptName") String deptName, @Param("parentId") Long parentId);
+ public SysDept checkDeptNameUnique(@Param("companyId") Long companyId,@Param("deptName") String deptName, @Param("parentId") Long parentId);
/**
* 新增部门信息
@@ -124,4 +133,10 @@
* @return 结果
*/
public int deleteDeptById(Long deptId);
+
+
+ int insetMangeBatch(List<SysDeptManage> sysDeptManages);
+ int deleteMangeBatch(long deptId);
+
+ List<SysDeptManage> getAllManage(long deptId);
}
--
Gitblit v1.9.2