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;
}