本文主要是介绍DataGrid 风格管理类测试版源码,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
众所周知,WINForm 的 DataGrid 组件的功能强大而且灵活,作为一个数据库程序离开它可不行,但是dataGrid在设计期间采用“套用式样”的方式设计表格的外观并不够灵活,那有没有办法统一管理表格风格呢?答案是有。
作为数据表格的应用最重要的应该不是风格的颜色搭配,而是字段属性的格式化,要格式化每一列的数据显示值,比如说:dataGrid的记录集如果有个“日期时间”字段的话,就会发现,默认的话其实它只显示了日期部分,而时间被Format掉了,这样的话不能满足应用的需求。很多新手朋友也发过帖子询问如何显示出时间,本人也是属于新手行列,查阅了MSDN后编写了一个管理dataGrid 格式列和风格的类,它可以实现管理‘列宽、字体、标题名、格式类型、是否隐藏、行选、行只读、列只读’的基本功能。
先大致讲一下格式化列的原理。列的格式由DataGridTextBoxColumn的Format属性进行控制,Format 属性可以支持日期、货币、数值、文本等格式字符,具体信息可以参考MSDN:http://msdn.microsoft.com/library/CHS/cpref/html/frlrfSystemWindowsFormsDataGridTextBoxColumnClassFormatTopic.asp?frame=true。
这里演示格式化“日期时间”,代码:
DataGridTextBoxColumn gridColumn = DataGridTextBoxColumn();
gridColumn.Format=System.String.Format("yyyy-MM-dd hh:mm:ss",gridColumn.TextBox);
现在我把类的源码贴上面,我不保证代码的一些做法是否合理与正确,仅供参考:
using System;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Drawing;

namespace Grid.Service
{

/**//// <summary>
/// 格式化字符串
/// </summary>

public enum FormatIndex
{
Text = 0x0, //文本
Boolean, //是/否(钩选框)
Money, //货币(¥#0.00)
Numeric, //数值格式(#0.00)
RealNumber, //实数(0.000000)
LongDateTime, //长日期时间(yyyy年mm月dd日 hh:mm:ss)
DateTime, //日期时间(yyyy-mm-dd hh:mm:ss)
LongDate, //长日期(yyyy-mm-dd)
ShortDate, //短日期(yy-mm-dd)
Time //时间(hh:mm:ss)
};

/**//// <summary>
/// StyleManager 的摘要说明。
/// DataGrid 的属性管理类
/// </summary>

public class StyleManager
{
public static int lastSelectIndex = -1;
private DataGrid _dataGrid =null;
private DataTable _dataTable =null;
private bool _allowSelectedRow =false;
private int[] ReadonlyRows = null;
private bool isReadonlyRow = false;
private bool _dataGridReadonly = false;

public StyleManager(DataGrid dataGrid)
{
_dataGrid = dataGrid;
}

public StyleManager()
{;}
[Category("Action")]
[Description("可操作的数据表格")]

public DataGrid @DataGrid
{

get
{return _dataGrid;}

set
{
_dataGrid=value;
this._dataGrid.CurrentCellChanged -= new System.EventHandler(this.dataGrid_CurrentCellChanged);

if(this._allowSelectedRow)
{

if(_dataGrid!=null)
{
//修改事件
this._dataGrid.CurrentCellChanged += new System.EventHandler(this.dataGrid_CurrentCellChanged);
}
}
}
}
[Category("Data")]
[Description("要与数据表格绑定的数据源")]

public DataTable DataSource
{

get
{return _dataTable;}

set
{_dataTable =(value as DataTable);}
}
[Category("Appearance")]
[Description("获取当前的表格风格")]

public DataGridTableStyle CurrentTableStyle
{

get
{return GetGridTableStyle();}
}

/**//// <summary>
/// 允许行选择模式
/// </summary>
[Category("Behavior")]
[Description("允许行选择模式")]

public bool AllowSelectedRow
{

get
{return _allowSelectedRow;}

set
{
_allowSelectedRow =value;
this._dataGrid.CurrentCellChanged -= new System.EventHandler(this.dataGrid_CurrentCellChanged);

if(value)
{

if(_dataGrid!=null)
{
//修改事件
this._dataGrid.CurrentCellChanged += new System.EventHandler(this.dataGrid_CurrentCellChanged);
}
}
}
}
[Category("Behavior")]
[Description("表格只读,也可隐藏底部的新增行")]

public bool ReadOnly
{

get
{return _dataGridReadonly;}

set
{_dataGridReadonly = value;}
}

/**//// <summary>
/// 行选择事件
/// </summary>
/// <param name="sender">对象</param>
/// <param name="e">事件参数</param>

private void dataGrid_CurrentCellChanged(object sender, System.EventArgs e)
{

if(this.DataSource!=null)
{

try
{
this._dataGrid.Select(this._dataGrid.CurrentRowIndex);

if(StyleManager.lastSelectIndex!=-1)
{
this._dataGrid.UnSelect(StyleManager.lastSelectIndex);
}
StyleManager.lastSelectIndex = this._dataGrid.CurrentRowIndex;

}catch
{;}
}
//锁定表格行的算法

if(isReadonlyRow&&this.ReadonlyRows!=null)
{
this._dataGrid.ReadOnly = false;
if(this.ReadonlyRows.Length>0)

for(int i=0;i<ReadonlyRows.Length;i++)
{

if(this._dataGrid.CurrentRowIndex==ReadonlyRows[i])
{
this._dataGrid.ReadOnly = true;
break;
}
}
}

if(_dataGridReadonly)
{
this._dataGrid.ReadOnly = true;
return;
}
}

/**//// <summary>
/// 设置列头风格
/// </summary>
/// <param name="HeaderFont">字体</param>
/// <param name="HeaderFontColor">文字颜色</param>
/// <returns>是否成功</returns>

public bool SetHeader(Font HeaderFont,Color HeaderFontColor)
{

try
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}
currGTS.HeaderFont = HeaderFont;
currGTS.HeaderForeColor = HeaderFontColor;
return true;

}catch
{
return false;
}
}

