WebSRM/WebSRM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebSRM/layuiAdmin.std-v1.2.1/src/layuiadmin/modules/excel.js | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | 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; }; }); });