[转]IList<T>与DataTable转换类

最新推荐文章于 2021-08-27 09:38:00 发布

stoco

最新推荐文章于 2021-08-27 09:38:00 发布

阅读量150

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/stoco/article/details/82804057

本文介绍了一个实用工具类CollectionHelper，它提供了将泛型列表(IList<T>)与DataTable相互转换的方法。这对于需要在不同数据结构间进行灵活转换的应用场景非常有用，例如在ADO.NET与业务对象模型之间进行数据传递。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.ComponentModel;
using System.Reflection;

namespace TKWS.Commen
{
    public class CollectionHelper
    {
        private CollectionHelper()
        {
        }

        /// <summary>
        /// 转换IList<T>为DataTable
        /// </summary>
        /// <typeparam name="T">泛型类型</typeparam>
        /// <param name="list">泛型List集合</param>
        /// <returns>Datatable 对象</returns>
        public static DataTable ConvertTo<T>(IList<T> list)
        {
            DataTable table = CreateTable<T>();
            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 IList<T> ConvertTo<T>(IList<DataRow> rows)
        {
            IList<T> list = null;

            if (rows != null)
            {
                list = new List<T>();

                foreach (DataRow row in rows)
                {
                    T item = CreateItem<T>(row);
                    list.Add(item);
                }
            }

            return list;
        }
        /// <summary>
        /// 转换DataTa为IList<T>泛型
        /// </summary>
        /// <typeparam name="T">泛型类型</typeparam>
        /// <param name="table">所需转换DataTab</param>
        /// <returns>IList<T></returns>
        public static IList<T> ConvertTo<T>(DataTable table)
        {
            if (table == null)
            {
                return null;
            }

List<DataRow> rows = new List<DataRow>();

            foreach (DataRow row in table.Rows)
            {
                rows.Add(row);
            }

return ConvertTo<T>(rows);
}

        public static T CreateItem<T>(DataRow row)
        {
            T obj = default(T);
            if (row != null)
            {
                obj = Activator.CreateInstance<T>();

                foreach (DataColumn column in row.Table.Columns)
                {
                    PropertyInfo prop = obj.GetType().GetProperty(column.ColumnName);
                    try
                    {
                        object value = row[column.ColumnName];
                        prop.SetValue(obj, value, null);
                    }
                    catch
                    {
                        // You can log something here
                        throw;