| | |
|---|
| | | package com.mes.downglassinfo.service.impl; |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
|---|
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
|---|
| | | import com.mes.downglassinfo.entity.DownGlassInfo; |
|---|
| | | import com.mes.downglassinfo.entity.DownGlassTask; |
|---|
| | |
|---|
| | | // 根据流程卡号查询最大序号 |
|---|
| | | @Override |
|---|
| | | public Integer getMaxSequenceByFlowCardId(String flowCardId) { |
|---|
| | | QueryWrapper<DownGlassInfo> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("flow_card_id", flowCardId); |
|---|
| | | queryWrapper.orderByDesc("sequence"); // 按照序号倒序排序 |
|---|
| | | queryWrapper.select("sequence").last("LIMIT 1"); // 选择最大序号并限制结果为1条记录 |
|---|
| | | DownGlassInfo downGlassInfo = baseMapper.selectOne(queryWrapper); |
|---|
| | | if (downGlassInfo != null) { |
|---|
| | | return downGlassInfo.getSequence(); |
|---|
| | | } |
|---|
| | | return 0; |
|---|
| | | LambdaQueryWrapper<DownGlassInfo> lambdaQueryWrapper = Wrappers.lambdaQuery(); |
|---|
| | | lambdaQueryWrapper.eq(DownGlassInfo::getFlowCardId, flowCardId) |
|---|
| | | .select(DownGlassInfo::getSequence) |
|---|
| | | .orderByDesc(DownGlassInfo::getSequence) |
|---|
| | | .last("LIMIT 1"); |
|---|
| | | |
|---|
| | | DownGlassInfo downGlassInfo = baseMapper.selectOne(lambdaQueryWrapper); |
|---|
| | | return downGlassInfo != null ? downGlassInfo.getSequence() : 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public void insertDownGlassInfo(DownGlassInfo downGlassInfo) { |
|---|
| | | baseMapper.insert(downGlassInfo); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
