From b700b37c67c8155d3078955f2690406d814f1826 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期二, 25 三月 2025 15:42:33 +0800 Subject: [PATCH] 第三方人事系统配置+设备导入 --- cnas-device/src/main/java/com/ruoyi/device/controller/DeviceController.java | 28 ++++++++++++++++++++++++---- 1 files changed, 24 insertions(+), 4 deletions(-) diff --git a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceController.java b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceController.java index bb70b52..5f0ab10 100644 --- a/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceController.java +++ b/cnas-device/src/main/java/com/ruoyi/device/controller/DeviceController.java @@ -1,17 +1,22 @@ package com.ruoyi.device.controller; +import com.alibaba.excel.EasyExcel; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.ruoyi.basic.excel.StructureTestObjectData; +import com.ruoyi.basic.excel.StructureTestObjectListener; import com.ruoyi.common.core.domain.Result; import com.ruoyi.device.dto.DataConfigDto; import com.ruoyi.device.dto.DeviceCollectionDto; import com.ruoyi.device.dto.DeviceDto; +import com.ruoyi.device.excel.upload.DeviceListener; import com.ruoyi.device.pojo.DataConfig; import com.ruoyi.device.pojo.Device; import com.ruoyi.device.service.DataConfigService; import com.ruoyi.device.service.DeviceService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import org.apache.commons.codec.digest.DigestUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.*; @@ -21,12 +26,11 @@ import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.File; +import java.io.IOException; +import java.io.InputStream; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; -import java.util.Arrays; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import java.util.*; import java.util.stream.Collectors; /** @@ -196,4 +200,20 @@ public void exportEquipmentDetails(HttpServletResponse response) throws Exception { deviceService.exportEquipmentDetails(response); } + + /** + * 瀵煎叆璁惧 + * @return + */ + @ApiOperation(value = "瀵煎叆璁惧") + @PostMapping("/importDevice") + public Result importDevice(@RequestParam("file") MultipartFile file){ + try { + EasyExcel.read(file.getInputStream(), Device.class, new DeviceListener(deviceService)).sheet().doRead(); + } catch (IOException e) { + // 杩欓噷鍙互鏍规嵁瀹為檯鎯呭喌杩涜鏇村畬鍠勭殑閿欒澶勭悊锛屾瘮濡傝褰曟棩蹇楃瓑 + System.err.println("璇诲彇鏂囦欢鏃跺彂鐢熼敊璇�: " + e.getMessage()); + } + return Result.success(); + } } -- Gitblit v1.9.3