//绑定数据库返回数据(myAVDG为AdvancedDataGrid的ID)
private function getStatInfoResult(e:ResultEvent):void
{
myAVDG.dataProvider=e.result;
//动态生成图表
orgAVDGData();
}
privatefunction orgAVDGData():void
{
myAVDG.validateNow();
var counts:int=0;
myAVDG.groupedColumns=new Array();
var AdvHeards:AdvancedDataGridColumn=newAdvancedDataGridColumn();
AdvHeards.dataField="id";
AdvHeards.headerText="操作";
var AdvHeardGroup:AdvancedDataGridColumnGroup=newAdvancedDataGridColumnGroup;
AdvHeardGroup.headerText="日期为"+formatDate(startDate)+"-"+formatDate(endDate);
myAVDG.groupedColumns=myAVDG.groupedColumns.concat(AdvHeards,AdvHeardGroup);
AdvHeardGroup.children=[];
var arrGroup:Array=new Array();
for(var i:int=1;i<=arr.length;i++)
{
var AdvHeards1:AdvancedDataGridColumn=newAdvancedDataGridColumn();
AdvHeards1.dataField="value"+i;
AdvHeards1.headerText=busiNames[i-1];
arrGroup.push(AdvHeards1);
}
//增加汇总列
var AdvHeards2:AdvancedDataGridColumn=newAdvancedDataGridColumn();
AdvHeards2.dataField="sum";
AdvHeards2.headerText="汇总";
arrGroup.push(AdvHeards2);
AdvHeardGroup.children=AdvHeardGroup.children.concat(arrGroup);
myAVDG.validateNow();
}
//运行结果