/// <summary>
/// table转成其他类型object
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="table">datatable</param>
/// <returns>list</returns>
public static List <T> ConvertToList <T>(this DataTable table) where T : new()
{
if (table == null)
{
return(null);
}
List <T> list = new List <T>();
if (table.Rows.Count == 0)
{
return(list);
}
DataTableEntityBuilder <T> dte;
foreach (DataRow dtr in table.Rows)
{
dte = DataTableEntityBuilder <T> .CreateBuilder(dtr);
T t = dte.Build(dtr);
list.Add(t);
}
return(list);
}
public static DataTableEntityBuilder <T> CreateBuilder(DataRow dr)
{
DataTableEntityBuilder <T> dynamicBuilder = new DataTableEntityBuilder <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 < dr.ItemArray.Length; i++)
{
PropertyInfo pi = typeof(T).GetProperty(dr.Table.Columns[i].ColumnName, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance);
Label endIfLabel = generator.DefineLabel();
if (pi != null && pi.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, pi.PropertyType);
generator.Emit(OpCodes.Callvirt, pi.GetSetMethod());
generator.MarkLabel(endIfLabel);
}
}
generator.Emit(OpCodes.Ldloc, result);
generator.Emit(OpCodes.Ret);
dynamicBuilder.handler = (Load)method.CreateDelegate(typeof(Load));
return(dynamicBuilder);
}