From 386249a71cdfab885ece64c0442fe366ac661392 Mon Sep 17 00:00:00 2001 From: whycxzp <perryhsu@163.com> Date: 星期三, 21 九月 2022 11:13:57 +0800 Subject: [PATCH] 产品附件更新和物料编码格式处理 --- src/main/java/com/whyc/service/SoftwareService.java | 16 +++++++++++++++- 1 files changed, 15 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java index d8bf23d..bc83a48 100644 --- a/src/main/java/com/whyc/service/SoftwareService.java +++ b/src/main/java/com/whyc/service/SoftwareService.java @@ -100,7 +100,21 @@ //鍙栫3鍒�,绗�5鍒� Cell cell = sheet.getRow(8 + i).getCell(2); cell.setCellType(Cell.CELL_TYPE_STRING); - software.setApplyMaterialCode(cell.getStringCellValue()); + String stringCellValue = cell.getStringCellValue(); + int length = stringCellValue.length(); + if(length == 9){ + stringCellValue = "0"+stringCellValue; + }else if(length < 9){ + int centerZeroNum = 10 - length -1; + StringBuilder centerZeroStr = new StringBuilder(); + for (int j = 0; j < centerZeroNum; j++) { + centerZeroStr.append("0"); + } + String strFront = stringCellValue.substring(0, 3); + String strBehind = stringCellValue.substring(3); + stringCellValue = "0"+strFront+centerZeroStr+strBehind; + } + software.setApplyMaterialCode(stringCellValue); software.setApplyModel(sheet.getRow(8+i).getCell(4).getStringCellValue()); softwareList.add(software); -- Gitblit v1.9.1