C#.net开发 List与DataTable相互转换

        /// 

        /// DataTable转化为List集合
        /// 
        /// 实体对象
        /// datatable表
        /// 是否存入数据库datetime字段，date字段没事，取出不用判断
        /// 返回list集合
        public static List TableToList(DataTable dt, bool isStoreDB = true)
        {
            List list = new List();
            Type type = typeof(T);
            //List listColums = new List();
             PropertyInfo[] pArray = type.GetProperties(); //集合属性数组
             foreach (DataRow row in dt.Rows) 
             {
               T entity = Activator.CreateInstance(); //新建对象实例 
               foreach (PropertyInfo p in pArray)
                { 
                  if (!dt.Columns.Contains(p.Name) || row[p.Name] == null || row[p.Name] == DBNull.Value)
                  { 
                     continue;  //DataTable列中不存在集合属性或者字段内容为空则，跳出循环，进行下个循环   
                  }                
                  if (isStoreDB && p.PropertyType == typeof(DateTime) && Convert.ToDateTime(row[p.Name]) "1753-01-01"))
                     { 
                     continue;
                  } 
                  try { 
                   var obj = Convert.ChangeType(row[p.Name], p.PropertyType);//类型强转，将table字段类型转为集合字段类型  
                   p.SetValue(entity, obj, null);
                   }
                   catch (Exception)
                   {                        
                   // throw;
                   }                    
                   //if (row[p.Name].GetType() == p.PropertyType)
                   //{
                   //    p.SetValue(entity, row[p.Name], null); //如果不考虑类型异常，foreach下面只要这一句就行
                   //}                    
                   //object obj = null;
                   //if (ConvertType(row[p.Name], p.PropertyType,isStoreDB, out obj))
                   //{                                        
                   //    p.SetValue(entity, obj, null);
                   //}                
                }
                list.Add(entity);
            }   
        return list;
        }

        /// 

        /// List集合转DataTable
        /// 
        /// 实体类型
        /// 传入集合
        /// 是否存入数据库DateTime字段，date时间范围没事，取出展示不用设置TRUE
        /// 返回datatable结果
        public static DataTable ListToTable(List list, bool isStoreDB = true)
        {
            Type tp = typeof(T);
            PropertyInfo[] proInfos = tp.GetProperties();
            DataTable dt = new DataTable();
            foreach (var item in proInfos)
            {
                dt.Columns.Add(item.Name, item.PropertyType); //添加列明及对应类型
            }
            foreach (var item in list)
            {
                DataRow dr = dt.NewRow();
                foreach (var proInfo in proInfos)
                {
                    object obj = proInfo.GetValue(item);
                    if (obj == null)
                    {
                        continue;
                    }
                    //if (obj != null)
                    // {
                    if (isStoreDB && proInfo.PropertyType == typeof(DateTime) && Convert.ToDateTime(obj) "1753-01-01"))
                    {
                        continue;
                    }
                    // dr[proInfo.Name] = proInfo.GetValue(item);
                    dr[proInfo.Name] = obj;
                    // }
                }
                dt.Rows.Add(dr);
            }
            return dt;
        }

        /// 

        /// table指定行转对象
        /// 
        /// 实体
        /// 传入的表格
        /// table行索引，默认为第一行
        /// 返回实体对象
        public static T TableToEntity(DataTable dt, int rowindex = 0, bool isStoreDB = true)
        {
            Type type = typeof(T);
            T entity = Activator.CreateInstance(); //创建对象实例
            if (dt == null)
            {
                return entity;
            }
            //if (dt != null)
            //{
            DataRow row = dt.Rows[rowindex]; //要查询的行索引
            PropertyInfo[] pArray = type.GetProperties();
            foreach (PropertyInfo p in pArray)
            {
                if (!dt.Columns.Contains(p.Name) || row[p.Name] == null || row[p.Name] == DBNull.Value)
                {
                    continue;
                }
 
                if (isStoreDB && p.PropertyType == typeof(DateTime) && Convert.ToDateTime(row[p.Name]) "1753-01-02"))
                {
                    continue;
                }
                try
                {
                    var obj = Convert.ChangeType(row[p.Name], p.PropertyType);//类型强转，将table字段类型转为对象字段类型
                    p.SetValue(entity, obj, null);
                }
                catch (Exception)
                {
                    // throw;
                }
                // p.SetValue(entity, row[p.Name], null);                   
            }
            //  }
            return entity;
        }