1

duhe

2024-03-13 d3b4b93d4ba49eb3994e3f9874a3dfda083524ab

 WebTM/views/»ù´¡×ÊÁÏ/Òþ²ØÁÐÉèÖÃ/Gy_GridView_Hide.html

@@ -5,10 +5,12 @@
    <title>隐藏列设置</title>
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js" type="text/javascript"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <style>
        /* é˜²æ­¢ä¸‹æ‹‰æ¡†çš„下拉列表被隐藏---必须设置--- */
        .layui-table-cell {
@@ -32,6 +34,7 @@
                        <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="ClearBill" id="ClearBill">全清</button>
                        <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">保存</button>
                        <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="Exit" id="Exit">退出</button>
                        <button class="layui-btn layui-btn-normal" type="button" lay-submit="" lay-filter="Del" id="Del">删除</button>
                    </div>
                    <div class="layui-collapse">
                        <div class="layui-colla-item">
@@ -58,15 +61,15 @@
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">标题行高</label>
                                            <label class="layui-form-label" style="width: 85px;">列宽</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" lay-verify="HHeadTextHeight" name="HHeadTextHeight" id="HHeadTextHeight">
                                                <input type="text" class="layui-input" lay-verify="HColumnWidth" name="HColumnWidth" id="HColumnWidth">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">内容行高</label>
                                            <label class="layui-form-label" style="width: 85px;">默认分页</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" lay-verify="HTextHeight" name="HTextHeight" id="HTextHeight">
                                                <input type="text" class="layui-input" lay-verify="HPageSize" name="HPageSize" id="HPageSize">
                                            </div>
                                        </div>
                                    </div>
@@ -137,10 +140,9 @@
        //#region è¿›å…¥é¡µé¢å³åŠ è½½

        var params = getUrlVars();
        var HModName = params[params[0]]; //从参数中获取 æ•°æ®ç±»åž‹  æ·»åŠ  ä¿å­˜
        //var linterid = params[params[1]]; //从参数中获取 å•æ®å†…码
        //var lSourceBillType = params[params[2]];  //从单据获取 æºå•ç±»åž‹

        var HModName = params[params[0]]; //模块名称
        var colName = params[params[1]]; //列名
        colName = decodeURI(colName);//对URI è¿›è¡Œè§£ç 
        //初始化界面
        set_ClearBill();

@@ -196,8 +198,13 @@
        });

        //退出
        form.on('submit(Cancel)', function () {
        form.on('submit(Exit)', function () {
            Pub_Close(1);
        })

        //删除
        form.on('submit(Del)', function () {
            get_Del();
        })

        //#endregion
@@ -210,7 +217,7 @@
            get_Display();
        }

        //#region æŸ¥è¯¢
        //查询
        function get_Display() {
            var ajaxLoad = layer.load();
            $.ajax({
@@ -218,13 +225,62 @@
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        option.data = data1.data;
                    var colNames = [];//相对单据传过来的列名
                    var cols = [];//要传进表格的数据
                    var dataCol = [];
                
                    if (data1.data.length != 0) {
                        //数据库查询出的列数据
                        dataCol = data1.data[0].HGridString.split(',');
                    }
                   
                    colNames = colName.split(',');

                    if (data1.data.length != 0 && dataCol.length == colNames.length) {
                        //冻结列
                        $("#HFixCols").val(data1.data[0].HFixCols);
                        //字体大小
                        $("#HFontSize").val(data1.data[0].HFontSize);
                        //列宽
                        $("#HColumnWidth").val(data1.data[0].HColumnWidth);
                        //默认分页
                        $("#HPageSize").val(data1.data[0].HPageSize);

                        //表格的数据填充
                        for (var i = 0; i < colNames.length; i++) {
                            var dataCols = dataCol[i].split('|');
                            cols.push({ "ColumnName": colNames[i], "IsHide": dataCols[1] == 1 ? true : false, "Alignment": dataCols[2], "ColumnWidth": dataCols[3] })
                        }
                        option.data = cols;
                        table.render(option);

                        //页面多选框 ä¸‹æ‹‰æ¡† é‡æ–°æ¸²æŸ“
                        for (var i = 0; i < colNames.length; i++) {
                            var dataCols = dataCol[i].split('|');
                            if (dataCols[1] == 1) {
                                $("#IsHide" + (i + 1)).attr("checked", true);
                            }
                            $('#Alignment' + (i + 1)).find("option[value='" + dataCols[2] + "']").attr("selected", true);
                        }
                        form.render('checkbox');
                        form.render('select');
                        layer.close(ajaxLoad);
                    } else {
                        //默认不选中 æ˜¾ç¤ºå­—体居左  è¡¨æ ¼çš„数据填充
                        for (var i = 0; i < colNames.length; i++) {
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L", "ColumnWidth": 120 })
                        }
                        option.data = cols;
                        table.render(option);

                        //默认不选中 æ˜¾ç¤ºå­—体居左 é¡µé¢å¤šé€‰æ¡† ä¸‹æ‹‰æ¡† é‡æ–°æ¸²æŸ“
                        for (var i = 0; i < colNames.length; i++) {
                            $('#IsHide' + (i + 1)).prop("checked", false);
                            $('#Alignment' + (i + 1)).find("option[value='L']").attr("selected", true);
                        }
                        form.render('checkbox');
                        form.render('select');
                        layer.close(ajaxLoad);
                        layer.alert(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
@@ -238,18 +294,16 @@
            option = {
                elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                , height: 690
                , height: 420
                , cellMinWidth: 90
                , limit: 500
                , loading: false
                , cols: [[
                    { field: 'ColumnName', title: '列名', width: 100 }
                    , { file: 'IsHide', title: '是否隐藏', width: 100, templet: '#IsHide' }
                    , { field: 'Alignment', title: '对齐方式', width: 100, templet: '#Alignment' }
                    , { field: 'ColumnWidth', title: '列宽', width: 100,edit: 'text' }
                ]]
            };
            option.data = [{ "ColumnName": "111", "IsHide": false, "Alignment": "L" }, { "ColumnName": "222", "IsHide": false, "Alignment": "R" }];
            table.render(option);
        }

        //保存HMaker
@@ -263,11 +317,20 @@
                }
            }

            //默认分页
            var HPageSize = $("#HPageSize").val();
            if (HPageSize != "") {
                var nums = /^[0-9]+?[0-9]*$/;
                if (!nums.test(HPageSize)) {
                    layer.msg("默认分页不为正整数!")
                    return false;
                }
            }

            var sMainStr = JSON.stringify(data.field);
            var sSubStr = JSON.stringify(num);
            var HModName = "1";//模块名称
            var OperationType = "1";
            var sMainSub = sMainStr + ';' + sSubStr + ';' + HModName + ';' + OperationType + ";" + 2;//sessionStorage["HUserName"]
            var sMainSub = sMainStr + ';' + sSubStr + ';' + HModName + ';' + OperationType + ";" + sessionStorage["HUserName"];//sessionStorage["HUserName"]

            var index = layer.load();
            $.ajax({
@@ -305,6 +368,32 @@
            return vars;
        }

        //删除
        function get_Del() {
            layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                var wait = layer.load();
                //逻辑删除方法
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/DelgrdAlignmentWMES',
                    type: "GET",
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            layer.msg(result.Message, { icon: 1 }, function () {
                                //关闭当前frame
                                layer.close(wait);
                            });
                        } else {
                            layer.alert(result.code + result.Message, { icon: 5 });
                            layer.close(wait);
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                        layer.close(wait);
                    }
                });
            })
        }


        //#endregion