From bc0fdd1f0c20ca4737e8f073050f37b27a658694 Mon Sep 17 00:00:00 2001
From: hongjli <3117313295@qq.com>
Date: 星期四, 22 五月 2025 16:31:12 +0800
Subject: [PATCH] 管路&气柜产能负载优化，实现动态row聚合统计
---
aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipelineMoServiceImpl.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipelineMoServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipelineMoServiceImpl.java
index d6f9650..d714577 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipelineMoServiceImpl.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipelineMoServiceImpl.java
@@ -118,17 +118,23 @@
/*鏁版嵁鍒椾粠1寮�濮�*/
for (int i = 1; i <= rows; i++) {
Row row = sheet.getRow(i);
+ if (row.getCell(0) == null){
+ continue;
+ }
String mo = row.getCell(0).getStringCellValue();
+ if (StringUtils.isEmpty(mo)){
+ continue;
+ }
String factory = row.getCell(1).getStringCellValue();
String materialNum = row.getCell(2).getStringCellValue();
double quantity = row.getCell(3).getNumericCellValue();
Date planEnd = row.getCell(4).getDateCellValue();
- if (StringUtils.isNotBlank(mo) &&
- StringUtils.isNotBlank(factory) &&
+ if (StringUtils.isNotBlank(factory) &&
StringUtils.isNotBlank(materialNum) &&
planEnd != null) {
ApsGasPipelineMo apsGasPipelineMo = new ApsGasPipelineMo();
apsGasPipelineMo.setMo(mo);
+ apsGasPipelineMo.setMaterialCode(materialNum);
apsGasPipelineMo.setId(IdUtil.getSnowflakeNextId());
apsGasPipelineMo.setFactory(factory);
apsGasPipelineMo.setCreateBy(SecurityUtils.getUsername());
--
Gitblit v1.9.3