| | |
|---|
| | | public Integer getMaxSequenceByFlowCardId(String flowCardId) { |
|---|
| | | QueryWrapper<DownGlassInfo> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("flow_card_id", flowCardId); |
|---|
| | | queryWrapper.select("MAX(sequence)"); // 选择最大序号 |
|---|
| | | queryWrapper.orderByDesc("sequence"); // 按照序号倒序排序 |
|---|
| | | queryWrapper.select("sequence").last("LIMIT 1"); // 选择最大序号并限制结果为1条记录 |
|---|
| | | DownGlassInfo downGlassInfo = baseMapper.selectOne(queryWrapper); |
|---|
| | | if (downGlassInfo != null) { |
|---|
| | | return downGlassInfo.getSequence(); // 返回最大序号 |
|---|
| | | return downGlassInfo.getSequence(); |
|---|
| | | } |
|---|
| | | return 0; // 如果没有找到记录，返回0或者其他适当的值 |
|---|
| | | return 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public void insertDownGlassInfo(DownGlassInfo downGlassInfo) { |
|---|
| | | baseMapper.insert(downGlassInfo); |
|---|
