ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/DictCompMapper.java
@@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ltkj.hosp.domain.DictComp; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; /** * 体检单位信息维护Mapper接口 @@ -61,4 +62,7 @@ * @return 结果 */ public int deleteDictCompByDrugManufacturerIds(String[] drugManufacturerIds); @Select("SELECT a.drug_manufacturer_id FROM dict_comp a WHERE a.deleted=0 AND LOCATE(#{dw},a.cn_name)") List<String> getdwIdByDwName(String dw); }