将DataTable转为实体对象

     首选引用 命令空间. using System.Reflection;

       /// <summary>
        /// 填充实体
        /// </summary>
        /// <param name="Table">传递的Table</param>
        /// <returns></returns>
        public List<Member> FillModel(System.Data.DataTable Table)
        {
            if (Table == null || Table.Rows.Count == 0)
            {
                return null;
            }
            List<Member> modelList = new List<Member>();
            foreach (System.Data.DataRow dr in Table.Rows)
            {
                Member model = new Member();
                foreach (PropertyInfo propertyInfo in typeof(Member).GetProperties())
                {
                    if (!DBNull.Value.Equals(dr[propertyInfo.Name]))
                    {
                        model.GetType().GetProperty(propertyInfo.Name).SetValue(model, dr[propertyInfo.Name], null);
                    }
                }
                modelList.Add(model);
            }
            return modelList;
        }