private List<T> ToList<T>(DataTable dt)
{
List<object> lst = new List<object>();
//获取列名
List<string> columnNames = dt.Columns.Cast<DataColumn>()
.Select(c => c.ColumnName)
.ToList();
//实例化
var properties = typeof(T).GetProperties();
return dt.AsEnumerable().Select(row =>//遍历行
{
//定义赋值变量
var objT = Activator.CreateInstance<T>();
//遍历列
foreach (var pro in properties)
{
try
{
//判断是否存在此列
if (columnNames.Contains(pro.Name))
{
//赋值
pro.SetValue(objT, row[pro.Name] == DBNull.Value ? null : row[pro.Name], null);
}
}
catch (Exception err)
{
pro.SetValue(objT, null);
}
}
return objT;
}).ToList();
}