表格
与ArrayCollection关联,可显示多条信息
1、定义
[Bindable]
private var dpConsumeDetail:ArrayCollection; //消费明细
2、赋值
dpConsumeDetail=new ArrayCollection();
var str:String="select consume_detail.id,date_time,types.name name,money,remark " +
"from consume_detail " +
"inner join " +
"types on consume_detail.type_id=types.id and consume_detail.userid=types.userid "+
"where date_time<="+selEndDate+" and date_time>="+selStartDate+
" and consume_detail.userid="+userId;
db.SelItemFromTable(str,dpConsumeDetail);
从数据库取值,赋给dpConsumeDetail
//访问dpConsumeDetail中的元素
sumMoney=0;
for(var i:int=0;i<dpConsumeDetail.length;i++)
{
sumMoney+=Number(dpConsumeDetail.getItemAt(i).money);
}
3、在DataGrid显示
<mx:DataGrid id="selDataSetId" x="40" y="218" height="169" width="366"
selectable="true"
selectionColor="0x7FCEFF"
dataProvider="{dpConsumeDetail}"
itemClick="itemClickDeal(event);">
<mx:columns>
<mx:DataGridColumn headerText="日期" dataField="date_time"/>
<mx:DataGridColumn headerText="类型" dataField="name"/>
<mx:DataGridColumn headerText="金额" dataField="money"/>
<mx:DataGridColumn headerText="备注" dataField="remark"/>
</mx:columns>
</mx:DataGrid>
dataProvider="{dpConsumeDetail}" 与第二步取出的值对应
dataField="date_time" 分别对应从数据库取出的字段名称