From 059c6a5058295cd93741cf04c0a52a4a53e2c284 Mon Sep 17 00:00:00 2001 From: cuijian <cuijian@xalxzn.com> Date: 星期一, 30 十月 2023 18:29:28 +0800 Subject: [PATCH] 操作证导入功能,创建工种表 --- lxzn-boot-base-core/src/main/java/org/jeecg/common/util/ImportExcelUtil.java | 25 +++++++++++++++++++++++++ 1 files changed, 25 insertions(+), 0 deletions(-) diff --git a/lxzn-boot-base-core/src/main/java/org/jeecg/common/util/ImportExcelUtil.java b/lxzn-boot-base-core/src/main/java/org/jeecg/common/util/ImportExcelUtil.java index ead7ee6..66849a1 100644 --- a/lxzn-boot-base-core/src/main/java/org/jeecg/common/util/ImportExcelUtil.java +++ b/lxzn-boot-base-core/src/main/java/org/jeecg/common/util/ImportExcelUtil.java @@ -39,6 +39,31 @@ } } + public static Result<?> imporReturnOperationCertificate(int totalLines,int partSuccessLines,int errorLines,int successLines,List<String> errorMessage) throws IOException { + if (errorLines == 0 && partSuccessLines == 0) { + return Result.ok("鍏�" + successLines + "琛屾暟鎹叏閮ㄥ鍏ユ垚鍔燂紒"); + } else { + JSONObject result = new JSONObject(5); + int totalCount = successLines + errorLines; + int fullSuccessLines = successLines - partSuccessLines; + result.put("totalCount", totalCount); + result.put("errorCount", errorLines); + result.put("fullSuccessLines", fullSuccessLines); + result.put("totalLines",totalLines); + result.put("partSuccessLines",partSuccessLines); + result.put("msg", "鎬讳笂浼犺鏁帮細" + totalLines + "锛屽畬鍏ㄥ鍏ユ垚鍔熻鏁帮細" + fullSuccessLines + "锛岄儴鍒嗗鍏ユ垚鍔熻鏁帮細"+partSuccessLines+"锛屽鍏ュけ璐ヨ鏁帮細" + errorLines); + String fileUrl = PmsUtil.saveErrorTxtByList(errorMessage, "userImportExcelErrorLog"); + int lastIndex = fileUrl.lastIndexOf(File.separator); + String fileName = fileUrl.substring(lastIndex + 1); + result.put("fileUrl", "/sys/common/static/" + fileUrl); + result.put("fileName", fileName); + Result res = Result.ok(result); + res.setCode(201); + res.setMessage("鏂囦欢瀵煎叆鎴愬姛锛屼絾鏈夐敊璇��"); + return res; + } + } + public static List<String> importDateSave(List<?> list, Class serviceClass, List<String> errorMessage, String errorFlag) { IService bean =(IService) SpringContextUtils.getBean(serviceClass); for (int i = 0; i < list.size(); i++) { -- Gitblit v1.9.3