■ GridView 클래스의 CustomSummaryCalculate 이벤트를 사용해 그룹 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 |
using System; using System.Globalization; using DevExpress.Data; using DevExpress.Utils; using DevExpress.XtraEditors; 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(); } #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 } } |
