From b6ec9700dda9dfa2530ddd9aac3c992acd9e5af2 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期日, 01 十二月 2024 21:32:56 +0800
Subject: [PATCH] zjh20241201-1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 31 +++++++++++++++++++++++++------
1 files changed, 25 insertions(+), 6 deletions(-)
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 55f6441..1971cac 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
@@ -30,7 +30,7 @@
@Select("SELECT * FROM histjv_Ltkj_middle_head")
public List<LtkjMiddleHead> getMiddleHead();
- @DataSource(value = DataSourceType.SLAVE_LIS)
+ @DataSource(value = DataSourceType.SLAVE_HIS)
@Select("SELECT * FROM histjv_Ltkj_middle_head where fead_id=#{partId}")
public LtkjMiddleHead getMiddleHeadByPartId(String partId);
@@ -55,6 +55,7 @@
" <when test='pacRemark!=null'>" +
" AND mobile = #{pacRemark}" +
"</when>" +
+ " order by fcard_iD desc"+
"</script>"})
public List<Map<String,Object>> newGetTjPat(@Param("pacCode")String pacCode,
@Param("pacName")String pacName,
@@ -202,12 +203,30 @@
" <when test='nn!=null'>" +
" AND patage+patagename=#{nn}" +
"</when>"+
- " <when test='sr!=null'>" +
- " AND patbirth=#{sr}" +
- "</when>"+
"</script>"})
public List<Map<String,Object>> getTjYxjcList(@Param("patname")String patname,
@Param("sex")String sex,
- @Param("nn")String nn,
- @Param("sr")String sr);
+ @Param("nn")String nn);
+
+ @DataSource(value = DataSourceType.SLAVE_PACS)
+ @Select({"<script>" +
+ "select * from V_JCBGLBHIS where mzh is not null " +
+ "<when test='name != null'>" +
+ "and name = #{name}" +
+ "</when>" +
+ "<when test='mzh != null'>" +
+ "and mzh = #{mzh}" +
+ "</when>" +
+ "<when test='start != null and end != null'>" +
+ "and examinationDate between #{start} and #{end}" +
+ "</when>" +
+ "order by examinationDate" +
+ "</script>"})
+ List<Map<String ,Object>> getPacsJcList(@Param("name")String name,@Param("mzh")String mzh,@Param("start")String start,@Param("end")String end);
+
+
+
+ @DataSource(value = DataSourceType.SLAVE_LIS)
+ @Select("SELECT * FROM vi_his_patientresult LIMIT 10")
+ List<Map<String, Object>> getCcXZxYyLisJgSt();
}
--
Gitblit v1.8.0