/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { this.pivotGrid.DataSource = dt; PivotGridStyleFormatCondition condition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); condition1.Appearance.BackColor = Color.Yellow; condition1.ApplyToCustomTotalCell = true; condition1.ApplyToCell = true; condition1.ApplyToGrandTotalCell = true; condition1.ApplyToTotalCell = true; condition1.Appearance.Options.UseBackColor = true; condition1.Condition = FormatConditionEnum.Expression; condition1.Expression = "HIGHLIGHT == 'Y'"; pivotGrid.FormatConditions.Add(condition1); dtDet.Columns.Add("BIZ_CODE"); dtDet.Columns.Add("MENU_CODE"); dtDet.Columns.Add("FACILITY_CODE"); dtDet.Columns.Add("FACILITY_NAME"); dtDet.Columns.Add("USE_DATE"); dtDet.Columns.Add("KEY_SEQ", typeof(decimal)); dtDet.Columns.Add("ST_TIME"); dtDet.Columns.Add("END_TIME"); dtDet.Columns.Add("STATUS_CODE"); dtDet.Columns.Add("STATUS"); dtDet.Columns.Add("FACING_EMP_NO"); dtDet.Columns.Add("RMRK"); dtDet.Columns.Add("U_EMP_NO"); dtDet.Columns.Add("U_DATE"); dtDet.Columns.Add("U_IP"); GridStyle gs = new GridStyle(this.gridFacility, this.gridViewFacility); gs.AddColumn("사업장코드", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("상품코드", "MENU_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("세미나", "FACILITY_NAME", _ColumnType.Default, 120, _ColumnAlign.Left, true); gs.AddColumn("사용일자", "USE_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("지급순번", "KEY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("시작시간", "ST_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("종료시간", "END_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("판매상태", "STATUS_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, false); gs.AddColumn("판매상태", "STATUS", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("담당자", "FACING_EMP_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("비고", "RMRK", _ColumnType.Default, 150, _ColumnAlign.Center, true); gs.AddColumn("수정자사번", "U_EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("수정일자", "U_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("수정자IP", "U_IP", _ColumnType.Default, 80, _ColumnAlign.Center, false); gridFacility.DataSource = dtDet; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { this.pivotGrid.DataSource = dt; PivotGridStyleFormatCondition condition1 = new DevExpress.XtraPivotGrid.PivotGridStyleFormatCondition(); condition1.Appearance.BackColor = Color.Yellow; condition1.ApplyToCustomTotalCell = true; condition1.ApplyToCell = true; condition1.ApplyToGrandTotalCell = true; condition1.ApplyToTotalCell = true; condition1.Appearance.Options.UseBackColor = true; condition1.Condition = FormatConditionEnum.Expression; condition1.Expression = "HIGHLIGHT == 'Y'"; pivotGrid.FormatConditions.Add(condition1); }