DEVEXPRESS GRIDVIEW 数据根据不同条件格式化显示色块和文字颜色

1.色块和文字颜色方法

/// <summary>
/// 设置单元格样式(色块)
/// </summary>
/// <param name="gc">Devexpress GridView </param>
/// <param name="color">颜色</param>
/// <param name="expression">表达式(条件)</param>
/// <returns></returns>
protected virtual StyleFormatCondition SetStyleFormatCondition(GridColumn gc, Color color, string expression)
{
StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition();
condition1.Column = gc;
condition1.Appearance.BackColor = color;
condition1.Appearance.Options.UseBackColor = true;
condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = expression;
return condition1;
}

/// <summary>
/// 设置单元格(字体颜色)
/// </summary>
/// <param name="gc">Devexpress GridView</param>
/// <param name="color">颜色</param>
/// <param name="expression">表达式(条件)</param>
/// <returns></returns>
protected virtual StyleFormatCondition SetStyleFormatFontCondition(GridColumn gc, Color color, string expression)
{
StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition();
condition1.Column = gc;
condition1.Appearance.ForeColor = color;
condition1.Appearance.Options.UseForeColor = true;
condition1.Appearance.Options.UseTextOptions = true;
condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = expression;
return condition1;
}

2.开始调用

gvData.FormatConditions.Add(SetStyleFormatCondition(gvData.Columns["AuditStatus"], Color.FromArgb(56, 173, 40), "AuditStatus=='已审核'"));//审核状态(色块)

gvData.FormatConditions.Add(SetStyleFormatFontCondition(gvData.Columns["OrderStatus"], Color.FromArgb(30, 119, 194), "OrderStatus=='未完成'"));//执行状态(文字颜色)

执行结果:

Devexpress Winform Gridcontrol 中根据条件单元格的值改变单元格的颜色等属性。

Devexpress Winform Gridcontrol 中根据条件单元格的值改变单元格的颜色等属性。 - 街西 - 博客园

提供一下三种方法

1.使用设计器

点击gridcontrol控件，run　designer,format Condtions， add，然后进行各种条件的设置。

2.用代码代替设计器。

实例代码：

 private void SetWarning()
        {
            #region 应收预警   应收100万以内绿色；100-300万蓝色；300-500万黄色；500-700万橙色；700万以上红色。
            StyleFormatCondition condition = new StyleFormatCondition();
            condition.Appearance.Options.UseForeColor = true;
            condition.Appearance.ForeColor = Color.Green;
            condition.Column = bandedGridViewSalesDailyReport.Columns["Diff"];
            condition.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
            condition.Expression = "1000000>Abs([Diff])";
            condition.Value1 = true;


            StyleFormatCondition condition2 = new StyleFormatCondition();
            condition2.Appearance.Options.UseForeColor = true;
            condition2.Appearance.ForeColor = Color.Yellow;
            condition2.Column = bandedGridViewSalesDailyReport.Columns["Diff"];
            condition2.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;          
            condition2.Expression = "3000000 > Abs([Diff]) And Abs([Diff]) > 3000000";
             condition2.Value1 = true;


            StyleFormatCondition condition4 = new StyleFormatCondition();
            condition4.Appearance.Options.UseForeColor = true;
            condition4.Appearance.ForeColor = Color.Orange;
            condition4.Column = bandedGridViewSalesDailyReport.Columns["Diff"];
            condition4.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
            condition4.Expression = "7000000 > Abs([Diff]) And Abs([Diff]) > 5000000";
            
            condition4.Value1 = true;

            StyleFormatCondition condition6 = new StyleFormatCondition();
            condition6.Appearance.Options.UseForeColor = true;
            condition6.Appearance.ForeColor = Color.Red;
            condition6.Column = bandedGridViewSalesDailyReport.Columns["Diff"];
            condition6.Condition = DevExpress.XtraGrid.FormatConditionEnum.Expression;
            condition6.Expression = "Abs([Diff])>7000000";
            condition6.Value1 = true;
            this.bandedGridViewSalesDailyReport.FormatConditions.AddRange(new DevExpress.XtraGrid.StyleFormatCondition[] {
                condition,
                condition2,
                condition4,
                condition6
            });
            #endregion 应收预警
        }

 3.在绘制行或者单元格时候设置

示例代码1：

  private void bandedGridViewSalesDailyReport_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
        {
            Color c = System.Drawing.Color.FromArgb(((int)(((byte)(253)))), ((int)(((byte)(234)))), ((int)(((byte)(218)))));

            if (e.Column.FieldName == "Diff")
            {
                e.Column.AppearanceCell.BackColor = c;
            }

            if (e.Column == this.colPrepayment)
            {
                e.Column.AppearanceCell.BackColor = c;
            }
            if (e.Column == colTotalAmount)
            {
                e.Column.AppearanceCell.BackColor = c;
            }
        }

 示例代码2：

 private void gridViewShipment_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
        {
            if (e.Column == this.colSettlementStatus && e.CellValue != null)
            {
                if (e.CellValue.ToString() == "完成结算")
                {
                    e.Appearance.ForeColor = Color.Green;
                }
                else
                if (e.CellValue.ToString() == "未结算")
                {
                    e.Appearance.ForeColor = Color.Red;
                }
                else
                {
                    e.Appearance.ForeColor = Color.Orange;
                }
            }
        }