#

luxiaotao1123

2020-06-06 b66cc5ddc2e671cecefa6edfc3b33003cc8d2f8e

#

 src/main/java/com/zy/asrs/controller/MatCodeController.java

@@ -1,6 +1,7 @@
package com.zy.asrs.controller;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
@@ -123,7 +124,10 @@
        response.setCharacterEncoding("utf-8");
        fileName = URLEncoder.encode(Cools.isEmpty(fileName)?"物料编码":fileName, "UTF-8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), MatCodeExcel.class).sheet("表1").doWrite(excels);
        EasyExcel.write(response.getOutputStream(), MatCodeExcel.class)
                .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
                .sheet("表1")
                .doWrite(excels);
    }

    // 导入

 src/main/webapp/views/matCode/matCode.html

@@ -22,7 +22,7 @@
    </div>

    <!-- 待添加 -->
    <div id="data-search-btn" class="layui-btn-container layui-form-item">
    <div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block">
        <button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索</button>
        <button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置</button>
    </div>
@@ -64,7 +64,7 @@
        <div class="layui-form-item">
            <label class="layui-form-label"  style="padding: 9px 0">导出行数</label>
            <div class="layui-input-block" style="margin-left: 90px;">
                <input type="text" id="exportRowCount" placeholder="选填" autocomplete="off" class="layui-input" lay-verify="number" lay-reqtext="请输入数字">
                <input type="text" id="exportRowCount" placeholder="选填（默认全部）" autocomplete="off" class="layui-input" lay-verify="number" lay-reqtext="请输入数字">
            </div>
        </div>
        <div style="text-align: center; margin-top: 20px">