| | |
| | | // } |
| | | |
| | | // 获取路径 |
| | | StaDesc staDesc = staDescService.queryCrnStn(ioType, locMast.getCrnNo(), 102); |
| | | StaDesc staDesc = staDescService.queryCrnStn(ioType, locMast.getCrnNo(), staNo.getDevNo()); |
| | | // 生成工作号 |
| | | int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(ioType)); |
| | | // 生成工作档 |
| | |
| | | @Scheduled(cron = "0/3 * * * * ? ") |
| | | private void execute() { |
| | | List<WrkMast> wrkMasts = wrkMastService.selectToBeCompleteData(); |
| | | if (wrkMasts.isEmpty()) { |
| | | List<WrkMast> wrkMasts1 = wrkMastService.selectList(new EntityWrapper<WrkMast>() |
| | | .eq("wrk_sts", 14) |
| | | .eq("io_type", 103)); |
| | | for (WrkMast wrkMast : wrkMasts1) { |
| | | BasDevp basDevp=basDevpService.selectOne(new EntityWrapper<BasDevp>() |
| | | .eq("dev_no",wrkMast.getStaNo()) |
| | | .eq("wrk_no",wrkMast.getWrkNo())); |
| | | if(basDevp==null){ |
| | | continue; |
| | | } |
| | | if (!Cools.isEmpty(wrkMast.getMemo())) { |
| | | wrkMast.setWrkSts(30L); |
| | | wrkMastService.updateById(wrkMast); |
| | | } |
| | | } |
| | | return; |
| | | } |
| | | |
| | | for (WrkMast wrkMast : wrkMasts) { |
| | | ReturnT<String> returnT = workMastHandler.start(wrkMast); |
| | | if (!returnT.isSuccess()) { |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | |
| | | .doPost(); |
| | | JSONObject jsonObject = JSON.parseObject(response); |
| | | if(jsonObject.getBoolean("IsSuccess")){ |
| | | wrkMast.setWrkSts(31L);//WMS下发搬运任务给RCS成功 |
| | | wrkMast.setWrkSts(15L);//WMS下发搬运任务给RCS成功,转历史档 |
| | | wrkMastService.updateById(wrkMast); |
| | | bool = true; |
| | | } |
| | |
| | | enabled: false |
| | | datasource: |
| | | driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver |
| | | url: jdbc:sqlserver://127.0.0.1:1433;databasename=jxtlfasrs-yclk |
| | | url: jdbc:sqlserver://127.0.0.1:50948;databasename=dlzasrs |
| | | username: sa |
| | | password: sa@123 |
| | | mvc: |
| | |
| | | or (wrk_sts=15 and ove_mk='Y' and wrk_no not in (select wrk_no from asr_bas_devp) and inv_wh = 'Y') |
| | | or (wrk_sts=15 and dateadd(mi,15,crn_end_time) <= getdate() and wrk_no not in (select wrk_no from asr_bas_devp) and inv_wh = 'Y') |
| | | or (wrk_sts=15 and crn_end_time is null and wrk_no not in (select wrk_no from asr_bas_devp) and inv_wh = 'Y') |
| | | or (wrk_sts=15 and io_type=110) |
| | | order by io_time,wrk_no asc |
| | | </select> |
| | | |