/**//// <summary>
/// 设置列头风格,默认黑色字体颜色
/// </summary>
/// <param name="HeaderFont">字体</param>
/// <returns>是否成功</returns>

public bool SetHeader(Font HeaderFont)
{
return SetHeader(HeaderFont,System.Drawing.Color.Black);
}

/**//// <summary>
/// 设置表格风格
/// </summary>
/// <param name="CaptionText">标题文本</param>
/// <param name="CaptionVisible">标题可视</param>
/// <param name="RowHeaderVisible">行头可视</param>
/// <returns>是否成功</returns>

public bool SetGrid(string CaptionText,bool CaptionVisible,bool RowHeaderVisible)
{

try
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}

if(this._dataGrid==null)
{
throw new Exception("无可操作的表格对象!");
}
this._dataGrid.CaptionText = CaptionText;
this._dataGrid.CaptionVisible = CaptionVisible;
currGTS.RowHeadersVisible = RowHeaderVisible;
return true;

}catch
{
return false;
}
}

/**//// <summary>
/// 根据数据类型获取列类型
/// </summary>
/// <param name="tp">数据类型</param>
/// <returns></returns>

private int getDataGridExColumn(Type tp)
{

if(tp==System.Type.GetType("System.Boolean"))
{
return 2;

}else if(tp==System.Type.GetType("System.DateTime"))
{
return 6;

}else if(tp==System.Type.GetType("System.Decimal"))
{
return 1;

}else if(tp==System.Type.GetType("System.Single")||tp==System.Type.GetType("System.Double"))
{
return 3;

}else
{
return 0;
}
}

/**//// <summary>
/// 获取默认默认风格
/// </summary>
/// <returns>表风格</returns>

private DataGridTableStyle GetGridTableStyle()
{

try
{
if (_dataGrid.TableStyles.Count<=0&&_dataTable==null)
throw new ArgumentNullException("数据源为空!");

if((_dataGrid.DataSource as DataTable)!=_dataTable)
{
_dataGrid.DataSource = _dataTable;
}

if(_dataGrid.TableStyles.Count<=0)
{
DataGridTableStyle style = new DataGridTableStyle();
style.MappingName = _dataTable.TableName;

foreach(DataColumn column in _dataTable.Columns)
{

if(column.DataType==System.Type.GetType("System.Boolean"))
{
DataGridBoolColumn gridColumn = new DataGridBoolColumn();
gridColumn.TrueValue = true;
gridColumn.FalseValue = false;
gridColumn.MappingName = column.ColumnName;
gridColumn.HeaderText = column.ColumnName;
gridColumn.Width = _dataGrid.PreferredColumnWidth;
style.GridColumnStyles.Add(gridColumn);

}else
{
DataGridTextBoxColumn gridColumn = new DataGridTextBoxColumn();
gridColumn.MappingName = column.ColumnName;
gridColumn.HeaderText = column.ColumnName;
gridColumn.Width = _dataGrid.PreferredColumnWidth;
gridColumn.NullText = "";
style.GridColumnStyles.Add(gridColumn);
}
}
_dataGrid.TableStyles.Clear();
_dataGrid.TableStyles.Add(style);
}
return _dataGrid.TableStyles[0];

}catch
{
return null;
}
}

