1 #region DataTale转为实体列表 2 /// 3 /// DataTale转为实体列表 4 /// 5 /// 实体类类型 6 /// DataTable 7 /// List 8 public ListDataTableToModelList(DataTable table) 9 {10 Listlist = new List();11 T t = default(T);12 PropertyInfo[] propertypes = null;13 string tempName = string.Empty;14 foreach (DataRow row in table.Rows)15 {16 t = Activator.CreateInstance();17 propertypes = t.GetType().GetProperties();18 foreach (PropertyInfo pro in propertypes)19 {20 tempName = pro.Name;21 if (table.Columns.Contains(tempName))22 {23 object value = row[tempName];24 if (value.GetType() == typeof(System.DBNull))25 {26 value = null;27 }28 pro.SetValue(t, value, null);29 }30 }31 list.Add(t);32 }33 return list;34 }35 #endregion36 37 #region DataRow转为实体类 38 /// 39 /// DataRow转为实体类 40 /// 41 /// 实体类类型 42 /// DataRow 43 /// T 44 public T DataRowToModel(DataRow row)45 {46 47 T t = default(T);48 PropertyInfo[] propertypes = null;49 string tempName = string.Empty;50 t = Activator.CreateInstance();51 propertypes = t.GetType().GetProperties();52 foreach (PropertyInfo pro in propertypes)53 {54 tempName = pro.Name;55 if (row.Table.Columns.Contains(tempName))56 {57 object value = row[tempName];58 if (value.GetType() == typeof(System.DBNull))59 {60 value = null;61 }62 pro.SetValue(t, value, null);63 }64 }65 return t;66 }67 #endregion
学习记录