mysql数据反射给实体类_C# DataTable通过反射转实体类

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Text;

namespace MySqlHelper

{

public static class DataTableToModel

{

///

/// DataTable通过反射获取单个像

///

public static T ToSingleModel(this DataTable data) where T : new()

{

try

{

T t = data.GetList(null, true).Single();

return t;

}

catch (Exception e)

{

return new T();

}

}

///

/// DataTable通过反射获取单个像

/// 前缀

/// 是否忽略大小写，默认不区分

///

public static T ToSingleModel(this DataTable data, string prefix, bool ignoreCase = true) where T : new()

{

T t = data.GetList(prefix, ignoreCase).Single();

return t;

}

///

/// DataTable通过反射获取多个对像

///

///

///

///

public static List ToListModel(this DataTable data) where T : new()

{

List t = data.GetList(null, true);

return t;

}

///

/// DataTable通过反射获取多个对像

///

/// 前缀

/// 是否忽略大小写，默认不区分

///

private static List ToListModel(this DataTable data, string prefix, bool ignoreCase = true) where T : new()

{

List t = data.GetList(prefix, ignoreCase);

return t;

}

private static List GetList(this DataTable data, string prefix, bool ignoreCase = true) where T : new()

{

List t = new List();

int columnscount = data.Columns.Count;

if (ignoreCase)

{

for (int i = 0; i < columnscount; i++)

data.Columns[i].ColumnName = data.Columns[i].ColumnName.ToUpper();

}

try

{

var properties = new T().GetType().GetProperties();

var rowscount = data.Rows.Count;

for (int i = 0; i < rowscount; i++)

{

var model = new T();

foreach (var p in properties)

{

var keyName = prefix + p.Name + "";

if (ignoreCase)

keyName = keyName.ToUpper();

for (int j = 0; j < columnscount; j++)

{

if (data.Columns[j].ColumnName == keyName && data.Rows[i][j] != null)

{

string pval = data.Rows[i][j].ToString();

if (!string.IsNullOrEmpty(pval))

{

try

{

// We need to check whether the property is NULLABLE

if (p.PropertyType.IsGenericType && p.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>))

{

p.SetValue(model, Convert.ChangeType(data.Rows[i][j], p.PropertyType.GetGenericArguments()[0]), null);

}

else

{

p.SetValue(model, Convert.ChangeType(data.Rows[i][j], p.PropertyType), null);

}

}

catch (Exception x)

{

throw x;

}

}

break;

}

}

}

t.Add(model);

}

}

catch (Exception ex)

{

throw ex;

}

return t;

}

}

}