////// DataSet转换为泛型集合 /// ///泛型 /// DataSet /// 待转换数据表索引 ///泛型集合 private static IListDataSetToIList (DataSet p_DataSet, int p_TableIndex) { if (p_DataSet == null || p_DataSet.Tables.Count < 0) return null; if (p_TableIndex > p_DataSet.Tables.Count - 1) return null; if (p_TableIndex < 0) p_TableIndex = 0; if (p_DataSet.Tables[p_TableIndex].Rows.Count <= 0) return null; DataTable p_Data = p_DataSet.Tables[p_TableIndex]; // 返回值初始化 IList result = new List (); for (int j = 0; j < p_Data.Rows.Count; j++) { T _t = (T)Activator.CreateInstance(typeof(T)); PropertyInfo[] propertys = _t.GetType().GetProperties(); foreach (PropertyInfo pi in propertys) { for (int i = 0; i < p_Data.Columns.Count; i++) { // 属性与字段名称一致的进行赋值 if (pi.Name.ToLower().Equals(p_Data.Columns[i].ColumnName.ToLower())) { // 数据库NULL值单独处理 if (p_Data.Rows[j][i] != DBNull.Value) { //if (p_Data.Rows[j][i] is byte[]) //{ // byte[] bytes = (byte[])p_Data.Rows[j][i]; // MemoryStream ms = new MemoryStream(bytes); // Image img = Image.FromStream(ms); // pi.SetValue(_t, img, null); // continue; //} pi.SetValue(_t, p_Data.Rows[j][i], null); } else pi.SetValue(_t, null, null); break; } } } result.Add(_t); } return result; }