public GetCurrentDataBaseLoginInfoResponse GetCurrentDataBaseLoginInfoAndConnetStatus() { GetCurrentDataBaseLoginInfoResponse response = new GetCurrentDataBaseLoginInfoResponse(); try { DbUtility dbUtility = DbUtilityCreator.GetDefaultDbUtility(); if (null != dbUtility) { response.Ip = dbUtility.SqlconModel.DBIP; response.Account = dbUtility.SqlconModel.DBUser; response.Password = dbUtility.SqlconModel.DBPasswd; if (dbUtility.TestConnection()) { response.DataBaseConnecting = true; } else { response.DataBaseConnecting = false; } } } catch (Exception ex) { string message = "操作失败。" + ex.Message; response.ResponseSucceed = false; response.Message = message; LoggingFactory.GetLogger().WriteDebugLogger(message); } return(response); }
private bool ExecuteSqlScript(IEnumerable <string> sqlScriptFilePaths) { bool connetSuccess = true; try { DbUtility dbUtility = DbUtilityCreator.GetDefaultDbUtility(); if (dbUtility.DbProviderType == DbProviderType.MySql) { foreach (var sqlScriptFilePath in sqlScriptFilePaths) { MySqlDataBaseHelper.ExecuteMySqlScriptFile(sqlScriptFilePath, dbUtility.ConnectionString); } } else { //TODO:处理其它数据库执行脚本代码 } } catch (Exception) { connetSuccess = false; throw; } return(connetSuccess); }
private bool CreataDataSqlScript(IEnumerable <string> sqlScriptFilePaths) { bool connetSuccess = true; try { DbUtility dbUtility = DbUtilityCreator.GetDefaultDbUtility(); if (dbUtility.DbProviderType == DbProviderType.MySql) { //创建数据库脚本时,还没有数据库存在,所以 //connectionString不能存在数据库名,否则执行脚本不成功。 string connectionString = dbUtility.ConnectionString.Replace(dbUtility.SqlconModel.DBName, ""); foreach (var sqlScriptFilePath in sqlScriptFilePaths) { MySqlDataBaseHelper.ExecuteMySqlScriptFile(sqlScriptFilePath, connectionString); } } else { //TODO:处理其它数据库执行脚本代码 } } catch (Exception) { connetSuccess = false; throw; } return(connetSuccess); }
private bool TestConnetDataBaseButNotSave(string ip, string account, string password) { bool connetSuccess = true; try { DbUtility dbUtility = DbUtilityCreator.GetDefaultDbUtility(); DbUtility dbUtilityToTest = null; SQLConnModel sqlConnModel = dbUtility.SqlconModel; sqlConnModel.DBIP = ip; sqlConnModel.DBUser = account; sqlConnModel.DBPasswd = password; dbUtilityToTest = new DbUtility(sqlConnModel, dbUtility.DbProviderType); connetSuccess = dbUtilityToTest.TestConnection(); if (connetSuccess) { this.sqlConnModel = sqlConnModel; } } catch (Exception) { connetSuccess = false; throw; } return(connetSuccess); }
public DataPointDataSession() { dbUtility = DbUtilityCreator.GetDefaultDbUtility(); }
public ModuleDataSession() { dbUtility = DbUtilityCreator.GetDefaultDbUtility(); }