| | |
| | | package com.mes.downworkstation.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.mes.downglassinfo.entity.DownGlassInfo; |
| | | import com.mes.downglassinfo.entity.DownGlassTask; |
| | | import com.mes.downworkstation.entity.DownWorkstationTask; |
| | | import com.mes.downworkstation.mapper.DownWorkstationTaskMapper; |
| | | import com.mes.downworkstation.service.DownWorkstationTaskService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | |
| | | public void insertdownWorkstationtask(DownGlassInfo downGlassInfo) { |
| | | DownWorkstationTask entity = new DownWorkstationTask(); |
| | | // 查询当前最大的 id 值 |
| | | Long maxId = getMaxId(); |
| | | // 如果没有记录,则将 id 设置为 1;否则,将 id 设置为当前最大 id 值加 1 |
| | | Long newId = (maxId == null) ? 1 : maxId + 1; |
| | | |
| | | entity.setId(newId); // 设置手动递增的 id |
| | | entity.setFlowCardId(downGlassInfo.getFlowCardId()); |
| | | entity.setWidth(downGlassInfo.getWidth()); |
| | | entity.setHeight(downGlassInfo.getHeight()); |
| | |
| | | baseMapper.insert(entity); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | // 查询最大的 ID |
| | | private Long getMaxId() { |
| | | QueryWrapper<DownWorkstationTask> wrapper = new QueryWrapper<>(); |
| | | wrapper.select("MAX(id) as max_id"); |
| | | List<Object> list = baseMapper.selectObjs(wrapper); |
| | | if (list != null && !list.isEmpty()) { |
| | | Object obj = list.get(0); |
| | | if (obj != null) { |
| | | return Long.parseLong(obj.toString()); |
| | | } |
| | | } |
| | | // 如果没有查询到结果,则返回 0 |
| | | return 0L; |
| | | } |
| | | @Override |
| | | public List<DownWorkstationTask> getTaskState() { |
| | | QueryWrapper<DownWorkstationTask> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("state", 1); |
| | | return baseMapper.selectList(queryWrapper); |
| | | } |
| | | @Override |
| | | public void updateTaskStateToZero(long id) { |
| | | UpdateWrapper<DownWorkstationTask> updateWrapper = new UpdateWrapper<>(); |