From 8aea3ecc955f5c55024686375bc6b2fc3a989a35 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期三, 03 七月 2024 15:44:32 +0800 Subject: [PATCH] zjh 2024/07/3-1 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 9 +++++++-- 1 files changed, 7 insertions(+), 2 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 80f92b9..9d66a56 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 @@ -9,6 +9,8 @@ import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; +import java.util.List; + /** * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃 * @Author: lige @@ -23,6 +25,9 @@ void deletedLtkjHybgdByTjhAndTmh(String tmh); - @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='妫�楠�'") - String getJianYanBaoGaoDan(String cardId); + @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); } -- Gitblit v1.8.0