.NET 数据表转换为T类列表

1.方法

public static (List<T> Data, string Error) DataTableToClassList<T>(DataTable dt)
{
List<T> lsData = new List<T>();//无数据的情况下返回NULL-标准化
string strError = "";
if (dt != null && dt.Rows.Count > 0)
{
#region
try
{
lsData = new List<T>();
foreach (DataRow dr in dt.Rows)
{
#region
T obj = Activator.CreateInstance<T>(); //活化剂类实例化泛型对象
//赋值
var cProperties = typeof(T).GetProperties();
foreach (var proper in cProperties)
{
if (
proper.PropertyType == typeof(string)
|| proper.PropertyType == typeof(long?)
|| proper.PropertyType == typeof(DateTime?)
|| proper.PropertyType == typeof(decimal?)
)
{
if (dt.Columns.Contains(proper.Name))
{
#region 存在列名
//仅处理4种类型
if (proper.PropertyType == typeof(string))
{
proper.SetValue(obj, clsBase.ObjectToString(dr[proper.Name]));
}
if (proper.PropertyType == typeof(long?))
{
proper.SetValue(obj, clsBase.StrToLong(clsBase.ObjectToString(dr[proper.Name])));
}
if (proper.PropertyType == typeof(DateTime?))
{
proper.SetValue(obj, clsBase.StrToDateTime(clsBase.ObjectToString(dr[proper.Name])));
}
if (proper.PropertyType == typeof(decimal?))
{
proper.SetValue(obj, clsBase.StrToDecimal(clsBase.ObjectToString(dr[proper.Name])));
}
//其它类型暂不处理
#endregion
}
else
{
#region 不存在列名
strError += "列名[" + proper.Name + "]不存在;";

#endregion
}
}
else
{
//非处理类型不处理
}

}

lsData.Add(obj);
#endregion
}
}
catch (Exception ex)
{
strError += ex.Message;
}

#endregion
}
if (!string.IsNullOrWhiteSpace(strError))
{
strError = "FullClassName[" + typeof(T).FullName + "];" + strError;
}
return (lsData, strError);
}

2.var vResult= DataTableToClassList<Class>(dt);