package jnpf.limsMapper;
|
|
import jnpf.base.mapper.SuperMapper;
|
import jnpf.limsEntity.LimsSxtQingyanXiangmuZixiangEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.data.repository.query.Param;
|
|
import java.util.List;
|
|
@Mapper
|
public interface LimsSxtQingyanXiangmuZixiangMapper extends SuperMapper<LimsSxtQingyanXiangmuZixiangEntity> {
|
|
|
|
/**
|
* 根据外键查询项目ID列表（未删除）
|
*/
|
@Select("SELECT xiangmu_id "
|
+ "FROM lims_sxt_qingyan_xiangmu_zixiang "
|
+ "WHERE f_foreign_id = #{foreignId} "
|
+ "AND f_delete_mark IS NULL")
|
List<String> selectXiangmuIdsByForeignId(@Param("foreignId") String foreignId);
|
|
}
|
