| | |
|---|
| | | WrkMast selectPickStep2(@Param("barcode")String barcode); |
|---|
| | | |
|---|
| | | WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 获取一条到104站点的出库任务 |
|---|
| | | * @return 工作主档 |
|---|
| | | */ |
|---|
| | | WrkMast selectBy104(); |
|---|
| | | |
|---|
| | | @Update({ |
|---|
| | | "<script>", |
|---|
| | | "UPDATE asr_wrk_mast", |
|---|
| | | "SET call_agv = 1", |
|---|
| | | "WHERE wrk_no IN", |
|---|
| | | "<foreach item='item' collection='workNos' open='(' separator=',' close=')'>", |
|---|
| | | "#{item}", |
|---|
| | | "</foreach>", |
|---|
| | | "AND io_type IN (101,110,103,104,107)", |
|---|
| | | "AND wrk_sts IN (14,15)", |
|---|
| | | "AND call_agv = 0", |
|---|
| | | "</script>" |
|---|
| | | }) |
|---|
| | | void updateCallAgvBatch(@Param("workNos") List<Integer> workNos); |
|---|
| | | } |
|---|
