From 19871e8ac9606710b1009f5f86366fb445a7ace8 Mon Sep 17 00:00:00 2001
From: heheng <475597332@qq.com>
Date: 星期三, 09 七月 2025 16:06:20 +0800
Subject: [PATCH] 优化改造sql
---
multi-system/src/main/java/com/gkhy/exam/system/mapper/SysDeptMapper.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 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 dbbfbf4..50fd0f7 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
@@ -63,6 +63,14 @@
public List<SysDept> selectChildrenDeptById(Long deptId);
/**
+ * 过滤掉本身和子级部门
+ * @param deptId
+ * @return
+ */
+
+ List<SysDept> getParentInfo(Long deptId);
+
+ /**
* 根据ID查询所有子部门（正常状态）
*
* @param deptId 部门ID
--
Gitblit v1.9.2