wtt
2024-12-23 96d9156985bde945919e3db90a58f026d6f791cb
高级过滤添加js文件案例在生产订单处
2个文件已修改
1个文件已添加
114 ■■■■ 已修改文件
WebTM/WebTM.csproj 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/layuiadmin/QueryCondition.js 53 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/生产管理/生产任务单/Sc_ICMOBillList.html 60 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/WebTM.csproj
@@ -97,6 +97,7 @@
    <Content Include="layuiadmin\ckou.js" />
    <Content Include="layuiadmin\echarts.min.js" />
    <Content Include="layuiadmin\grwebapp.js" />
    <Content Include="layuiadmin\QueryCondition.js" />
    <Content Include="layuiadmin\SetColumn.js" />
    <Content Include="layuiadmin\modules\tableFilter2.js" />
    <Content Include="layuiadmin\PlateBinding.js" />
WebTM/layuiadmin/QueryCondition.js
New file
@@ -0,0 +1,53 @@
//高级过滤 HTableName是这个列表的视图名
function set_QueryCondition(option, HTableName, get_FastQuery) {
    var colName = "";
    var contentUrl = "";
    for (var i = 0; i < option.cols[0].length; i++) {
        if (option.cols[0][i]["field"] != undefined && option.cols[0][i]["hide"] != true) {
            colName += option.cols[0][i]["title"] + ",";
        }
    }
    var urlStr = window.document.location.pathname;//获取文件路径
    var urlLen = urlStr.split('/');
    for (var i = 0; i < urlLen.length - 4; i++) {
        contentUrl += "../";
    }
    colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
    contentUrl += '../基础资料/隐藏列设置/Gy_QueryCondition.html?HModName=' + HTableName + '&colName=' + colName;
    layer.open({
        type: 2
        , skin: "layui-layer-rim" //加上边框
        , title: "高级过滤"  //标题
        , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
        , shift: 2 //弹出动画
        , area: ["50%", "80%"] //窗体大小
        , maxmin: true //设置最大最小按钮是否显示
        , content: [contentUrl, "yes"]
        , btn: ["确定", "取消"]
        , btn1: function (index, laero) {
            var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
            var checkStatus = iframeWindow.layui.table.cache["mainTable"];//获取选中的数据
            if (checkStatus.length == 0) {
                return layer.msg("请输入过滤条件!");
            }
            var myIframe = window[laero.find('iframe')[0]['name']];
            GetDataCols += "and (";
            for (var i = 0; i < checkStatus.length; i++) {
                GetDataCols += myIframe.get_FastQuery(checkStatus[i]); //get_FastQuery()为子页面的方法
                if ((i + 1) < checkStatus.length) {
                    GetDataCols += " " + checkStatus[i]["HRelationCol"] + " ";
                }
            }
            GetDataCols += ")";
            //更新表格缓存的数据
            layer.close(index);//关闭弹窗
        }
        , end: function () {
            if (GetDataCols != "") {
                get_FastQuery();
            }
        }
    })
}
WebTM/views/Éú²ú¹ÜÀí/Éú²úÈÎÎñµ¥/Sc_ICMOBillList.html
@@ -16,6 +16,7 @@
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/QueryCondition.js"></script>
</head>
<body>
    <div class="layui-fluid">
@@ -624,7 +625,7 @@
                        break;
                    //高级过滤
                    case 'set_QueryCondition':
                        set_QueryCondition();
                        set_QueryCondition(option, "h_v_IF_ICMOBillList", get_FastQuery);
                        break;
                };
            });
@@ -2914,62 +2915,7 @@
                })
            }
            //高级过滤
            function set_QueryCondition() {
                var colName = "";
                var contentUrl = "";
                for (var i = 0; i < option.cols[0].length; i++) {
                    if (option.cols[0][i]["field"] != undefined && option.cols[0][i]["hide"] != true) {
                        colName += option.cols[0][i]["title"] + ",";
                    }
                }
                var urlStr = window.document.location.pathname;//获取文件路径
                var urlLen = urlStr.split('/');
                for (var i = 0; i < urlLen.length - 4; i++) {
                    contentUrl += "../";
                }
                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                var HModBillName = "h_v_IF_ICMOBillList";//等于该列表的视图
                contentUrl += '基础资料/隐藏列设置/Gy_QueryCondition.html?HModName=' + HModBillName + '&colName=' + colName;
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "高级过滤"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "80%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: [contentUrl, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
                        var checkStatus = iframeWindow.layui.table.cache["mainTable"];//获取选中的数据
                        if (checkStatus.length == 0) {
                            return layer.msg("请输入过滤条件!");
                        }
                        var myIframe = window[laero.find('iframe')[0]['name']];
                        GetDataCols += "and (";
                        for (var i = 0; i < checkStatus.length; i++) {
                            GetDataCols += myIframe.get_FastQuery(checkStatus[i]); //get_FastQuery()为子页面的方法
                            if ((i + 1) < checkStatus.length) {
                                GetDataCols += " " + checkStatus[i]["HRelationCol"] + " ";
                            }
                        }
                        GetDataCols += ")";
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                    , end: function () {
                        if (GetDataCols != "") {
                            get_FastQuery();
                        }
                    }
                })
            }
            //#endregion