泛型——转化实体类的方法

七的不是海

已于 2022-12-09 15:24:05 修改

阅读量4k

点赞数 3

文章标签： c# 开发语言

于 2022-11-22 08:36:37 首次发布

本文链接：https://blog.csdn.net/weixin_50478033/article/details/127975660

版权

1、DataTable转为实体类List

public static class ConvertHelper<T> where T : new()
{
    /// <summary>
    /// 将DataTable转为实体类List
    /// </summary>
    /// <param name="dt"></param>
    /// <returns></returns>
    public static IList<T> ConvertToModel(DataTable dt)
    {
        //定义集合
        IList<T> ts = new List<T>();
        T t = new T();
        string tempName = "";
        //获取此模型的公共属性
        PropertyInfo[] propertys = t.GetType().GetProperties();
        foreach (DataRow row in dt.Rows)
        {
            t = new T();
            foreach (PropertyInfo pi in propertys)
            {
                tempName = pi.Name;
                //检查DataTable是否包含此列
                if (dt.Columns.Contains(tempName))
                {
                    //判断此属性是否有set
                    if (!pi.CanWrite)
                        continue;
                    object value = row[tempName];
                    if (value != DBNull.Value)
                        pi.SetValue(t, value, null);
                }
            }
            ts.Add(t);
        }
        return ts;
    }
}

public static List<T> ToDataList<T>(this DataTable dt)
{
    var list = new List<T>();
    var plist = new List<PropertyInfo>(typeof(T).GetProperties());
    foreach (DataRow item in dt.Rows)
    {
        T s = Activator.CreateInstance<T>();
        for (int i = 0; i < dt.Columns.Count; i++)
        {
            PropertyInfo info = plist.Find(p => p.Name == dt.Columns[i].ColumnName);
            if (info != null)
            {
                try
                {
                    if (!Convert.IsDBNull(item[i]))
                    {
                        object v = null;
                        if (info.PropertyType.ToString().Contains("System.Nullable"))
                        {
                            v = Convert.ChangeType(item[i], Nullable.GetUnderlyingType(info.PropertyType));
                        }
                        else
                        {
                            v = Convert.ChangeType(item[i], info.PropertyType);
                        }
                        info.SetValue(s, v, null);
                    }
                }
                catch (Exception ex)
                {
                    throw new Exception("字段[" + info.Name + "]转换出错," + ex.Message);
                }
            }
        }
        list.Add(s);
    }
    return list;
}

2、DataTable转实体类

public static T ToDataDto<T>(this DataTable dt)
{
    T s = Activator.CreateInstance<T>();
    if (dt == null || dt.Rows.Count == 0)
    {
        return s;
    }
    var plist = new List<PropertyInfo>(typeof(T).GetProperties());
    for (int i = 0; i < dt.Columns.Count; i++)
    {
        PropertyInfo info = plist.Find(p => p.Name == dt.Columns[i].ColumnName);
        if (info != null)
        {
            try
            {
                if (!Convert.IsDBNull(dt.Rows[0][i]))
                {
                    object v = null;
                    if (info.PropertyType.ToString().Contains("System.Nullable"))
                    {
                        v = Convert.ChangeType(dt.Rows[0][i], Nullable.GetUnderlyingType(info.PropertyType));
                    }
                    else
                    {
                        v = Convert.ChangeType(dt.Rows[0][i], info.PropertyType);
                    }
                    info.SetValue(s, v, null);
                }
            }
            catch (Exception ex)
            {
                throw new Exception("字段[" + info.Name + "]转换出错," + ex.Message);
            }
        }
    }
    return s;
}

3、实体集合转换为DataTable

/// <summary>
/// 将实体集合转换为DataTable
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="entities">实体集合</param>
public static DataTable ToDataTable<T>(List<T> entities)
{
    var result = CreateTable<T>();
    FillData(result, entities);
    return result;
}

/// <summary>
/// 创建表
/// </summary>
private static DataTable CreateTable<T>()
{
    var result = new DataTable();
    var type = typeof(T);
    foreach (var property in type.GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance))
    {
        var propertyType = property.PropertyType;
        if ((propertyType.IsGenericType) && (propertyType.GetGenericTypeDefinition() == typeof(Nullable<>)))
            propertyType = propertyType.GetGenericArguments()[0];
        result.Columns.Add(property.Name, propertyType);
    }
    return result;
}

/// <summary>
/// 填充数据
/// </summary>
private static void FillData<T>(DataTable dt, IEnumerable<T> entities)
{
    foreach (var entity in entities)
    {
        dt.Rows.Add(CreateRow(dt, entity));
    }
}

/// <summary>
/// 创建行
/// </summary>
private static DataRow CreateRow<T>(DataTable dt, T entity)
{
    DataRow row = dt.NewRow();
    var type = typeof(T);
    foreach (var property in type.GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance))
    {
        row[property.Name] = property.GetValue(entity) ?? DBNull.Value;
    }
    return row;
}