DataTable&DataSet反射实体
/// <summary>
/// 将DataSet转成List集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="p_Data"></param>
/// <returns></returns>
public List<T> DataTableToList<T>(DataSet p_Data)
{
// 反射技术
// 返回值初始化
List<T> result = new List<T>();
for (int j = 0; j < p_Data.Tables[0].Rows.Count; j++)
{
T _t = (T)Activator.CreateInstance(typeof(T));
PropertyInfo[] propertys = _t.GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
for (int i = 0; i < p_Data.Tables[0].Rows.Count; i++)
{
// 属性与字段名称一致的进行赋值
if (pi.Name.Equals(p_Data.Tables[0].Columns[i].ColumnName))
{
// 数据库NULL值单独处理
if (p_Data.Tables[0].Rows[j][i] != DBNull.Value)
pi.SetValue(_t, p_Data.Tables[0].Rows[j][i], null);
else
pi.SetValue(_t, null, null);
break;
}
}
}
result.Add(_t);
}
return result;
}
/// <summary>
/// DataTable装换为泛型集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="p_DataSet">DataSet</param>
/// <returns></returns>
public List<T> DataTableToList<T>(DataTable p_Data)
{
// 反射技术
// 返回值初始化
List<T> result = new List<T>();
for (int j = 0; j < p_Data.Rows.Count; j++)
{
T _t = (T)Activator.CreateInstance(typeof(T));
PropertyInfo[] propertys = _t.GetType().GetProperties();
foreach (PropertyInfo pi in propertys)
{
for (int i = 0; i < p_Data.Columns.Count; i++)
{
// 属性与字段名称一致的进行赋值
if (pi.Name.Equals(p_Data.Columns[i].ColumnName))
{
// 数据库NULL值单独处理
if (p_Data.Rows[j][i] != DBNull.Value)
pi.SetValue(_t, p_Data.Rows[j][i], null);
else
pi.SetValue(_t, null, null);
break;
}
}
}
result.Add(_t);
}
return result;
}
浙公网安备 33010602011771号