From 760eb97dd624b69e254d148c71347fe35171dcc9 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 05 十二月 2024 18:07:19 +0800
Subject: [PATCH] 增加字段部门字段
---
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