/// <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;
}
}
