From fc868e56b1e8199d2c4267fae74c44cfa62a777f Mon Sep 17 00:00:00 2001 From: zjh <zjh@888> Date: 星期三, 31 一月 2024 09:13:51 +0800 Subject: [PATCH] zjh 本地 2024/01/31 -1 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 21 +++++++++++++++++---- 1 files changed, 17 insertions(+), 4 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 c66bf04..f9a4313 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 @@ -47,10 +47,10 @@ " pat_id price , mobile pacRemark" + " from histjv_ltkjvtjpat where 1=1 "+ " <when test='pacCode!=null'>" + - " AND fcard_no = #{pacCode}" + + " AND fcard_no like '%'+#{pacCode}+'%'" + "</when>" + " <when test='pacName!=null'>" + - " AND pat_name = #{pacName}" + + " AND pat_name like '%'+#{pacName}+'%' " + "</when>" + " <when test='pacRemark!=null'>" + " AND mobile = #{pacRemark}" + @@ -81,6 +81,16 @@ @Param("orderId")String orderId, @Param("tjnum")String tjnum, @Param("dockerId")String dockerId); + + @DataSource(value = DataSourceType.MASTER) + @Select("call tj_jc_update_detatil(#{cardId,mode=IN},#{orderId,mode=IN},#{tjnum,mode=IN},#{dockerId,mode=IN})") + public void updateDetailByTjJcCall(@Param("cardId") String cardId, + @Param("orderId")String orderId, + @Param("tjnum")String tjnum, + @Param("dockerId")String dockerId); + + + @DataSource(value = DataSourceType.SLAVE_HIS) @Select("SELECT * FROM histjv_exam_jcbgd") @@ -161,10 +171,10 @@ @Select({"<script> select *"+ " from histjv_Ltkj_hyxm where 1=1 "+ " <when test='pacCode!=null'>" + - " AND pacCode = #{pacCode}" + + " AND pacCode like '%'+#{pacCode}+'%'" + "</when>" + " <when test='pacName!=null'>" + - " AND pacName = #{pacName}" + + " AND pacName like '%'+#{pacName}+'%' " + "</when>" + " <when test='pacRemark!=null'>" + " AND pacRemark = #{pacRemark}" + @@ -174,4 +184,7 @@ @Param("pacName")String pacName, @Param("pacRemark")String pacRemark); + @Select("SELECT * FROM histjv_ltkj_userinfo") + @DataSource(value = DataSourceType.SLAVE_HIS) + public List<LtkjHisUser> getLtkjHisUser(); } -- Gitblit v1.8.0