152 lines
5.6 KiB
C#
152 lines
5.6 KiB
C#
using System;
|
||
using System.Collections;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using System.Reflection;
|
||
using System.Text;
|
||
|
||
namespace DataCommon
|
||
{
|
||
public class DatatableToEntity
|
||
{
|
||
public class ConvertHelper<T> where T : class, new()
|
||
{
|
||
/// <summary>
|
||
/// 利用反射和泛型
|
||
/// </summary>
|
||
/// <param name="dt"></param>
|
||
/// <returns></returns>
|
||
public static List<T> ConvertToList(DataTable dt)
|
||
{
|
||
// 定义集合
|
||
List<T> ts = new List<T>();
|
||
try
|
||
{
|
||
// 获得此模型的类型
|
||
Type type = typeof(T);
|
||
//定义一个临时变量
|
||
string tempName = string.Empty;
|
||
///列的属性Status是否改变
|
||
bool typeChange = false;
|
||
DataTable resutTable = dt.Clone();
|
||
foreach (DataColumn clmn in resutTable.Columns)
|
||
{
|
||
PropertyInfo[] propertys = type.GetProperties();
|
||
//遍历该对象的所有属性
|
||
foreach (PropertyInfo pi in propertys)
|
||
{
|
||
if (pi.Name.ToUpper() == clmn.ColumnName.ToUpper())
|
||
{
|
||
if (pi.PropertyType != clmn.DataType)
|
||
{
|
||
clmn.DataType = pi.PropertyType;
|
||
typeChange = true;
|
||
continue;
|
||
|
||
}
|
||
}
|
||
}
|
||
}
|
||
if (typeChange)
|
||
{
|
||
foreach (DataRow dr in dt.Rows)
|
||
{
|
||
DataRow row = resutTable.NewRow();
|
||
try
|
||
{
|
||
foreach (DataColumn clm in dt.Columns)
|
||
{
|
||
row[clm.ColumnName] = dr[clm.ColumnName];
|
||
}
|
||
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
|
||
}
|
||
resutTable.Rows.Add(row);
|
||
resutTable.AcceptChanges();
|
||
}
|
||
|
||
}
|
||
else
|
||
{
|
||
resutTable = dt.Copy();
|
||
}
|
||
//遍历DataTable中所有的数据行
|
||
foreach (DataRow dr in resutTable.Rows)
|
||
{
|
||
T t = new T();
|
||
// 获得此模型的公共属性
|
||
PropertyInfo[] propertys = t.GetType().GetProperties();
|
||
//遍历该对象的所有属性
|
||
foreach (PropertyInfo pi in propertys)
|
||
{
|
||
tempName = pi.Name;//将属性名称赋值给临时变量
|
||
//检查DataTable是否包含此列（列名==对象的属性名）
|
||
if (dt.Columns.Contains(tempName))
|
||
{
|
||
Type v = pi.PropertyType;
|
||
|
||
// 判断此属性是否有Setter
|
||
if (!pi.CanWrite) continue;//该属性不可写，直接跳出
|
||
//取值
|
||
object value = dr[tempName];
|
||
if (v != dr[tempName].GetType())
|
||
{
|
||
|
||
}
|
||
//如果非空，则赋给对象的属性
|
||
if (value != DBNull.Value)
|
||
|
||
pi.SetValue(t, value, null);
|
||
}
|
||
}
|
||
//对象添加到泛型集合中
|
||
ts.Add(t);
|
||
}
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
|
||
}
|
||
|
||
return ts;
|
||
|
||
}
|
||
|
||
/// <summary>
|
||
/// 将集合类转换成DataTable
|
||
/// </summary>
|
||
/// <param name="list">集合</param>
|
||
/// <returns></returns>
|
||
public static DataTable ToDataTable(IList<T> list)
|
||
{
|
||
DataTable result = new DataTable();
|
||
if (list.Count > 0)
|
||
{
|
||
PropertyInfo[] propertys = list[0].GetType().GetProperties();
|
||
foreach (PropertyInfo pi in propertys)
|
||
{
|
||
result.Columns.Add(pi.Name, pi.PropertyType);
|
||
}
|
||
|
||
for (int i = 0; i < list.Count; i++)
|
||
{
|
||
ArrayList tempList = new ArrayList();
|
||
foreach (PropertyInfo pi in propertys)
|
||
{
|
||
object obj = pi.GetValue(list[i], null);
|
||
tempList.Add(obj);
|
||
}
|
||
object[] array = tempList.ToArray();
|
||
result.LoadDataRow(array, true);
|
||
}
|
||
}
|
||
return result;
|
||
}
|
||
}
|
||
}
|
||
}
|