泛型多功能操作类-2(通过属性获取数据库类型并返回参数)

        Model.Provide_basic_info_check pbic = new Model.Provide_basic_info_check();

        pbic.PB_INDEX = 10;

        pbic.PB_ID = 2;

        pbic.PB_INPUTER = "chen";

        pbic.PB_INPUTDATE = DateTime.Now;

        pbic.PB_RESULT = 1;

        pbic.PB_SUBMITER = "chen";

        pbic.PB_DESCRIPT = "pass";

        pbic.PB_CHECKER = "chen";

        Attributes.DataOperate<Model.Provide_basic_info_check>.Insert(pbic);

 

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;
using System.Reflection;

namespace Attributes
{
    public static class GetParamter
    {

        public static OracleParameter GetOracleParamter(string name, PropertyInfo info,string val)
        {
    

            var propertyType = Nullable.GetUnderlyingType(info.PropertyType) ?? info.PropertyType;

            if (propertyType.Equals(typeof(String)))
            {
                OracleParameter para = new OracleParameter(name, OracleType.VarChar, 30);

                para.Value = val;

                return para;
            }
            else if (propertyType.Equals(typeof(int)))
            {
                 OracleParameter para = new OracleParameter(name, OracleType.Number,4);

                 para.Value = Convert.ToInt32(val);

                 return para;
            }
            else if (propertyType.Equals(typeof(decimal)))
            {
                OracleParameter para = new OracleParameter(name, OracleType.Number,4);

                para.Value = Convert.ToDecimal(val);

                return para;

            }
            else if (propertyType.Equals(typeof(System.DateTime)))
            {
                OracleParameter para = new OracleParameter(name, OracleType.DateTime);

                para.Value = Convert.ToDateTime(val);

                return para;

            }
            else if (propertyType.Equals(typeof(double)))
            {
                OracleParameter para = new OracleParameter(name, OracleType.Double);

                para.Value = Convert.ToDouble(val);

                return para;
            }
            else
            {
                OracleParameter para = new OracleParameter(name, OracleType.Number,4);

                para.Value = Convert.ToInt32(val);

                return para;
            }
           
        }

    }
}