From 3eeaad61513758f2e05277995fb2af3a21f72b35 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 05 十二月 2024 08:55:00 +0800
Subject: [PATCH] zjh20241205-1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 3 ++-
1 files changed, 2 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 1d65155..c4d7e19 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
@@ -234,7 +234,8 @@
@DataSource(value = DataSourceType.SLAVE_LIS)
- @Select("SELECT * FROM vi_his_patientresult ")
+ @Select("select t.* from vi_his_patientresult t \n" +
+ "\tjoin(select * from vi_his_patientinfo t where t.HOSPITALID='chkwyy' and t.PATIENTNO like '800%') b on b.SAMPLEID = t.SAMPLEID")
List<Map<String, Object>> getCcXZxYyLisJgSt();
--
Gitblit v1.8.0