From fd05507e8595739c80f485d67fdeeed91708f746 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期四, 21 十二月 2023 16:32:14 +0800
Subject: [PATCH] zjh 本地 2023/12/21 -1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 5 +++--
1 files changed, 3 insertions(+), 2 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 f310186..c657cf5 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
@@ -34,7 +34,7 @@
public List<LtkjTjPat> getTjPat();
@DataSource(value = DataSourceType.SLAVE_HIS)
- @Select("SELECT * FROM histjv_LTKJVTJPAT where fcard_no=#{id}")
+ @Select("SELECT * FROM histjv_LTKJVTJPAT where Ltrim(Rtrim(fcard_no)) = #{id} ")
public LtkjTjPat getTjPatByIdCard(String id);
@@ -100,10 +100,11 @@
public List<LtkjMiddleDetail> getMiddleDetailByHeadId(String id);
- //鏍规嵁浣撴鍙� 瀵瑰簲鐨� 鍖栭獙椤圭洰 +鈥滆娓呪�濇爣鏈�
+ //鏍规嵁浣撴鍙� 瀵瑰簲鐨� 鍖栭獙椤圭洰 +鏍囨湰
@DataSource(value = DataSourceType.SLAVE_HIS)
@Select("SELECT * FROM histjv_Ltkj_hysqd where tjh=#{id}")
public List<LtkjHysqd> getHysqdByTmh(String id);
+
//鍖栭獙椤圭洰涓嬬殑瀛愰」 浼犱笂闈㈢殑鎺ュ彛鐨則mh
@DataSource(value = DataSourceType.SLAVE_HIS)
@Select("SELECT * FROM histjv_Ltkj_hybgd where tmh=#{id}")
--
Gitblit v1.8.0