通过泛型+反射实现
第一种
这种方式有个致命的缺点:对象属性的大小写一定要与DataTable中列名一致,不然无法获取到数据
/// <summary>
/// 将Datatable数据转换成实体对象集合
/// </summary>
/// <typeparam name="T">对象</typeparam>
/// <param name="dt">Datatable数据</param>
/// <returns></returns>
public List<T> ConvertDataTableToList<T>(DataTable dt) where T : new()
{
List<T> list = new List<T>();
foreach (DataRow row in dt.Rows)
{
T obj = new T();
foreach (DataColumn column in dt.Columns)
{
string columnName = column.ColumnName;
PropertyInfo property = typeof(T).GetProperty(columnName, BindingFlags.Public | BindingFlags.Instance);
if (property != null && row[columnName] != DBNull.Value)
{
if (property.PropertyType == typeof(DateTime?))
{
DateTime? value = null;
string dateString = row[columnName].ToString();
DateTime parsedDate;
if (DateTime.TryParse(dateString, out parsedDate))
{
value = parsedDate;
}
property.SetValue(obj, value);
}
else if (property.PropertyType == typeof(int?))
{
int? value = null;
string dateString = row[columnName].ToString();
int parsedDate;
if (int.TryParse(dateString, out parsedDate))
{
value = parsedDate;
}
property.SetValue(obj, value);
}
else if (property.PropertyType == typeof(bool?))
{
bool? value = null;
string dateString = row[columnName].ToString();
bool parsedDate;
if (bool.TryParse(dateString, out parsedDate))
{
value = parsedDate;
}
property.SetValue(obj, value);
}
else
{
object value = Convert.ChangeType(row[columnName], property.PropertyType);
property.SetValue(obj, value);
}
}
}
list.Add(obj);
}
return list;
}
第二种
改良后,这个版本可以直接用,不用担心对象属性大小写与DataTable列名不一致问题
public static List<T> ConvertDataTableToList<T>(DataTable dataTable) where T : new()
{
List<T> result = new List<T>();
if (dataTable == null || dataTable.Rows.Count == 0)
{
return result;
}
foreach (DataRow row in dataTable.Rows)
{
T item = CreateItemFromRow<T>(row);
result.Add(item);
}
return result;
}
private static T CreateItemFromRow<T>(DataRow row) where T : new()
{
T item = new T();
PropertyInfo[] properties = typeof(T).GetProperties();
foreach (PropertyInfo property in properties)
{
string columnName = property.Name;
if (!row.Table.Columns.Contains(columnName))
{
foreach (DataColumn column in row.Table.Columns)
{
if (string.Equals(column.ColumnName, columnName, StringComparison.OrdinalIgnoreCase))
{
columnName = column.ColumnName;
break;
}
}
}
if (row.Table.Columns.Contains(columnName))
{
if (property.PropertyType == typeof(DateTime?))
{
DateTime? value = null;
string dateString = row[columnName].ToString();
DateTime parsedDate;
if (DateTime.TryParse(dateString, out parsedDate))
{
value = parsedDate;
}
property.SetValue(item, value);
}
else if (property.PropertyType == typeof(int?))
{
int? value = null;
string dateString = row[columnName].ToString();
int parsedDate;
if (int.TryParse(dateString, out parsedDate))
{
value = parsedDate;
}
property.SetValue(item, value);
}
else if (property.PropertyType == typeof(bool?))
{
bool? value = null;
string dateString = row[columnName].ToString();
bool parsedDate;
if (bool.TryParse(dateString, out parsedDate))
{
value = parsedDate;
}
property.SetValue(item, value);
}
else
{
object value = Convert.ChangeType(row[columnName], property.PropertyType);
property.SetValue(item, value);
}
}
}
return item;
}