DataTable 转 Entity
生活随笔
收集整理的這篇文章主要介紹了
DataTable 转 Entity
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
代碼 ///?<summary>
///?DataTransfer?的摘要說明
///?</summary>
public?static?class?DataTransfer
{
????///?<summary>
????///?datatable?to?list
????///?</summary>
????///?<typeparam?name="T"></typeparam>
????///?<param?name="dt"></param>
????///?<returns></returns>
????public?static?List<T>?ToList<T>(DataTable?dt)
????{
????????List<T>?list?=?new?List<T>();
????????if?(dt?==?null)?return?list;
????????if?(dt.Rows.Count?<?1)?return?list;
????????DataTableEntityBuilder<T>?eblist?=?DataTableEntityBuilder<T>.CreateBuilder(dt.Rows[0]);
????????foreach?(DataRow?info?in?dt.Rows)
????????????list.Add(eblist.Build(info));
????????dt.Dispose();
????????dt?=?null;
????????return?list;
????}
????///?<summary>
????///?builder
????///?</summary>
????///?<typeparam?name="T"></typeparam>
????public?class?DataTableEntityBuilder<T>
????{
????????private?static?readonly?MethodInfo?getValueMethod?=?typeof(DataRow).GetMethod("get_Item",?new?Type[]?{?typeof(int)?});
????????private?static?readonly?MethodInfo?isDBNullMethod?=?typeof(DataRow).GetMethod("IsNull",?new?Type[]?{?typeof(int)?});
????????private?delegate?T?Load(DataRow?dataRecord);
????????private?Load?handler;
????????private?DataTableEntityBuilder()?{?}
????????public?T?Build(DataRow?dataRecord)
????????{
????????????return?handler(dataRecord);
????????}
????????public?static?DataTableEntityBuilder<T>?CreateBuilder(DataRow?dataRow)
????????{
????????????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?index?=?0;?index?<?dataRow.ItemArray.Length;?index++)
????????????{
????????????????PropertyInfo?propertyInfo?=?typeof(T).GetProperty(dataRow.Table.Columns[index].ColumnName);
????????????????Label?endIfLabel?=?generator.DefineLabel();
????????????????if?(propertyInfo?!=?null?&&?propertyInfo.GetSetMethod()?!=?null)
????????????????{
????????????????????generator.Emit(OpCodes.Ldarg_0);
????????????????????generator.Emit(OpCodes.Ldc_I4,?index);
????????????????????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,?index);
????????????????????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;
????????}
????}
///?DataTransfer?的摘要說明
///?</summary>
public?static?class?DataTransfer
{
????///?<summary>
????///?datatable?to?list
????///?</summary>
????///?<typeparam?name="T"></typeparam>
????///?<param?name="dt"></param>
????///?<returns></returns>
????public?static?List<T>?ToList<T>(DataTable?dt)
????{
????????List<T>?list?=?new?List<T>();
????????if?(dt?==?null)?return?list;
????????if?(dt.Rows.Count?<?1)?return?list;
????????DataTableEntityBuilder<T>?eblist?=?DataTableEntityBuilder<T>.CreateBuilder(dt.Rows[0]);
????????foreach?(DataRow?info?in?dt.Rows)
????????????list.Add(eblist.Build(info));
????????dt.Dispose();
????????dt?=?null;
????????return?list;
????}
????///?<summary>
????///?builder
????///?</summary>
????///?<typeparam?name="T"></typeparam>
????public?class?DataTableEntityBuilder<T>
????{
????????private?static?readonly?MethodInfo?getValueMethod?=?typeof(DataRow).GetMethod("get_Item",?new?Type[]?{?typeof(int)?});
????????private?static?readonly?MethodInfo?isDBNullMethod?=?typeof(DataRow).GetMethod("IsNull",?new?Type[]?{?typeof(int)?});
????????private?delegate?T?Load(DataRow?dataRecord);
????????private?Load?handler;
????????private?DataTableEntityBuilder()?{?}
????????public?T?Build(DataRow?dataRecord)
????????{
????????????return?handler(dataRecord);
????????}
????????public?static?DataTableEntityBuilder<T>?CreateBuilder(DataRow?dataRow)
????????{
????????????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?index?=?0;?index?<?dataRow.ItemArray.Length;?index++)
????????????{
????????????????PropertyInfo?propertyInfo?=?typeof(T).GetProperty(dataRow.Table.Columns[index].ColumnName);
????????????????Label?endIfLabel?=?generator.DefineLabel();
????????????????if?(propertyInfo?!=?null?&&?propertyInfo.GetSetMethod()?!=?null)
????????????????{
????????????????????generator.Emit(OpCodes.Ldarg_0);
????????????????????generator.Emit(OpCodes.Ldc_I4,?index);
????????????????????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,?index);
????????????????????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;
????????}
????}
?
轉載于:https://www.cnblogs.com/OSoft/archive/2010/12/03/1895485.html
總結
以上是生活随笔為你收集整理的DataTable 转 Entity的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: C核心技术手册(五)
- 下一篇: 总结SQL Server窗口函数的简单使