8,834
社区成员
发帖
与我相关
我的任务
分享
//开始视图的编辑,防止触发其他事件
view.BeginUpdate();
//开始数据的编辑
view.BeginDataUpdate();
view.Bands.Clear();
view.Columns.Clear();
//创建第一列
GridBand bandNCCode = view.Bands.AddBand("产品编号");
GridBand bandNCName = view.Bands.AddBand("产品名称");
GridBand bandInToday = view.Bands.AddBand("今日入库");
//第一列绑定字段
bandNCCode.Columns.Add(new BandedGridColumn() { FieldName = "bandNCCode", Visible = true });
bandNCName.Columns.Add(new BandedGridColumn() { FieldName = "bandNCName", Visible = true });
//创建第二列
GridBand bandInCT = bandInToday.Children.AddBand("厂提"); //今日入库
GridBand bandInCTM = bandInToday.Children.AddBand("厂提金额");
GridBand bandInYT = bandInToday.Children.AddBand("院提");
GridBand bandInYTM = bandInToday.Children.AddBand("院提金额");
//第二列绑定字段
bandInCT.Columns.Add(new BandedGridColumn() { FieldName = "bandInCT", Visible = true });
bandInCTM.Columns.Add(new BandedGridColumn() { FieldName = "bandInCTM", Visible = true });
bandInYT.Columns.Add(new BandedGridColumn() { FieldName = "bandInYT", Visible = true });
bandInYTM.Columns.Add(new BandedGridColumn() { FieldName = "bandInYTM", Visible = true });
//底部求和
view.OptionsView.ShowFooter = true;
string[] sum = { "bandInCT", "bandInCTM", "bandInYT", "bandInYTM" };
foreach (var i in sum)
{
view.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
view.Columns[i].SummaryItem.DisplayFormat = "{0}";
}
//结束数据的编辑
view.EndDataUpdate();
//结束视图的编辑
view.EndUpdate();