C# DataTable与Model互转的示例代码

2023-07-08 19:23:06 76

///

///实体转换辅助类 ///

publicclassModelConvertHelperwhereT:new() { ///

///List泛型转换DataTable. ///

publicDataTableListToDataTable(Listitems) { vartb=newDataTable(typeof(T).Name); PropertyInfo[]props=typeof(T).GetProperties(BindingFlags.Public|BindingFlags.Instance); foreach(PropertyInfopropinprops) { Typet=GetCoreType(prop.PropertyType); tb.Columns.Add(prop.Name,t); } foreach(Titeminitems) { varvalues=newobject[props.Length]; for(inti=0;i ///model转换DataTable /// /// /// /// publicDataTableModelToDataTable(Titems) { vartb=newDataTable(typeof(T).Name); PropertyInfo[]props=typeof(T).GetProperties(BindingFlags.Public|BindingFlags.Instance); foreach(PropertyInfopropinprops) { Typet=GetCoreType(prop.PropertyType); tb.Columns.Add(prop.Name,t); } varvalues=newobject[props.Length]; for(inti=0;i ///Determineofspecifiedtypeisnullable /// publicstaticboolIsNullable(Typet) { return!t.IsValueType||(t.IsGenericType&&t.GetGenericTypeDefinition()==typeof(Nullable<>)); } ///

///ReturnunderlyingtypeiftypeisNullableotherwisereturnthetype ///

publicstaticTypeGetCoreType(Typet) { if(t!=null&&IsNullable(t)) { if(!t.IsValueType) { returnt; } else { returnNullable.GetUnderlyingType(t); } } else { returnt; } } ///

///DataTable转换泛型List ///

/// /// publicstaticListDataTableToList(DataTabledt) { //定义集合 Listts=newList(); //获得此模型的类型 Typetype=typeof(T); stringtempName=""; foreach(DataRowdrindt.Rows) { Tt=newT(); //获得此模型的公共属性 PropertyInfo[]propertys=t.GetType().GetProperties(); foreach(PropertyInfopiinpropertys) { tempName=pi.Name;//检查DataTable是否包含此列 if(dt.Columns.Contains(tempName)) { //判断此属性是否有Setter if(!pi.CanWrite)continue; objectvalue=dr[tempName]; if(value!=DBNull.Value) pi.SetValue(t,value,null); } } ts.Add(t); } returnts; } publicstaticTDataTableToModel(DataTabledt) { //定义实体 Tt=newT(); //获得此模型的类型 Typetype=typeof(T); stringtempName=""; foreach(DataRowdrindt.Rows) { //获得此模型的公共属性 PropertyInfo[]propertys=t.GetType().GetProperties(); foreach(PropertyInfopiinpropertys) { tempName=pi.Name;//检查DataTable是否包含此列 if(dt.Columns.Contains(tempName)) { //判断此属性是否有Setter if(!pi.CanWrite)continue; objectvalue=dr[tempName]; if(value!=DBNull.Value) pi.SetValue(t,value,null); } } break; } returnt; } }

C# DataTable与Model互转的示例代码

热门推荐

随机推荐