/// <summary>
/// List对象转Table
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
/// <param name="tableName">表名</param>
/// <returns></returns>
public static DataTable ConvertToDataTable <T>(this IEnumerable <T> list, string tableName = null) where T : class
{
DataTable table = DataTableCommon.CreateEmptyTable <T>(tableName);
Type entityType = typeof(T);
PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(entityType);
foreach (T item in list)
{
DataRow row = table.NewRow();
foreach (PropertyDescriptor prop in properties)
{
row[prop.Name] = prop.GetValue(item);
}
table.Rows.Add(row);
}
return(table);
}
public static DTResult <Country> GetDataFromBL(HttpContext context, List <DTColumn> columns)
{
DTResult <Country> dataCountry = new DTResult <Country>();
DTParameters param = DataTableCommon.SetParameters(context, columns);
try
{
using (var db = new AnroAppEntities())
{
var query = db.Countries.AsQueryable().Where(a => (a.CountryName.Contains(param.Search.Value) || param.Search.Value == null));;
dataCountry = DataTableFiltering <Country> .GetResult(param, query);
}
}
catch (Exception ex)
{
Console.Write(ex);
}
return(dataCountry);
}
