工序出站汇报单 增加子表 单品过站优化

yangle

2023-12-14 725da978a391c7d5c4e649855c141d8277e34ff1

工序出站汇报单  增加子表
单品过站优化

 WebTM/views/³µ¼ä¹ÜÀí/µ¥Æ·¹ýÕ¾/Cj_ProcessItemStationPlatform.html

@@ -475,7 +475,7 @@

        // ç”Ÿæˆå•æ®å·
        function createBillNo() {
            var sql = "select * from Sc_StationOutBillMain  where HProcExchBillNo='" + $("#HProcExchBillNo").val() + "' and HProcID=" + $("#HProcID").val()
            var sql = "select * from Sc_StationOutBillMain  where HProcExchBillNo='" + $("#HProcExchBillNo").val() + "' and HProcID=" + $("#HProcID").val() +" order by HDate desc"
            $.ajax({
                url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList",
                async: false,
@@ -846,7 +846,7 @@
                        table.render(option)

                        for (var i = 0; i < option.data.length; i++) {
                            if (parseFloat(option.data[i]["配件数量"]) == 0) {
                            if (parseFloat(option.data[i]["配件数量"]) == 0|| isNaN(parseFloat(option.data[i]["配件数量"])) ) {
                                if (setIntervalIndex != null) {
                                    //clearInterval(setIntervalIndex);
                                    //setIntervalIndex = null;
@@ -910,6 +910,12 @@
                layer.msg("流转卡不能为空！")
                return;
            }

            //查询不良记录
            get_BadRecords();
            //查询合格记录
            get_HGRecords();

            if (option2.data.length != 0 || option3.data.length != 0) {
                get_BomList(HBarCode);
            }
@@ -918,10 +924,7 @@
            //    //保存到临时表
            //    get_AddBomTempList();
            //}
            //查询不良记录
            get_BadRecords();
            //查询合格记录
            get_HGRecords();
     

            setIntervalIndex = setInterval(setIntervalList, 30000);
        }

 WebTM/views/³µ¼ä¹ÜÀí/¹¤Ðò³öÕ¾»ã±¨µ¥/Cj_StationOutBillList.html

@@ -148,6 +148,32 @@
                        </div>

                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div class="layui-tab layui-tab-card" style="margin-top:0px;">
                            <ul class="layui-tab-title">
                                <li >工艺参数</li>
                                <li>操作日志</li>
                                <li class="layui-this">SN序列码</li>
                                <li>操作员清单</li>
                            </ul>
                            <div class="layui-tab-content">
                                <div class="layui-tab-item">
                                    <!--工艺参数-->
                                    <table class="layui-hide" id="mainTable1" lay-filter="mainTable1"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--操作日志-->
                                    <table class="layui-hide" id="mainTable2" lay-filter="mainTable2"></table>
                                </div>
                                <div class="layui-tab-item layui-show" >
                                    <!--SN序列码-->
                                    <table class="layui-hide" id="mainTable3" lay-filter="mainTable3"></table>
                                </div>
                                <div class="layui-tab-item">
                                    <!--操作员清单-->
                                    <table class="layui-hide" id="mainTable4" lay-filter="mainTable4"></table>
                                </div>
                            </div>
                        </div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-add-1"></i>新增</button>
@@ -165,6 +191,30 @@
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Exit" id="btn-Exit">退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>
                            </div>
                        </script>
                        <script type="text/html" id="toolbarDemo1">
                            <div class="layui-btn-container">
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Delete1" id="btn-Delete1"><i class="layui-icon layui-icon-delete"></i>删除</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn1" id="set_HideColumn1"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
                        <script type="text/html" id="toolbarDemo2">
                            <div class="layui-btn-container">
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Delete2" id="btn-Delete2"><i class="layui-icon layui-icon-delete"></i>删除</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn2" id="set_HideColumn2"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
                        <script type="text/html" id="toolbarDemo3">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Delete3" id="btn-Delete3"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn3" id="set_HideColumn3"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
                        <script type="text/html" id="toolbarDemo4">
                            <div class="layui-btn-container">
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Delete4" id="btn-Delete4"><i class="layui-icon layui-icon-delete"></i>删除</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn4" id="set_HideColumn4"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
                    </form>
@@ -195,8 +245,16 @@
            //公用变量
            var sWhere = "";
            var option = [];
            var option1 = [];
            var option2 = [];
            var option3 = [];
            var option4 = [];
            var ins;                        //用于导出excel
            var HModName = "Cj_StationOutBillList";
            var HModName1 = "Sc_StationOutBillSub_TechParam";
            var HModName2 = "Sc_StationOutBillSub_Note";
            var HModName3 = "Sc_StationOutBillSub_SN";
            var HModName4 = "Sc_StationOutBillSub_Emp";
            var titleData = ["HMaterID", "HUnitID", "HSourceID", "hmainid", "HProcExchInterID", "HProcID", "HunitID", "HEmpID", "HGroupID", "HProcExchEntryID", "HSubID", "HICMOInterID", "选择", "查询日期", "成本对象", "成本对象名称", "HBillStatus", "HBillType", "HPRDORGID"];//不需要显示的字段 å¯æ‰©å±•


@@ -251,6 +309,212 @@
                    $("#btnSearch").click();
                }
            });

            //点击主表带出从表数据
            table.on('row(mainTable)', function (obj) { //注：tool æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"

                //选中行改变颜色
                check_row(obj);
                var datas = obj.data; //获得当前行数据
                var HMainID = datas.hmainid;
             
                SelectTechParam(HMainID,"TechParam");//工艺参数
                SelectTechParam(HMainID,"Note");    //操作日志
                SelectTechParam(HMainID, "SN");    //SN序列码
                SelectTechParam(HMainID, "Emp");    //操作员清单
            });

            //查询工艺参数
            table.on('toolbar(mainTable1)', function (obj) {
                switch (obj.event) {
                    //删除
                    case 'btn-Delete1': btn_Delete1();
                        break;
                    //明细列设置
                    case 'set_HideColumn1': get_HideColumn_TechParam();
                        break;
                };
            });

            //查询操作日志
            table.on('toolbar(mainTable2)', function (obj) {
                switch (obj.event) {
                    //删除
                    case 'btn-Delete2': btn_Delete2();
                        break;
                    //明细列设置
                    case 'set_HideColumn2': get_HideColumn_Note();
                        break;
                };
            });

            //查询SN序列码
            table.on('toolbar(mainTable3)', function (obj) {
                switch (obj.event) {
                    //删除
                    case 'btn-Delete3': btn_Delete3();
                        break;
                    //明细列设置
                    case 'set_HideColumn3': get_HideColumn_SN();
                        break;
                };
            });

            //查询操作员清单
            table.on('toolbar(mainTable4)', function (obj) {
                switch (obj.event) {
                    //删除
                    case 'btn-Delete4': btn_Delete4();
                        break;
                    //明细列设置
                    case 'set_HideColumn4': get_HideColumn_Emp();
                        break;
                };
            });


            //查询工艺参数
            function SelectTechParam(HMainID,TableName) {
                var wait = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Cj_StationOutBill/get_SubDisplay',
                    type: "GET",
                    data: { "sWhere": HMainID, "TableName": TableName},
                    async: false,
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                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 (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                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: 200 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                    }
                                }
                            }
                            switch (TableName) {
                                case "TechParam":

                                    //动态显示列名
                                    option1 = {
                                        elem: '#mainTable1'
                                        , toolbar: '#toolbarDemo1'
                                        , cols: [col]
                                        , data: data1.data
                                        , height: 550
                                        , page: true
                                        , cellMinWidth: 90
                                        , limit: 50
                                        , limits: [50, 500, 5000, 20000]
                                    }
                                    table.render(option1);

                                    DisPlay_HideColumn_TechParam();

                                    break;
                                case "Note":

                                    //动态显示列名
                                      option2 = {
                                        elem: '#mainTable2'
                                        , toolbar: '#toolbarDemo2'
                                        , cols: [col]
                                        , data: data1.data
                                        , height: 550
                                        , page: true
                                        , cellMinWidth: 90
                                        , limit: 50
                                        , limits: [50, 500, 5000, 20000]
                                    }
                                    table.render(option2);

                                    DisPlay_HideColumn_Note();
                                    break;
                                case "SN":

                                    //动态显示列名
                                      option3 = {
                                        elem: '#mainTable3'
                                        , toolbar: '#toolbarDemo3'
                                        , cols: [col]
                                        , data: data1.data
                                        , height: 550
                                        , page: true
                                        , cellMinWidth: 90
                                        , limit: 50
                                        , limits: [50, 500, 5000, 20000]
                                    }
                                    table.render(option3);

                                    DisPlay_HideColumn_SN();

                                    break;
                                case "Emp":

                                    //动态显示列名
                                     option4 = {
                                        elem: '#mainTable4'
                                        , toolbar: '#toolbarDemo4'
                                        , cols: [col]
                                        , data: data1.data
                                        , height: 550
                                        , page: true
                                        , cellMinWidth: 90
                                        , limit: 50
                                        , limits: [50, 500, 5000, 20000]
                                    }
                                    table.render(option4);

                                    DisPlay_HideColumn_Emp();
                                    break;

                            }

                            layer.close(wait);
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            layer.close(wait);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(wait);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            function check_row(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;
                    }
                });
            }

            //初始化表格
            function set_InitGrid() {
@@ -376,29 +640,63 @@
                };
            });

            //行监听事件
            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;
                    }
                });
            });
            ////行监听事件
            //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;
            //        }
            //    });
            //});

            //隐藏列设置
            //条码删除
            function btn_Delete3() {
                var checkStatus = table.checkStatus('mainTable3')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    layer.confirm('确定删除条码:' + data[0].条码 + '吗？', function (index) {
                        var HInterID = data[0].HInterID;
                        var HBardcode = data[0].条码;
                        var ajaxLoad = layer.load();
                        //逻辑删除方法
                        $.ajax({
                            url: GetWEBURL() + '/Cj_StationOutBill/del_StationOutBill_SN',
                            type: "GET",
                            data: { "HInterID": HInterID, "HBardcode": HBardcode, "HDeleteMan": sessionStorage["HUserName"], "HBillSubType": "3791" },
                            success: function (result) {
                                if (result.count == 1) {
                                    SelectTechParam(HInterID, "SN");
                                    layer.close(ajaxLoad);
                                } else {
                                    layer.close(ajaxLoad);
                                    layer.alert(result.Message, { icon: 5 });
                                }
                            }, error: function () {
                                layer.close(ajaxLoad);
                                layer.alert("接口请求失败!", { icon: 5 });
                            }
                        });
                        layer.close(index);
                    });
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }

            //隐藏列设置 ä¸»è¡¨
            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"] + ",";
                }

