From b622ca077cd6a4e35c1476d497999538b3720e1a Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期四, 25 三月 2021 00:12:54 +0800
Subject: [PATCH] feat(员工其它信息): 员工档案中的其它信息按时间顺序排序
---
febs-server/febs-server-system/src/main/java/cc/mrbird/febs/server/system/mapper/DeptMapper.java | 9 ++++++++-
1 files changed, 8 insertions(+), 1 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 162c4e6..98ee69a 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
@@ -2,10 +2,17 @@
import cc.mrbird.febs.common.core.entity.system.Dept;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Update;
/**
* @author MrBird
*/
public interface DeptMapper extends BaseMapper<Dept> {
-
+ @Update("<script>" +
+ " update t_dept\n" +
+ " set allDeptName = replace(allDeptName, #{fromName}, #{toName})" +
+ " where allDeptName like #{queryParam}" +
+ "</script>")
+ public void changeAllDeptName(@Param("fromName") String fromName, @Param("toName") String toName,@Param("queryParam") String queryParam);
}
\ No newline at end of file
--
Gitblit v1.8.0