■ GridView 클래스의 GetRowSummaryItem 메소드를 사용해 SUMMARY 항목을 구하는 방법을 보여준다.
▶ MainForm.cs
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 |
using System; using System.Collections; using System.Globalization; using DevExpress.Data; using DevExpress.Utils; using DevExpress.XtraEditors; using DevExpress.XtraGrid; using DevExpress.XtraGrid.Views.Base; using DevExpress.XtraGrid.Views.Grid; namespace TestProject { /// <summary> /// 메인 폼 /// </summary> public partial class MainForm : XtraForm { //////////////////////////////////////////////////////////////////////////////////////////////////// Field ////////////////////////////////////////////////////////////////////////////////////////// Private #region Field /// <summary> /// 일자 카운트 /// </summary> private int dateCount = 0; #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor ////////////////////////////////////////////////////////////////////////////////////////// Public #region 생성자 - MainForm() /// <summary> /// 생성자 /// </summary> public MainForm() { InitializeComponent(); this.gridView.InitializeView ( true, // Multi Select GridMultiSelectMode.RowSelect, // Grid Multi Select Mode DrawFocusRectStyle.CellFocus, // Draw Focus Rect Style true, // Show Indicator true, // Show Column Headers true, // Allow Column Moving true, // Allow Column Resizing true, // Allow Filter true, // Allow Sort false, // Allow Cell Merge EditorShowMode.Default, // Editor Show Mode false // Editable ); this.gridView.OptionsBehavior.AutoPopulateColumns = true; this.gridView.OptionsBehavior.AutoExpandAllGroups = true; this.gridView.OptionsView.ShowGroupPanel = true; this.gridView.OptionsView.ShowGroupedColumns = true; this.gridView.CustomSummaryCalculate += gridView_CustomSummaryCalculate; this.gridControl.DataSource = new nwindDataSetTableAdapters.OrdersTableAdapter().GetData(); this.gridView.Columns["OrderDate"].GroupIndex = 0; this.gridView.GroupSummary.Add(SummaryItemType.Custom, "OrderDate", gridView.Columns["OrderDate"], "{0} this week"); this.gridView.BestFitColumns(); this.gridView.FocusedRowChanged += gridView_FocusedRowChanged; } #endregion //////////////////////////////////////////////////////////////////////////////////////////////////// Method ////////////////////////////////////////////////////////////////////////////////////////// Private #region 그리드 뷰 SUMMARY 커스텀 계산하기 - gridView_CustomSummaryCalculate(sender, e) /// <summary> /// 그리드 뷰 SUMMARY 커스텀 계산하기 /// </summary> /// <param name="sender">이벤트 발생자</param> /// <param name="e">이벤트 인자</param> private void gridView_CustomSummaryCalculate(object sender, CustomSummaryEventArgs e) { if(e.IsGroupSummary) { GridView gridView = sender as GridView; switch(e.SummaryProcess) { case CustomSummaryProcess.Start : dateCount = 0; break; case CustomSummaryProcess.Calculate : DateTime orderDate = Convert.ToDateTime(gridView.GetRowCellValue(e.RowHandle, gridView.Columns["OrderDate"])); DateTime currentDate = DateTime.Now; CultureInfo cultureInfo = CultureInfo.CurrentCulture; int orderDateWeek = cultureInfo.Calendar.GetWeekOfYear ( orderDate, CalendarWeekRule.FirstDay, DayOfWeek.Monday ); int currentDateWeek = cultureInfo.Calendar.GetWeekOfYear ( currentDate, CalendarWeekRule.FirstDay, DayOfWeek.Monday ); if(orderDateWeek == currentDateWeek) { dateCount++; } break; case CustomSummaryProcess.Finalize : e.TotalValue = dateCount; break; } } } #endregion #region 그리드 뷰 포커스 행 변경시 처리하기 - gridView_FocusedRowChanged(sender, e) /// <summary> /// 그리드 뷰 포커스 행 변경시 처리하기 /// </summary> /// <param name="sender">이벤트 발생자</param> /// <param name="e">이벤트 인자</param> private void gridView_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e) { GridView gridView = sender as GridView; DictionaryEntry dictionaryEntry = gridView.GetRowSummaryItem(e.FocusedRowHandle, gridView.FocusedColumn); if(dictionaryEntry.Key != null) { GridGroupSummaryItem gridGroupSummaryItem = (GridGroupSummaryItem)dictionaryEntry.Key; this.messageLabelControl.Text = $"SUMMARY : {gridGroupSummaryItem.GetDisplayText(dictionaryEntry.Value, true)}"; } else { this.messageLabelControl.Text = "이 행과 컬럼에 대한 SUMMARY가 없습니다."; } } #endregion } } |