自动化立体仓库 - WCS系统
yxFwq
2024-08-12 a395c37ac600ec6c73fed890ba94ede9fec5cc68
src/main/java/com/zy/asrs/mapper/WrkMastExecuteMapper.java
@@ -3,10 +3,42 @@
import com.zy.asrs.entity.WrkMastExecute;
import com.baomidou.mybatisplus.mapper.BaseMapper;
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 WrkMastExecuteMapper extends BaseMapper<WrkMastExecute> {
    WrkMastExecute getWrkMastExecuteByCharge(@Param("steNo") Integer steNo);
    WrkMastExecute getWrkMastExecuteByWrkNo(@Param("wrkNo") Long wrkNo);
    List<WrkMastExecute> getWrkMastExecuteByWrkNoList(@Param("wrkNo") Long wrkNo);
    List<WrkMastExecute> getWrkMastExecuteByJarNo(@Param("jarId") Integer jarId);
    List<WrkMastExecute> selectWrkMastExecuteByType(@Param("type") Integer type);
    List<WrkMastExecute> selectWrkMastExecuteByTypeAndIoTyperAndWrkType(@Param("type")Integer type,@Param("ioType")Integer ioType,@Param("wrkSts")Integer wrkSts,@Param("jarRegin")Integer jarRegin);
    List<WrkMastExecute> selectWrkMastExecuteByWrk(@Param("type")Integer type,@Param("ioType")Integer ioType,
                                                   @Param("wrkSts")Integer wrkSts,@Param("steNo")Integer steNo,
                                                   @Param("jarNo")Integer jarNo,@Param("rgvNo")Integer rgvNo);
    Integer getWrkMastExecuteByJarIdCount(@Param("jarId") Integer jarId);
    Integer getWrkMastExecuteByjarReginCount(@Param("jarRegin") Integer jarId);
    Integer selectNoStart(@Param("jarRegin") Integer jarRegin);
    Integer selectNoStartCharge(@Param("jarRegin") Integer jarRegin);
    Integer selectMoveStart(@Param("jarRegin") Integer jarRegin);
    Integer selectMoveStartCharge(@Param("jarRegin") Integer jarRegin);
    WrkMastExecute selectStart(@Param("jarRegin") Integer jarRegin);
}