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 | 2 +-
1 files changed, 1 insertions(+), 1 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 b637555..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);
--
Gitblit v1.8.0