yusijie
2024-04-12 7f7179d00825d06ec064f8bbbccdf406424a4609
WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_MaterOutEntryReport_Cloth.html
@@ -43,7 +43,25 @@
            </select>
        </div>
    </div>-->
                                <div class="layui-inline">
                                <div class="layui-form layui-inline" style="position:relative;top:10px;">
                                    <label class="layui-form-label">日期</label>
                                    <div class="layui-form-item  layui-inline">
                                        <div class="layui-inline">
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-form-item  layui-inline">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">-</label>
                                            <div class="layui-input-inline">
                                                <input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label">日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HBeginDate" style="width:190px;">
@@ -54,7 +72,7 @@
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HEndDate" style="width:190px;">
                                    </div>
                                </div>
                                </div>-->
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
@@ -131,6 +149,7 @@
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></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="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                            </div>
@@ -162,6 +181,10 @@
            var sWhere = "";
            var option = [];
            var HModName = "MaterOutEntryReport_Cloth";
            var ins;                        //用于导出excel
            var detailBar = 0;       //用于汇总报表查看明细报表,当为0时显示明细汇总报表对应明细报表。
            //#endregion
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
@@ -175,6 +198,10 @@
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //退出
                    case 'btn-exit': Pub_Close(2);
                        break;
@@ -193,6 +220,24 @@
                get_FastQuery();
            });
            //行监听事件-单击
            table.on('row(mainTable)', function (obj) {
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据,前面的只是添加或删除选中未选中样式以及设置背景色,字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            });
            //#endregion
            //#region æ­¤é¡µé¢æ‰€æœ‰çš„æ–¹æ³•
@@ -200,10 +245,29 @@
            //初始化界面
            function set_ClearBill() {
                //初始化时间
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HBeginDate
                });
                laydate.render({
                    elem: '#HEndDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HEndDate
                });
                ////初始化时间
                //$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//开始日期
                //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                //初始化表格
                //set_InitGrid();
                set_InitGrid();
                //加载数据到网格
                get_FastQuery();
                DisPlay_HideColumn();
