DataTable操作工具类DataTableHelper。
功能介绍：
- 将泛型集合填充为数据表
- 将泛型填充为数据表
- 将对象集合填充为数据表
- 将对象填充为数据表
- 将定IDictionary数据转换为DataSet数据
- 将数据表填充为泛型集合
- 将数据表填充为泛型集合
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Reflection;
using System.Data;
using System.Collections; namespace IM.Common
{
/// <summary>
/// 数据操作
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
public class DataHelper
{
/// <summary>
/// 将泛型集合填充为数据表
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="list">泛型集合</param>
/// <param name="tableName">表名</param>
/// <returns>数据表</returns>
public static DataTable Fill<T>(IList<T> list, string tableName)
{
DataTable dt = new DataTable(tableName);
T t = Activator.CreateInstance<T>();
Type type = t.GetType();
PropertyInfo[] properties = type.GetProperties().Where(p => p.MemberType == MemberTypes.Property && p.CanRead).ToArray();
foreach (PropertyInfo p in properties)
{
dt.Columns.Add(p.Name);
}
foreach (T t1 in list)
{
PropertyInfo[] properties1 = t1.GetType().GetProperties().Where(p => p.MemberType == MemberTypes.Property && p.CanRead).ToArray();
DataRow dr = dt.NewRow();
for (int i = ; i < dt.Columns.Count; i++)
{
PropertyInfo propertyInfo = properties1.SingleOrDefault(p => p.Name == Convert.ToString(dt.Columns[i].ColumnName));
if (propertyInfo != null)
{
dr[dt.Columns[i].ColumnName] = propertyInfo.GetValue(t1, null);
}
}
dt.Rows.Add(dr);
}
return dt;
} /// <summary>
/// 将泛型填充为数据表
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="t">泛型</param>
/// <param name="tableName">表名</param>
/// <returns>数据表</returns>
public static DataTable Fill<T>(T t, string tableName)
{
IList<T> list = new List<T>();
if (t != null)
{
list.Add(t);
}
return Fill<T>(list, tableName);
} /// <summary>
/// 将对象集合填充为数据表
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="list">对象集合</param>
/// <param name="tableName">表名</param>
/// <returns>数据表</returns>
public static DataTable Fill(IList list, string tableName)
{
DataTable dt = new DataTable(tableName);
if (list.Count > )
{
PropertyInfo[] properties = list[].GetType().GetProperties().Where(p => p.MemberType == MemberTypes.Property && p.CanRead).ToArray();
foreach (PropertyInfo p in properties)
{
dt.Columns.Add(p.Name);
}
foreach (var t in list)
{
PropertyInfo[] properties1 = t.GetType().GetProperties().Where(p => p.MemberType == MemberTypes.Property && p.CanRead).ToArray();
DataRow dr = dt.NewRow();
for (int i = ; i < dt.Columns.Count; i++)
{
PropertyInfo propertyInfo = properties1.SingleOrDefault(p => p.Name == Convert.ToString(dt.Columns[i].ColumnName));
if (propertyInfo != null)
{
dr[dt.Columns[i].ColumnName] = propertyInfo.GetValue(t, null);
}
}
dt.Rows.Add(dr);
}
}
return dt;
} /// <summary>
/// 将对象填充为数据表
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="obj">对象</param>
/// <param name="tableName">表名</param>
/// <returns>数据表</returns>
public static DataTable Fill(Object obj, string tableName)
{
IList list = null;
if (typeof(IEnumerable).IsAssignableFrom(obj.GetType()))
{
list = (IList)obj;
}
else
{
list = new ArrayList();
if (obj != null)
{
list.Add(obj);
}
}
return Fill(list, tableName);
} /// <summary>
/// 将定IDictionary数据转换为DataSet数据
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="dictionary">键值对数据:key表名,value实体(或实体集合)</param>
/// <returns>DataSet数据集</returns>
public static DataSet Fill(IDictionary dictionary)
{
DataSet ds = new DataSet();
foreach (DictionaryEntry de in dictionary)
{
DataTable dt = Fill(de.Value, de.Key.ToString());
ds.Tables.Add(dt);
}
return ds;
} /// <summary>
/// 将数据表填充为泛型集合
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="dataTable">数据表</param>
/// <returns>泛型集合</returns>
public static IList<T> FillList<T>(DataTable dataTable)
{
IList<T> list = list = new List<T>();
if (dataTable != null && dataTable.Rows.Count > && dataTable.Columns.Count > )
{
List<string> columnNameList = new List<string>();
for (int i = ; i < dataTable.Columns.Count; i++)
{
columnNameList.Add(dataTable.Columns[i].ColumnName);
}
for (int i = ; i < dataTable.Rows.Count; i++)
{
DataRow dr = dataTable.Rows[i];
T t = Activator.CreateInstance<T>();
Type type = t.GetType();
PropertyInfo[] properties = type.GetProperties().Where(p => p.MemberType == MemberTypes.Property && p.CanWrite).ToArray();
foreach (PropertyInfo p in properties)
{
if (columnNameList.Contains(p.Name) && dr[p.Name] != DBNull.Value)
{
if (p.PropertyType.IsGenericType)
{
p.SetValue(t, Convert.ChangeType(dr[p.Name], p.PropertyType.GetGenericArguments()[]), null);
}
else
{
p.SetValue(t, Convert.ChangeType(dr[p.Name], p.PropertyType), null);
}
}
}
list.Add(t);
}
}
return list;
} /// <summary>
/// 将数据表填充为泛型集合
/// <para>创建作者：changjin</para>
/// <para>创建日期：2011/07/26</para>
/// </summary>
/// <param name="dataTable">数据表</param>
/// <returns>泛型集合</returns>
public static T Fill<T>(DataTable dataTable)
{
return FillList<T>(dataTable)[];
}
}
}