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 |   16 ++++++++++++++++
 1 files changed, 16 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..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
@@ -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