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 }
View Code
