Excel支持sort导出排序

RuoYi

2020-07-10 ec096965123b1e341f1ec80ea674c3d7de485d2e

 ruoyi/src/main/java/com/ruoyi/project/system/controller/SysDictTypeController.java

@@ -3,6 +3,7 @@
import java.util.List;

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

import org.springframework.security.access.prepost.PreAuthorize;

import org.springframework.validation.annotation.Validated;

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

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

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

@@ -10,10 +11,10 @@
import org.springframework.web.bind.annotation.PutMapping;

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

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

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

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

import com.ruoyi.common.constant.UserConstants;

import com.ruoyi.common.utils.SecurityUtils;

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

import com.ruoyi.framework.aspectj.lang.annotation.Log;

import com.ruoyi.framework.aspectj.lang.enums.BusinessType;

import com.ruoyi.framework.web.controller.BaseController;

@@ -36,12 +37,21 @@


    @PreAuthorize("@ss.hasPermi('system:dict:list')")

    @GetMapping("/list")

    @ResponseBody

    public TableDataInfo list(SysDictType dictType)

    {

        startPage();

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

        return getDataTable(list);

    }



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

    @PreAuthorize("@ss.hasPermi('system:dict:export')")

    @GetMapping("/export")

    public AjaxResult export(SysDictType dictType)

    {

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

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

        return util.exportExcel(list, "字典类型");

    }



    /**

@@ -60,7 +70,7 @@
    @PreAuthorize("@ss.hasPermi('system:dict:add')")

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

    @PostMapping

    public AjaxResult add(@RequestBody SysDictType dict)

    public AjaxResult add(@Validated @RequestBody SysDictType dict)

    {

        if (UserConstants.NOT_UNIQUE.equals(dictTypeService.checkDictTypeUnique(dict)))

        {

@@ -76,7 +86,7 @@
    @PreAuthorize("@ss.hasPermi('system:dict:edit')")

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

    @PutMapping

    public AjaxResult edit(@RequestBody SysDictType dict)

    public AjaxResult edit(@Validated @RequestBody SysDictType dict)

    {

        if (UserConstants.NOT_UNIQUE.equals(dictTypeService.checkDictTypeUnique(dict)))

        {

@@ -91,9 +101,31 @@
     */

    @PreAuthorize("@ss.hasPermi('system:dict:remove')")

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

    @DeleteMapping("/{dictId}")

    public AjaxResult remove(@PathVariable Long dictId)

    @DeleteMapping("/{dictIds}")

    public AjaxResult remove(@PathVariable Long[] dictIds)

    {

        return toAjax(dictTypeService.deleteDictTypeById(dictId));

        return toAjax(dictTypeService.deleteDictTypeByIds(dictIds));

    }



    /**

     * 清空缓存

     */

    @PreAuthorize("@ss.hasPermi('system:dict:remove')")

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

    @DeleteMapping("/clearCache")

    public AjaxResult clearCache()

    {

        dictTypeService.clearCache();

        return AjaxResult.success();

    }



    /**

     * 获取字典选择框列表

     */

    @GetMapping("/optionselect")

    public AjaxResult optionselect()

    {

        List<SysDictType> dictTypes = dictTypeService.selectDictTypeAll();

        return AjaxResult.success(dictTypes);

    }

}