package cn.iocoder.yudao.module.research.dal.mysql.application;
|
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.module.research.dal.dataobject.application.ResearchApplicationMemberDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
@Mapper
|
public interface ResearchApplicationMemberMapper extends BaseMapperX<ResearchApplicationMemberDO> {
|
|
default List<ResearchApplicationMemberDO> selectListByApplicationId(Long applicationId) {
|
LambdaQueryWrapperX<ResearchApplicationMemberDO> query = new LambdaQueryWrapperX<>();
|
query.eq(ResearchApplicationMemberDO::getApplicationId, applicationId);
|
query.orderByAsc(ResearchApplicationMemberDO::getSortNo);
|
query.orderByAsc(ResearchApplicationMemberDO::getId);
|
return selectList(query);
|
}
|
|
default int deleteByApplicationId(Long applicationId) {
|
return delete(ResearchApplicationMemberDO::getApplicationId, applicationId);
|
}
|
|
}
|
