From c42f62b32bac302a7ac9fcde7489f7c5fc6e11aa Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 06 十二月 2024 15:35:17 +0800 Subject: [PATCH] zjh20241205-3 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java | 17 ++++++++++++++--- 1 files changed, 14 insertions(+), 3 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java index b1fab3a..09d8492 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java @@ -8,6 +8,7 @@ import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd; import com.ltkj.hosp.sqlDomain.LtkjHysqd; import org.apache.ibatis.annotations.*; +import org.springframework.beans.factory.annotation.Qualifier; import java.util.List; import java.util.Map; @@ -24,8 +25,8 @@ @Select ("SELECT * FROM ltkj_exam_jcsqd a WHERE a.tjh=#{tjh} AND a.tmh=#{tmh} ") LtkjExamJcsqd getLtkjJcsqdByTjhAndTmh(@Param("tjh") String tjh,@Param("tmh") String tmh); - @Delete ("DELETE FROM ltkj_exam_jcsqd WHERE tjh=#{tjh} AND tmh=#{tmh} ") - void deletedLtkjJcsqdByTjhAndTmh(@Param("tjh")String tjh,@Param("tmh")String tmh); + @Delete ("DELETE FROM ltkj_exam_jcsqd WHERE tjh=#{tjh}") + void deletedLtkjJcsqdByTjhAndTmh(@Param("tjh")String tjh); @Select("SELECT * FROM ltkj_exam_jcsqd a WHERE a.tjh=#{tjh}") List<LtkjExamJcsqd> getLtkjJcsqdByTjh(String tjh); @@ -37,7 +38,17 @@ "FROM ltkj_exam_jcbgd a WHERE a.tjh=#{tjh} GROUP BY a.xmmc") void saveLtkjExamJcsqd(String tjh); + @Select("SELECT a.tjh,a.tmh,NULL jclx,NULL jczlx,a.shysxm bgys,a.shysdm bgysid,a.sqsj,a.zdsj jgsj, a.xmmc jcxmmc,a.xmdm jcxmid,a.jcbw bw," + + "a.yxzd jgzt,a.yxbx jgbx FROM ltkj_exam_jcbgd a WHERE a.tjh=#{tjh} GROUP BY a.xmmc") + List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh); + @DataSource(value = DataSourceType.SLAVE_HIS) - List<Map<String, Object>> getTjJcProByHisCall(Map<String, Object> map); + @Qualifier (value = "slaveHisDataSource") + List<Map<String, Object>> getTjJcProByHisCall(@Param("ksmc") String ksmc, + @Param("str_in")String strIn, + @Param("brid")String brid, + @Param("pagecount")int pagecount, + @Param("page")int page, + @Param("status")String status); } -- Gitblit v1.8.0