| | |
| | | private JdbcConnections jdbcConnections; |
| | | |
| | | public void AddOutSliceS(String[][] AluminumFrames) throws SQLException { |
| | | int sequence = homeMapper.SelectMaxSquence(); |
| | | // int sequence = homeMapper.SelectMaxSquence(); |
| | | |
| | | // 添加到数据库 |
| | | for (String[] item : AluminumFrames) { |
| | | if (item[1] == "true") { |
| | | Short state=0; |
| | | String position = jdbcConnections.SelectPositionByFrameBarcode(item[3]); |
| | | homeMapper.AddOutSliceS(item[0], item[2], item[3], item[4], item[5], sequence, position,state ); |
| | | sequence += 1; |
| | | } |
| | | } |
| | | // for (String[] item : AluminumFrames) { |
| | | // if (item[1] == "true") { |
| | | // Short state=0; |
| | | // String position = jdbcConnections.SelectPositionByFrameBarcode(item[3]); |
| | | // homeMapper.AddOutSliceS(item[0], item[2], item[3], item[4], item[5], sequence, position,state ); |
| | | // sequence += 1; |
| | | // } |
| | | // } |
| | | } |
| | | |
| | | // 查询出片队列 |
| | | public List<Out_slice> SelectProductionqueue() { |
| | | List<Out_slice> listoutslice = homeMapper.SelectProductionqueue(); |
| | | for (Out_slice out_slice : listoutslice) { |
| | | out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId())); |
| | | } |
| | | // for (Out_slice out_slice : listoutslice) { |
| | | // out_slice.setstorageCage(homeMapper.SelectStorageGlassById(out_slice.getGlassId())); |
| | | // } |
| | | return listoutslice; |
| | | } |
| | | |
| | | //完成出片任务 |
| | | public Result CompleteQueue(String id, String frameid, String glassid) { |
| | | homeMapper.CompleteQueue(id); |
| | | Short num = homeMapper.SelectCountByFrameNo(frameid); |