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