From 33de5e90c14e44e1639c961a48e338c1da3d5624 Mon Sep 17 00:00:00 2001 From: zjh <zjh@888> Date: 星期三, 26 六月 2024 16:51:56 +0800 Subject: [PATCH] zjh 本地 2024/06/26 --2 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 7 +++++++ 1 files changed, 7 insertions(+), 0 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 62c7346..7f6c269 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 @@ -7,6 +7,9 @@ import com.ltkj.hosp.sqlDomain.LtkjHybgd; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.List; /** * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃 @@ -20,4 +23,8 @@ @Delete("DELETE FROM ltkj_hybgd WHERE tmh=#{tmh} ") void deletedLtkjHybgdByTjhAndTmh(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> getJianYanBaoGaoDan(String cardId); } -- Gitblit v1.8.0