From db86fa075e9c9d88e5a74b85696cabfae6bd70b0 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期二, 29 四月 2025 10:32:11 +0800 Subject: [PATCH] 登记增加外国人身份证判断 --- ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java | 13 +++++++++++++ 1 files changed, 13 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..4dac7d2 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,17 @@ 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(); + + @Select("SELECT e.dept_name FROM sys_dept e WHERE e.dept_id=#{deptId}") + String getprentks(String deptId); } -- Gitblit v1.8.0