From aa0625b828d0c65fd46f9cffcb4d0df87ca1056f Mon Sep 17 00:00:00 2001 From: lige <bestlige@outlook.com> Date: 星期五, 15 三月 2024 14:22:41 +0800 Subject: [PATCH] 1 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 11 ++++------- 1 files changed, 4 insertions(+), 7 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 bf2e759..3fe9307 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 @@ -41,7 +41,7 @@ @Select("SELECT * FROM histjv_LTKJVTJPAT") public List<LtkjTjPat> getTjPat(); - @DataSource(value = DataSourceType.SLAVE_PACS) + @DataSource(value = DataSourceType.SLAVE_HIS) @Select({"<script> select isnull(fcard_no,'涓嶈') xh,fcard_iD pacCode,pat_name pacName,\n" + " (case when patsex_id='0' then '鐢�' when patsex_id='1' then '濂�' else '鏈煡' end )+';'+brnl detail,\n" + " pat_id price , mobile+tjbz pacRemark" + @@ -55,6 +55,7 @@ " <when test='pacRemark!=null'>" + " AND mobile = #{pacRemark}" + "</when>" + + " order by fcard_iD desc"+ "</script>"}) public List<Map<String,Object>> newGetTjPat(@Param("pacCode")String pacCode, @Param("pacName")String pacName, @@ -167,7 +168,7 @@ - @DataSource(value = DataSourceType.SLAVE_PACS) + @DataSource(value = DataSourceType.SLAVE_LIS) @Select({"<script> select *"+ " from histjv_Ltkj_hyxm where 1=1 "+ " <when test='pacCode!=null'>" + @@ -202,12 +203,8 @@ " <when test='nn!=null'>" + " AND patage+patagename=#{nn}" + "</when>"+ - " <when test='sr!=null'>" + - " AND patbirth=#{sr}" + - "</when>"+ "</script>"}) public List<Map<String,Object>> getTjYxjcList(@Param("patname")String patname, @Param("sex")String sex, - @Param("nn")String nn, - @Param("sr")String sr); + @Param("nn")String nn); } -- Gitblit v1.8.0