private bool isBoolColumn(string ColumnName)
{
return (_dataTable.Columns[ColumnName].DataType==System.Type.GetType("System.Boolean"));
}

private int getColumnIndex(DataGridTableStyle DGTS , string columName)
{

for(int i=0;i<DGTS.GridColumnStyles.Count;i++)
{

if(DGTS.GridColumnStyles[i].HeaderText.ToString().Trim()==columName.ToString().Trim())
{
return i;
}
}
return -1;
}

/**//// <summary>
/// 设置只读的行
/// </summary>
/// <param name="rowIndexs">行索引数组</param>
/// <param name="Readonly">是否只读</param>
/// <returns>是否成功</returns>

public bool SetReadOnlyRows(int[] rowIndexs,bool Readonly)
{

try
{
this.isReadonlyRow = Readonly;
this.ReadonlyRows = rowIndexs;
return true;

}catch
{
return false;
}
}

/**//// <summary>
/// 设置列只读属性
/// </summary>
/// <param name="columnIndexs">列索引数组</param>
/// <param name="Readonly">只读属性</param>
/// <returns>是否处理成功</returns>

public bool SetReadOnlyColumns(int[] columnIndexs,bool Readonly)
{
//获取表风格

try
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}

if(columnIndexs==null||columnIndexs.Length<=0)
{
throw new ArgumentOutOfRangeException("只读索引超出范围!");
}
DataGridColumnStyle GCS;

for(int i=0;i<columnIndexs.Length;i++)
{

if(columnIndexs[i]<0&&columnIndexs[i]>currGTS.GridColumnStyles.Count-1)
{
throw new ArgumentOutOfRangeException("索引超出范围!");
}
GCS = currGTS.GridColumnStyles[columnIndexs[i]];

if(GCS is DataGridBoolColumn)
{
(GCS as DataGridBoolColumn).ReadOnly = Readonly;

}else if(GCS is DataGridTextBoxColumn)
{
(GCS as DataGridTextBoxColumn).ReadOnly = Readonly;
}
}
return true;

}catch
{return false;}
}

/**//// <summary>
/// 设置列只读属性
/// </summary>
/// <param name="columnNames">列名称数组</param>
/// <param name="Readonly">只读属性</param>
/// <returns>是否处理成功</returns>

public bool SetReadOnlyColumns(string[] columnNames,bool Readonly)
{
//获取表风格

try
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}

if(columnNames==null||columnNames.Length<=0)
{
throw new ArgumentOutOfRangeException("只读索引超出范围!");
}
DataGridColumnStyle GCS;
int columnIndex =-1;

for(int i=0;i<columnNames.Length;i++)
{
columnIndex = getColumnIndex(currGTS,columnNames[i]);

if(columnIndex==-1)
{
throw new Exception("列名称为空或者无效!");
}
GCS = currGTS.GridColumnStyles[columnNames[i]];

if(GCS is DataGridBoolColumn)
{
(GCS as DataGridBoolColumn).ReadOnly = Readonly;

}else if(GCS is DataGridTextBoxColumn)
{
(GCS as DataGridTextBoxColumn).ReadOnly = Readonly;
}
}
return true;

}catch
{return false;}
}

/**//// <summary>
/// 设置列属性
/// </summary>
/// <param name="columnIndex">列索引值</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <param name="Format">列格式</param>
/// <param name="Align">靠齐方式</param>
/// <param name="Visible">是否可见</param>
/// <returns>完成状态</returns>

