- $('#text').datagrid({
- border : 2,
- nowrap : false,
- fit : true,
- url: '<%=request.getContextPath()%>/report/showreport.action',
- frozenColumns: [[
- { title: '区域名称', field: 'regionname', width: 80, sortable: true}
- ]],
- columns: [
- [{"title":"人员管理","colspan":3},
- {"title":"资料管理","colspan":3}],
- [{"field":"uname0","title":"姓名类似于李","rowspan":1},
- {"field":"config_gender1","title":"性别等于女","rowspan":1},
- {"field":"config_gender2","title":"性别等于男","rowspan":1},
- {"field":"config_datatype0","title":"资料类别等于视频资料","rowspan":1},
- {"field":"config_datatype1","title":"资料类别等于图片资料","rowspan":1},
- {"field":"config_datatype2","title":"资料类别等于文件资料","rowspan":1}]],
- rownumbers: true
- });
- 结果如下图:
- 说明:从代码中可以看到,表单数组中有两个数组(一般的表格都是有一个数组), 第一个数组就是表头中第一行,该数组对象中没有field属性,第二个数组就是表头第二行。返回的数据格式中字段以第二个数组中的field属性的值为key。格式如下:
- [{"regionname":"区域1","uname0":278,"config_gender1":1516,"config_gender2":2522,"config_datatype0":19,"config_datatype1":538,"config_datatype2":525}]