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 |   22 ++++++++++++++++++++++
 1 files changed, 22 insertions(+), 0 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 5d45f06..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
@@ -207,4 +207,26 @@
     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);
+
+
+
+    @DataSource(value = DataSourceType.SLAVE_LIS)
+    @Select("SELECT * FROM vi_his_patientresult LIMIT 10")
+    List<Map<String, Object>> getCcXZxYyLisJgSt();
 }

--
Gitblit v1.8.0