当前位置：首页 > news >正文

js循环生成多个easyui datagrid数据网格时，初始化表格

news 来源：原创 2024/5/7 11:47:49

$.each( content, function(i, item){
                    var info_tpl = "";var result_tpl = "";var pre = /\<+\s*([a-z]+)\s*/;
                    info_tpl += "<div class='result-info'>"
                            + "<p>【执行SQL：（"+i+"）】</p>"
                            + "<p>"+item.sql+"</p>"
                            + "<p>"+item.msg+"</p>";
                    //显示执行结果
                    $("#pagebox .pagebox-list:eq("+index1+") .resultbox .result-info-box").append(info_tpl);
                    $("#pagebox .pagebox-list:eq("+index1+") .resultbox .result-info-box").show();

                    if ( item.excute_result != '' && item.excute_result != undefined ) {
                        //显示结果集列
                        var resultnav_tpl = "<li><span class='resultnav-title' title='"+item.sql+"'>结果集"+x+"</span></li>";
                        
                        $("#pagebox .pagebox-list:eq("+index1+") .resultnav ul").append(resultnav_tpl);

                        result_tpl += "<div class='result-content' >"
                            +"<table class=\"easyui-datagrid\" style=\"width:100%;height:"+resultbox_height+"px;\" data-options=\"striped:true,rownumbers:true,singleSelect:true\" >"
                            +"<thead><tr>";
                        $.each( item.excute_result, function(j, vo){
                            if( j == 0 ){
                                $.each( vo, function(h, v){
                                    result_tpl += "<th data-options=\"field:'" + h + "',align:'center',width:80\">"+h+"</th>";
                                } );
                                result_tpl += "</tr></thead><tbody>";
                            }
                            result_tpl += "<tr>";
                            $.each( vo, function( k, val){
                                if ( pre.test(val) ) {
                                    result_tpl += "<td><xmp>" + val + "</xmp></td>";
                                } else {
                                    result_tpl += "<td title='" + val + "'>" + val + "</td>";
                                }
                            });
                            result_tpl += "</tr>";
                        } );
                        result_tpl += "</tbody></table></div>";
                        $("#pagebox .pagebox-list:eq("+index1+") .resultbox").append(result_tpl);
                        $.parser.parse("#pagebox .pagebox-list:eq("+index1+") .resultbox");//JQuery选择器是解析组件的父级节点

                        x++;
                    }
                } );