list和datatable相互转化

?

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 63 64 65 66 67 68 69 70 71

/// <summary>         /// list转datatable         /// </summary>         /// <typeparam name="T"></typeparam>         /// <param name="collection"></param>         /// <returns></returns>         public static DataTable ListToDataTable<T>(IEnumerable<T> collection)         {             var props = typeof(T).GetProperties();             var dt = new DataTable();             dt.Columns.AddRange(props.Select(p => new DataColumn(p.Name, p.PropertyType)).ToArray());             if (collection.Count() > 0)             {                 for (int i = 0; i < collection.Count(); i++)                 {                     ArrayList tempList = new ArrayList();                     foreach (PropertyInfo pi in props)                     {                         object obj = pi.GetValue(collection.ElementAt(i), null);                         tempList.Add(obj);                     }                     object[] array = tempList.ToArray();                     dt.LoadDataRow(array, true);                 }             }             return dt;         }                      /// <summary>         /// datatable转list         /// </summary>         /// <param name="dt"></param>         /// <returns></returns>         public static List<T> DataTableToList<T>(DataTable dt) where T : new()         {             List<T> ts = new List<T>();// 定义集合             Type type = typeof(T); // 获得此模型的类型             string tempName = "";             foreach (DataRow dr in dt.Rows)             {                 T t = new T();                 PropertyInfo[] propertys = t.GetType().GetProperties();// 获得此模型的公共属性                 foreach (PropertyInfo pi in propertys)                 {                     tempName = pi.Name;                     if (dt.Columns.Contains(tempName))                     {                         if (!pi.CanWrite) continue;                         object value = dr[tempName];                         if (value != DBNull.Value)                         {                             if(pi.PropertyType == typeof(decimal))                                 pi.SetValue(t, decimal.Parse(value.ToString()), null);                             else if (pi.PropertyType == typeof(double))                                 pi.SetValue(t, double.Parse(value.ToString()), null);                             else if (pi.PropertyType == typeof(float))                                 pi.SetValue(t, float.Parse(value.ToString()), null);                             else if (pi.PropertyType == typeof(int))                                 pi.SetValue(t, int.Parse(value.ToString()), null);                             else if (pi.PropertyType == typeof(DateTime))                                 pi.SetValue(t, DateTime.Parse(value.ToString()), null);                             else                                 pi.SetValue(t, value, null);                         }                     }                 }                 ts.Add(t);             }               return ts;         }