| | |
| | | Double selectOrderDetlAndSku(@Param("orderNo")String orderNo, @Param("matnr")String matnr); |
| | | OrderDetlValueResultUtil selectOrderDetlValue(@Param("orderNo")String orderNo, @Param("matnr")String matnr); |
| | | Double selectBasArmMastSignValue(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("bindingTags")Long bindingTags); |
| | | Integer selectCountAndBindingTags(@Param("armNo")int armNo,@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("bindingTags")Long bindingTags); |
| | | Integer selectCountAndBindingTagsLog(@Param("armNo")int armNo,@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("bindingTags")Long bindingTags); |
| | | } |
| | |
| | | Double selectOrderDetlAndSku(String order,String matnr); |
| | | OrderDetlValueResultUtil selectOrderDetlValue(String order, String matnr); |
| | | Double selectBasArmMastSignValue(String order, String matnr,Long bindingTags); |
| | | Integer selectCountAndBindingTags(int armNo,String order, String matnr,Long bindingTags); |
| | | Integer selectCountAndBindingTagsLog(int armNo,String order, String matnr,Long bindingTags); |
| | | |
| | | } |
| | |
| | | public Double selectBasArmMastSignValue(String order, String matnr,Long bindingTags){ |
| | | return this.baseMapper.selectBasArmMastSignValue(order,matnr,bindingTags); |
| | | } |
| | | |
| | | @Override |
| | | public Integer selectCountAndBindingTags(int armNo,String order, String matnr,Long bindingTags){ |
| | | return this.baseMapper.selectCountAndBindingTags(armNo,order,matnr,bindingTags); |
| | | } |
| | | |
| | | @Override |
| | | public Integer selectCountAndBindingTagsLog(int armNo,String order, String matnr,Long bindingTags){ |
| | | return this.baseMapper.selectCountAndBindingTagsLog(armNo,order,matnr,bindingTags); |
| | | } |
| | | } |
| | |
| | | //mark - 3 - .... |
| | | this.locToLoc(crn, crnProtocol,mark); |
| | | //预调度 |
| | | this.crnRebackHp(crn, crnProtocol, crnThread); |
| | | // this.crnRebackHp(crn, crnProtocol, crnThread); |
| | | |
| | | } |
| | | // News.infoNoLog(""+mark+" - 0"+" - 堆垛机入出库作业下发执行完成"); |
| | |
| | | new EntityWrapper<BasCrnp>().eq("crn_no", crnProtocol.getCrnNo()) |
| | | ); |
| | | boolean result = true; |
| | | if(crnProtocol.getCrnNo() != 5 ){ |
| | | return; |
| | | } |
| | | |
| | | for (CrnSlave.CrnStn crnStn : slave.getCrnInStn()) { |
| | | DevpThread devpThread = (DevpThread) SlaveConnection.get(SlaveType.Devp, crnStn.getDevpPlcId()); |
| | | if(crnStn.getStaNo() == 4001){ |
| | |
| | | int x=1; |
| | | switch (crnProtocol.getCrnNo()){ |
| | | case 1: x =2; break; |
| | | case 2: x =6; break; |
| | | case 3: x =11; break; |
| | | case 2: x =7; break; |
| | | case 3: x =10; break; |
| | | case 4: x =14; break; |
| | | case 5: x =18; break; |
| | | } |
| | |
| | | new EntityWrapper<BasArmMast>() |
| | | .eq("status", 2) |
| | | .eq("binding_tags", basArmMast.getBindingTags())); |
| | | if (binding_tags<2){ |
| | | if (binding_tags==1){ |
| | | BasArmMast basArmMastOne = basArmMastService.selectOne( |
| | | new EntityWrapper<BasArmMast>() |
| | | .eq("status", 2) |
| | |
| | | continue; |
| | | } |
| | | |
| | | } else if (binding_tags == 0){ |
| | | boolean signBinding_tags_barcode = false; |
| | | List<BasArmMast> binding_tags_barcodeList = basArmMastService.selectList( |
| | | new EntityWrapper<BasArmMast>() |
| | | .eq("barcode", barcode)); |
| | | for (BasArmMast basArmMastBarcode : binding_tags_barcodeList){ |
| | | Integer selectCountAndBindingTags = basArmMastService.selectCountAndBindingTags(basArmMastBarcode.getArmNo(), basArmMastBarcode.getOrderNo(), basArmMastBarcode.getMatnr(),basArmMastBarcode.getBindingTags()); |
| | | Integer selectCountAndBindingTagsLog = basArmMastService.selectCountAndBindingTagsLog(basArmMastBarcode.getArmNo(),basArmMastBarcode.getOrderNo(), basArmMastBarcode.getMatnr(),basArmMastBarcode.getBindingTags()); |
| | | |
| | | Double anfmeSignOne = basArmMastService.selectBasArmMastSignValue(basArmMastBarcode.getOrderNo(), basArmMastBarcode.getMatnr(),basArmMastBarcode.getBindingTags()); |
| | | if ((selectCountAndBindingTags + selectCountAndBindingTagsLog) != anfmeSignOne.intValue()) { |
| | | // signBinding_tags_barcode = true; ///// |
| | | break; |
| | | } |
| | | } |
| | | if (signBinding_tags_barcode){ |
| | | armTaskAssignmentCallApiLogSave(staProtocol, "数据异常!!!", staProtocol.getSiteId()+"码垛位置,上一个分拣组未全部完成!!!", false); |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | // OrderDetlValueResultUtil orderDetlValueResultUtil = basArmMastService.selectOrderDetlValue(basArmMast.getOrderNo(), basArmMast.getMatnr()); |
| | |
| | | add(2022);add(2024); |
| | | add(2028);add(2030); |
| | | add(2025);add(2027); |
| | | add(2031);add(2033); |
| | | add(2031);add(2032);add(2033); |
| | | add(2034);add(2035);add(2037); |
| | | // add(2041);add(2042);add(2043);add(2044); |
| | | // add(2045);add(2046);add(2047);add(2048); |
| | |
| | | boolean[] status1 = siemensS7Net.getByteTransform().TransBool(result.Content, offset + offset3 - 4, 3); |
| | | boolean[] statusErr = siemensS7Net.getByteTransform().TransBool(result.Content, offset + offset3 - 8, 3); |
| | | boolean[] statusSign = siemensS7Net.getByteTransform().TransBool(resultErr.Content, offsetSign, 3); |
| | | if(siteId == 2032){ |
| | | |
| | | } |
| | | boolean loading = false; |
| | | if(!status1[0]) |
| | | { |
| | |
| | | and d.matnr = #{matnr} |
| | | </select> |
| | | |
| | | |
| | | |
| | | <select id="selectBasArmMastSignValue" resultType="java.lang.Double"> |
| | | select top 1 |
| | | d.anfme |
| | |
| | | and d.create_time = #{bindingTags} |
| | | </select> |
| | | |
| | | <select id="selectCountAndBindingTags" resultType="java.lang.Integer"> |
| | | select count(1) |
| | | from asr_bas_arm_mast d |
| | | where 1=1 |
| | | and d.arm_no = #{armNo} |
| | | and d.order_no = #{orderNo} |
| | | and d.matnr = #{matnr} |
| | | and d.binding_tags = #{bindingTags} |
| | | </select> |
| | | |
| | | <select id="selectCountAndBindingTagsLog" resultType="java.lang.Integer"> |
| | | select count(1) |
| | | from asr_bas_arm_mast_log d |
| | | where 1=1 |
| | | and d.arm_no = #{armNo} |
| | | and d.order_no = #{orderNo} |
| | | and d.matnr = #{matnr} |
| | | and d.binding_tags = #{bindingTags} |
| | | </select> |
| | | |
| | | </mapper> |