private void pivotGridControl1_CustomDrawCell(object sender, PivotCustomDrawCellEventArgs e) { int index = 0; PivotGridField[] fields = e.GetRowFields(); for (int i = 0; i < fields.Length; i++) { if (fields[i].Caption == BalanceTableViewData.CATEGORY) { index = i; break; } } if (index >= 0 && fields.Length > index) { if (e.GetFieldValue(fields[index]).ToString().StartsWith(CellInfo.CELL_IN_BALANCE) || e.GetFieldValue(fields[index]).ToString().StartsWith(CellInfo.CELL_OUT_BALANCE) ) { e.Appearance.BackColor = Color.PowderBlue; e.Appearance.BackColor2 = Color.PowderBlue; e.Appearance.Options.UseBackColor = true; } else if (e.GetFieldValue(fields[index]).ToString().StartsWith(CellInfo.CELL_IN_TARGET) || e.GetFieldValue(fields[index]).ToString().StartsWith(CellInfo.CELL_OUT_TARGET) ) { e.Appearance.BackColor = Color.WhiteSmoke; e.Appearance.BackColor2 = Color.WhiteSmoke; e.Appearance.Options.UseBackColor = true; } else if (e.GetFieldValue(fields[index]).ToString().StartsWith(CellInfo.CELL_IN_PLAN) || e.GetFieldValue(fields[index]).ToString().StartsWith(CellInfo.CELL_OUT_PLAN) ) { e.Appearance.BackColor = Color.WhiteSmoke; e.Appearance.BackColor2 = Color.WhiteSmoke; e.Appearance.Options.UseBackColor = true; } } index = 0; // 색상 변경 : 특정 Data Cell : 색상 처리 if (e.DataField.FieldName == BalanceTableViewData.QTY && (decimal)e.GetFieldValue(e.DataField) < 0) { e.Appearance.Options.UseBackColor = true; e.Appearance.DrawBackground(e.GraphicsCache, e.Bounds); e.Appearance.DrawString(e.GraphicsCache, e.DisplayText, e.Bounds, e.Appearance.Font, Brushes.Red, e.Appearance.GetStringFormat()); e.Handled = true; } }
private void pivotGridControl1_CustomDrawCell(object sender, PivotCustomDrawCellEventArgs e) { int index = 0; PivotGridField[] fields = e.GetRowFields(); for (int i = 0; i < fields.Length; i++) { if (fields[i].Caption == TargetPlanCompareData.CATEGORY) { index = i; break; } } if (e.Value != null && (decimal)e.GetFieldValue(e.DataField) < 0) { e.Appearance.Options.UseBackColor = true; //e.Appearance.BackColor = Color.Yellow; //e.Appearance.BackColor2 = Color.Yellow; e.Appearance.ForeColor = Color.Red; } index = 0; for (int i = 0; i < fields.Length; i++) { if (fields[i].Caption == "FACTORY") { index = i; break; } } if (index >= 0 && fields.Length > index && e.GetFieldValue(fields[index]).ToString().StartsWith(TargetPlanCompareData.TOTAL)) { e.Appearance.BackColor = Color.LightGreen; e.Appearance.BackColor2 = Color.LightGreen; e.Appearance.Options.UseBackColor = true; } //if (index >= 0 && fields.Length > index && e.GetFieldValue(fields[index]).ToString().StartsWith("Plan")) //{ // e.Appearance.BackColor = Color.Gainsboro; // e.Appearance.BackColor2 = Color.Gainsboro; // e.Appearance.Options.UseBackColor = true; //} }