C# 泛型实现Table与实体的相互转换

1public class ModelHandler<T> where T : new()
2    {
3        /// <summary>
4        /// Table转换成实体
5        /// </summary>
6        /// <param name="dt">表</param>
7        /// <returns></returns>
8        public static List<T> FillModel(DataTable dt)
9        {
10            if (dt == null || dt.Rows.Count == 0)
11            {
12                return null;
13            }
14            List<T> modelList = new List<T>();
15            foreach (DataRow dr in dt.Rows)
16            {
17                //T model = (T)Activator.CreateInstance(typeof(T));  
18                T model = new T();
19                for (int i = 0; i < dr.Table.Columns.Count; i++)
20                {
21                    PropertyInfo propertyInfo = model.GetType().GetProperty(dr.Table.Columns[i].ColumnName);
22                    if (propertyInfo != null && dr[i] != DBNull.Value)
23                        propertyInfo.SetValue(model, dr[i], null);
24                }
25
26                modelList.Add(model);
27            }
28            return modelList;
29        }
30
31        /// <summary>
32        /// 将一条Table转换成实体
33        /// </summary>
34        /// <param name="dt"></param>
35        /// <returns></returns>
36        public static T FillSigleMode(DataRow dr)
37        {
38            T model = new T();
39            if (dr != null)
40            {
41                for (int i = 0; i < dr.Table.Columns.Count; i++)
42                {
43                    PropertyInfo propertyInfo = model.GetType().GetProperty(dr.Table.Columns[i].ColumnName);
44                    if (propertyInfo != null && dr[i] != DBNull.Value)
45                        propertyInfo.SetValue(model, dr[i], null);
46                }
47            }
48            return model;
49        }
50
51
52        /// <summary>
53        /// 实体类转换成DataTable
54        /// </summary>
55        /// <param name="modelList">实体类列表</param>
56        /// <returns></returns>
57        public static DataTable FillDataTable(List<T> modelList)
58        {
59            if (modelList == null || modelList.Count == 0)
60            {
61                return null;
62            }
63            DataTable dt = CreateData(modelList[0]);
64
65            foreach (T model in modelList)
66            {
67                DataRow dataRow = dt.NewRow();
68                foreach (PropertyInfo propertyInfo in typeof(T).GetProperties())
69                {
70                    dataRow[propertyInfo.Name] = propertyInfo.GetValue(model, null);
71                }
72                dt.Rows.Add(dataRow);
73            }
74            return dt;
75        }
76
77        /// <summary>
78        /// 根据实体类得到表结构
79        /// </summary>
80        /// <param name="model">实体类</param>
81        /// <returns></returns>
82        private static DataTable CreateData(T model)
83        {
84            DataTable dataTable = new DataTable(typeof(T).Name);
85            foreach (PropertyInfo propertyInfo in typeof(T).GetProperties())
86            {
87                dataTable.Columns.Add(new DataColumn(propertyInfo.Name, propertyInfo.PropertyType));
88            }
89            return dataTable;
90        }
91    }