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