#region 实体转换

        /// <summary>

        /// add extension method for datable

        /// </summary>

        /// <param name="dt"></param>

        /// <returns></returns>

        public static IList<TEntity> ToList<TEntity>(this DataTable dt) where TEntity : class ,new() {

            return ConvertToModel<TEntity>(dt);

        }

        public static IList<TEntity> ConvertToModel<TEntity>(DataTable dt) where TEntity : class ,new() {

            // 定义集合

            IList<TEntity> ts = new List<TEntity>();

            // 获得此模型的类型

            Type type = typeof(T);

            string tempName = "";

            foreach (DataRow dr in dt.Rows) {

                TEntity t = new TEntity();

                // 获得此模型的公共属性

                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;

        }

        #endregion