//使用原因 :在程序运行时,数据库数据直接加载到本地内存,可以提高程序的运行效率
//定义类型
public class hospital
{public string KeHuHospitalCode { get; set; }
public string KeHuHospitalName { get; set; }
}
//客户医院查询数据
if (list_hospital == null)
{
//从数据库获取所需要的数据,只能是2个字段的数据,名称必须为 KeHuHospitalCode ,KeHuHospitalName
DataTable dt = new BasicDAO().Get_DR_DouBao_Hostpital ();list_hospital = CommonMe.DataTableHelper.ToListEntity<hospital>(dt);
}
//方法如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Reflection;
namespace CommonMe
{
public static class DataTableHelper
{
#region 利用反射把DataTable的数据写到集合实体类里
public static List<T> ToListEntity<T>(this DataTable dtSource)
{
List<T> list = new List<T>();
if (dtSource == null)
{
return null;
}
Type type = typeof(T);
List<string> arrayColumn = GetColumnsByDataTable(dtSource);
foreach (DataRow dataRow in dtSource.Rows)
{
Object entity = Activator.CreateInstance(type); //创建实例
PropertyInfo[] listPro = type.GetProperties(BindingFlags.Public | BindingFlags.Instance);//Instance|Public:获取公共的的实例属性(非静态的) Static|Public:获取公共的静态属性 Instance|Static|Public:获取公共的的实例或静态属性
foreach (PropertyInfo entityCols in listPro)
{
string columnName = arrayColumn.Where(a => a.ToUpper() == entityCols.Name.ToUpper()).FirstOrDefault();//不区分大小写
if (columnName != null && columnName != "")
{
object cellvalue = dataRow[columnName];
if (columnName != null
&& dataRow[columnName] != null && dataRow[columnName] != DBNull.Value
)
{
if (!entityCols.PropertyType.IsGenericType)
{
entityCols.SetValue(entity, Convert.ChangeType(cellvalue, entityCols.PropertyType), null);
}
else
{
Type genericTypeDefinition = entityCols.PropertyType.GetGenericTypeDefinition();
if (genericTypeDefinition == typeof(Nullable<>))
{
entityCols.SetValue(entity, Convert.ChangeType(cellvalue, Nullable.GetUnderlyingType(entityCols.PropertyType)), null);
}
}
}
}
}
list.Add((T)entity);
}
return list;
}
#endregion
public static List<string> GetColumnsByDataTable(DataTable dt)
{
List<string> strColumns = new List<string>();
if (dt != null && dt.Columns.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
strColumns.Add(dt.Columns[i].ColumnName);
}
}
return strColumns;
}
}
}
}