From bd94f17a788da5fde253ce877a2d79de5d04df9c Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 15 八月 2025 17:39:02 +0800
Subject: [PATCH] zjh202500815
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 4 ++--
1 files changed, 2 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 81ccbf8..e02680d 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
@@ -319,7 +319,7 @@
" \n" +
"FROM\n" +
" vi_his_patientinfo a\n" +
- "WHERE a.PATIENTTYPE=3 AND a.GH_PATIENTNO =#{tjNum} AND a.HOSPITALID = #{hosp}")
+ "WHERE a.PATIENTTYPE=3 AND LOCATE(#{tjNum},.GH_PATIENTNO) AND a.HOSPITALID = #{hosp}")
List<Map<String, Object>> sysgetCcXZxYyLtkjHysqdByLisVi(@Param("tjNum") String tjNum,@Param("hosp") String hosp);
@@ -465,7 +465,7 @@
" a.SQRJ 鐢宠鏃堕棿,\n" +
" a.JCBW 妫�鏌ラ儴浣峔n" +
"FROM\n" +
- "ris.V_TJ_JCBGXX_NEWTJ a WHERE trim(a.HIS_ID)=#{tjNum} AND a.HOSTPITALID = #{hosp}")
+ "ris.V_TJ_JCBGXX_NEWTJ a WHERE INSTR(trim(a.HIS_ID),#{tjNum}) > 0 AND a.HOSTPITALID = #{hosp}")
List<Map<String, Object>> sysgetCcXZxYyPacsLtkjExamJcsqd(@Param("tjNum") String tjNum,@Param("hosp") String hosp);
--
Gitblit v1.8.0