DataTableとソリッドオブジェクトの相互回転

1688 ワード

/// 
///  DataTable 
/// 
/// 
/// 
/// 
public static List GetEntityFromDataTable(DataTable sourceDT) where T : class
{
    List list = new List();
    //  
    Type type = typeof(T);
    foreach (DataRow dRow in sourceDT.Rows)
    {
        //  
        object obj = System.Activator.CreateInstance(type);
        foreach (var prop in type.GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance))
        {
            if (prop.GetSetMethod() != null)//  setter
            {
                //  
                prop.SetValue(obj, dRow[prop.Name], null);
            }
        }

        list.Add(obj as T);
    }
    return list;
}


/// 
///  DataTable
/// 
/// 
/// 
/// 
private DataTable GetDataTableFromEntity(List list)
{
    DataTable dt = new DataTable();
    System.Reflection.PropertyInfo[] properties = typeof(ReturnMessages).GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);
    foreach (System.Reflection.PropertyInfo pro in properties)
    {
        //  
        dt.Columns.Add(pro.Name, pro.PropertyType);
    }

    foreach (T item in list)
    {
        DataRow dr = dt.NewRow();
        foreach (System.Reflection.PropertyInfo pro in properties)
        {
            dr[pro.Name] = item.GetType().GetProperty(pro.Name).GetValue(item, null);
        }

        dt.Rows.Add(dr);
    }
    dt.AcceptChanges();
    return dt;
}