1

zrg

2025-05-22 d11769f5dd4fe359f6856e9038ab6ec13d5c135d

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

@@ -11,6 +11,7 @@
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <style>
        /* é˜²æ­¢ä¸‹æ‹‰æ¡†çš„下拉列表被隐藏---必须设置--- */
        .layui-table-cell {
@@ -34,6 +35,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">
@@ -63,6 +65,12 @@
                                            <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="HColumnWidth" name="HColumnWidth" id="HColumnWidth">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <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="HPageSize" name="HPageSize" id="HPageSize">
                                            </div>
                                        </div>
                                    </div>
@@ -112,17 +120,24 @@
        <input type="checkbox" name="IsHide" lay-filter="IsHide" id="IsHide{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
    </div>
</script>
<!--复选框 æ˜¯å¦ç»Ÿè®¡è¡Œ-->
<script type="text/html" id="IsTotalRow">
    <div class="layui-input-block" style="margin-left: 20px;">
        <input type="checkbox" name="IsTotalRow" lay-filter="IsTotalRow" id="IsTotalRow{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
    </div>
</script>
<script>
    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['index', 'form', 'laydate', 'table', 'element'], function () {
    }).use(['index', 'form', 'laydate', 'table',"soulTable", 'element'], function () {
        //#region å…¬å…±å˜é‡
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , soulTable = layui.soulTable
            , form = layui.form
            , element = layui.element;
        //查询条件
@@ -135,7 +150,12 @@
        var params = getUrlVars();
        var HModName = params[params[0]]; //模块名称
        var colName = params[params[1]]; //列名
        var colTitleName = params[params[2]]; //列别名
        if (colTitleName == undefined) {
            colTitleName = "";
        }
        colName = decodeURI(colName);//对URI è¿›è¡Œè§£ç 
        colTitleName = decodeURI(colTitleName);
        //初始化界面
        set_ClearBill();

@@ -167,6 +187,19 @@
            });
        });

        //是否统计
        form.on('checkbox(IsTotalRow)', function (data) {
            //获取下拉框选中的值
            var elem = data.othis.parents('tr');
            var dataindex = elem.attr("data-index");
            $.each(option.data, function (index, value) {
                if (value.LAY_TABLE_INDEX == dataindex) {
                    value.IsTotalRow = data.elem.checked;//把选中下拉框id值赋值给表格缓存
                }
            });
        });


        //保存提交
        form.on('submit(btnSave)', function (data) {//提交
            set_AddNew(data);
@@ -195,6 +228,11 @@
            Pub_Close(1);
        })

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

        //#endregion

        //#region æ­¤é¡µé¢æ‰€æœ‰çš„方法
@@ -215,25 +253,31 @@
                success: function (data1) {
                    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 && data1.data.length == colNames.length) {
                    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);

                        var dataCol = [];//数据库查询出的列数据

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

                        //默认分页
                        $("#HPageSize").val(data1.data[0].HPageSize);
                        //是否排序
                        $("#HSortFlag").val(data1.data[0].HSortFlag);
                        //表格的数据填充
                        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] })
                            var ColumnName_Other = dataCols[4] == dataCols[5] ? "" : dataCols[4];
                            cols.push({ "ColumnName": dataCols[5], "IsHide": dataCols[1] == 1 ? true : false, "Alignment": dataCols[2], "ColumnWidth": dataCols[3], "ColumnName_Other": ColumnName_Other, "ColumnName_real": dataCols[5], "IsTotalRow": dataCols[6] == 1 ? true : false })
                        }
                        option.data = cols;
                        table.render(option);
@@ -244,15 +288,19 @@
                            if (dataCols[1] == 1) {
                                $("#IsHide" + (i + 1)).attr("checked", true);
                            }
                            if (dataCols[6] == 1) {
                                $("#IsTotalRow" + (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 {
                        var colTitleNames = colTitleName.split(',');
                        //默认不选中 æ˜¾ç¤ºå­—体居左  è¡¨æ ¼çš„数据填充
                        for (var i = 0; i < colNames.length; i++) {
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L", "ColumnWidth": 120 })
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L", "ColumnWidth": 120, "ColumnName_Other": colTitleNames[i], "IsTotalRow": false })
                        }
                        option.data = cols;
                        table.render(option);
@@ -260,6 +308,7 @@
                        //默认不选中 æ˜¾ç¤ºå­—体居左 é¡µé¢å¤šé€‰æ¡† ä¸‹æ‹‰æ¡† é‡æ–°æ¸²æŸ“
                        for (var i = 0; i < colNames.length; i++) {
                            $('#IsHide' + (i + 1)).prop("checked", false);
                            $('#IsTotalRow' + (i + 1)).prop("checked", false);
                            $('#Alignment' + (i + 1)).find("option[value='L']").attr("selected", true);
                        }
                        form.render('checkbox');
@@ -276,7 +325,8 @@
        //表格数据
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                id: "mainTable"
                , elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                , height: 420
                , cellMinWidth: 90
@@ -285,19 +335,47 @@
                    { 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' }
                    , { field: 'ColumnWidth', title: '列宽', width: 100, edit: 'text' }
                    , { field: 'ColumnName_Other', title: '别名', width: 120, edit: 'text' }
                    , { field: 'ColumnName_real', title: '别名对应列名', width: 120, edit: 'text', hide: "true" }
                    , { field: 'IsTotalRow', title: '是否统计', width: 100, templet:'#IsTotalRow' }
                ]]
                , even: true
                , rowDrag: {/*trigger: 'row',*/
                    done: function (obj) {
                        // å®Œæˆæ—¶ï¼ˆæ¾å¼€æ—¶ï¼‰è§¦å‘
                        // å¦‚果拖动前和拖动后无变化，则不会触发此方法
                        console.log(obj.row) // å½“前行数据
                        console.log(obj.cache) // æ”¹åŠ¨åŽå…¨è¡¨æ•°æ®
                        console.log(obj.oldIndex) // åŽŸæ¥çš„数据索引
                        console.log(obj.newIndex) // æ”¹åŠ¨åŽæ•°æ®ç´¢å¼•
                        console.log(table.cache["mainTable"]) // æ”¹åŠ¨åŽæ•°æ®ç´¢å¼•
                    }
                }
                , done: function () {
                    soulTable.render(this)
                }
            };
        }

        //保存HMaker
        function set_AddNew(data) {

            var num = [];
            var num = []
            for (var i = 0; i < table.cache["mainTable"].length; i++) {
                if (table.cache["mainTable"][i] != "") {
                    table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
                    num.push(table.cache["mainTable"][i])
                }
            }

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

@@ -342,6 +420,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