DataSet和泛型之间相互转换

 

 取数据的时候，存储过程返回了多个结果集，后台用DataSet去接收这几个结果集，然后接收之后，需要将结果集转换为不同的实体，于是下面的代码便出现了。

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62

/// <summary> /// 将DataSet转换为泛型集合 /// </summary> /// <typeparam name="T">泛型</typeparam> /// <param name="dataSet">DataSet对象</param> /// <param name="tableIndex">表索引</param> /// <returns>返回泛型</returns> public static IList<T> DataSetToIList<T>(DataSet dataSet, int tableIndex) {     if (dataSet == null || dataSet.Tables.Count < 0)         return null;     if (tableIndex > dataSet.Tables.Count - 1)         return null;     if (tableIndex < 0)         tableIndex = 0;       var tableData = dataSet.Tables[tableIndex];     // 返回值初始化     IList<T> result = new List<T>();     for (var j = 0; j < tableData.Rows.Count; j++)     {         var _t = (T)Activator.CreateInstance(typeof(T));         var propertys = _t.GetType().GetProperties();         foreach (var pi in propertys)         {             for (var i = 0; i < tableData.Columns.Count; i++)             {                 // 属性与字段名称一致的进行赋值                 if (!pi.Name.Equals(tableData.Columns[i].ColumnName)) continue;                 // 数据库NULL值单独处理                 pi.SetValue(_t, tableData.Rows[j][i] != DBNull.Value ? tableData.Rows[j][i] : null, null);                 break;             }         }         result.Add(_t);     }     return result; }   /// <summary> /// DataSet装换为泛型集合 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="dataSet">DataSet</param> /// <param name="tableName">待转换数据表名称</param> /// <returns>返回指定的list</returns> public static IList<T> DataSetToIList<T>(DataSet dataSet, string tableName) {     var tableIndex = 0;     if (dataSet == null || dataSet.Tables.Count < 0)         return null;     if (string.IsNullOrEmpty(tableName))         return null;     for (var i = 0; i < dataSet.Tables.Count; i++)     {         // 获取Table名称在Tables集合中的索引值         if (!dataSet.Tables[i].TableName.Equals(tableName)) continue;         tableIndex = i;         break;     }     return DataSetToIList<T>(dataSet, tableIndex); }