如圖,已經有底部匯總,但是單列的,想指定紅色雙列和藍色雙列再次進行匯總,求指點
uj5u.com熱心網友回復:
代碼如下,用設計器的話在其他博客找到過可以實作,但轉換成代碼就不知道怎么弄了…
//開始視圖的編輯,防止觸發其他事件
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();
轉載請註明出處,本文鏈接:https://www.uj5u.com/net/99292.html
標籤:組件/控件開發
上一篇:c#程式關閉后,后臺行程還在,任務管理器里也結束不掉
下一篇:Microsoft Dynamics CRM 批量上傳web資源(非官方WebResourceUtility)并替換物體圖示
