onLoadSuccess: function(data){
if (data.rows.length > 0) {
//调用mergeCellsByField()合并单元格
mergeCellsByField();
}
}
下面结果是empName字段合并几行!monthTotalScore字段就合并几行!
方法
function mergeCellsByField() {
var rows = $('#kpi_list_datagrid').datagrid('getRows');
if(rows.length!=0){
var monthTotalScore=rows[0].monthTotalScore;
var empName=rows[0].empName;
var index=0;
var size=0;
for( i=0;i<rows.length;i++){
if( empName!=rows[i].empName){
$('#kpi_list_datagrid').datagrid('mergeCells',{
index:index,
field:'empName',
rowspan:size,
colspan:1
});
$('#kpi_list_datagrid').datagrid('mergeCells',{
index:index,
field:'monthTotalScore',
rowspan:size,
colspan:1
});
monthTotalScore=rows[i].monthTotalScore;
empName=rows[i].empName;
index+=size;
size=0;
}
size++;
}
$('#kpi_list_datagrid').datagrid('mergeCells',{
index:index,
field:'empName',
rowspan:size,
colspan:1,
});
$('#kpi_list_datagrid').datagrid('mergeCells',{
index:index,
field:'monthTotalScore',
rowspan:size,
colspan:1,
});
}