using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.Common;


namespace HH.WMS.DAL
{
  public  class ComDbType
    { 
        /// <summary>
        /// CHAR 字符类型
        /// </summary>
      public static DbType CHAR
        {
            get
            {
                return GetDataType("CHAR");
            } 
        }
        

      /// <summary>
      /// FLOAT
      /// </summary>
      public static DbType FLOAT
      {
          get
          {
              return GetDataType("FLOAT");
          }
      }

      /// <summary>
      /// 字符类型
      /// </summary>
      public static DbType DOUBLE
      {
          get
          {
              return GetDataType("DOUBLE");
          }
      }

      /// <summary>
      /// DECIMAL
      /// </summary>
      public static DbType DECIMAL
      {
          get
          {
              return GetDataType("DECIMAL");
          }
      }


      /// <summary>
      /// INT
      /// </summary>
      public static DbType INT
      {
          get
          {
              return GetDataType("INT");
          }
      }

      /// <summary>
      /// INT32
      /// </summary>
      public static DbType INT32
      {
          get
          {
              return GetDataType("INT32");
          }
      }
        
      /// <summary>
      /// VARCHAR
      /// </summary>
      public static DbType STRING
      {
          get
          {
              return GetDataType("VARCHAR");
          }
      }

      /// <summary>
      /// DATE
      /// </summary>
      public static DbType DATE
      {
          get
          {
              return GetDataType("DATE");
          }
      }
       

      /// <summary>
      /// CURSOR 仅oracle使用 
      /// </summary>
      public static DbType CURSOR
      {
          get
          {
              return GetDataType("CURSOR");
          }
      }


        /// <summary>
        ///  得到数据类型
        /// </summary>
        /// <param name="Type">字段类型</param> 
        private static DbType GetDataType(string Type)
        {
                switch (Type.ToLower())
                {
                    case "char":
                        return DbType.String;
                    case "nchar":
                        return DbType.String;
                    case "float":
                        return DbType.Single;
                    case "double":
                        return DbType.Double;
                    case "decimal":
                        return DbType.Decimal;
                    case "int":
                        return DbType.Int32;
                    case "int16":
                        return DbType.Int16;
                    case "int32":
                        return DbType.Int32;
                    case "int64":
                        return DbType.Int64;
                    case "varchar":
                        return DbType.String;
                    case "nvarchar":
                        return DbType.String;
                    case "date":
                        return DbType.DateTime;
                    case "number":
                        return DbType.Decimal;
                    default:
                        return DbType.String;

                }

            } 
        } 
}