染厂产量报表：增加客户字段、增加根据用户关联客户过滤

duhe

2024-05-28 262cee2e43059f55330b5efda849fcd1d445efd2

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

@@ -34,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">
@@ -63,6 +64,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>
@@ -195,6 +202,11 @@
            Pub_Close(1);
        })

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

        //#endregion

        //#region æ­¤é¡µé¢æ‰€æœ‰çš„方法
@@ -213,27 +225,31 @@
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    //冻结列
                    $("#HFixCols").val(data1.data[0].HFixCols);
                    //字体大小
                    $("#HFontSize").val(data1.data[0].HFontSize);
                    //列宽
                    $("#HColumnWidth").val(data1.data[0].HColumnWidth);

                    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) {
                        var dataCol = [];//数据库查询出的列数据

                        dataCol = data1.data[0].HGridString.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] })
                            cols.push({ "ColumnName": colNames[i], "IsHide": dataCols[1] == 1 ? true : false, "Alignment": dataCols[2], "ColumnWidth": dataCols[3] })
                        }
                        option.data = cols;
                        table.render(option);
@@ -252,7 +268,7 @@
                    } else {
                        //默认不选中 æ˜¾ç¤ºå­—体居左  è¡¨æ ¼çš„数据填充
                        for (var i = 0; i < colNames.length; i++) {
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L" })
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L", "ColumnWidth": 120 })
                        }
                        option.data = cols;
                        table.render(option);
@@ -285,6 +301,7 @@
                    { 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' }
                ]]
            };
        }
@@ -297,6 +314,16 @@
                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;
                }
            }

@@ -341,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