package com.zy.asrs.mapper;
|
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import com.zy.asrs.entity.WrkMastSta;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
@Mapper
|
@Repository
|
public interface WrkMastStaMapper extends BaseMapper<WrkMastSta> {
|
|
/*
|
* 获取所有任务数量
|
* */
|
Integer selectAllWrkCount(@Param("type")Integer type);
|
Integer selectAllWrkStsCount(@Param("type")Integer type,@Param("wrkSts")Integer wrkSts);
|
|
/*
|
* 获取所有可执行任务
|
* */
|
List<WrkMastSta> selectAllWrkMastStaList(@Param("type")Integer type);
|
|
/*
|
* 查询指定工作号任务
|
* */
|
WrkMastSta selectByWrkNo(@Param("workNo") Integer workNo);
|
WrkMastSta selectByWrkNoPut(@Param("workNo") Integer workNo);
|
|
/*
|
* 查询不干涉的可执行任务
|
* */
|
WrkMastSta selectNoInterfere(@Param("staStarts") List<Integer> staStarts, @Param("staEnds") List<Integer> staEnds,@Param("workNo")Long workNo );
|
WrkMastSta selectNoInterfereCrn(@Param("staStarts") List<Integer> staStarts, @Param("staEnds") List<Integer> staEnds,@Param("workNo")Long workNo );
|
|
List<WrkMastSta> selectNoInterfereList(@Param("staStarts") List<Integer> staStarts, @Param("staEnds") List<Integer> staEnds);
|
WrkMastSta selectNoInterfereToCrn(@Param("staStarts") List<Integer> staStarts, @Param("staEnds") List<Integer> staEnds,@Param("workNo")Long workNo );
|
|
|
List<WrkMastSta> selectByWorkStaList(@Param("workSta") Integer workSta, @Param("rgvNo") Short rgvNo);
|
WrkMastSta selectByWorkSta(@Param("workSta") Integer workSta, @Param("rgvNo") Integer rgvNo);
|
|
List<WrkMastSta> selectLockWrk();
|
List<WrkMastSta> selectLockWrkT();
|
List<WrkMastSta> selectPakingWrk(@Param("staStart") Integer staStart);
|
|
List<WrkMastSta> selectPakingWrkNum(@Param("rgvNo") Integer rgvNo);
|
|
}
|
