| package com.zy.mapper; | 
|   | 
| import com.baomidou.mybatisplus.mapper.BaseMapper; | 
| import com.zy.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 selectNoInterfere(@Param("staStarts") List<Integer> staStarts, @Param("staEnds") List<Integer> staEnds); | 
|     List<WrkMastSta> selectNoInterfereList(@Param("staStarts") List<Integer> staStarts, @Param("staEnds") List<Integer> staEnds); | 
|   | 
| } |