Flex AdvancedDataGrid动态添加列并绑定数据库返回数据

最新推荐文章于 2014-02-13 20:38:13 发布

转载最新推荐文章于 2014-02-13 20:38:13 发布 · 1.6k 阅读

flex 专栏收录该内容

79 篇文章

订阅专栏

本文介绍了一种使用Flash中的AdvancedDataGrid组件进行数据展示的方法，并通过动态生成图表的方式提高数据可视化的灵活性。该方法首先从数据库获取数据并绑定到AdvancedDataGrid中，然后根据这些数据动态创建图表所需的列。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//绑定数据库返回数据(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();
    }