将 SqlDataReader 转为Model, 如果 SqlDataReader.read() 有值 ，返回对象，否则返回Null

View Code

 1  /// <summary>
 2 /// 将 SqlDataReader 转为Model, 如果 SqlDataReader.read() 有值 ，返回对象，否则返回Null
 3 /// </summary>
 4 /// <param name="dr">SqlDataReader</param>
 5 /// <returns>泛型实体</returns>
 6         public static T ToModel(SqlDataReader dr)
 7         {
 8             // 获得此模型的类型
 9             Type type = typeof(T);
10             string tempName = "";
11             T t = new T();
12             // 获得此模型的公共属性
13             PropertyInfo[] propertys = t.GetType().GetProperties();
14             int clen = dr.FieldCount;
15             Dictionary<string, object> nv = new Dictionary<string, object>();
16             for (int i = 0; i < clen; i++)
17             {
18                 string fieldname = dr.GetName(i).ToLower();
19                 nv[fieldname] = dr[i];
20             }
21             foreach (PropertyInfo pi in propertys)
22             {
23                 tempName = pi.Name.ToLower();
24                 if (nv.ContainsKey(tempName))
25                 {
26                     if (!pi.CanWrite)
27                         continue;
28                     object value = nv[tempName];
29                     if (value != DBNull.Value)
30                     {
31                         if (pi.PropertyType.IsEnum)
32                         {
33                             pi.SetValue(t, Enum.Parse(pi.PropertyType, value.ToString().Trim(), true), null);
34                         }
35                         else if (pi.PropertyType.IsGenericType && pi.PropertyType.GetGenericTypeDefinition().Equals(typeof(Nullable<>)))
36                         {
37                             pi.SetValue(t, Convert.ChangeType(value, System.Nullable.GetUnderlyingType(pi.PropertyType)), null);
38                         }
39                         else
40                         {
41                             pi.SetValue(t, Convert.ChangeType(value, pi.PropertyType), null);
42                         }
43                     }
44                 }
45             }
46             return t;
47         }

 

转载于:https://www.cnblogs.com/xunqi2012/archive/2012/01/29/2331137.html