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


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 类型 默认32位
      /// </summary>
      public static DbType INT
      {
          get
          {
              return GetDataType("INT");
          }
      }


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

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

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

        
      /// <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>
      /// 针对oracle 传递指针参数的方法
      /// </summary>
      /// <param name="command">SQL执行对象</param>
      /// <param name="name">参数名称</param>
      /// <param name="dbType">参数值类型</param>
      public static void AddOrcOutParameter(DbCommand command, string name, System.Data.OracleClient.OracleType dbType)
      {
          System.Data.OracleClient.OracleParameter _op = new System.Data.OracleClient.OracleParameter(name, System.Data.OracleClient.OracleType.Cursor);
          _op.Direction = ParameterDirection.Output;
          command.Parameters.Add(_op);
      }

        /// <summary>
        ///  得到数据类型
        /// </summary>
        /// <param name="Type">字段类型</param> 
        private static DbType GetDataType(string Type)
        {
            //得到数据类型
            string DataConnectionType =ConstantBase.APP_DATA_TYPE;
            //ORACLE 数据库
            if (DataConnectionType.ToUpper() == ComDbName.ORACLE)
            {
                //数据库类型转换为小谢
                switch (Type.ToLower())
                {
                    case "char":
                        return DbType.AnsiStringFixedLength;
                    case "nchar":
                        return DbType.StringFixedLength;   
                    case "float":
                        return DbType.Single;
                    case "double":
                        return DbType.Double;
                    case "decimal":
                        return DbType.Decimal;
                    case "int16":
                        return DbType.Int16;
                    case "int32":
                        return DbType.Int32;
                    case "int":
                        return DbType.Int32;
                    case "int64":
                        return DbType.Int64; 
                    case "varchar":
                        return DbType.AnsiString;
                    case "nvarchar":
                        return DbType.String;
                    case "varchar2":
                        return DbType.String;
                    case "date":
                        return DbType.DateTime;   
                    case "number":
                        return DbType.VarNumeric;
                    case "cursor":
                        return DbType.Object;
                    default:
                        return DbType.String;

                }
            }
            else if (DataConnectionType.ToUpper() == ComDbName.MSSQL)
            {
                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;

                }

            }
            else  //MYSQL
            {
                switch (Type)
                {
                    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.AnsiString;
                    case "nvarchar":
                        return DbType.String;
                    case "date":
                        return DbType.DateTime;
                    case "number":
                        return DbType.Decimal;
                    default:
                        return DbType.String;

                }
            } 
        } 
    }
}