From 44e0f0472d8efa0646b20db8a40c16beab0b752e Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期六, 06 四月 2024 12:22:12 +0800
Subject: [PATCH] feat: 一些需求改进 打开档案时增加了部门选择项 处理了合同信息录入时的性别不自动填入问题 合同到期提醒模块发布
---
febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java b/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java
index 98ee69a..91aa35e 100644
--- a/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java
+++ b/febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java
@@ -15,4 +15,18 @@
" where allDeptName like #{queryParam}" +
"</script>")
public void changeAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam);
+
+ @Update("<script>" +
+ " update t_emp_baseinfo\n" +
+ " set allDeptName = replace(allDeptName, #{fromName}, #{toName})" +
+ " where allDeptName like #{queryParam}" +
+ "</script>")
+ public void updateEmpAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam);
+
+ @Update("<script>" +
+ " update t_emp_baseinfo \n" +
+ " set deptName = #{newDeptName} \n" +
+ " where deptId = #{queryParam} \n" +
+ "</script>")
+ public void updateEmpDeptName(@Param("newDeptName") String newDeptName,@Param("queryParam") String queryParam);
}
\ No newline at end of file
--
Gitblit v1.8.0