首页 > > 程序设计 > delphi >

DataSet转化为实体集合类

2018-06-17 20:14:02来源：未知阅读 ()

 1 /// <summary>
 2         /// DataSet转换为实体类
 3         /// </summary>
 4         /// <typeparam name="T">实体类</typeparam>
 5         /// <param name="p_DataSet">DataSet</param>
 6         /// <param name="p_TableIndex">待转换数据表索引</param>
 7         /// <returns>实体类</returns>
 8         public static T DataSetToEntity<T>(DataSet p_DataSet, int p_TableIndex)
 9         {
10             if (p_DataSet == null || p_DataSet.Tables.Count < 0)
11                 return default(T);
12             if (p_TableIndex > p_DataSet.Tables.Count - 1)
13                 return default(T);
14             if (p_TableIndex < 0)
15                 p_TableIndex = 0;
16             if (p_DataSet.Tables[p_TableIndex].Rows.Count <= 0)
17                 return default(T);
18 
19             DataRow p_Data = p_DataSet.Tables[p_TableIndex].Rows[0];
20             // 返回值初始化
21             T _t = (T)Activator.CreateInstance(typeof(T));
22             PropertyInfo[] propertys = _t.GetType().GetProperties();
23             foreach (PropertyInfo pi in propertys)
24             {
25                 if (p_DataSet.Tables[p_TableIndex].Columns.IndexOf(pi.Name.ToUpper()) != -1 && p_Data[pi.Name.ToUpper()] != DBNull.Value)
26                 {
27                     pi.SetValue(_t, p_Data[pi.Name.ToUpper()], null);
28                 }
29                 else
30                 {
31                     pi.SetValue(_t, null, null);
32                 }
33             }
34             return _t;
35         }
36 
37         /// <summary>
38         /// DataSet转换为实体列表
39         /// </summary>
40         /// <typeparam name="T">实体类</typeparam>
41         /// <param name="p_DataSet">DataSet</param>
42         /// <param name="p_TableIndex">待转换数据表索引</param>
43         /// <returns>实体类列表</returns>
44         public static IList<T> DataSetToEntityList<T>(DataSet p_DataSet, int p_TableIndex)
45         {
46             if (p_DataSet == null || p_DataSet.Tables.Count < 0)
47                 return default(IList<T>);
48             if (p_TableIndex > p_DataSet.Tables.Count - 1)
49                 return default(IList<T>);
50             if (p_TableIndex < 0)
51                 p_TableIndex = 0;
52             if (p_DataSet.Tables[p_TableIndex].Rows.Count <= 0)
53                 return default(IList<T>);
54 
55             DataTable p_Data = p_DataSet.Tables[p_TableIndex];
56             // 返回值初始化
57             IList<T> result = new List<T>();
58             for (int j = 0; j < p_Data.Rows.Count; j++)
59             {
60                 T _t = (T)Activator.CreateInstance(typeof(T));
61                 PropertyInfo[] propertys = _t.GetType().GetProperties();
62                 foreach (PropertyInfo pi in propertys)
63                 {
64                     if (p_Data.Columns.IndexOf(pi.Name.ToUpper()) != -1 && p_Data.Rows[j][pi.Name.ToUpper()] != DBNull.Value)
65                     {
66                         pi.SetValue(_t, p_Data.Rows[j][pi.Name.ToUpper()], null);
67                     }
68                     else
69                     {
70                         pi.SetValue(_t, null, null);
71                     }
72                 }
73                 result.Add(_t);
74             }
75             return result;
76         }