| | |
|---|
| | | @Repository |
|---|
| | | public interface WrkMastMapper extends BaseMapper<WrkMast> { |
|---|
| | | |
|---|
| | | // @Select("select * from asr_wrk_mast where ((wrk_sts = 4 Or wrk_sts = 14 ) and io_type <> 103 and io_type <> 104 and io_type <> 107 ) or (wrk_sts = 2 and io_type=6) order by upd_mk,io_time,wrk_no") |
|---|
| | | List<WrkMast> selectToBeCompleteData(); |
|---|
| | | |
|---|
| | | List<WrkMast> selectToBeHistoryData(); |
|---|
| | | |
|---|
| | | // wcs --------------------------------------------- |
|---|
| | | // 入库第一步，扫码仪获取条码信息时查询 |
|---|
| | | // @Select("select top 1 * from asr_wrk_mast where source_sta_no=#{sourceStaNo} and wrk_sts=2 and barcode=#{barcode} and (io_type=1 or io_type=10) order by io_pri desc,io_time,wrk_no ASC") |
|---|
| | |
|---|
| | | |
|---|
| | | List<WrkMast> selectInWrkMastByLiftNo(Integer liftNo);//搜索指定提升机的入库任务 |
|---|
| | | |
|---|
| | | WrkMast selectChargeWorking(Integer shuttleNo); |
|---|
| | | |
|---|
| | | WrkMast selectChargeWorkingByChargeSta(Integer chargeSta); |
|---|
| | | |
|---|
| | | } |
|---|
