/// <summary>
/// datatable转List
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dt"></param>
/// <returns></returns>
public static List <T> ToList <T>(this DataTable dt) where T : class, new()
{
var list = new List <T>();
if (dt == null || dt.Rows.Count == 0)
{
return(list);
}
list.AddRange(dt.Rows.Cast <DataRow>().Select(info => DataTableBuilder <T> .CreateBuilder(dt.Rows[0]).Build(info)));
return(list);
}
/// <summary>
/// datatable转List
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dt"></param>
/// <returns></returns>
public static List <T> ToList <T>(this DataTable dt) where T : class, new()
{
List <T> list = new List <T>();
using (dt)
{
if (dt == null || dt.Rows.Count == 0)
{
return(list);
}
DataTableBuilder <T> eblist = DataTableBuilder <T> .CreateBuilder(dt.Rows[0]);
foreach (DataRow info in dt.Rows)
{
list.Add(eblist.Build(info));
}
return(list);
}
}
public static DataTableBuilder <T> CreateBuilder(DataRow dataRecord)
{
DataTableBuilder <T> dynamicBuilder = new DataTableBuilder <T>();
DynamicMethod method = new DynamicMethod("DynamicCreateEntity", typeof(T), new Type[]
{
typeof(DataRow)
}, typeof(T), true);
ILGenerator generator = method.GetILGenerator();
LocalBuilder result = generator.DeclareLocal(typeof(T));
generator.Emit(OpCodes.Newobj, typeof(T).GetConstructor(Type.EmptyTypes));
generator.Emit(OpCodes.Stloc, result);
for (int i = 0; i < dataRecord.ItemArray.Length; i++)
{
PropertyInfo propertyInfo = typeof(T).GetProperty(dataRecord.Table.Columns[i].ColumnName);
Label endIfLabel = generator.DefineLabel();
if (propertyInfo != null && propertyInfo.GetSetMethod() != null)
{
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4, i);
generator.Emit(OpCodes.Callvirt, IsDbNullMethod);
generator.Emit(OpCodes.Brtrue, endIfLabel);
generator.Emit(OpCodes.Ldloc, result);
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4, i);
generator.Emit(OpCodes.Callvirt, GetValueMethod);
generator.Emit(OpCodes.Unbox_Any, propertyInfo.PropertyType);
generator.Emit(OpCodes.Callvirt, propertyInfo.GetSetMethod());
generator.MarkLabel(endIfLabel);
}
}
generator.Emit(OpCodes.Ldloc, result);
generator.Emit(OpCodes.Ret);
dynamicBuilder._handler = (Load)method.CreateDelegate(typeof(Load));
return(dynamicBuilder);
}