/// <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);
}
