QiFeng.ZWY.Utility/DataHelper/ConvertHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using NPOI.SS.Formula.Functions;

namespace QiFeng.LMSD.Utility
{
    public static class ConvertHelper
    {

        public static T GetFromReader<T>(IDataReader reader)
        {
            object result = Activator.CreateInstance(typeof(T));

            for (int i = 0; i < reader.FieldCount; i++)
            {
                if (reader[i] == DBNull.Value)
                    continue;
                PropertyInfo property = typeof(T).GetProperty(reader.GetName(i));//得到第i列的所有属性
                if (property == null || !property.CanWrite)
                    continue;
                if (property.PropertyType == typeof(bool))
                    property.SetValue(result, Convert.ToBoolean(reader[i]), null);
                else
                    property.SetValue(result, reader[i], null);
            }

            return (T)result;
        }

        /// <summary>
        /// Object转化为Decimal
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        public static decimal ObjectToDecimal(object value)
        {
            return value == null || value == DBNull.Value ? 0 : Convert.ToDecimal(value);
        }

        /// <summary>
        /// Object转化为Int32
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        public static Int32 ObjectToInt32(object value)
        {
            return value == null || value == DBNull.Value ? 0 : Convert.ToInt32(value);
        }

        /// <summary>
        /// Object转化为Int64
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        public static Int64 ObjectToInt64(object value)
        {