public async Task <IActionResult> GetSqlTree([FromBody] SqlSearchDto request)
{
var use = await _sqlOnlineApplication.UseDevelopment();
if (use == false)
{
return(LayuiError("系统出了个小差！"));
}
try {
if (string.IsNullOrEmpty(request.SearchType))
{
var connDtos = await _sqlOnlineApplication.GetConnList();
return(LayuiSuccess(GetSqlTree(connDtos, request), null));
}
else if (request.SearchType == "GetDatabaseNames")
{
var databaseEntities = await _sqlOnlineApplication.GetDatabaseNames(request.SqlConnId);
return(LayuiSuccess(GetSqlTree(databaseEntities, request), null));
}
} catch (Exception ex) {
LogUtil.Error(ex);
}
return(LayuiError("系统出了个小差！"));
}
public async Task <IActionResult> OnGetAsync(int sqlConnId = 0, string database = null)
{
if (sqlConnId <= 0)
{
return(Redirect("/NotFound"));
}
var use = await _sqlOnlineApplication.UseDevelopment();
if (use == false)
{
return(Redirect("/Developments/Prompt"));
}
ConnId = sqlConnId;
DatabaseName = database;
DatabaseEntities = await _sqlOnlineApplication.GetDatabaseNames(sqlConnId);
if (string.IsNullOrEmpty(DatabaseName))
{
if (DatabaseEntities.Count > 0)
{
DatabaseName = DatabaseEntities[0].DatabaseName;
}
}
return(Page());
}