| | |
| | | |
| | | import com.baomidou.mybatisplus.mapper.BaseMapper; |
| | | import com.zy.entity.WrkMast; |
| | | import org.apache.ibatis.annotations.*; |
| | | import org.apache.ibatis.annotations.Insert; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Update; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | @Mapper |
| | | @Repository |
| | | public interface WrkMastMapper extends BaseMapper<WrkMast> { |
| | | |
| | | /** |
| | | * 查询入灌装线站点在途任务数(未进罐装线里面) |
| | | * @param site 入罐装线站点 |
| | | */ |
| | | int selectInGzxCount(@Param("site") int site); |
| | | |
| | | WrkMast selectByLocNo(@Param("sourceLocNo") String sourceLocNo); |
| | | |
| | |
| | | WrkMast selectPickStep2(@Param("barcode")String barcode); |
| | | |
| | | WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo); |
| | | WrkMast selectByIoTypeAndWrkSts(@Param("ioType")Integer ioTyper,@Param("wrkSts")Long wrkSts); |
| | | |
| | | /** |
| | | * 获取一条到104站点的出库任务 |
| | | * @return 工作主档 |
| | | */ |
| | | WrkMast selectBy104(); |
| | | |
| | | int selectCountByKb(); |
| | | |
| | | // 根据出入库类型和工作时间,查询历史表记录数量 |
| | | int selectCountHisByIoTypeAndIoTime(@Param("ioType") Integer IoType,@Param("ioType") Date ioTime); |
| | | } |