yusijie
2023-06-29 29a92fcf4fc990763d08c8d88ee4f9b1c8bf2e80
Merge branch 'master' of http://101.37.171.70:10101/r/zymesSrmLayUi
1个文件已添加
2个文件已修改
32662 ■■■■■ 已修改文件
WebSRM/WebSRM.csproj 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebSRM/layuiAdmin.std-v1.2.1/src/layuiadmin/modules/excel.js 32630 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html 30 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebSRM/WebSRM.csproj
@@ -716,6 +716,7 @@
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\common.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\console.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\contlist.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\excel.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\forum.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\im.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\message.js" />
@@ -729,6 +730,7 @@
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\jquery-1.4.1.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\jquery-1.4.1.min.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\json2.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\webConfig.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\style\admin.css" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\style\login.css" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\style\res\bg-none.jpg" />
WebSRM/layuiAdmin.std-v1.2.1/src/layuiadmin/modules/excel.js
New file
Diff too large
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
@@ -181,6 +181,7 @@
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button>
                        </div>
                    </script>
                </div>
@@ -229,14 +230,15 @@
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element;
                , element = layui.element
                , excel = layui.excel;
            //常规用法
            laydate.render({
                elem: '#HDate1'
@@ -880,6 +882,30 @@
                            }
                        });
                        break;
                    case 'set_dao':
                        //获取列表列数据源
                        var ColName = [];
                        for (var i = 1; i < option.cols[0].length; i++) {
                            if (option.cols[0][i]["hide"] != true) {
                                ColName.push(option.cols[0][i]["field"]);
                            }
                        }
                        //绑定数据
                        var data = excel.filterExportData(option.data, ColName)
                        //赋值于表头列名
                        var Title = [];
                        for (var i = 0; i < ColName.length; i++) {
                            Title.push("\"" + ColName[i] + "\":\"" + ColName[i] + "\"");
                        }
                        var TitleName = JSON.parse("{" + Title.toString() + "}");
                        data.unshift(TitleName);
                        //导出 sheet1 工作表名
                        excel.exportExcel({
                            sheet1: data
                        }, '采购订单列表.xlsx', 'xlsx');
                        break;
                };
            });
        });