木子冬
程序就是规范流程下的替代品,互联网就是对应需求下的一个产业链!

导航

 
 1   public class ModelConvertHelper<T> where T : new()
 2     {
 3 
 4         /// <summary>
 5         /// Convert To Model
 6         /// </summary>
 7         /// <param name="dt">Datatable for convert</param>
 8         /// <returns>Collection of model</returns>
 9         public static IList<T> ConvertToModel(DataTable dt)
10         {
11             // Collection definition
12             IList<T> ts = new List<T>();
13 
14             // Get model type
15             Type type = typeof(T);
16 
17             string tempName = "";
18 
19             foreach (DataRow dr in dt.Rows)
20             {
21                 T t = new T();
22 
23                 // Get property of model
24                 PropertyInfo[] propertys = t.GetType().GetProperties();
25 
26                 foreach (PropertyInfo pi in propertys)
27                 {
28                     tempName = pi.Name;
29 
30                     // check column is exsit
31                     if (dt.Columns.Contains(tempName))
32                     {
33                         // Whether can be set value
34                         if (!pi.CanWrite) continue;
35 
36                         object value = dr[tempName];
37                         if (value != DBNull.Value)
38                         {
39                             try
40                             {
41                                 pi.SetValue(t, value, null);
42                             }
43                             catch (Exception)
44                             {
45                                 pi.SetValue(t, value.ToString(), null);
46                             }
47                         }
48                     }
49                 }
50 
51                 ts.Add(t);
52             }
53 
54             return ts;
55         }
56 
57     }

 

posted on 2013-11-29 15:40  木子_冬  阅读(303)  评论(0编辑  收藏  举报