基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 1 元　

支付宝支付

微信支付

   源码介绍

---

[实例简介]GhExcel 将datatable 转换成实体类 例子源码下载

[实例截图]

[核心代码]

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
/**
 * 作者：黄炳桂
 * Email:516821420@qq.com
 */
namespace GhOrm
{
    public class GhExcel<T> where T : new()
    {
        /// <summary>
        /// 
        /// </summary>
        /// <param name="keys"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static List<T> ToList(string keys, DataTable dt)
        {
            return GhConvert<T>.ToList(keys, dt);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="fileName"></param>
        /// <returns></returns>
        public static DataTable ToDataTable(string fileName)
        {
            //var book = new Workbook(fileName);
            //worksheet sheet = book.Worksheets[0];
            //Cells cells = sheet.Cells;
            //DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow 1, cells.MaxDataColomn 1, true);
            return null;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="keys"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static Boolean IsColumnNamesEqual(string keys, DataTable dt)
        {
            var columnNames = (from DataColumn column in dt.Columns select column.ColumnName).ToList();
            string dtColumnNames = string.Join(",", columnNames);
            return keys == dtColumnNames;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="keys"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static Boolean IsColumnCountEqual(string keys, DataTable dt)
        {
            string[] splitKeys = keys.Split(',');
            return splitKeys.Count() == dt.Columns.Count;
        }
    }
}
 
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Reflection;
/**
 * 作者：黄炳桂
 * Email:516821420@qq.com
 */
namespace GhOrm
{
    public class GhConvert<T> where T : new()
    {
        /// <summary>
        /// 将DataTable转换成Model实体
        /// </summary>
        /// <param name="obj">Model名称</param>
        /// <param name="dt">DataTable</param>
        /// <returns></returns>
        public static T ToObject(DataTable dt)
        {
            if (dt.Rows.Count <= 0) return new T();
            T t = new T();
            string tempName = "";
            PropertyInfo[] pis = t.GetType().GetProperties();
            foreach (PropertyInfo pi in pis)
            {
                tempName = pi.Name;
                if (dt.Columns.Contains(tempName))
                {
                    // 判断此属性是否有Setter
                    if (!pi.CanWrite) continue;
                    object value = dt.Rows[0][tempName];
                    if (value != DBNull.Value)
                    {
                        if (dt.Rows[0][pi.Name].GetType().Name.ToString().ToLower() == "datetime")
                            pi.SetValue(t, value.ToString(), null);
                        else
                            pi.SetValue(t, value, null);
                    }
                }
            }
            return t;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <typeparam name="T1"></typeparam>
        /// <typeparam name="T2"></typeparam>
        /// <param name="t1"></param>
        /// <param name="t2"></param>
        public static void ToObject<T1, T2>(T1 t1, T2 t2)
        {
            PropertyInfo[] t1Properties = t1.GetType().GetProperties();
            PropertyInfo[] t2Properties = t2.GetType().GetProperties();
            foreach (PropertyInfo p in t1Properties)
            {
                if (p == null) continue;
                var t2Property = t2Properties.FirstOrDefault(m => m.Name == p.Name);
                if (t2Property == null) continue;
                object dstV = p.GetValue(t1, null);
                object srcV = t2Property.GetValue(t2, null);
                if (dstV != null && srcV != null)
                    if (dstV.ToString() == srcV.ToString()) continue;
                p.SetValue(t1, srcV, null);
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <typeparam name="T2"></typeparam>
        /// <param name="t2"></param>
        /// <returns></returns>
        public static T ToObject<T2>(T2 t2)
        {
            var t1 = new T();
            PropertyInfo[] t1Properties = t1.GetType().GetProperties();
            PropertyInfo[] t2Properties = t2.GetType().GetProperties();
            foreach (PropertyInfo p in t1Properties)
            {
                if (p == null) continue;
                var t2Property = t2Properties.FirstOrDefault(m => m.Name == p.Name);
                if (t2Property == null) continue;
                object dstV = p.GetValue(t1, null);
                object srcV = t2Property.GetValue(t2, null);
                if (dstV != null && srcV != null)
                    if (dstV.ToString() == srcV.ToString()) continue;
                p.SetValue(t1, srcV, null);
            }
            return t1;
        }
        /// <summary>
        /// 将DataTable转换成IList
        /// </summary>
        /// <param name="dt">要转换的DataTable</param>
        /// <returns>返回IList</returns>
        public static IList<T> ToList(DataTable dt)
        {
            IList<T> list = new List<T>();
            string tempName = "";
            foreach (DataRow dr in dt.Rows)
            {
                T t = new T();
                // 获得此模型的公共属性
                PropertyInfo[] propertys = t.GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    tempName = pi.Name;
                    // 检查DataTable是否包含此列
                    if (dt.Columns.Contains(tempName))
                    {
                        // 判断此属性是否有Setter
                        if (!pi.CanWrite) continue;
                        object value = dr[tempName];
                        if (value != DBNull.Value)
                        {
                            if (dr[pi.Name].GetType().Name.ToString().ToLower() == "datetime")
                                pi.SetValue(t, value.ToString(), null);
                            else
                                pi.SetValue(t, value, null);
                        }
                    }
                }
                list.Add(t);
            }
            return list;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="keys"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static List<T> ToList(string keys, DataTable dt)
        {
            List<T> lists = new List<T>();
            string[] splitKeys = keys.Split(',');
            PropertyInfo[] properties = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
            for (var row = 0; row < dt.Rows.Count; row )
            {
                var t = new T();
                for (var column = 0; column < dt.Columns.Count; column )
                {
                    try
                    {
                        var value = dt.Rows[row][column].ToString();
                        if (value == "") continue;
                        if (column > splitKeys.Count()) break;
                        PropertyInfo property = properties.FirstOrDefault(m => m.Name == splitKeys[column]);
                        if (property == null) continue;
                        if (value.GetType().Name.ToString().ToLower() == "datetime")
                            property.SetValue(t, value.ToString(), null);
                        else
                            property.SetValue(t, value, null);
                    }
                    catch (Exception e)
                    {
                        e.HelpLink = "导入数据第" (row 1) "行" dt.Columns[column].ColumnName "数据格式有误！";
                        throw e;
                    }
                }
                lists.Add(t);
            }
            return lists;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ts"></param>
        /// <returns></returns>
        public static DataTable ToDataTable(IEnumerable<T> ts) { 
            var propertyInfos=new List<PropertyInfo>();
            Type type=typeof(T);
            var dt=new DataTable();
            Array.ForEach<PropertyInfo>(type.GetProperties(),p=>{propertyInfos.Add(p);dt.Columns.Add(p.Name,p.PropertyType);});
            foreach(var item in ts){
                DataRow row=dt.NewRow();
                propertyInfos.ForEach(p=>row[p.Name]=p.GetValue(item,null));
                dt.Rows.Add(row);
            }
            return dt;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="keys"></param>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static Boolean IsColumnNamesEqual(string keys, DataTable dt)
        {
            var columnNames = (from DataColumn column in dt.Columns select column.ColumnName).ToList();
            string dtColumnNames = string.Join(",", columnNames);
            return keys == dtColumnNames;
        }
    }
}