From 9469c22c850711a0dd09e394ce3113726e5fc5bb Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期五, 21 六月 2024 11:34:50 +0800 Subject: [PATCH] 增加字段 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java | 10 ++++++++++ 1 files changed, 10 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 1b04fe1..1ceab0f 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 @@ -5,7 +5,9 @@ import com.ltkj.common.enums.DataSourceType; import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd; import com.ltkj.hosp.sqlDomain.LtkjHybgd; +import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; /** * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃 @@ -15,4 +17,12 @@ @Mapper @DataSource(value = DataSourceType.MASTER) public interface LtkjHybgdMapper extends BaseMapper<LtkjHybgd> { + + + @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") + String getJianYanBaoGaoDan(String cardId); } -- Gitblit v1.8.0