C# 将DataTable数据源转换成实体类

1 using System; 2 using System.Collections.Generic; 3 using System.Data; 4 using System.Reflection; 5 6 /// <summary> 7 /// 将DataTable数据源转换成实体类 8 /// </summary> 9 /// <typeparam name="T">实体</typeparam>10 public static class ToModel<T> where T : new()11 {12/// <summary>13/// 将DataTable数据源转换成实体类14/// </summary>15public static List<T> ConvertToModel(DataTable dt)16{17 List<T> ts = new List<T>();// 定义集合18 foreach (DataRow dr in dt.Rows)19 {20 T t = new T();21 PropertyInfo[] propertys = t.GetType().GetProperties();// 获得此模型的公共属性22 foreach (PropertyInfo pi in propertys)23 {24 if (dt.Columns.Contains(pi.Name))25 {26 if (!pi.CanWrite) continue;27 var value = dr[pi.Name];28 if (value != DBNull.Value)29 {30switch (pi.PropertyType.FullName)31{32 case "System.Decimal":33 pi.SetValue(t, decimal.Parse(value.ToString()), null);34 break;35 case "System.String":36 pi.SetValue(t, value.ToString(), null);37 break;38 case "System.Int32":39 pi.SetValue(t, int.Parse(value.ToString()), null);40 break;41 default:42 pi.SetValue(t, value, null);43 break;44}45 }46 }47 }48 ts.Add(t);49 }50 return ts;51}52 }