zjh20250415

zjh

2025-04-15 3acbfbf90dbaa7f87aa2d37405700a9abc08073a

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

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

    @Delete ("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tjh} and tmh=#{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);

    @Select ("SELECT  a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='检查' GROUP BY a.sqdh")