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()
{
var use = await _sqlOnlineApplication.UseDevelopment();
if (use == false)
{
return(Redirect("/Developments/Prompt"));
}
var logoDto = await _adminApplication.GetSettingValueByCode("Logo");
if (logoDto != null)
{
Logo = logoDto.Value;
}
TopMenus = new List <TopMenuDto>();
TopMenus.Add(new TopMenuDto()
{
Activity = true,
Name = "数据结构",
Url = "/Developments",
});
TopMenus.Add(new TopMenuDto()
{
Name = "代码生成器",
Url = "/Developments/CodeGen",
});
ViewData["Title"] = "开发环境";
return(Page());
}
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());
}