DataTable转换为List<Model>的通用类

using System;  
using System.Collections.Generic;  
using System.Text;  
using System.Data;  
using System.Reflection;  
  
namespace NCL.Data  
{  
    /// <summary>  
    /// 实体转换辅助类  
    /// </summary>  
    public class ModelConvertHelper<T> where  T : new()  
    {  
        public static IList<T> ConvertToModel(DataTable dt)  
        {  
            // 定义集合  
            IList<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;  
  
                    // 检查DataTable是否包含此列  
                    if (dt.Columns.Contains(tempName))  
                    {  
                        // 判断此属性是否有Setter  
                        if (!pi.CanWrite) continue;  
  
                        object value = dr[tempName];  
                        if (value != DBNull.Value)  
                            pi.SetValue(t, value, null);  
                    }  
                }  
  
                ts.Add(t);  
            }  
  
            return ts;  
  
        }  
    }  
}  

  public static List<T> ConvertToModel(DataTable dt)
            {
                if (dt == null || dt.Rows.Count == 0)
                {
                    return null;
                }
                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];
                            setValue(ref t, pi, value);
                        }
                    }
                    ts.Add(t);
                }
                return ts;
            }

使用方式：

// 获得查询结果
DataTable dt = DbHelper.ExecuteDataTable(...);
// 把DataTable转换为IList<UserInfo>
IList<UserInfo> users = ModelConvertHelper<UserInfo>.ConvertToModel(dt);