@@ -211,174 +275,12 @@
            }
            //初始化表格
            function set_InitGrid(sWhere) {
                //动态列-缓存列表
                $.ajax({
                    url: GetWEBURL() + "/MaterOutEntryReport/MaterOutEntryReport_Cloth",
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere },
                    //async: false,
                    success: function (data1) {
            function set_InitGrid() {
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                var width = data1.list[key].width * 23;
                                if (width < 150) {
                                    width = 150;
                                } else if (width > 300) {
                                    width = 300;
                                }
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType, "width": width });
                            }
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, "") > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: data[i].width });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: data[i].width });
                                    }
                                }
                            }
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cellMinWidth: 120
                                , limit: Number.MAX_VALUE // æ•°æ®è¡¨æ ¼é»˜è®¤å…¨éƒ¨æ˜¾ç¤º
                                , totalRow: true
                                , height: 'full-70'
                                , cols: [col]
                                , data: data1.data
                            };
                            table.render(option);
                        } else {
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cellMinWidth: 120
                                , limit: Number.MAX_VALUE // æ•°æ®è¡¨æ ¼é»˜è®¤å…¨éƒ¨æ˜¾ç¤º
                                , totalRow: true
                                , height: 'full-70'
                                , cols: [[
                                    { type: 'checkbox', fixed: 'left', totalRowText: '合计' }
                                    , { field: '日期', title: '日期', width: 160 }
                                    , { field: '任务单', title: '任务单', width: 160 }
                                    , { field: '工序流转卡号', title: '工序流转卡号', width: 160 }
                                    , { field: '产品名称', title: '产品名称', width: 160 }
                                    , { field: '规格型号', title: '规格型号', width: 160 }
                                    , { field: '当前工序', title: '当前工序', width: 160 }
                                    , { field: '任务数量', title: '任务数量', width: 160 }
                                    , { field: '制单人', title: '制单人', width: 200 }
                                    , { field: '流转卡数量', title: '流转卡数量', width: 160, totalRow: true }
                                ]]
                                , done: function (res) {
                                    //var count = 0;
                                    //var OnlyID = -1;
                                    //for (var i = 0; i < res.data.length; i++) {
                                    //    if (res.data[i]["唯一ID"] != OnlyID) {
                                    //        count += res.data[i]["整批"];
                                    //        OnlyID = res.data[i]["唯一ID"];
                                    //    }
                                    //}
                                    //var divArr = $(".layui-table-total div.layui-table-cell");
                                    //$.each(divArr, function (index, item) {
                                    //    var _div = $(item);
                                    //    var content = _div.html();
                                    //    if (index == 9) {
                                    //        content = count;
                                    //    }
                                    //    _div.html(content);
                                    //});
                                }
                            };
                            table.render(option);
                        }
                    },
                    error: function (err) {
                        layer.msg('错误' + err, {
                            icon: 5,
                            time: 20000
                        }, function () {
                            //do something
                        });
                    }
                })
            }
            //列明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                form.render('select');
            }
            //加载网格
            function get_Display(sWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    url: GetWEBURL() + '/MaterOutEntryReport/MaterOutEntryReport_Cloth',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    success: function (data1) {
                        if (data1.count == 1) {
                            option.data = data1.data;
                            //var num = 0;
                            //for (let i = 0; i < data1.data.length; i++) {
                            //    for (let j = i + 1; j < data1.data.length; j++) {
                            //        if (data1.data[i].流转卡号 === data1.data[j].流转卡号) {
                            //            //num += data1.data[i].整批;
                            //            //data1.data[i].filter(() => {
                            //            //    return
                            //            //})
                            //            data1.data[j].整批 = '';
                            //        }
                            //    }
                            //}
                            table.render(option);
                            //计算合计公斤数
                            var sumHMaterOutQty = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumHMaterOutQty += data1.data[i]["白坯发布"];
                            }
                            $("#SumHMaterOutQty").val(sumHMaterOutQty);
                            layer.close(wait);
                        } else {
                            $("#SumHMaterOutQty").val("");
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        $("#SumHMaterOutQty").val("");
                        layer.close(wait);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //快速过滤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期
                //var HBeginDate = $("#HBeginDate").val() + ":00:00" ;//下达日期 å¼€å§‹æ—¥æœŸ
                //var HEndDate = $("#HEndDate").val()+":00:00";//结束日期
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
@@ -421,8 +323,266 @@
                    , HProductModel: HProductModel
                    , RandomSearch: com
                }
                sWhere = JSON.stringify(sWhere);
                set_InitGrid(JSON.stringify(sWhere));
                //动态列-缓存列表
                $.ajax({
                    url: GetWEBURL() + "/MaterOutEntryReport/MaterOutEntryReport_Cloth",
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    //async: false,
                    success: function (data1) {
                        if (data1.count == 1) {
                            var totalArray = ["任务数量","白坯发布", "流转卡数量"];
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                var width = data1.list[key].width * 23;
                                if (width < 150) {
                                    width = 150;
                                } else if (width > 300) {
                                    width = 300;
                                }
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType});
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, "") > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if ($.inArray(data[i].name, totalArray) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                }
                                else if (data[i].ColName == '白坯发布') {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow:true });
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
                                    }
                                }
                            }
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cellMinWidth: 120
                                , limit: Number.MAX_VALUE // æ•°æ®è¡¨æ ¼é»˜è®¤å…¨éƒ¨æ˜¾ç¤º
                                , totalRow: true
                                , height: 'full-70'
                                , cols: [col]
                                , data: data1.data
                            };
                            ins = table.render(option);
                        } else {
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cellMinWidth: 120
                                , limit: Number.MAX_VALUE // æ•°æ®è¡¨æ ¼é»˜è®¤å…¨éƒ¨æ˜¾ç¤º
                                , totalRow: true
                                , height: 'full-70'
                                , cols: [[
                                    { type: 'checkbox', fixed: 'left', totalRowText: '合计' }
                                    , { field: '日期', title: '日期', width: 160 }
                                    , { field: '任务单', title: '任务单', width: 160 }
                                    , { field: '工序流转卡号', title: '工序流转卡号', width: 160 }
                                    , { field: '产品名称', title: '产品名称', width: 160 }
                                    , { field: '规格型号', title: '规格型号', width: 160 }
                                    , { field: '当前工序', title: '当前工序', width: 160 }
                                    , { field: '任务数量', title: '任务数量', totalRow: true,width: 160 }
                                    , { field: '制单人', title: '制单人', width: 200 }
                                    , { field: '流转卡数量', title: '流转卡数量', width: 160, totalRow: true }
                                ]]
                                , done: function (res) {
                                    //var count = 0;
                                    //var OnlyID = -1;
                                    //for (var i = 0; i < res.data.length; i++) {
                                    //    if (res.data[i]["唯一ID"] != OnlyID) {
                                    //        count += res.data[i]["整批"];
                                    //        OnlyID = res.data[i]["唯一ID"];
                                    //    }
                                    //}
                                    //var divArr = $(".layui-table-total div.layui-table-cell");
                                    //$.each(divArr, function (index, item) {
                                    //    var _div = $(item);
                                    //    var content = _div.html();
                                    //    if (index == 9) {
                                    //        content = count;
                                    //    }
                                    //    _div.html(content);
                                    //});
                                }
                            };
                            ins = table.render(option);
                        }
                    },
                    error: function (err) {
                        layer.msg('错误' + err, {
                            icon: 5,
                            time: 20000
                        }, function () {
                            //do something
                        });
                    }
                })
            }
            //列明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                form.render('select');
            }
            //加载网格
            function get_Display(sWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    url: GetWEBURL() + '/MaterOutEntryReport/MaterOutEntryReport_Cloth',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            //调整日期格式:显示 å¹´æœˆæ—¥ å’Œ æ—¶ åˆ†
                            for (var i = 0; i < data1.data.length; i++) {
                                if (data1.data[i].日期 != null) {
                                    data1.data[i].日期 = data1.data[i]["日期"].split(":")[0] + ":" + data1.data[i]["日期"].split(":")[1];
                                    data1.data[i].日期 = data1.data[i]["日期"].replace("T", " ");
                                }
                            }
                            option.data = data1.data;
                            //var num = 0;
                            //for (let i = 0; i < data1.data.length; i++) {
                            //    for (let j = i + 1; j < data1.data.length; j++) {
                            //        if (data1.data[i].流转卡号 === data1.data[j].流转卡号) {
                            //            //num += data1.data[i].整批;
                            //            //data1.data[i].filter(() => {
                            //            //    return
                            //            //})
                            //            data1.data[j].整批 = '';
                            //        }
                            //    }
                            //}
                            ins = table.render(option);
                            //计算合计公斤数
                            var sumHMaterOutQty = 0;
                            for (var i = 0; i < data1.data.length; i++) {
                                sumHMaterOutQty += data1.data[i]["白坯发布"];
                            }
                            $("#SumHMaterOutQty").val(sumHMaterOutQty);
                            layer.close(wait);
                        } else {
                            $("#SumHMaterOutQty").val("");
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        $("#SumHMaterOutQty").val("");
                        layer.close(wait);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //快速过滤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
                var HEndDate = $("#HEndDate").val();//结束日期
                if (HBeginDate == '') {
                    HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                } else {
                    HBeginDate = $("#HBeginDate").val() + ":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                }
                if (HEndDate == '') {
                    HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//结束日期
                } else {
                    HEndDate = $("#HEndDate").val() + ":00:00";//结束日期
                }
                //var HBeginDate = $("#HBeginDate").val()+":00:00";//下达日期 å¼€å§‹æ—¥æœŸ
                //var HEndDate = $("#HEndDate").val()+":00:00";//结束日期
                var HMaterNumber = $("#HMaterNumber").val();//物料代码
                var HBillNo = $("#HBillNo").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
                var HProductModel = $("#HProductModel").val();//产品规格
                //任意字段条件过滤 æ¡ä»¶æå–
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                //拼接任一字段过滤查询条件
                var com = "";
                if (ColName != 0 && Comparator != 0) {
                    switch (Comparator) {
                        case "7":
                            com = "like ''%" + ColContent + "%''";
                            break;
                        case "8":
                            com = "like ''%" + ColContent + "''";
                            break;
                        case "9":
                            com = "like ''" + ColContent + "%''";
                            break;
                        case "10":
                            com = "not like ''%" + ColContent + "%''";
                            break;
                        default:
                            com = "" + Comparator + " ''" + ColContent + "''";
                            break;
                    }
                    com = " and (" + ColName + " " + com + ")";
                }
                var params = get_UrlVars();
                if (params[params[0]] != null && detailBar == 0) {
                    //汇总报表的生产订单号
                    HBillNo = params[params[0]];
                    //设置生产订单号标签
                    $("#HBillNo").val(HBillNo);
                    //设置时间为一个很大的值,默认搜索所有时间的明细
                    HBeginDate = "1900-01-01 00:00:00";
                    HEndDate = "2200-01-01 00:00:00";
                    detailBar = 1;
                } else {
                    HBillNo = $("#HBillNo").val();          //单据号
                }
                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
                    , HMaterNumber: HMaterNumber
                    , HBillNo: HBillNo
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch: com
                }
                //set_InitGrid(JSON.stringify(sWhere));
                get_Display(JSON.stringify(sWhere));
                //调用接口后清空sWhere缓存
                sWhere = "";
@@ -430,8 +590,26 @@
            //重置过滤条件
            function set_ClearQuery() {
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                //初始化时间
                var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
                laydate.render({
                    elem: '#HBeginDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HBeginDate
                });
                laydate.render({
                    elem: '#HEndDate',
                    type: 'datetime',
                    fullPanel: true
                    , format: 'yyyy-MM-dd HH'
                    , value: HEndDate
                });
                //$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开始日期
                //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//结束日期
                $("#HMaterNumber").val("");
                $("#HBillNo").val("");
                $("#HProductName").val("");
@@ -445,10 +623,32 @@
            }
            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Kf_MaterOutEntryReport_Cloth_ExportExcel";
                //逻辑审核方法
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //方法所在页面和方法名
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }
@@ -487,7 +687,7 @@
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }