DataTable&DataSet反射实体

/// <summary>
        /// 将DataSet转成List集合
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="p_Data"></param>
        /// <returns></returns>
        public List<T> DataTableToList<T>(DataSet p_Data)
        {
            // 反射技术
            // 返回值初始化       
            List<T> result = new List<T>();
            for (int j = 0; j < p_Data.Tables[0].Rows.Count; j++)
            {
                T _t = (T)Activator.CreateInstance(typeof(T));
                PropertyInfo[] propertys = _t.GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    for (int i = 0; i < p_Data.Tables[0].Rows.Count; i++)
                    {
                        // 属性与字段名称一致的进行赋值       
                        if (pi.Name.Equals(p_Data.Tables[0].Columns[i].ColumnName))
                        {
                            // 数据库NULL值单独处理       
                            if (p_Data.Tables[0].Rows[j][i] != DBNull.Value)
                                pi.SetValue(_t, p_Data.Tables[0].Rows[j][i], null);
                            else
                                pi.SetValue(_t, null, null);
                            break;
                        }
                    }
                }
                result.Add(_t);
            }
            return result;
        }

        /// <summary>
        /// DataTable装换为泛型集合     
        /// </summary>     
        /// <typeparam name="T"></typeparam>    
        /// <param name="p_DataSet">DataSet</param>    
        /// <returns></returns>  
        public List<T> DataTableToList<T>(DataTable p_Data)
        {
            // 反射技术
            // 返回值初始化       
            List<T> result = new List<T>();
            for (int j = 0; j < p_Data.Rows.Count; j++)
            {
                T _t = (T)Activator.CreateInstance(typeof(T));
                PropertyInfo[] propertys = _t.GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    for (int i = 0; i < p_Data.Columns.Count; i++)
                    {
                        // 属性与字段名称一致的进行赋值       
                        if (pi.Name.Equals(p_Data.Columns[i].ColumnName))
                        {
                            // 数据库NULL值单独处理       
                            if (p_Data.Rows[j][i] != DBNull.Value)
                                pi.SetValue(_t, p_Data.Rows[j][i], null);
                            else
                                pi.SetValue(_t, null, null);
                            break;
                        }
                    }
                }
                result.Add(_t);
            }
            return result;
        }

posted on 2018-07-29 16:29  hyoukei  阅读(259)  评论(0)    收藏  举报

导航