一、问题描述

    在我们使用Winform配合DevExpress进行开发表格时，表格中的涉及到百分比数据的内容除了显示百分比的数字内容外，还希望搭配显示进度条效果（且低于百分之60的内容用红色表示不合格，高于百分之60的用绿色表示），这样百分比的显示效果更加清晰直观。

二、实现方法

2.1、先注册单元格绘制方法

2.2、编写给指定单元格绘制进度条的方法

#region 给表格指定列绘制进度条/// 
/// 给指定列绘制进度条/// 
/// GridView控件/// 需绘制进度条列的字段名称/// 警告值（用于区分不同的颜色）/// 警告值前的进度条颜色/// 警告值后的进度条颜色public static void DrawProgressBarToColumn(DevExpress.XtraGrid.Views.Grid.GridView gridView, string columnFieldName, double warningValue = 60, Brush beforeWaringValueColor = null, Brush afterWaringValueColor = null){var column = gridView.Columns[columnFieldName];if (column == null) return;column.AppearanceCell.Options.UseTextOptions = true;//设置该列显示文本内容的位置（这里默认居中）column.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center;//绘制事件方法(前提需要先注册才能够接收到参数使用)gridView.CustomDrawCell += (s, e) =>{if (e.Column.FieldName == columnFieldName){DrawProgressBar(e, warningValue, beforeWaringValueColor, afterWaringValueColor);e.Handled = true;DrawEditor(e);}};}/// 
/// 绘制进度条/// 
/// 单元格绘制事件参数/// 警告值（用于区分不同的颜色）/// 警告值前的进度条颜色/// 警告值后的进度条颜色public static void DrawProgressBar(DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e, double warningValue = 60,Brush beforeWaringValueColor = null, Brush afterWaringValueColor = null){string tmpValue = e.CellValue.ToString();float percent = 0;if (!string.IsNullOrEmpty(tmpValue)){float.TryParse(tmpValue, out percent);}int width = 0;if (percent >2){width = (int)(Math.Abs(percent / 100) * e.Bounds.Width);}else{width = (int)(Math.Abs(percent) * e.Bounds.Width);} Rectangle rect = new Rectangle(e.Bounds.X, e.Bounds.Y, width, e.Bounds.Height);Brush b = Brushes.Green;if (afterWaringValueColor != null){b = afterWaringValueColor;}if (percent < warningValue){if (beforeWaringValueColor == null){b = Brushes.Red;}else{b = beforeWaringValueColor;}}e.Graphics.FillRectangle(b, rect);}/// 
/// 绘制单元格/// 
/// 单元格绘制事件参数public static void DrawEditor(DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e){DevExpress.XtraGrid.Views.Grid.ViewInfo.GridCellInfo cell = e.Cell as DevExpress.XtraGrid.Views.Grid.ViewInfo.GridCellInfo;Point offset = cell.CellValueRect.Location;DevExpress.XtraEditors.Drawing.BaseEditPainter pb = cell.ViewInfo.Painter as DevExpress.XtraEditors.Drawing.BaseEditPainter;AppearanceObject style = cell.ViewInfo.PaintAppearance;if (!offset.IsEmpty)cell.ViewInfo.Offset(offset.X, offset.Y);try{pb.Draw(new DevExpress.XtraEditors.Drawing.ControlGraphicsInfoArgs(cell.ViewInfo, e.Cache, cell.Bounds));}finally{if (!offset.IsEmpty){cell.ViewInfo.Offset(-offset.X, -offset.Y);}}}#endregion 

 2.3、使用给指定单元格绘制进度条方法

    注意：在使用给指定单元格绘制进度条方法时（如果数字都是小于1的那么警告值也是需要小于1；如果是大于1的则按照需要设置即可）。

 --使用方法语法DrawProgressBarToColumn(gridView组件名称, 需要绘制进度条的单元格字段, 警告值,警告值前的进度条颜色,警告值后的进度条颜色);--示例1DrawProgressBarToColumn(gridView1, "Age", 0.6,Brushes.OrangeRed,Brushes.LawnGreen);--示例2DrawProgressBarToColumn(gridView1, "Age", 0.6, new SolidBrush(Color.FromArgb(236, 65, 65)), new SolidBrush(Color.FromArgb(45, 115, 186)));

三、相关内容

3.1、给单元格设置百分比

/// 
/// 设置表格指定单元格都使用百分比/// 
/// gridView组件/// 列名称public static void SetPercentage(GridView gridView, string columnName){if (gridView != null && gridView.Columns.Count > 0 && !string.IsNullOrEmpty(columnName)){gridView.Columns[columnName].DisplayFormat.FormatType = FormatType.Numeric;gridView.Columns[columnName].DisplayFormat.FormatString = "P2";}}

上面这个代码实现的是将小数转为百分比显示【比如将小数(0.3)使用后就转为（30%）显示】 

/// 
/// 给表格指定单元格都保留2位小数后添加%号/// 
/// /// /// public static void SetResreserveTwoBitAndPercentageChar(GridView gridView, int startColumnIndex, int endColumnIndex){if (gridView != null && gridView.Columns.Count > 0 && startColumnIndex > 0 && endColumnIndex > 0 && endColumnIndex <= gridView.Columns.Count){for (int i = startColumnIndex; i <= endColumnIndex; i++){gridView.Columns[i].DisplayFormat.FormatType = FormatType.Numeric;gridView.Columns[i].DisplayFormat.FormatString = $"{0:N2}'%'";}}}

 上面这个代码实现的是给数字添加百分号符号显示【比如将小数(86.2356)使用后就转为（86.24%）显示】 

3.2、相关资料

GridView Class | WinForms Controls | DevExpress Documentationhttps://docs.devexpress.com/WindowsForms/DevExpress.XtraGrid.Views.Grid.GridView

GridView.CustomDrawCell Event | WinForms Controls | DevExpress Documentationhttps://docs.devexpress.com/WindowsForms/DevExpress.XtraGrid.Views.Grid.GridView.CustomDrawCell

RowCellCustomDrawEventArgs Class | WinForms Controls | DevExpress Documentationhttps://docs.devexpress.com/WindowsForms/DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgsBrush 类 (System.Drawing) | Microsoft Docshttps://docs.microsoft.com/zh-cn/dotnet/api/system.drawing.brush?view=dotnet-plat-ext-6.0Graphics.DrawEllipse 方法 (System.Drawing) | Microsoft Docshttps://docs.microsoft.com/zh-cn/dotnet/api/system.drawing.graphics.drawellipse?view=dotnet-plat-ext-6.0SolidBrush 类 (System.Drawing) | Microsoft Docshttps://docs.microsoft.com/zh-cn/dotnet/api/system.drawing.solidbrush?view=dotnet-plat-ext-6.0