DataTable转List

    
        public static List<T> DatatTable_ToList<T>(DataTable dt) where T : class, new()
        {
            int a = 0;
            int b = 0;
            try
            {
                List<T> ts = new List<T>();

                if (dt != null && dt.Rows.Count > 0)
                {
                    // 获得此模型的类型  
                    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);  
                                    // pi.SetValue(t, Convert.ChangeType(value, pi.PropertyType, CultureInfo.CurrentCulture), null);
                                    pi.SetValue(t, ChanageType(value, pi.PropertyType), null);
                                }
                            }
                        }
                        ts.Add(t);
                    }
                }

                return ts;
            }
            catch (Exception ex)
            {
                string aa = a.ToString();
                string bb = b.ToString();
                throw;
            }
        }
 

 

posted @ 2021-09-11 11:01  旧夏潜入梦  阅读(102)  评论(0编辑  收藏  举报