| | |
| | | import com.example.springboot.entity.CarPosition; |
| | | import com.example.springboot.entity.StorageCage; |
| | | import com.example.springboot.entity.alarmmg; |
| | | import com.example.springboot.entity.north_frame_buffer1_frames; |
| | | import com.example.springboot.entity.north_glass_buffer1; |
| | | import com.example.springboot.entity.Out_slice; |
| | | import com.example.springboot.entity.Queue; |
| | |
| | | |
| | | // 根据玻璃id手动上片 |
| | | @GetMapping("/Addglassid") |
| | | public Result Addglassid(String glassid) { |
| | | public Result Addglassid(String glassid) throws SQLException { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | short taskno = homeMapper.SelectInTask(); |
| | | if (taskno > 0) { |
| | | map.put("message2", "500"); |
| | | } else { |
| | | // 调用伍上片函数 |
| | | short results = spianService.selectAll(glassid); |
| | | north_glass_buffer1 north_glass_buffer1 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", ""); |
| | | short results = spianService.selectAll(north_glass_buffer1); |
| | | if (results == 200) { |
| | | map.put("message2", "200"); |
| | | } else if (results == 300) { |
| | |
| | | Map<String, Object> map = new HashMap<>(); |
| | | Out_slice result = homeMapper.SelectQueueByglassid(glassid); |
| | | if (result == null) { |
| | | north_glass_buffer1 north_glass_buffer1 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameId(glassid, "", ""); |
| | | north_glass_buffer1 north_glass_buffer1 = jdbcConnections.SelectGlassByGlassIdOrderIdFrameIdout(glassid, "", ""); |
| | | String flip = jdbcConnections.SelectFlipByFrameBarcode(north_glass_buffer1.getFrameBarcode()); |
| | | |
| | | if (flip != null&&flip != "") { |
| | |
| | | Map<String, Object> map = new HashMap<>(); |
| | | short result = homeMapper.SelectStorageByGlassId(queue.getglassId()); |
| | | Double cagewidth = homeMapper.SelectCageWidth(cage, cell); |
| | | if (cagewidth - queue.getglasswidth() - 400 < 0 || (cagewidth == 2750 && queue.getglasswidth() > cagewidth)) { |
| | | if (cagewidth - queue.getglasswidth() - 600 < 0 || (cagewidth == 2750 && queue.getglasswidth() > cagewidth)) { |
| | | map.put("message", "400"); |
| | | } else { |
| | | if (result > 0) { |
| | |
| | | |
| | | // 手动添加扫码位玻璃 |
| | | @PostMapping("/InsertQueueGlassId") |
| | | public Result InsertQueueGlassId(Short id, @RequestBody Queue queue) { |
| | | public Result InsertQueueGlassId(Short id, @RequestBody Queue queue) throws SQLException { |
| | | return storageCageService.InsertQueueGlassId(id, queue); |
| | | |
| | | } |
| | |
| | | public Result SelectAluminumFrameInfoById(String FrameBarcode) throws SQLException { |
| | | String flip = jdbcConnections.SelectFlipByFrameBarcode(FrameBarcode); |
| | | List<north_glass_buffer1> AluminumFrame = north_Glass_Buffer1Service.SelectAluminumFrameInfoById(FrameBarcode); |
| | | Plchome.AluminumFrameInfo=jdbcConnections.SelectFrameBarcode(FrameBarcode); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("AluminumFrame", AluminumFrame); |
| | | map.put("flip", flip); |
| | |
| | | // public Result AddOutSliceS(@RequestBody String[][] AluminumFrames) throws |
| | | // SQLException { |
| | | north_Glass_Buffer1Service.AddOutSliceS(FrameNo); |
| | | Plchome.AluminumFrame = null; |
| | | Plchome.AluminumFrameInfo = new north_frame_buffer1_frames(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message", "200"); |
| | | return Result.success(map); |
| | |
| | | @PostMapping("/CloseForm7") |
| | | public Result CloseForm7() { |
| | | Plchome.AluminumFrame = null; |
| | | Plchome.AluminumFrameInfo = new north_frame_buffer1_frames(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message", "200"); |
| | | return Result.success(map); |