/// <summary>
/// 创建SQL连接对象
/// </summary>
/// <returns></returns>
public OracleConnection CreateConnection()
{
if (_sqlConfig == null)
{
_sqlConfig = new IniFileWriter(Application.StartupPath + DbConfiguration_Factory.INI_CFG_PATH);
}
return(CreateConnection(_sqlConfig));
}
/// <summary>
/// 设置连接
/// </summary>
/// <param name="config"></param>
public static void SetSQLConfig(IWriteSQLConfigValue config)
{
if (DbType == DbAcessTyp.SQLServer) //SQL
{
new SqlConfiguration().SetSQLConfig(config);
}
else if (DbType == DbAcessTyp.Oracle)
{
new OraConfiguration().SetSQLConfig(config);
}
}
/// <summary>
/// 获取连接
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public static IDbConnection CreateConnection(IWriteSQLConfigValue config)
{
if (DbType == DbAcessTyp.SQLServer) //SQL
{
return new SqlConfiguration().CreateConnection(config);
}
else if (DbType == DbAcessTyp.Oracle)
{
return new OraConfiguration().CreateConnection(config);
}
return null;
}
/// <summary>
/// 获取连接
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public static IDbConnection CreateConnection(IWriteSQLConfigValue config)
{
if (DbType == DbAcessTyp.SQLServer) //SQL
{
return(new SqlConfiguration().CreateConnection(config));
}
else if (DbType == DbAcessTyp.Oracle)
{
return(new OraConfiguration().CreateConnection(config));
}
return(null);
}
/// <summary>
/// 建立连接
/// </summary>
public SqlConnection CreateConnection(IWriteSQLConfigValue config)
{
if (config == null)
{
throw new Exception("Program cann't run without a SQL configuration.You should config the SQL connection by running LZHBaseFrame.Tools.SqlConnector.exe!");
}
string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password);
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
return(conn);
}
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);
}
private void btnConnect_Click(object sender, EventArgs e)
{
btnConnect.Enabled = false;
try
{
string errMsg = string.Empty;
label5.Visible = true;
timer1.Start();
if (rbINI.Checked)//连接配置保存在INI文件
{
_writer = new IniFileWriter(Application.StartupPath + SqlConfiguration.INI_CFG_PATH);
}
else//连接配置保存在注册表. Registry.LocalMachine根目录下
{
_writer = new RegisterWriter(SqlConfiguration.REG_SQL_CFG);
}
SqlConnection conn = this.TestConnection(txtServerName.Text, txtDatabase.Text, txtUserName.Text, txtPwd.Text, ref errMsg);
if (conn == null)
{
timer1.Stop();
label5.Visible = false;
MessageBox.Show("Connecting to SQL Server failed.\n" + errMsg, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
else //连接成功，保存连接参数
{
_writer.ServerName = txtServerName.Text;
_writer.UserName = txtUserName.Text;
_writer.Password = txtPwd.Text;
_writer.InitialCatalog = txtDatabase.Text;
_writer.Write();
Successed = true;
MessageBox.Show("Connect SQL Server successfully!", "Connect to Server", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
this.Close();
}
}
finally
{
timer1.Stop();
label5.Visible = false;
btnConnect.Enabled = true;
}
}
/// <summary>
/// 生成连接字符串
/// </summary>
/// <param name="config">SQL配置策略</param>
/// <returns></returns>
public string GetConnectionString(IWriteSQLConfigValue config)
{
string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password);
return(connstr);
}
/// <summary>
/// 设置SQL配置策略
/// </summary>
/// <param name="config"></param>
public static void SetSQLConfig(IWriteSQLConfigValue config)
{
_sqlConfig = config;
}
/// <summary>
/// 设置连接
/// </summary>
/// <param name="config"></param>
public static void SetSQLConfig(IWriteSQLConfigValue config)
{
if (DbType == DbAcessTyp.SQLServer) //SQL
{
new SqlConfiguration().SetSQLConfig(config);
}
else if (DbType == DbAcessTyp.Oracle)
{
new OraConfiguration().SetSQLConfig(config);
}
}
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>
/// 设置SQL配置策略
/// </summary>
/// <param name="config"></param>
public void SetSQLConfig(IWriteSQLConfigValue config)
{
_sqlConfig = config;
}
/// <summary>
/// 生成连接字符串
/// </summary>
/// <param name="config">SQL配置策略</param>
/// <returns></returns>
public string GetConnectionString(IWriteSQLConfigValue config)
{
string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password);
return connstr;
}
/// <summary>
/// 建立连接
/// </summary>
public SqlConnection CreateConnection(IWriteSQLConfigValue config)
{
if (config == null) throw new Exception("Program cann't run without a SQL configuration.You should config the SQL connection by running CSFramework.Tools.SqlConnector.exe!");
string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password);
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
return conn;
}
/// <summary>
/// 创建SQL连接对象
/// </summary>
/// <returns></returns>
public SqlConnection CreateConnection()
{
if (_sqlConfig == null)
_sqlConfig = new IniFileWriter(Application.StartupPath + DbConfiguration_Factory.INI_CFG_PATH);
return CreateConnection(_sqlConfig);
}
