| | |
| | | try { |
| | | List<SparesPartInventory> list = ExcelImportUtil.importExcel(file.getInputStream(), SparesPartInventory.class, params); |
| | | for (SparesPartInventory temp : list) { |
| | | temp.setId(mainId); |
| | | temp.setSparePartId(mainId); |
| | | } |
| | | long start = System.currentTimeMillis(); |
| | | sparesPartInventoryService.saveBatch(list); |
| | |
| | | } |
| | | return Result.error("文件导入失败!"); |
| | | } |
| | | /* @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request; |
| | | Map<String, MultipartFile> fileMap = multipartRequest.getFileMap(); |
| | | for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) { |
| | | // 获取上传文件对象 |
| | | MultipartFile file = entity.getValue(); |
| | | ImportParams params = new ImportParams(); |
| | | params.setTitleRows(2); |
| | | params.setHeadRows(1); |
| | | params.setNeedSave(true); |
| | | try { |
| | | List<SparesPartInventory> list = ExcelImportUtil.importExcel(file.getInputStream(), SparesPartInventory.class, params); |
| | | long start = System.currentTimeMillis(); |
| | | sparesPartInventoryService.saveBatch(list); |
| | | log.info("消耗时间" + (System.currentTimeMillis() - start) + "毫秒"); |
| | | return Result.OK("文件导入成功!数据行数:" + list.size()); |
| | | } catch (Exception e) { |
| | | log.error(e.getMessage(), e); |
| | | return Result.error("文件导入失败:" + e.getMessage()); |
| | | } finally { |
| | | try { |
| | | file.getInputStream().close(); |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | | } |
| | | } |
| | | } |
| | | return Result.error("文件导入失败!"); |
| | | }*/ |
| | | |
| | | |
| | | |
| | | /** |