| | |
| | | } |
| | | String excelFilePath = excelDir + File.separator + originalFilename.substring(0,originalFilename.lastIndexOf(".")) + "_" + dateUnion +originalFilename.substring(originalFilename.lastIndexOf(".")); |
| | | String excelHttpUrl = excelFilePath.substring(excelDir.lastIndexOf("doc_file"+ File.separator + "ecr")); |
| | | multipartFile.transferTo(new File(excelFilePath)); |
| | | |
| | | Workbook workbook = null; |
| | | workbook = WorkbookFactory.create(inputStream); |
| | |
| | | if(ecrNumberObj!= null) { |
| | | return new Response().set(1,false,"ecr编号已存在"); |
| | | } |
| | | //存储操作执行 |
| | | multipartFile.transferTo(new File(excelFilePath)); |
| | | mapper.insertBatchSomeColumn(ecrList); |
| | | |
| | | return new Response().set(1,true,"导入完成"); |