Ejemplo n.º 1
0
        /// <summary>
        /// 根据数据库类型获取操作类
        /// </summary>
        /// <param name="at">数据库类型</param>
        /// <returns>DataBaseOper 数据操作类</returns>
        public static SybaseHelperByODBC GetDataBaseOper(eDBType at)
        {
            switch (at)
            {
            case eDBType.Access:
                if (dbOper_Sybase == null)
                {
                    dbOper_Sybase = new SybaseHelperByODBC(at);
                }
                return(dbOper_Sybase);

                break;

            case eDBType.Sybase:

                if (dbOper_Sybase == null)
                {
                    dbOper_Sybase = new SybaseHelperByODBC(at);
                }
                return(dbOper_Sybase);

                break;

            case eDBType.Custom:
                break;

            default:     //默认是本地库
                if (dbOper_Sybase == null)
                {
                    dbOper_Sybase = new SybaseHelperByODBC(at);
                }
                return(dbOper_Sybase);

                break;
            }

            return(null);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 在自定义数据库连接中根据数据库类型获取数据库连接
        /// </summary>
        /// <param name="at">数据库的连接方式</param>
        /// <param name="at2">自定义数据库的数据库类型</param>
        /// <param name="ServerName">(net)服务器名称</param>
        /// <param name="DataBaseName">数据库名称</param>
        /// <param name="UserIdName">用户</param>
        /// <param name="Password">密码</param>
        /// <returns></returns>
        public static SybaseHelperByODBC GetDataBaseOper(eDBType at, eDBType at2, string ServerName, string DataBaseName, string UserIdName, string Password)
        {
            switch (at)
            {
            case eDBType.Access:
            case eDBType.Oracle:
            case eDBType.SqlServer:
                break;

            case eDBType.Custom:
                if (dbOper_Custom != null)
                {
                    dbOper_Custom.ConnClose();     //先关闭 再连接
                }
                dbOper_Custom = new SybaseHelperByODBC(at2, ServerName, DataBaseName, UserIdName, Password);
                return(dbOper_Custom);

                break;

            default:     //默认是本地库
                break;
            }
            return(null);
        }
Ejemplo n.º 3
0
 /// <summary>
 /// 在自定义数据库连接中根据数据库类型获取数据库连接
 /// </summary>
 /// <param name="at">数据库的连接方式</param>
 /// <param name="at2">自定义数据库的数据库类型</param>
 /// <param name="ServerName">(net)服务器名称</param>
 /// <param name="DataBaseName">数据库名称</param>
 /// <param name="UserIdName">用户</param>
 /// <param name="Password">密码</param>
 /// <returns></returns>
 public static SybaseHelperByODBC GetDataBaseOper(eDBType at, eDBType at2, string ServerName, string DataBaseName, string UserIdName, string Password)
 {
     switch (at)
     {
         case eDBType.Access:
         case eDBType.Oracle:
         case eDBType.SqlServer:
             break;
         case eDBType.Custom:
             if (dbOper_Custom != null)
             {
                 dbOper_Custom.ConnClose(); //先关闭 再连接
             }
             dbOper_Custom = new SybaseHelperByODBC(at2, ServerName, DataBaseName, UserIdName, Password);
             return dbOper_Custom;
             break;
         default: //默认是本地库
             break;
     }
     return null;
 }
Ejemplo n.º 4
0
        /// <summary>
        /// 根据数据库类型获取操作类
        /// </summary>
        /// <param name="at">数据库类型</param>
        /// <returns>DataBaseOper 数据操作类</returns>
        public static SybaseHelperByODBC GetDataBaseOper(eDBType at)
        {
            switch (at)
            {
                case eDBType.Access:
                    if (dbOper_Sybase == null)
                    {
                        dbOper_Sybase = new SybaseHelperByODBC(at);
                    }
                    return dbOper_Sybase;

                    break;
                case eDBType.Sybase:

                    if (dbOper_Sybase == null)
                    {
                        dbOper_Sybase = new SybaseHelperByODBC(at);
                    }
                    return dbOper_Sybase;

                    break;
                case eDBType.Custom:
                    break;

                default: //默认是本地库
                    if (dbOper_Sybase == null)
                    {
                        dbOper_Sybase = new SybaseHelperByODBC(at);
                    }
                    return dbOper_Sybase;
                    break;
            }

            return null;
        }