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; /** *

* 服务实现类 *

* * @author zhoush * @since 2024-04-07 */ @Service public class DownWorkstationTaskServiceImpl extends ServiceImpl implements DownWorkstationTaskService { 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()); entity.setThickness(downGlassInfo.getThickness()); entity.setFilmsid(downGlassInfo.getFilmsid()); entity.setState(1); baseMapper.insert(entity); } // 查询最大的 ID private Long getMaxId() { QueryWrapper wrapper = new QueryWrapper<>(); wrapper.select("MAX(id) as max_id"); List 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 getTaskState() { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.eq("state", 1); return baseMapper.selectList(queryWrapper); } @Override public void updateTaskStateToZero(long id) { UpdateWrapper updateWrapper = new UpdateWrapper<>(); updateWrapper.set("state", 0).eq("id", id); baseMapper.update(null, updateWrapper); } }