20241226

zhaowenxuan

2024-12-26 045dc3a1be1c2980458c6cf20de9e2f2efe7e15d

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