From 83fbc58aa801c13224dca4cd628d93e4cc5f656e Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期二, 30 一月 2024 17:00:10 +0800
Subject: [PATCH] zjh 本地 2024/01/30 -1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHisUserService.java | 8 ++++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHisUserMapper.java | 14 +++++++
ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHisUser.java | 29 ++++++++++++++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHisUserServiceImpl.java | 22 +++++++++++
ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java | 19 +++++++++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 3 +
6 files changed, 94 insertions(+), 1 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
index 8fac456..34c0ce9 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
@@ -75,6 +75,8 @@
private ITjOrderService orderService;
@Resource
private ISysDeptService deptService;
+ @Resource
+ private LtkjHisUserService hisUserService;
@GetMapping("/getTjHyBgList")
@ApiOperation(value = "鏌ヨlis鏁版嵁搴撻」鐩俊鎭帴鍙�")
@@ -333,5 +335,20 @@
}
-
+ @GetMapping("/getLtkjHisUser")
+ @ApiOperation(value = "鍚屾his鐢ㄦ埛")
+ public AjaxResult getLtkjHisUser() {
+ List<LtkjHisUser> list = testMapper.getLtkjHisUser();
+ if(null !=list && list.size()>0){
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ for (LtkjHisUser user : list) {
+ LtkjHisUser hisUser= hisUserService.getHisUserByHisGh(user.getHisgh());
+ if(null == hisUser){
+ hisUserService.save(user);
+ }
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ }
+ return AjaxResult.success();
+ }
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHisUserMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHisUserMapper.java
new file mode 100644
index 0000000..647c31b
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHisUserMapper.java
@@ -0,0 +1,14 @@
+package com.ltkj.hosp.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.hosp.sqlDomain.LtkjHisUser;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
+
+
+@Mapper
+public interface LtkjHisUserMapper extends BaseMapper<LtkjHisUser> {
+
+ @Select("SELECT * FROM ltkj_his_user a WHERE a.hisgh=#{hisgh}")
+ LtkjHisUser getHisUserByHisGh(String hisgh);
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
index 189f319..f9a4313 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
@@ -184,4 +184,7 @@
@Param("pacName")String pacName,
@Param("pacRemark")String pacRemark);
+ @Select("SELECT * FROM histjv_ltkj_userinfo")
+ @DataSource(value = DataSourceType.SLAVE_HIS)
+ public List<LtkjHisUser> getLtkjHisUser();
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHisUserService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHisUserService.java
new file mode 100644
index 0000000..6ef65a9
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHisUserService.java
@@ -0,0 +1,8 @@
+package com.ltkj.hosp.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ltkj.hosp.sqlDomain.LtkjHisUser;
+
+public interface LtkjHisUserService extends IService<LtkjHisUser> {
+ LtkjHisUser getHisUserByHisGh(String hisgh);
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHisUserServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHisUserServiceImpl.java
new file mode 100644
index 0000000..556159c
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHisUserServiceImpl.java
@@ -0,0 +1,22 @@
+package com.ltkj.hosp.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ltkj.common.annotation.RepeatSubmit;
+import com.ltkj.hosp.mapper.LtkjHisUserMapper;
+import com.ltkj.hosp.service.LtkjHisUserService;
+import com.ltkj.hosp.sqlDomain.LtkjHisUser;
+import org.springframework.stereotype.Service;
+
+import javax.annotation.Resource;
+
+@Service
+public class LtkjHisUserServiceImpl extends ServiceImpl<LtkjHisUserMapper, LtkjHisUser> implements LtkjHisUserService {
+
+ @Resource
+ private LtkjHisUserMapper mapper;
+
+ @Override
+ public LtkjHisUser getHisUserByHisGh(String hisgh) {
+ return mapper.getHisUserByHisGh(hisgh);
+ }
+}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHisUser.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHisUser.java
new file mode 100644
index 0000000..2b447d8
--- /dev/null
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHisUser.java
@@ -0,0 +1,29 @@
+package com.ltkj.hosp.sqlDomain;
+
+import com.ltkj.common.annotation.DataSource;
+import lombok.Data;
+
+@Data
+public class LtkjHisUser {
+
+ private String id;
+ private String hisgh;
+ private String xb;
+ private String sfzh;
+ private String dh;
+ private String ybbm;
+ private String zgzh;
+ private String zc;
+ private String ksdm;
+ private String ksmc;
+ private String qmtp;
+ private String rylx;
+ private String ryzt;
+ private String csrq;
+ private String ghzlbm;
+ private String ghzlmc;
+ private String czykl;
+ private String czyjj;
+ private String zsmc;
+
+}
--
Gitblit v1.8.0