From f4c591df7d87b6276caa9aa09602c128bedcf738 Mon Sep 17 00:00:00 2001
From: Jinquan_Ou <Jinquan@gdut.com>
Date: 星期三, 22 三月 2023 14:52:21 +0800
Subject: [PATCH] 导入接口
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java | 33 ++++++++++++++++++++++++++++++++-
1 files changed, 32 insertions(+), 1 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java
index aa0c7f4..ee85e92 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfPropertyController.java
@@ -3,14 +3,19 @@
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.core.domain.entity.SysUser;
+import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.core.text.Convert;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.ServletUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.domain.ZfProperty;
+import com.ruoyi.framework.web.service.TokenService;
import com.ruoyi.service.IZfPropertyService;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
import java.util.Arrays;
@@ -24,6 +29,7 @@
* @Author Jin_quan Ou
* @Date 2023-03-09 10:18
*/
+@Slf4j
@RestController
@RequestMapping("/family/property")
public class ZfPropertyController extends BaseController
@@ -31,11 +37,14 @@
@Autowired
private IZfPropertyService zfPropertyService;
+ @Autowired
+ private TokenService tokenService;
+
@GetMapping("/all")
public AjaxResult listAll(ZfProperty zfProperty){
Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1);
Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10);
- return zfPropertyService.selectUserList(zfProperty,pageNum,pageSize);
+ return zfPropertyService.selectUserList(zfProperty, pageNum, pageSize);
}
// /**
@@ -59,10 +68,32 @@
public void export(HttpServletResponse response,ZfProperty zfProperty)
{
List<ZfProperty> list = zfPropertyService.selectByCondition(zfProperty);
+ log.info("瀵煎嚭璁板綍涓�:{}",list);
ExcelUtil<ZfProperty> util = new ExcelUtil<ZfProperty>(ZfProperty.class);
util.exportExcel(response, list, "瀹跺涵璧勪骇璁板綍鏁版嵁");
}
//
+
+ /**
+ * 瀵煎叆瀹跺涵璧勪骇璁板綍鍒楄〃
+ */
+ @Log(title = "鐢ㄦ埛绠＄悊", businessType = BusinessType.IMPORT)
+ @PostMapping("/importData")
+ public AjaxResult importData(@RequestParam("excelImport")MultipartFile file) throws Exception
+ {
+ ExcelUtil<ZfProperty> util = new ExcelUtil<>(ZfProperty.class);
+ List<ZfProperty> propertyList = util.importExcel(file.getInputStream());
+ log.info("璧勪骇鍒楄〃涓猴細{}",propertyList);
+
+ if (zfPropertyService.saveBatch(propertyList)) {
+ return AjaxResult.success("瀵煎叆鏁版嵁鎴愬姛");
+ }
+
+ return AjaxResult.error("瀵煎叆鏁版嵁澶辫触");
+
+ }
+
+
/**
* 鑾峰彇瀹跺涵璧勪骇璁板綍璇︾粏淇℃伅
*/
--
Gitblit v1.9.1