From edd6968aa0f62dce0229f6addb8a0762696eed0d Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 28 十一月 2024 16:49:50 +0800
Subject: [PATCH] 2024-11-28

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java |   18 +++++++++++++++++-
 1 files changed, 17 insertions(+), 1 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 3fe9307..3465685 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);
 
@@ -207,4 +207,20 @@
     public List<Map<String,Object>> getTjYxjcList(@Param("patname")String patname,
                                                   @Param("sex")String sex,
                                                   @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);
 }

--
Gitblit v1.8.0