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();
}
