/// <summary>
/// DataTable转换模型
/// </summary>
/// <typeparam name="T">模型类型</typeparam>
/// <param name="obj">模型</param>
/// <param name="data">数据行</param>
/// <returns></returns>
public T DataSetBindModel<T>(T obj, DataTable data) where T : class, new()
{
T result = new T();
foreach (DataRow item in data.Rows)
{
result = assignmentClass(obj, item);
}
return result;
}
/// <summary>
/// DataTable转换List
/// </summary>
/// <typeparam name="T">模型类型</typeparam>
/// <param name="obj">模型</param>
/// <param name="data">数据行</param>
/// <returns></returns>
public List<T> DataSetBindList<T>(T obj, DataTable data) where T : class, new()
{
List<T> result = new List<T>();
foreach (DataRow item in data.Rows)
{
result.Add(assignmentClass(obj, item));
}
return result;
}
/// <summary>
/// DataRow 转换成模型
/// </summary>
/// <typeparam name="T">模型类型</typeparam>
/// <param name="obj">模型</param>
/// <param name="row">数据行</param>
/// <returns></returns>
private T assignmentClass<T>(T obj, DataRow row) where T : class, new()
{
if (obj == null)
{
obj = new T();
}
Type type = obj.GetType();
//得到类型的所有属性,也就是表对应的实体模型的所有属性
//嗮选一下只要公开的GetProperties(BindingFlags bindingAttr);
PropertyInfo[] properts = type.GetProperties();
if (properts.Any())
{
foreach (PropertyInfo item in properts)
{
if (row.Table.Columns.IndexOf(item.Name) != -1)
{
if (row[item.Name] != null && row[item.Name] != DBNull.Value)
{
item.SetValue(obj, row[item.Name]);
}
}
}
}
return obj;
}