public DbConfiguration_Factory() { //获取配置文件 IWriteSQLConfigValue _write = new IniFileWriter(SG.Parameters.SGParameter.sAppPath + INI_CFG_PATH); _dbType= _write.DbType; }
public DbConfiguration_Factory() { //获取配置文件 IWriteSQLConfigValue _write = new IniFileWriter(SG.Parameters.SGParameter.sAppPath + INI_CFG_PATH); _dbType = _write.DbType; }
/// <summary> /// 加载连接配置 /// </summary> /// <param name="ConfigFile">配置文件</param> public static void LoadConfiguration(string ConfigFile) { if (File.Exists(ConfigFile)) { IWriteSQLConfigValue cfg = new IniFileWriter(ConfigFile); new SqlConfiguration().SetSQLConfig(cfg); } else { throw new Exception("Program cann't run without a BdConfiguration.You should config the SQL connection by running CSFramework.Tools.SqlConnector.exe!"); } }
/// <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 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> /// <param name="ConfigFile">配置文件</param> public static void LoadConfiguration(string ConfigFile) { if (File.Exists(ConfigFile)) { IWriteSQLConfigValue cfg = new IniFileWriter(ConfigFile); new SqlConfiguration().SetSQLConfig(cfg); } else throw new Exception("Program cann't run without a BdConfiguration.You should config the SQL connection by running CSFramework.Tools.SqlConnector.exe!"); }
/// <summary> /// 初始化桥接功能 /// </summary> public static bool InitializeBridge() { bool connected = false; try { //ADODirect方式,从INI文件读配置信息 if (BridgeType.ADODirect == BridgeType) { //获取连接配置.支持4种连接配置:1.INI, 2.注册表 3.SQLExpress INI 4.Web.Config //IWriteSQLConfigValue cfgRegistry = new RegisterWriter(SqlConfiguration.REG_SQL_CFG); //开发环境,直接从INI文件读取SQL连接配置 //IWriteSQLConfigValue cfgSQLExpress = new SQLExpressCfg(Application.StartupPath + @"\CSFramework.ini"); //生产环境连接配置 IWriteSQLConfigValue cfgNormal = new IniFileWriter(Application.StartupPath + DbConfiguration_Factory.INI_CFG_PATH); //设置配置信息 //SqlConfiguration.SetSQLConfig(cfgNormal); DbConfiguration_Factory.SetSQLConfig(cfgNormal); connected = TestADOConnection();//测试AdoDirect连接 } if (BridgeType.WebService == BridgeType) { //初始化服务端的SQL连接 connected = TestWebServiceConnection();//测试WebService连接 } if (BridgeType.WcfHost == BridgeType) { //初始化服务端SQL连接 connected = TestWcfHostConnection();//测试WebService连接 } } catch (Exception ex) { Msg.ShowException(ex); } //测试桥接是否成功 if (false == connected) { Msg.Warning(TEST_BRIDGE_FAILED + "\r\n\r\nBridgeType:" + BridgeFactory.BridgeType.ToString()); } return connected; }