From 2b2763c83e352f8ffd2ac0b5c46b60c49ee78439 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期二, 13 五月 2025 14:26:33 +0800 Subject: [PATCH] 2025-05-13 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java index 2a4700f..e24f7a4 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java @@ -4,7 +4,13 @@ import com.ltkj.common.annotation.DataSource; import com.ltkj.common.enums.DataSourceType; import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd; +import com.ltkj.hosp.sqlDomain.LtkjHybgd; +import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; + +import java.util.List; /** * @Company: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃 @@ -14,4 +20,22 @@ @Mapper @DataSource(value = DataSourceType.MASTER) public interface LtkjExamJcbgdMapper extends BaseMapper<LtkjExamJcbgd> { + + @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tmh} and lx=0 and sgorzd=0 ") + void deletedLtkjJcbgdByTjhAndTmh(String tmh); + + @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tjh} and tmh=#{tmh} and lx=1 ") + void deletedLtkjJcbgdByTjhandtmh(@Param("tjh") String tjh, @Param("tmh") String tmh); + + @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tjh} and tmh=#{tmh} and lx=0 and sgorzd=1 ") + void deletedLtkjJcbgdByTjhAndTmhA(@Param("tjh") String tjh, @Param("tmh") 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> getJianJcBaoGaoDan(String cardId); + + @Select("SELECT * FROM ltkj_exam_jcbgd WHERE tmh=#{tmh} GROUP BY xmmc ") + List<LtkjExamJcbgd> getJianJcBaoGaoDanList(String tmh); + + @Select("SELECT * FROM ltkj_exam_jcbgd WHERE tjh=#{cardId}") + List<LtkjExamJcbgd> getJianJcBaoGaoDanByTjh(String cardId); } -- Gitblit v1.8.0