From 2b2763c83e352f8ffd2ac0b5c46b60c49ee78439 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期二, 13 五月 2025 14:26:33 +0800
Subject: [PATCH] 2025-05-13
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 39 ++++++++++++++++++++++++++++-----------
1 files changed, 28 insertions(+), 11 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 a6846ab..0c626e7 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
@@ -217,22 +217,36 @@
@Param("nn")String nn);
@DataSource(value = DataSourceType.SLAVE_PACS)
- @Select({"<script>" +
- "select * from V_JCBGLBHIS where mzh is not null " +
- "and (mzh = #{mzh} or name like '%' + #{name} + '%' )" +
- "order by examinationDate" +
+// @Select({"<script>" +
+// "select * from V_JCBGLBHIS where mzh is not null " +
+// "and (mzh = #{mzh} or name = #{name} )" +
+// "order by examinationDate" +
+// "</script>"})
+ @Select({"<script>",
+ "SELECT * FROM V_JCBGLBHIS ",
+ "WHERE name = #{name} ",
+ "<if test='mzh != null and mzh != \"\"'>",
+ " OR mzh = #{mzh} ",
+ "</if>",
+ "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);
+ 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_HIS)
- @Select({"<script>" +
- "select * from V_JYBGHIS where mzh is not null " +
- "and (mzh = #{mzh} or name like '%' + #{name} + '%' )" +
- "order by examinationDate" +
+// @Select({"<script>" +
+// "select * from V_JYBGHIS where mzh is not null " +
+// "and (mzh = #{mzh} or name = #{name} )" +
+// "order by examinationDate" +
+// "</script>"})
+ @Select({"<script>",
+ "select * from V_JYBGHIS where name = #{name}",
+ "<if test='mzh != null and mzh != \"\"'>",
+ " OR mzh = #{mzh} ",
+ "</if>",
+ "order by examinationDate",
"</script>"})
List<Map<String ,Object>> getLisJyList(@Param("name")String name,@Param("mzh")String mzh,@Param("start")String start,@Param("end")String end);
-
-
@DataSource(value = DataSourceType.SLAVE_LIS)
@Select("select t.* from vi_his_patientresult t \n" +
@@ -438,4 +452,7 @@
@DataSource(value = DataSourceType.MASTER)
@Select("call tj_bingzhongtongji(#{p_start,mode=IN},#{p_end,mode=IN})")
List<Map<String ,Object>> getBingZhongInfo(@Param("p_start") String start,@Param("p_end") String end);
+
+ @Select("select * from v_gnkssctp where gnlx=#{gnlx}")
+ List<Map<String ,Object>> getExeUploadImgListByGnLx(@Param("gnlx") String gnlx);
}
--
Gitblit v1.8.0