@@ -422,7 +720,7 @@
                })
            }

            //显示列数据
            //显示列数据 ä¸»è¡¨
            function DisPlay_HideColumn() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
@@ -437,7 +735,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('|');
                                }
@@ -502,6 +800,466 @@
                            table.render(option);
                        }

                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, "3791", HModName, sessionStorage["HUserName"]);

                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }

             //隐藏列设置 å·¥è‰ºå‚æ•°
            function get_HideColumn_TechParam() {
                var colName = "";
                for (var i = 1; i < option1.cols[0].length; i++) {
                    colName += option1.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName1 + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn_TechParam();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }

            //显示列数据 å·¥è‰ºå‚æ•°
            function DisPlay_HideColumn_TechParam() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    data: { "HModName": HModName1, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {


                            var dataCol = [];//数据库查询出的列数据
                            /*var titleData = ["HMaterID", "HUnitID", "HSourceID"];//不需要显示的字段 å¯æ‰©å±•*/

                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option1.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option1.cols[0][i + 1]["hide"] = true;
                                }
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    option1.cols[0][i + 1]["width"] = dataCols[3];
                                }
                                //设置内容字体大小
                                if (data1.data[0].HFontSize != 0) {
                                    option1.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                } else {
                                    option1.cols[0][i + 1]["style"] = "font-size:100%";
                                }
                                //设置列宽
                                //if (data1.data[0].HColumnWidth != 0) {
                                //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                                //} else {
                                //    option.cols[0][i + 1]["width"] = "";
                                //}
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option1.cols[0][i + 1]["title"], titleData) == -1) {
                                    option1.cols[0][i + 1]["hide"] = false;
                                }
                                //字体所在位置(å·¦ å±…中 å³)
                                switch (dataCols[2]) {
                                    case "L":
                                        option1.cols[0][i + 1]["align"] = "left";
                                        break;
                                    case "M":
                                        option1.cols[0][i + 1]["align"] = "center";
                                        break;
                                    case "R":
                                        option1.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }

                            //取消冻结列
                            for (var i = 1; i < option1.cols[0].length - 1; i++) {
                                if (option1.cols[0][i]["fixed"] != null) {
                                    option1.cols[0][i]["fixed"] = null;
                                }
                                else {
                                    break;
                                }
                            }
                            //冻结列
                            if (data1.data[0].HFixCols != 0) {
                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                    if ($.inArray(option1.cols[0][i + 1]["title"], titleData) != -1) {
                                        data1.data[0].HFixCols += 1;
                                    }
                                    option1.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            table.render(option1);
                        } else {
                            table.render(option1);
                        }
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, "3791", HModName, sessionStorage["HUserName"]);

                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }

              //隐藏列设置 æ“ä½œæ—¥å¿—
            function get_HideColumn_Note() {
                var colName = "";
                for (var i = 1; i < option2.cols[0].length  ; i++) {
                    colName += option2.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName2 + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn_Note();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }

            //显示列数据  æ“ä½œæ—¥å¿—
            function DisPlay_HideColumn_Note() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    data: { "HModName": HModName2, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {


                            var dataCol = [];//数据库查询出的列数据
                            /*var titleData = ["HMaterID", "HUnitID", "HSourceID"];//不需要显示的字段 å¯æ‰©å±•*/

                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option2.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option2.cols[0][i + 1]["hide"] = true;
                                }
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    option2.cols[0][i + 1]["width"] = dataCols[3];
                                }
                                //设置内容字体大小
                                if (data1.data[0].HFontSize != 0) {
                                    option2.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                } else {
                                    option2.cols[0][i + 1]["style"] = "font-size:100%";
                                }
                                //设置列宽
                                //if (data1.data[0].HColumnWidth != 0) {
                                //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                                //} else {
                                //    option.cols[0][i + 1]["width"] = "";
                                //}
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option2.cols[0][i + 1]["title"], titleData) == -1) {
                                    option2.cols[0][i + 1]["hide"] = false;
                                }
                                //字体所在位置(å·¦ å±…中 å³)
                                switch (dataCols[2]) {
                                    case "L":
                                        option2.cols[0][i + 1]["align"] = "left";
                                        break;
                                    case "M":
                                        option2.cols[0][i + 1]["align"] = "center";
                                        break;
                                    case "R":
                                        option2.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }

                            //取消冻结列
                            for (var i = 1; i < option2.cols[0].length - 1; i++) {
                                if (option2.cols[0][i]["fixed"] != null) {
                                    option2.cols[0][i]["fixed"] = null;
                                }
                                else {
                                    break;
                                }
                            }
                            //冻结列
                            if (data1.data[0].HFixCols != 0) {
                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                    if ($.inArray(option2.cols[0][i + 1]["title"], titleData) != -1) {
                                        data1.data[0].HFixCols += 1;
                                    }
                                    option2.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            table.render(option2);
                        } else {
                            table.render(option2);
                        }
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, "3791", HModName, sessionStorage["HUserName"]);

                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }

             //隐藏列设置 SN序列码
            function get_HideColumn_SN() {
                var colName = "";
                for (var i = 1; i < option3.cols[0].length; i++) {
                    colName += option3.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName3 + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn_SN();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }

            //显示列数据 SN序列码
            function DisPlay_HideColumn_SN() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    data: { "HModName": HModName3, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {


                            var dataCol = [];//数据库查询出的列数据
                            /*var titleData = ["HMaterID", "HUnitID", "HSourceID"];//不需要显示的字段 å¯æ‰©å±•*/

                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option3.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option3.cols[0][i + 1]["hide"] = true;
                                }
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    option3.cols[0][i + 1]["width"] = dataCols[3];
                                }
                                //设置内容字体大小
                                if (data1.data[0].HFontSize != 0) {
                                    option3.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                } else {
                                    option3.cols[0][i + 1]["style"] = "font-size:100%";
                                }
                                //设置列宽
                                //if (data1.data[0].HColumnWidth != 0) {
                                //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                                //} else {
                                //    option.cols[0][i + 1]["width"] = "";
                                //}
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option3.cols[0][i + 1]["title"], titleData) == -1) {
                                    option3.cols[0][i + 1]["hide"] = false;
                                }
                                //字体所在位置(å·¦ å±…中 å³)
                                switch (dataCols[2]) {
                                    case "L":
                                        option3.cols[0][i + 1]["align"] = "left";
                                        break;
                                    case "M":
                                        option3.cols[0][i + 1]["align"] = "center";
                                        break;
                                    case "R":
                                        option3.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }

                            //取消冻结列
                            for (var i = 1; i < option3.cols[0].length - 1; i++) {
                                if (option3.cols[0][i]["fixed"] != null) {
                                    option3.cols[0][i]["fixed"] = null;
                                }
                                else {
                                    break;
                                }
                            }
                            //冻结列
                            if (data1.data[0].HFixCols != 0) {
                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                    if ($.inArray(option3.cols[0][i + 1]["title"], titleData) != -1) {
                                        data1.data[0].HFixCols += 1;
                                    }
                                    option3.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            table.render(option3);
                        } else {
                            table.render(option3);
                        }
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, "3791", HModName, sessionStorage["HUserName"]);

                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }

            //隐藏列设置 æ“ä½œå‘˜æ¸…单
            function get_HideColumn_Emp() {
                var colName = "";
                for (var i = 1; i < option4.cols[0].length; i++) {
                    colName += option4.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName4 + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn_Emp();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }

            //显示列数据 æ“ä½œå‘˜æ¸…单
            function DisPlay_HideColumn_Emp() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    data: { "HModName": HModName4, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {


                            var dataCol = [];//数据库查询出的列数据
                            /*var titleData = ["HMaterID", "HUnitID", "HSourceID"];//不需要显示的字段 å¯æ‰©å±•*/

                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option4.cols[0].length - 1; i++) {
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option4.cols[0][i + 1]["hide"] = true;
                                }
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    option4.cols[0][i + 1]["width"] = dataCols[3];
                                }
                                //设置内容字体大小
                                if (data1.data[0].HFontSize != 0) {
                                    option4.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                } else {
                                    option4.cols[0][i + 1]["style"] = "font-size:100%";
                                }
                                //设置列宽
                                //if (data1.data[0].HColumnWidth != 0) {
                                //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                                //} else {
                                //    option.cols[0][i + 1]["width"] = "";
                                //}
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option4.cols[0][i + 1]["title"], titleData) == -1) {
                                    option4.cols[0][i + 1]["hide"] = false;
                                }
                                //字体所在位置(å·¦ å±…中 å³)
                                switch (dataCols[2]) {
                                    case "L":
                                        option4.cols[0][i + 1]["align"] = "left";
                                        break;
                                    case "M":
                                        option4.cols[0][i + 1]["align"] = "center";
                                        break;
                                    case "R":
                                        option4.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }

                            //取消冻结列
                            for (var i = 1; i < option4.cols[0].length - 1; i++) {
                                if (option4.cols[0][i]["fixed"] != null) {
                                    option4.cols[0][i]["fixed"] = null;
                                }
                                else {
                                    break;
                                }
                            }
                            //冻结列
                            if (data1.data[0].HFixCols != 0) {
                                for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                    if ($.inArray(option4.cols[0][i + 1]["title"], titleData) != -1) {
                                        data1.data[0].HFixCols += 1;
                                    }
                                    option4.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            table.render(option4);
                        } else {
                            table.render(option4);
                        }
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, "3791", HModName, sessionStorage["HUserName"]);

@@ -878,7 +1636,7 @@
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 'full-50'
                                , height: 300
                                , page: true
                                , totalRow: true
                                , cellMinWidth: 90