机床加字段

yangys

2025-09-19 b0d0191a88912b352385349461b500a4964d693b

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
 
package org.springblade.mdm.program.service;
 
import com.baomidou.mybatisplus.core.metadata.IPage;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.base.BizServiceImpl;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.tool.utils.BeanUtil;
 
import org.springblade.mdm.flow.vo.ProgramOnMachineExcel;
import org.springblade.mdm.program.entity.ProgramOnMachine;
import org.springblade.mdm.program.mapper.ProgramOnMachineMapper;
import org.springblade.mdm.program.vo.ProgramOnMachineRecordQueryVO;
import org.springblade.mdm.program.vo.ProgramOnMachineVO;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;
 
import java.util.*;
 
/**
 * 现场编程记录处理忘
 *
 * @author yangys
 */
@Slf4j
@Service
@AllArgsConstructor
public class ProgramOnMachineService extends BizServiceImpl<ProgramOnMachineMapper, ProgramOnMachine> {
 
    @Transactional(rollbackFor = Exception.class)
    public int importData(MultipartFile file) {
        List<ProgramOnMachineExcel> excelList = ExcelUtil.read(file, ProgramOnMachineExcel.class);
 
        List<ProgramOnMachine> list = excelList.stream().map(excel -> {
            ProgramOnMachine progMachine = new ProgramOnMachine();
            BeanUtil.copyProperties(excel, progMachine);
            return progMachine;
        }).toList();
 
        batchSaveData(list);
 
        return list.size();
    }
 
    /**
     * 批量保存
     * @param list
     */
    void batchSaveData(List<ProgramOnMachine> list) {
        for (ProgramOnMachine progOnMachine : list) {
            if(!existsByProcessInstanceId(progOnMachine.getProcessInstanceId())){
                save(progOnMachine);
            }
        }
    }
 
    /**
     * 根据流程实例id判定是否存在
     * @param processInstanceId 流程实例id
     * @return 是否存在
     */
    boolean existsByProcessInstanceId(String processInstanceId){
        return this.lambdaQuery().eq(ProgramOnMachine::getProcessInstanceId,processInstanceId).count() > 0;
    }
 
    /**
     * 现场编程导入记录查询
     * @param queryVO 查询树据
     * @return 分页树据
     */
    public IPage<ProgramOnMachineVO> pageQuery(ProgramOnMachineRecordQueryVO queryVO) {
        return baseMapper.pageQuery(Condition.getPage(queryVO),queryVO);//IPage<ProgramOnMachineExcel>,queryVO
    }
}