public async Task <IActionResult> CreateDBConn(DbConnInfo dbConnInfo)
{
CommonResult result = new CommonResult();
DBConnResult dBConnResult = new DBConnResult();
if (dbConnInfo != null)
{
if (string.IsNullOrEmpty(dbConnInfo.DbName))
{
dbConnInfo.DbName = "master";
}
else if (string.IsNullOrEmpty(dbConnInfo.DbAddress))
{
result.ErrMsg = "访问地址不能为空";
}
else if (string.IsNullOrEmpty(dbConnInfo.DbUserName))
{
result.ErrMsg = "访问用户不能为空";
}
else if (string.IsNullOrEmpty(dbConnInfo.DbPassword))
{
result.ErrMsg = "访问密码不能为空";
}
if (string.IsNullOrEmpty(dbConnInfo.DbPort.ToString()))
{
if (dbConnInfo.DbType == "SqlServer")
{
dbConnInfo.DbPort = 1433;
}
else if (dbConnInfo.DbType == "MySql")
{
dbConnInfo.DbPort = 3306;
}
}
if (dbConnInfo.DbType == "SqlServer")
{
dBConnResult.ConnStr = string.Format("Server={0},{1};Database={2};User id={3}; password={4};MultipleActiveResultSets=True;", dbConnInfo.DbAddress, dbConnInfo.DbPort, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword);
}
else if (dbConnInfo.DbType == "MySql")
{
dBConnResult.ConnStr = string.Format("server={0};database={1};uid={2}; pwd={3};port={4};Allow User Variables=True;", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword, dbConnInfo.DbPort);
}
YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper();
TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now;
yuebonCacheHelper.Add("CodeGeneratorDbConn", dBConnResult.ConnStr, expiresSliding, false);
yuebonCacheHelper.Add("CodeGeneratorDbType", dbConnInfo.DbType, expiresSliding, false);
yuebonCacheHelper.Add("CodeGeneratorDbName", dbConnInfo.DbName, expiresSliding, false);
DbExtractor dbExtractor = new DbExtractor();
List <DataBaseInfo> listTable = dbExtractor.GetAllDataBases();
result.ResData = listTable;
result.Success = true;
result.ErrCode = ErrCode.successCode;
}
return(ToJsonContent(result));
}
public IActionResult ConnStrDecrypt(string strConn)
{
CommonResult result = new CommonResult();
DBConnResult dBConnResult = new DBConnResult();
if (string.IsNullOrEmpty(strConn))
{
result.ErrMsg = "数据库名称不能为空";
}
else
{
dBConnResult.ConnStr = DEncrypt.Decrypt(strConn);
result.Success = true;
result.ErrCode = ErrCode.successCode;
}
result.ResData = dBConnResult;
return(ToJsonContent(result));
}
public async Task <IActionResult> ConnStrEncrypt([FromQuery] DbConnInfo dbConnInfo)
{
CommonResult result = new CommonResult();
DBConnResult dBConnResult = new DBConnResult();
if (dbConnInfo != null)
{
if (string.IsNullOrEmpty(dbConnInfo.DbName))
{
result.ErrMsg = "数据库名称不能为空";
}
else if (string.IsNullOrEmpty(dbConnInfo.DbAddress))
{
result.ErrMsg = "访问地址不能为空";
}
else if (string.IsNullOrEmpty(dbConnInfo.DbUserName))
{
result.ErrMsg = "访问用户不能为空";
}
else if (string.IsNullOrEmpty(dbConnInfo.DbPassword))
{
result.ErrMsg = "访问密码不能为空";
}
if (dbConnInfo.DbType == "SqlServer")
{
dBConnResult.ConnStr = string.Format("Server={0};Database={1};User id={2}; password={3};MultipleActiveResultSets=True;", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword);
dBConnResult.EncryptConnStr = DEncrypt.Encrypt(dBConnResult.ConnStr);
result.Success = true;
result.ErrCode = ErrCode.successCode;
}
else if (dbConnInfo.DbType == "MySql")
{
dBConnResult.ConnStr = string.Format("server={0};database={1};uid={2}; pwd={3};", dbConnInfo.DbAddress, dbConnInfo.DbName, dbConnInfo.DbUserName, dbConnInfo.DbPassword);
dBConnResult.EncryptConnStr = DEncrypt.Encrypt(dBConnResult.ConnStr);
result.Success = true;
result.ErrCode = ErrCode.successCode;
}
result.ResData = dBConnResult;
}
return(ToJsonContent(result));
}
