/// <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 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 bool TestConnection(string database, string user, string password) //{ // try // { // string connstr = string.Format(DEF_SQL_CONNECTION, database, password, user); // OracleConnection conn = new OracleConnection(connstr); // conn.Open(); // //Msg.ShowInformation("测试成功!"); // return true; // } // catch (Exception ex) // { // Msg.ShowException(ex); // return false; // } //} /// <summary> /// 测试连接 /// </summary> /// <returns></returns> public bool TestConnection() { try { OraConfiguration cfg = new OraConfiguration(); OracleConnection conn = cfg.CreateConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); conn.Close(); } return(true); } catch (Exception ex) { Msg.ShowException(ex); return(false); } }
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(string database, string user, string password) //{ // try // { // string connstr = string.Format(DEF_SQL_CONNECTION, database, password, user); // OracleConnection conn = new OracleConnection(connstr); // conn.Open(); // //Msg.ShowInformation("测试成功!"); // return true; // } // catch (Exception ex) // { // Msg.ShowException(ex); // return false; // } //} /// <summary> /// 测试连接 /// </summary> /// <returns></returns> public bool TestConnection() { try { OraConfiguration cfg = new OraConfiguration(); OracleConnection conn = cfg.CreateConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); conn.Close(); } return true; } catch (Exception ex) { Msg.ShowException(ex); return false; } }