ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.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.Select; /** * @Company: 西安路泰科技有限公司 @@ -20,4 +21,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='检验'") String getJianYanBaoGaoDan(String cardId); }