| | |
|---|
| | | import org.apache.poi.xssf.streaming.SXSSFRow; |
|---|
| | | import org.apache.poi.xssf.streaming.SXSSFSheet; |
|---|
| | | import org.apache.poi.xssf.streaming.SXSSFWorkbook; |
|---|
| | | import org.springframework.beans.BeanUtils; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | import org.springframework.transaction.annotation.Transactional; |
|---|
| | |
|---|
| | | formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
|---|
| | | simpleDateFormat = new SimpleDateFormat("yyyy-MM"); |
|---|
| | | } |
|---|
| | | apsGasPipingRouteStats = apsGasPipingRouteStatMapper.selectApsGasPipingRouteStatList(apsGasPipingRouteStat); |
|---|
| | | ApsGasPipingRouteStat queryStatParam = new ApsGasPipingRouteStat(); |
|---|
| | | BeanUtils.copyProperties(apsGasPipingRouteStat,queryStatParam); |
|---|
| | | queryStatParam.setMajor(""); |
|---|
| | | apsGasPipingRouteStats = apsGasPipingRouteStatMapper.selectApsGasPipingRouteStatList(queryStatParam); |
|---|
| | | //根据开工日进行升序排序 |
|---|
| | | apsGasPipingRouteStats.sort((a, b)->a.getProcessPlanStartDay().compareTo(b.getProcessPlanStartDay())); |
|---|
| | | //工序开工日期 |
|---|
| | |
|---|
| | | } |
|---|
| | | // 批量插入以提高性能 |
|---|
| | | if (!cptStateList.isEmpty()) { |
|---|
| | | int batchSize = 500; |
|---|
| | | int batchSize = 1000; |
|---|
| | | int size = cptStateList.size(); |
|---|
| | | for (int i = 0; i < size; i += batchSize) { |
|---|
| | | int end = Math.min(i + batchSize, size); |
|---|
