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