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