public bool SetColumn(int columnIndex,int Width,string Title,FormatIndex Format,HorizontalAlignment Align,bool Visible)
{

try
{
//获取表风格
DataGridTableStyle currGTS = GetGridTableStyle();
string MappingName= null;

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}

if(columnIndex<0&&columnIndex>currGTS.GridColumnStyles.Count-1)
{
throw new ArgumentOutOfRangeException("索引超出范围!");
}
//处理参数
Width = (Math.Abs(Width));
Title = (Title == null ? "" : Title);
Format = ((object)Format == null ? FormatIndex.Text : Format);
Align = ((object)Align == null ? HorizontalAlignment.Left : Align);
MappingName = currGTS.GridColumnStyles[columnIndex].MappingName;
DataGridColumnStyle GCS = currGTS.GridColumnStyles[columnIndex];

if(GCS is DataGridTextBoxColumn)
{
DataGridTextBoxColumn gridColumn = (GCS as DataGridTextBoxColumn);

switch((int)Format)
{
case 2:
gridColumn.Format = "C";
break;
case 3:
gridColumn.Format = "N";
break;
case 5:
gridColumn.Format=System.String.Format("yyyy年MM月dd日 hh:mm:ss",gridColumn.TextBox);
break;
case 6:
gridColumn.Format=System.String.Format("yyyy-MM-dd hh:mm:ss",gridColumn.TextBox);
break;
case 7:
gridColumn.Format=System.String.Format("yyyy-MM-dd",gridColumn.TextBox);
break;
case 8:
gridColumn.Format=System.String.Format("yy-MM-dd",gridColumn.TextBox);
break;
case 9:
gridColumn.Format= System.String.Format("hh:mm:ss",gridColumn.TextBox);
break;
default:
gridColumn.Format = "";
break;
}
gridColumn.Width = Width;
gridColumn.MappingName = MappingName;
gridColumn.HeaderText = (Title.ToString()==""||Title==null ? MappingName : Title.ToString());
gridColumn.Alignment = Align;
gridColumn.NullText = "";
}
//隐藏字段

if(!Visible)
{
GCS.Width =0;
GCS.HeaderText ="";
}
return true;

}catch
{
return false;
}
}

/**//// <summary>
/// 设置列属性,默认可见
/// </summary>
/// <param name="columnIndex">列索引值</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <param name="Format">列格式</param>
/// <param name="Align">靠齐方式</param>
/// <returns>完成状态</returns>

public bool SetColumn(int columnIndex,int Width,string Title,FormatIndex Format,HorizontalAlignment Align)
{
return SetColumn(columnIndex,Width,Title,Format,Align,true);
}

/**//// <summary>
/// 设置列属性,默认可见,默认靠齐居左
/// </summary>
/// <param name="columnIndex">列索引值</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <param name="Format">列格式</param>
/// <returns>完成状态</returns>

public bool SetColumn(int columnIndex,int Width,string Title,FormatIndex Format)
{
return SetColumn(columnIndex,Width,Title,Format,HorizontalAlignment.Left,true);
}

/**//// <summary>
/// 设置列属性,默认可见,默认靠齐居左,默认文本格式
/// </summary>
/// <param name="columnIndex">列索引值</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <returns>完成状态</returns>

public bool SetColumn(int columnIndex,int Width,string Title)
{
return SetColumn(columnIndex,Width,Title,FormatIndex.Text,HorizontalAlignment.Left,true);
}

/**//// <summary>
/// 设置列属性,默认可见,默认靠齐居左,默认文本格式,默认标题为影射名
/// </summary>
/// <param name="columnIndex">列索引值</param>
/// <param name="Width">宽度</param>
/// <returns>完成状态</returns>

public bool SetColumn(int columnIndex,int Width)
{
return SetColumn(columnIndex,Width,"",FormatIndex.Text,HorizontalAlignment.Left,true);
}

/**//// <summary>
/// 设置列属性
/// </summary>
/// <param name="columnName">列名称</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <param name="Format">列格式</param>
/// <param name="Align">靠齐方式</param>
/// <param name="Visible">是否可见</param>
/// <returns>完成状态</returns>

public bool SetColumn(string columnName,int Width,string Title,FormatIndex Format,HorizontalAlignment Align,bool Visible)
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}
int columnIndex = getColumnIndex(currGTS,columnName);

if(columnIndex==-1)
{
throw new Exception("列名称为空或者无效!");
}
return SetColumn(columnIndex,Width,Title,Format,Align,Visible);
}

/**//// <summary>
/// 设置列属性,默认可见
/// </summary>
/// <param name="columnName">列名称</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <param name="Format">列格式</param>
/// <param name="Align">靠齐方式</param>
/// <returns>完成状态</returns>

public bool SetColumn(string columnName,int Width,string Title,FormatIndex Format,HorizontalAlignment Align)
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}
int columnIndex = getColumnIndex(currGTS,columnName);

