From 01964e6852e3e52ffc2cc7b45cccf583fee93927 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Wed, 17 Apr 2024 14:07:35 +0800
Subject: [PATCH] 填报水位库容导入接口
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbResStagCapDiscController.java | 31 +++++++++++++++++++++++++++++--
1 files changed, 29 insertions(+), 2 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbResStagCapDiscController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbResStagCapDiscController.java
index f3f354d..cfd85c0 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbResStagCapDiscController.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbResStagCapDiscController.java
@@ -1,17 +1,21 @@
package cn.gistack.sm.sjztmd.controller;
-import cn.gistack.sm.sjztmd.entity.TbAttResBase;
-import cn.gistack.sm.sjztmd.entity.TbFileStorageLocation;
import cn.gistack.sm.sjztmd.entity.TbResStagCapDisc;
+import cn.gistack.sm.sjztmd.excel.TbResStagCapDiscImport;
+import cn.gistack.sm.sjztmd.excel.TbResStagCapDiscImportExcel;
import cn.gistack.sm.sjztmd.service.ITbResStagCapDiscService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
+import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.StringUtil;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletResponse;
+import java.util.ArrayList;
import java.util.List;
@Slf4j
@@ -61,6 +65,29 @@
return R.status(tbResStagCapDiscService.auditByGuid(list));
}
+ /**
+ * 导入模板
+ */
+ @GetMapping("export-template")
+ @ApiOperation(value = "导入模板")
+ public void exportUser(HttpServletResponse response) {
+ List<TbResStagCapDiscImportExcel> list = new ArrayList<>();
+ ExcelUtil.export(response, "水位库容导入模板", "水位库容数据表", list, TbResStagCapDiscImportExcel.class);
+ }
+
+ /**
+ * 导入数据(返回数据给前端,由前端进行真正的保存)
+ */
+ @PostMapping("import-tbResStagCapDisc")
+ @ApiOperation(value = "导入用户", notes = "传入excel")
+ public R importUser(MultipartFile file,String resGuid) {
+
+ List<TbResStagCapDisc> list = tbResStagCapDiscService.readExcel(file);
+
+ return R.data(list);
+ }
+
+
}
--
Gitblit v1.9.3