更新下片逻辑

wuyouming666

2024-04-01 f42bb93047f0aba68f358968499e1174e67a715a

 UnLoadGlassModule/src/main/java/com/mes/service/PlcService.java

@@ -72,11 +72,10 @@
                downGlassInfoMapper.insert(newdownGlassInfo);

                //插入数据到机械手任务表

                downWorkstationMapper.insertdownWorkstationtask(newdownGlassInfo);

                //更新任务表状态为0

                //更新下片任务表状态为0

                downGlassInfoMapper.updateTaskStateToZero(downGlassInfo.getFlowCardId());



                sequence++; // 递增顺序字段值









@@ -91,11 +90,18 @@
        //downWorkstationMapper = WebSocketServer.applicationContext.getBean(DownWorkstationMapper.class);

        //downGlassInfoMapper = WebSocketServer.applicationContext.getBean(DownGlassInfoMapper.class);

        try {

            //查询下片工位表中架子是否绑定了流程卡号 工位表和任务表中状态为1的流程卡号和已落架数量

            List<DownWorkstation> taskdownWorkstation = downWorkstationMapper.selectdownWorkstationstate();

            if (taskdownWorkstation != null && !taskdownWorkstation.isEmpty()) {

                //查询下片工位表中是否绑定了架子是否绑定了流程卡号，如果已经绑定则更新已落架数量,并且删除下片任务表中的记录

                //，如果已经绑定则更新已落架数量,并且删除下片任务表中的记录

                for (DownWorkstation downWorkstation : taskdownWorkstation) {

                    downWorkstationMapper.update_racks_number(downWorkstation.getFlowCardId(),6 );



                    //更新下片工位表中已落架数量

                    downWorkstationMapper.update_racks_number(downWorkstation.getFlowCardId(),downWorkstation.getRacksnumber()+1 );



                    //更新机械任务表中状态为0

                    downWorkstationMapper.update_task_state_to_zero(downWorkstation.getFlowCardId());

                    //删除下片任务表中的记录

                    downGlassInfoMapper.deletetask(downWorkstation.getFlowCardId());



                }

@@ -111,18 +117,23 @@








    //绑定流程卡号架子

    public void bindingshelf(DownWorkstation downWorkstation){



        String FlowCardId=downWorkstation.getFlowCardId();

        int WorkstationId=downWorkstation.getWorkstationId();







        downWorkstationMapper.updateFlowCardId(downWorkstation);

    }







    // 满架拉走 清除流程卡信息

    public void clearFlowCardId(DownWorkstation downWorkstation){



       downWorkstationMapper.clearFlowCardId(downWorkstation);

    }