2021-05-21 仓库温控系统(Winform) 06 DataRow/DataTable/SqlDataReader和实体类相互转换DbConvert

/// <summary>
/// 类型转换处理---DataRow/DataTable/SqlDataReader    T/List<T>
/// </summary>
public class DbConvert
{
   
    /// <summary>
    /// 将DataRow转换成实体
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="dr"></param>
    /// <returns></returns>
    private static T DataRowToModel<T>(DataRow dr, string cols)
    {
   
        //创建实例对象
        T model = Activator.CreateInstance<T>();

        Type type = typeof(T);
        if (dr != null)
        {
   
            //获取指定列名的属性数组
            var properties = PropertyHelper.GetTypeProperties<T>(cols);
            //将第列的值赋值给对应的属性
            foreach (var p in properties)
            {
   
                string colName = p.GetColName();
                if (dr[colName] is DBNull)
                    p.SetValue(model, null);//为属性设置值 
                else
                {
   
                    SetPropertyValue<T