package com.example.springboot.service;
|
|
import java.sql.SQLException;
|
import java.util.HashMap;
|
import java.util.List;
|
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;
|
import com.example.springboot.mapper.SpianMapper;
|
|
@Service
|
public class OutSliceServive {
|
|
@Autowired
|
private HomeMapper homeMapper;
|
@Autowired
|
private SpianMapper spianMapper;
|
|
@Autowired
|
private JdbcConnections jdbcConnections;
|
|
public void AddOutSliceS(String[][] AluminumFrames) throws SQLException {
|
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;
|
}
|
}
|
}
|
|
// 查询出片队列
|
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()));
|
}
|
return listoutslice;
|
}
|
|
public Result CompleteQueue(String id, String frameid, String glassid) {
|
homeMapper.CompleteQueue(id);
|
Short num = homeMapper.SelectCountByFrameNo(frameid);
|
if (num == 0) {
|
homeMapper.CompleteQueueByFrameNo(frameid);
|
}
|
StorageCage storageCage = homeMapper.SelectGlassInfo(glassid);
|
if(storageCage!=null){
|
spianMapper.UpdataOutCage1(storageCage.getGlassWidth(), storageCage.getCage(), storageCage.getCell());
|
}
|
homeMapper.UpdateCageTask2(glassid);
|
S7control.getinstance().WriteWord("DB105.12", (short) 0);
|
Map<String, Object> map = new HashMap<>();
|
map.put("message", "200");
|
return Result.success(map);
|
}
|
|
}
|
