优化导出数据操作

RuoYi

2021-11-17 173c0e384ffc63baa3f07b8adacedc5ff7ae0a10

 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysDictTypeController.java

@@ -1,6 +1,5 @@
package com.ruoyi.system.controller;



import java.io.IOException;

import java.util.List;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;

@@ -14,15 +13,15 @@
import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import com.ruoyi.common.core.constant.UserConstants;

import com.ruoyi.common.core.utils.SecurityUtils;

import com.ruoyi.common.core.utils.poi.ExcelUtil;

import com.ruoyi.common.core.web.controller.BaseController;

import com.ruoyi.common.core.web.domain.AjaxResult;

import com.ruoyi.common.core.web.page.TableDataInfo;

import com.ruoyi.common.log.annotation.Log;

import com.ruoyi.common.log.enums.BusinessType;

import com.ruoyi.common.security.annotation.PreAuthorize;

import com.ruoyi.system.domain.SysDictType;

import com.ruoyi.common.security.annotation.RequiresPermissions;

import com.ruoyi.common.security.utils.SecurityUtils;

import com.ruoyi.system.api.domain.SysDictType;

import com.ruoyi.system.service.ISysDictTypeService;



/**

@@ -37,7 +36,7 @@
    @Autowired

    private ISysDictTypeService dictTypeService;



    @PreAuthorize(hasPermi = "system:dict:list")

    @RequiresPermissions("system:dict:list")

    @GetMapping("/list")

    public TableDataInfo list(SysDictType dictType)

    {

@@ -47,9 +46,9 @@
    }



    @Log(title = "字典类型", businessType = BusinessType.EXPORT)

    @PreAuthorize(hasPermi = "system:dict:export")

    @RequiresPermissions("system:dict:export")

    @PostMapping("/export")

    public void export(HttpServletResponse response, SysDictType dictType) throws IOException

    public void export(HttpServletResponse response, SysDictType dictType)

    {

        List<SysDictType> list = dictTypeService.selectDictTypeList(dictType);

        ExcelUtil<SysDictType> util = new ExcelUtil<SysDictType>(SysDictType.class);

@@ -59,7 +58,7 @@
    /**

     * 查询字典类型详细

     */

    @PreAuthorize(hasPermi = "system:dict:query")

    @RequiresPermissions("system:dict:query")

    @GetMapping(value = "/{dictId}")

    public AjaxResult getInfo(@PathVariable Long dictId)

    {

@@ -69,7 +68,7 @@
    /**

     * 新增字典类型

     */

    @PreAuthorize(hasPermi = "system:dict:add")

    @RequiresPermissions("system:dict:add")

    @Log(title = "字典类型", businessType = BusinessType.INSERT)

    @PostMapping

    public AjaxResult add(@Validated @RequestBody SysDictType dict)

@@ -85,7 +84,7 @@
    /**

     * 修改字典类型

     */

    @PreAuthorize(hasPermi = "system:dict:edit")

    @RequiresPermissions("system:dict:edit")

    @Log(title = "字典类型", businessType = BusinessType.UPDATE)

    @PutMapping

    public AjaxResult edit(@Validated @RequestBody SysDictType dict)

@@ -101,23 +100,24 @@
    /**

     * 删除字典类型

     */

    @PreAuthorize(hasPermi = "system:dict:remove")

    @RequiresPermissions("system:dict:remove")

    @Log(title = "字典类型", businessType = BusinessType.DELETE)

    @DeleteMapping("/{dictIds}")

    public AjaxResult remove(@PathVariable Long[] dictIds)

    {

        return toAjax(dictTypeService.deleteDictTypeByIds(dictIds));

        dictTypeService.deleteDictTypeByIds(dictIds);

        return success();

    }



    /**

     * 清空缓存

     * 刷新字典缓存

     */

    @PreAuthorize(hasPermi = "system:dict:remove")

    @RequiresPermissions("system:dict:remove")

    @Log(title = "字典类型", businessType = BusinessType.CLEAN)

    @DeleteMapping("/clearCache")

    public AjaxResult clearCache()

    @DeleteMapping("/refreshCache")

    public AjaxResult refreshCache()

    {

        dictTypeService.clearCache();

        dictTypeService.resetDictCache();

        return AjaxResult.success();

    }