| | |
|---|
| | | package com.mes.downglassinfo.service.impl; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | 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.mapper.DownGlassInfoMapper; |
|---|
| | |
|---|
| | | // 根据流程卡号查询最大序号 |
|---|
| | | @Override |
|---|
| | | public Integer getMaxSequenceByFlowCardId(String flowCardId) { |
|---|
| | | QueryWrapper<DownGlassInfo> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("flow_card_id", flowCardId); |
|---|
| | | queryWrapper.select("MAX(sequence)"); // 选择最大序号 |
|---|
| | | DownGlassInfo downGlassInfo = baseMapper.selectOne(queryWrapper); |
|---|
| | | if (downGlassInfo != null) { |
|---|
| | | return downGlassInfo.getSequence(); // 返回最大序号 |
|---|
| | | } |
|---|
| | | return 0; // 如果没有找到记录，返回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); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
