From fe9f16a02c89eb6c5264c06bf76e748a0d809647 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期五, 01 十一月 2024 18:03:58 +0800 Subject: [PATCH] 2024-11-01 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java index c1e9439..5ecb689 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java @@ -25,9 +25,12 @@ void deletedLtkjHybgdByTjhAndTmh(String tmh); - @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND (a.type='妫�楠�' OR a.type='妫�鏌�') GROUP BY a.sqdh") + @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='妫�楠�' GROUP BY a.sqdh") List<String> getJianYanBaoGaoDan(String cardId); @Select("SELECT * FROM ltkj_hybgd WHERE tmh=#{tmh}") List<LtkjHybgd> getJianYanBaoGaoDanList(String tmh); + + @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='妫�鏌�' GROUP BY a.sqdh") + List<String> getJianChaBaoGaoDan(String cardId); } -- Gitblit v1.8.0