- <script>
-
var array =[]; var columns=[]; $.ajax({ url:_ctx+'/nodeManage/getMysqlFields', type:'POST', data:'id='+node['id'], success:function(data){//data后台的传过来的表字段数组 $(data).each(function(){ array.push({field:'',title:'',width:''}); }); columns.push(array); $(data).each(function(index,el){ columns[0][index]['field']= el['column_name'].toLocaleLowerCase(); columns[0][index]['title']= el['column_name']; columns[0][index]['width']= "130"; }); $('#dg').datagrid({ fit:true,checkOnSelect:true, selectOnCheck:true, singleSelect:true,toolbar:'#queryToolbar', pageSize : 5, columns:columns, dataType: 'json', pageList: [5,10,30,50,70,100], pageNumber : 1, pagination:true, queryParams:{id:node['id']}, url:_ctx+'/nodeManage/getMd5Datagrid' }); }, dataType:'json' });
- $(function () {
- $.getJSON('${pageContext.request.contextPath}/resources/json/datagrid_data.json',function(result){
- var columns=new Array();
- $.each(result.headers[0], function(i, field){
- var column={};
- column["title"]=i;
- column["field"]=field;
- column["width"]=50;
- columns.push(column);//当需要formatter的时候自己添加就可以了,原理就是拼接字符串.
- });
- $('#tt').datagrid({
- title:' XXX公司价差补差分配表',
- height:500,
- singleSelect:true,
- url:'',
- frozenColumns :[[
- {field:'name',title:'项目',width:80,sortable:true,align:'center'},
- {field:'count',title:'合计',width:150,sortable:true}
- ]],columns : [
- columns
- ],
- rownumbers:true}).datagrid('loadData',result.bodys);
- });
- })
- </script>
- <div title="XXX公司价差补差分配表" fit="true" border="false" style="height: 94%;">
- <table id="tt" ></table>
- </div>
- {"headers":[
{"一月份":"Jan","二月份":"Feb"}
],"bodys":[
{"name":"LNG","count":"50000","Jan":"20000","Feb":"30000"}
]
}