if(columnIndex==-1)
{
throw new Exception("列名称为空或者无效!");
}
return SetColumn(columnIndex,Width,Title,Format,Align);
}

/**//// <summary>
/// 设置列属性,默认可见,默认靠齐居左
/// </summary>
/// <param name="columnName">列名称</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <param name="Format">列格式</param>
/// <returns>完成状态</returns>

public bool SetColumn(string columnName,int Width,string Title,FormatIndex Format)
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}
int columnIndex = getColumnIndex(currGTS,columnName);

if(columnIndex==-1)
{
throw new Exception("列名称为空或者无效!");
}
return SetColumn(columnIndex,Width,Title,Format);
}

/**//// <summary>
/// 设置列属性,默认可见,默认靠齐居左,默认文本格式
/// </summary>
/// <param name="columnName">列名称</param>
/// <param name="Width">宽度</param>
/// <param name="Title">标题文本</param>
/// <returns>完成状态</returns>

public bool SetColumn(string columnName,int Width,string Title)
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}
int columnIndex = getColumnIndex(currGTS,columnName);

if(columnIndex==-1)
{
throw new Exception("列名称为空或者无效!");
}
return SetColumn(columnIndex,Width,Title);
}

/**//// <summary>
/// 设置列属性,默认可见,默认靠齐居左,默认文本格式,默认标题为影射名
/// </summary>
/// <param name="columnName">列名称</param>
/// <param name="Width">宽度</param>
/// <returns>完成状态</returns>

public bool SetColumn(string columnName,int Width)
{
DataGridTableStyle currGTS = GetGridTableStyle();

if(currGTS==null)
{
throw new Exception("初始化表风格出错!");
}
int columnIndex = getColumnIndex(currGTS,columnName);

if(columnIndex==-1)
{
throw new Exception("列名称为空或者无效!");
}
return SetColumn(columnIndex,Width);
}
}
}
下面的代码是演示如何使用这个类:
OleDbConnection conn = new OleDbConnection( " Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=/ " E://sf//DataBasew.mdb/ " ;Mode=Share Deny None;Jet OLEDB:Engine Type=5;Provider=/ " Microsoft.Jet.OLEDB. 4.0 / " ;Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1 " );
OleDbDataAdapter da = new OleDbDataAdapter( " SELECT A.设备编号, b.设备名称, b.所属设备组, A.检测时间, A.气体压力, A.换算压力, A.气体湿度, A.气体温度, A.诊断代码 FR " +
" OM (六氟化硫数据 A LEFT OUTER JOIN 测试设备 b ON A.设备编号 = b.编号) ORDER BY b.所属设备组, A.检测时间 " , conn );
DataSet ds = new DataSet();

try
{
da.Fill( ds, "六氟化硫数据" );
}

catch ( Exception ex )
{
MessageBox.Show( ex.Message );
}
// 这里不需要制定,因为要由风格管理类接管,并且避免dataGrid自动初始化表风格影响速度
// dataGrid.DataSource = ds.Tables[0];
Grid.Service.StyleManager sm = new Grid.Service.StyleManager();
sm.DataGrid = dataGrid; // 目标DataGrid
sm.DataSource = ds.Tables[ 0 ]; // 目标DataTable
sm.AllowSelectedRow = true ; // 允许行选择
// 设置第1列宽200,名称为“设备编号!",数据类型为数值型,局中,不隐藏
sm.SetColumn( 0 , 200 , " 设备编号 ! " ,Grid.Service.FormatIndex.Numeric,HorizontalAlignment.Center, true );
// 设置第2列宽100,不制定名称“用表字段真实名称”,文本类型
sm.SetColumn( 1 , 100 ,( string ) null ,Grid.Service.FormatIndex.Text,HorizontalAlignment.Center, true );
// 设置第4列为日期时间类型
sm.SetColumn( 3 , 200 ,( string ) null ,Grid.Service.FormatIndex.DateTime);

sm.SetReadOnlyColumns( new int []
{0,2,5} , true ); // 只读列0,2,5

sm.SetReadOnlyRows( new int []
{0,4,6,8} , true ); // 只读行0,4,6,8
sm.SetHeader( new Font( " 黑体 " ,9f),Color.Red); // 设置列头字体,黑体9号字,红色
sm.SetGrid( " 测试表格 " , true , false ); // 显示表格标题,不显示行标题
conn.Close();
这篇关于DataGrid 风格管理类测试版源码的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!