From 3c6095c6e3f55f3371ba063aefc104a28ce7fd15 Mon Sep 17 00:00:00 2001 From: zjh <zjh@888> Date: 星期三, 27 十二月 2023 16:34:58 +0800 Subject: [PATCH] zjh 本地 2023/12/27 -3 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 6 ++---- 1 files changed, 2 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 1ed2198..04d523f 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 @@ -158,10 +158,8 @@ @DataSource(value = DataSourceType.SLAVE_PACS) - @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 pacRemark" + - " from histjv_ltkjvtjpat where 1=1 "+ + @Select({"<script> select *"+ + " from histjv_Ltkj_hyxm where 1=1 "+ " <when test='pacCode!=null'>" + " AND fcard_no = #{pacCode}" + "</when>" + -- Gitblit v1.8.0