2025-0704

zhaowenxuan

8 天以前 b73fedc4026231b31cbc99f9fdad54c8e73a1a34

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java

@@ -7,6 +7,7 @@
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;
@@ -17,18 +18,23 @@
 * @Date: 2023/12/11 17:56
 */
@Mapper
@DataSource(value = DataSourceType.MASTER)
//@DataSource(value = DataSourceType.MASTER)
public interface LtkjExamJcbgdMapper extends BaseMapper<LtkjExamJcbgd> {

    @Delete ("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tmh} ")
    void  deletedLtkjJcbgdByTjhAndTmh(String tmh);
    @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tmh} and lx=0 ")
    void deletedLtkjJcbgdByTjhAndTmh(String tmh);

    @Select ("SELECT  a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='检查' GROUP BY a.sqdh")
    @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}")
    @Select("SELECT * FROM ltkj_exam_jcbgd WHERE tjh=#{cardId}")
    List<LtkjExamJcbgd> getJianJcBaoGaoDanByTjh(String cardId);


    @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);

}