yangys
2025-09-17 1e2b04fabbbc4b1ae37d7951068d7ab235f5b5f9
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
 
package org.springblade.mdm.program.service;
 
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.tool.utils.BeanUtil;
import org.springblade.mdm.basesetting.machine.service.MachineService;
import org.springblade.mdm.commons.service.ParamService;
 
import org.springblade.mdm.flow.vo.ProgramOnMachineExcel;
import org.springblade.mdm.program.entity.ProgramOnMachine;
import org.springblade.mdm.program.mapper.ProgramOnMachineMapper;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;
 
import java.util.*;
 
/**
 * DNC回传文件处理服务
 *
 * @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();
    }
 
    void batchSaveData(List<ProgramOnMachine> list) {
        for (ProgramOnMachine progOnMachine : list) {
            if(!existsByProcessInstanceId(progOnMachine.getProcessInstanceId())){
                save(progOnMachine);
            }
        }
    }
 
    boolean existsByProcessInstanceId(String processInstanceId){
        return this.lambdaQuery().eq(ProgramOnMachine::getProcessInstanceId,processInstanceId).count() > 0;
    }
}