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