| | |
| | | import java.util.Map; |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.boot.autoconfigure.mongo.embedded.EmbeddedMongoProperties.Storage; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.example.springboot.common.Result; |
| | | import com.example.springboot.component.S7control; |
| | | import com.example.springboot.entity.Out_slice; |
| | | import com.example.springboot.entity.StorageCage; |
| | | import com.example.springboot.mapper.HomeMapper; |
| | |
| | | @Autowired |
| | | SpianService spianService; |
| | | |
| | | @Autowired |
| | | private JdbcConnections jdbcConnections; |
| | | |
| | | public void AddOutSliceS(String[][] AluminumFrames) throws SQLException { |
| | | // int sequence = homeMapper.SelectMaxSquence(); |
| | |
| | | return Result.success(map); |
| | | } |
| | | |
| | | // 确认后完成修改出片队列状态 |
| | | public void CompleteQueueByGlassId(String glassid) { |
| | | homeMapper.CompleteQueueByGlassId(glassid); |
| | | Out_slice outslice=homeMapper.SelectQueueByglassid(glassid); |
| | | Short num = homeMapper.SelectCountByFrameNo(outslice.getBarCode()); |
| | | if (num == 0) { |
| | | homeMapper.CompleteQueueByFrameNo(outslice.getBarCode()); |
| | | } |
| | | } |
| | | |
| | | //终止进片/出片 |
| | | public void StopTask(String glassid, int i) { |
| | | if (i == 0) {// 进片终止 |
| | | spianService.overtask(glassid); |
| | | DeleteByGlassID(glassid); |
| | | DeleteByGlassIDs(glassid); |
| | | homeMapper.UpdateOutSliceGlass(glassid); |
| | | } else {// 出片终止 |
| | | spianMapper.UpdatetaskOut(glassid);//完成出片任务 |
| | | spianMapper.UpdataGlassCage(glassid, 0);// 清除出片格子玻璃信息 |
| | | spianMapper.UpdateCageOver(glassid, 0);// 更改笼子表出片状态 |
| | | homeMapper.UpdateOutSliceGlass(glassid);//修改出片队列此玻璃状态为缺失 |
| | | |
| | | } |
| | | } |
| | | |
| | | //删除笼内玻璃还原宽度 |
| | | public void DeleteByGlassID(String glassid) { |
| | | public void DeleteByGlassIDs(String glassid) { |
| | | StorageCage glassinfor = homeMapper.SelectGlassInfo(glassid); |
| | | spianMapper.UpdataOutCage1(glassinfor.getGlassWidth(), glassinfor.getCage(), glassinfor.getCell()); |
| | | homeMapper.DeleteByGlassID(glassid); |
| | | } |
| | | |
| | | public Result FrameStateUpdate(String frameno, String framestate) { |
| | | homeMapper.FrameStateUpdate(frameno, framestate); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("message", "200"); |
| | | return Result.success(map); |
| | | } |
| | | |
| | | } |