/// <summary> /// 创建指定帐号的SQL连接. /// </summary> /// <param name="DBName">帐套的数据库名或系统数据库名</param> /// <returns></returns> public SqlConnection CreateConnection(string DBName) { //下面的代码是按帐套创建数据库连接 if (String.IsNullOrEmpty(DBName)) throw new Exception("没指定帐套,无法获取数据!"); string sConn; //连接系统数据库,取连接配置参数(INI文件) if (DBName == Globals.DEF_SYSTEM_DB) sConn = new SqlConfiguration().CurrentConnectionString; else if (DBName == Globals.DEF_MASTER_DB) { sConn = new SqlConfiguration().CurrentConnectionString; sConn = sConn.Replace(Globals.DEF_SYSTEM_DB, Globals.DEF_MASTER_DB); } else { //连接帐套数据库 DataRow current = DataSetCache.FindDataSet(DBName); if (current == null) throw new Exception("无效的帐套数据库名!"); //连接帐套数据库, 要跟据帐套参数定义创建连接字符串 sConn = "Server={0};Database={1};User ID={2};Password={3};Connection TimeOut=180;"; sConn = String.Format(sConn, current["ServerIP"].ToString(), current["DBName"].ToString(), current["DBUserName"].ToString(), current["DBUserPassword"].ToString()); } SqlConnection conn = new SqlConnection(sConn); if (conn.State != ConnectionState.Connecting) conn.Open(); return conn; }
public bool TestConnection(string dbType, string Server, string database, string user, string password) { bool Successed = false; if (dbType == "Oracle") { //Oracle //OraConfiguration orcf = new OraConfiguration(); //string RefMsg = ""; Successed = new OraConfiguration().TestConnection(Server, database, user, password); } else { //SQLServer //SqlConfiguration sqlcf = new SqlConfiguration(); Successed = new SqlConfiguration().TestConnection(Server, database, user, password); } return Successed; }
/// <summary> /// 获取帐套管理数据库连接串 /// </summary> /// <returns></returns> public static string GetAccountConnString() { string sConn = ""; IWriteSQLConfigValue cfg = new IniFileWriter(SG.Parameters.SGParameter.sAppPath + INI_CFG_PATH); if(cfg.DbType==DbAcessTyp.SQLServer) { sConn = new SqlConfiguration().GetConnectionString(cfg); } else if(cfg.DbType==DbAcessTyp.Oracle) { sConn = new OraConfiguration().GetConnectionString(cfg); } return sConn; }
/// <summary> /// 测试连接 /// </summary> /// <returns></returns> public static bool TestConnection() { bool sRet = false; if(DbType==DbAcessTyp.SQLServer) //SQL { sRet = new SqlConfiguration().TestConnection(); } else if (DbType == DbAcessTyp.Oracle) { sRet = new OraConfiguration().TestConnection(); } return sRet; }
public static string GetConnString(IWriteSQLConfigValue cfg) { string sConn = ""; if (cfg.DbType == DbAcessTyp.SQLServer) { sConn = new SqlConfiguration().GetConnectionString(cfg); } else if (cfg.DbType == DbAcessTyp.Oracle) { sConn = new OraConfiguration().GetConnectionString(cfg); } return sConn; }
/// <summary> /// 测试连接 /// </summary> /// <returns></returns> public bool TestConnection() { try { SqlConfiguration cfg = new SqlConfiguration(); SqlConnection conn = cfg.CreateConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); conn.Close(); } return true; } catch (Exception ex) { Msg.ShowException(ex); return false; } }