优化导出数据操作

RuoYi

2021-11-17 173c0e384ffc63baa3f07b8adacedc5ff7ae0a10

 ruoyi-modules/ruoyi-gen/src/main/resources/vm/java/controller.java.vm

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

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

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

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

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

import ${packageName}.domain.${ClassName};

import ${packageName}.service.I${ClassName}Service;

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

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

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

#if($table.crud)

#if($table.crud || $table.sub)

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

#elseif($table.tree)

#end

@@ -41,9 +41,9 @@
    /**

     * 查询${functionName}列表

     */

    @PreAuthorize(hasPermi = "${permissionPrefix}:list")

    @RequiresPermissions("${permissionPrefix}:list")

    @GetMapping("/list")

#if($table.crud)

#if($table.crud || $table.sub)

    public TableDataInfo list(${ClassName} ${className})

    {

        startPage();

@@ -61,30 +61,30 @@
    /**

     * 导出${functionName}列表

     */

    @PreAuthorize(hasPermi = "${permissionPrefix}:export")

    @RequiresPermissions("${permissionPrefix}:export")

    @Log(title = "${functionName}", businessType = BusinessType.EXPORT)

    @PostMapping("/export")

    public void export(HttpServletResponse response, ${ClassName} ${className}) throws IOException

    public void export(HttpServletResponse response, ${ClassName} ${className})

    {

        List<${ClassName}> list = ${className}Service.select${ClassName}List(${className});

        ExcelUtil<${ClassName}> util = new ExcelUtil<${ClassName}>(${ClassName}.class);

        util.exportExcel(response, list, "${businessName}");

        util.exportExcel(response, list, "${functionName}数据");

    }



    /**

     * 获取${functionName}详细信息

     */

    @PreAuthorize(hasPermi = "${permissionPrefix}:query")

    @RequiresPermissions("${permissionPrefix}:query")

    @GetMapping(value = "/{${pkColumn.javaField}}")

    public AjaxResult getInfo(@PathVariable("${pkColumn.javaField}") ${pkColumn.javaType} ${pkColumn.javaField})

    {

        return AjaxResult.success(${className}Service.select${ClassName}ById(${pkColumn.javaField}));

        return AjaxResult.success(${className}Service.select${ClassName}By${pkColumn.capJavaField}(${pkColumn.javaField}));

    }



    /**

     * 新增${functionName}

     */

    @PreAuthorize(hasPermi = "${permissionPrefix}:add")

    @RequiresPermissions("${permissionPrefix}:add")

    @Log(title = "${functionName}", businessType = BusinessType.INSERT)

    @PostMapping

    public AjaxResult add(@RequestBody ${ClassName} ${className})

@@ -95,7 +95,7 @@
    /**

     * 修改${functionName}

     */

    @PreAuthorize(hasPermi = "${permissionPrefix}:edit")

    @RequiresPermissions("${permissionPrefix}:edit")

    @Log(title = "${functionName}", businessType = BusinessType.UPDATE)

    @PutMapping

    public AjaxResult edit(@RequestBody ${ClassName} ${className})

@@ -106,11 +106,11 @@
    /**

     * 删除${functionName}

     */

    @PreAuthorize(hasPermi = "${permissionPrefix}:remove")

    @RequiresPermissions("${permissionPrefix}:remove")

    @Log(title = "${functionName}", businessType = BusinessType.DELETE)

   @DeleteMapping("/{${pkColumn.javaField}s}")

    public AjaxResult remove(@PathVariable ${pkColumn.javaType}[] ${pkColumn.javaField}s)

    {

        return toAjax(${className}Service.delete${ClassName}ByIds(${pkColumn.javaField}s));

        return toAjax(${className}Service.delete${ClassName}By${pkColumn.capJavaField}s(${pkColumn.javaField}s));

    }

}