//xtraPrivot
var colEmpName = new PivotGridField
{
Area = PivotArea.FilterArea,
AreaIndex = num,
FieldName = item.Caption,
Name = "col" + item.Caption,
Caption = item.Caption,
/这里设置数据区的统计类型为统计数量
};
num++;
this.pivotGridControl1.Fields.AddRange(new[] { colEmpName });
//PrivotGridControl赋值
pivotGridControl1.DataSource = dt;
//XtraGrid
GridView gridView = new GridView();
gridView.Columns.ColumnByFieldName(item.Caption);
//gridControl 赋值
gridControl1.DataSource = dt;
//布局储存、读取
var gridLayoutFileName= Path.Combine(AppDomain.CurrentDomain.BaseDirectory)//绝对地址
//保存布局
pivotGridControl1.SaveLayoutToXml(gridLayoutFileName, DevExpress.Utils.OptionsLayoutBase.FullLayout);
//读取布局
pivotGridControl1.RestoreLayoutFromXml(gridLayoutFileName, DevExpress.Utils.OptionsLayoutBase.FullLayout);
网友评论