[钣金计划大表] 优化：焊缝统计导出Excel样式

zhanghl

2025-05-23 dec8951aae400e54f6ee83a8f95867dba9da8af1

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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
package com.aps.core.service.impl;
 
import com.aps.common.core.utils.DateUtils;
import com.aps.common.core.utils.uuid.IdUtils;
import com.aps.core.domain.ApsProcessRoute;
import com.aps.core.domain.ApsProcessRouteTemp;
import com.aps.core.mapper.ApsProcessRouteMapper;
import com.aps.core.mapper.ApsProcessRouteTempMapper;
import com.aps.core.service.IApsProcessRouteService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
/**
 * 工艺路线Service业务层处理
 * 
 * @author wwj
 * @date 2025-04-10
 */
@Service
public class ApsProcessRouteServiceImpl implements IApsProcessRouteService 
{
    @Autowired
    private ApsProcessRouteMapper apsProcessRouteMapper;
    @Autowired
    private ApsProcessRouteTempMapper apsProcessRouteTempMapper;
 
    /**
     * 查询工艺路线
     * 
     * @param id 工艺路线主键
     * @return 工艺路线
     */
    @Override
    public ApsProcessRoute selectApsProcessRouteById(String id)
    {
        return apsProcessRouteMapper.selectApsProcessRouteById(id);
    }
 
    /**
     * 查询工艺路线列表
     * 
     * @param apsProcessRoute 工艺路线
     * @return 工艺路线
     */
    @Override
    public List<ApsProcessRoute> selectApsProcessRouteList(ApsProcessRoute apsProcessRoute)
    {
        return apsProcessRouteMapper.selectApsProcessRouteList(apsProcessRoute);
    }
 
    /**
     * 新增工艺路线
     * 
     * @param apsProcessRoute 工艺路线
     * @return 结果
     */
    @Override
    public int insertApsProcessRoute(ApsProcessRoute apsProcessRoute)
    {
        apsProcessRoute.setId(IdUtils.fastUUID());
        apsProcessRoute.setCreateTime(DateUtils.getNowDate());
        return apsProcessRouteMapper.insertApsProcessRoute(apsProcessRoute);
    }
 
    /**
     * 修改工艺路线
     * 
     * @param apsProcessRoute 工艺路线
     * @return 结果
     */
    @Override
    public int updateApsProcessRoute(ApsProcessRoute apsProcessRoute)
    {
        apsProcessRoute.setUpdateTime(DateUtils.getNowDate());
        return apsProcessRouteMapper.updateApsProcessRoute(apsProcessRoute);
    }
 
    /**
     * 批量删除工艺路线
     * 
     * @param ids 需要删除的工艺路线主键
     * @return 结果
     */
    @Override
    public int deleteApsProcessRouteByIds(String[] ids)
    {
        return apsProcessRouteMapper.deleteApsProcessRouteByIds(ids);
    }
 
    /**
     * 删除工艺路线信息
     * 
     * @param id 工艺路线主键
     * @return 结果
     */
    @Override
    public int deleteApsProcessRouteById(String id)
    {
        return apsProcessRouteMapper.deleteApsProcessRouteById(id);
    }
 
    @Override
    public int confirmProcessRoute(ApsProcessRouteTemp apsProcessRouteTemp) {
        //查询临时表数据
        List<ApsProcessRouteTemp> apsProcessRouteTemps =apsProcessRouteTempMapper.selectApsProcessRouteTempList(apsProcessRouteTemp);
        int count=0;
        String[] ids=new String[apsProcessRouteTemps.size()];
        for (int i = 0; i < apsProcessRouteTemps.size() ; i++) {
            //记录临时表id
            ids[i]= apsProcessRouteTemps.get(i).getId();
            ApsProcessRoute apsProcessRoute =new ApsProcessRoute();
            BeanUtils.copyProperties(apsProcessRouteTemps.get(i), apsProcessRoute);
            ApsProcessRoute apsProcessRoutetmp =new ApsProcessRoute();
            apsProcessRoutetmp.setWorkOrderNo(apsProcessRoute.getWorkOrderNo());
            apsProcessRoutetmp.setProcessNumber(apsProcessRoute.getProcessNumber());
            List<ApsProcessRoute> apsProcessRoutes =apsProcessRouteMapper.selectApsProcessRouteList(apsProcessRoutetmp);
            if(apsProcessRoutes.size()>0){
                apsProcessRoute.setId(apsProcessRoutes.get(0).getId());
                //插入正式表，并记录
                apsProcessRoute.setCreateTime(DateUtils.getNowDate());
                apsProcessRoute.setIntegrationDay(DateUtils.getNowDate());
                apsProcessRouteMapper.updateApsProcessRoute(apsProcessRoute);
            }else {
                apsProcessRoute.setId(IdUtils.fastUUID());
                //插入正式表，并记录
                apsProcessRoute.setCreateTime(DateUtils.getNowDate());
                apsProcessRoute.setIntegrationDay(DateUtils.getNowDate());
                apsProcessRouteMapper.insertApsProcessRoute(apsProcessRoute);
            }
 
 
            count++;
        }
        //插入数量与临时表查询一直则删除临时表数据
        if (count== apsProcessRouteTemps.size()) {
            apsProcessRouteTempMapper.deleteApsProcessRouteTempByIds(ids);
        }
        return 1;
    }
 
    @Override
    public List<ApsProcessRoute> selectProcessNameList(String orgCode) {
        return apsProcessRouteMapper.selectProcessNameList(orgCode);
    }
}