yusijie
2024-10-14 e63e2d1d2b0354896dc6aaea0e3a13cdb25f7eed
WebTM/views/»ù´¡×ÊÁÏ/Òþ²ØÁÐÉèÖÃ/Gy_QueryCondition.html
@@ -6,13 +6,13 @@
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/layui/layui.js"></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/layui/layui1.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/layui/lay/modules/table.js"></script>
    <style>
        /*树状图点击高亮变色*/
        .layui-tree-set-active > .layui-tree-entry .layui-tree-main {
@@ -203,6 +203,7 @@
                layer.close(index);
                TreeData.push({ "TreeData": [], "id": "0", "title": text  });
                MenuMain(TreeData);
                HtitleId = [];
            });
        });
@@ -256,7 +257,7 @@
                return layer.msg("请选中需要保存的方案!");
            }
            layer.confirm('确认要保存选中方案吗?', function (index) {
            layer.confirm('确认要保存:' + HtitleId.title + '方案吗?', function (index) {
                var TableData = table.cache["mainTable"];
                var sMainStr = JSON.stringify(TableData);
                var sMainStr1 = JSON.stringify(HtitleId);
@@ -271,11 +272,14 @@
                            layer.msg(data1.Message);
                            var index = parent.layer.getFrameIndex(window.name);
                            //返回方法
                            var TableDataSql = "";
                            var TableDataSql = "and (";
                            for (var i = 0; i < TableData.length; i++) {
                                TableDataSql += get_FastQuery(TableData[i]);
                                if ((i + 1) < TableData.length) {
                                    TableDataSql += " " + TableData[i]["HRelationCol"] + " ";
                                }
                            }
                            TableDataSql += ")";
                            parent.GetDataCol(TableDataSql);
                            parent.layer.close(index);
                        } else {
@@ -353,6 +357,7 @@
            for (var i = 0; i < data.length; i++) {
                if (data[i].title == "默认方案") {
                    sWhere = " and HInterID=" + data[i].id;
                    HtitleId = data[i];
                }
                liStr += '{"title": "' + data[i].title + '", "id": "' + data[i].id + '"},';
            };
@@ -411,49 +416,15 @@
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": sessionStorage["Organization"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        var colNames = [];//相对单据传过来的列名
                        var cols = [];//要传进表格的数据
                        var dataCol = [];//获取返回数据
                        dataCol = data1.data;
                        option.data = dataCol;
                        table.render(option);
                        if (data1.data.length == 0) {
                            set_InitGrid()
                        } else {
                            var dataCol = [];//获取返回数据
                            dataCol = data1.data;
                            option.data = dataCol;
                            table.render(option);
                        }
                        selectCol();
                        //colNames = colName.split(',');
                        //var HFieldNameCol_s = "";
                        //for (var i = 0; i < colNames.length; i++) {
                        //    HFieldNameCol_s += '<option  style="color:blue;" value="' + colNames[i] + '">' + colNames[i] + '</option>';
                        //}
                        //for (var i = 0; i < option.data.length; i++) {
                        //    $('#HFieldNameCol' + (i + 1)).append(HFieldNameCol_s);;
                        //}
                        //form.render('select');
                        //for (var i = 0; i < colNames.length; i++) {
                        //    cols.push({ "HFieldNameCol": colNames[i], "HControlCol": "", "HConditionCol": "", "HRelationCol": "" })
                        //}
                        //for (var i = 0; i < colNames.length; i++) {
                        //    for (var j = 0; j < dataCol.length; j++) {
                        //        if (colNames[i] == dataCol[j]["HFieldNameCol"]) {
                        //            cols[i]["HControlCol"] = dataCol[j]["HControlCol"];
                        //            cols[i]["HConditionCol"] = dataCol[j]["HConditionCol"];
                        //            cols[i]["HRelationCol"] = dataCol[j]["HRelationCol"];
                        //            break;
                        //        }
                        //    }
                        //}
                        //option.data = cols;
                        //table.render(option);
                        //for (var i = 0; i < colNames.length; i++) {
                        //    $('#HControlCol' + (i + 1)).find("option[value='" + option.data[i]["HControlCol"] + "']").attr("selected", true);
                        //    $('#HRelationCol' + (i + 1)).find("option[value='" + option.data[i]["HRelationCol"] + "']").attr("selected", true);
                        //}
                        form.render('select');
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
@@ -465,8 +436,6 @@
                }
            });
        }
        //行内删除
        function set_GridDelete(obj) {
@@ -507,7 +476,7 @@
        var ColName = TableData["HFieldNameCol"];//复选框
        var Comparator = TableData["HControlCol"];
        var ColContent = TableData["HConditionCol"];
        var HRelationCol = TableData["HRelationCol"];
        //var HRelationCol = TableData["HRelationCol"];
        var sWheres = "";
        if (ColName != 0 && Comparator != 0) {
@@ -516,10 +485,10 @@
                case "包含":
                    com = "like'%" + ColContent + "%'";
                    break;
                case "左包含":
                case "右包含":
                    com = "like'%" + ColContent + "'";
                    break;
                case "右包含":
                case "左包含":
                    com = "like'" + ColContent + "%'";
                    break;
                case "不包含":
@@ -529,7 +498,7 @@
                    com = "" + Comparator + "'" + ColContent + "'";
                    break;
            }
            sWheres += HRelationCol + " " + ColName + " " + com;
            sWheres += ColName + " " + com ;
        }
        return sWheres;
    }