From 96d09d6776cd3d9995bc7f4a40dcf3567abaae5a Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期四, 31 十月 2024 10:03:45 +0800
Subject: [PATCH] 签到登记分割两个事务
---
ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java
index 9740b24..61566d0 100644
--- a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java
+++ b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java
@@ -145,4 +145,14 @@
List<List<?>> getSysDeptHyAndYxYjWjCustomerList13(Map<String,Object> map);
List<ResultSet> getSysDeptYjWjCustomerList2(Map<String,Object> map);
+
+
+ @Select("SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.`status`=0 AND a.org_type=1")
+ List<String> getJyDeptIds();
+
+ @Select("SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.`status`=0 AND a.org_type=2")
+ List<String> getJcDeptIds();
+
+ @Select("SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.`status`=0 AND a.org_type=3")
+ List<String> getCzDeptIds();
}
--
Gitblit v1.8.0