public async Task <IActionResult> GetSqlTree([FromBody] Req <SqlSearchDto> request)
{
request.Data.AdminId = request.OperatorId;
try {
if (string.IsNullOrEmpty(request.Data.SearchType))
{
var connDtos = await _sqlOnlineApplication.GetConnList(request.Data);
return(LayuiSuccess(GetSqlTree(connDtos, request.Data), request.PasswordString));
}
else if (request.Data.SearchType == "GetDatabaseNames")
{
var databaseEntities = await _sqlOnlineApplication.GetDatabaseNames(request.Data);
return(LayuiSuccess(GetSqlTree(databaseEntities, request.Data), request.PasswordString));
}
else if (request.Data.SearchType == "GetTableNames")
{
var tableEntities = await _sqlOnlineApplication.GetTableNames(request.Data);
return(LayuiSuccess(GetSqlTree(tableEntities, request.Data), request.PasswordString));
}
else if (request.Data.SearchType == "GetViewNames")
{
var viewEntities = await _sqlOnlineApplication.GetViewNames(request.Data);
return(LayuiSuccess(GetSqlTree(viewEntities, request.Data), request.PasswordString));
}
else if (request.Data.SearchType == "GetProcedureNames")
{
var procedureEntities = await _sqlOnlineApplication.GetProcedureNames(request.Data);
return(LayuiSuccess(GetSqlTree(procedureEntities, request.Data), request.PasswordString));
}
else if (request.Data.SearchType == "GetFunctionNames")
{
var functionEntities = await _sqlOnlineApplication.GetFunctionNames(request.Data);
return(LayuiSuccess(GetSqlTree(functionEntities, request.Data), request.PasswordString));
}
} catch (Exception ex) {
LogUtil.Error(ex);
}
return(LayuiError("系统出了个小差！"));
}
public async Task <IActionResult> OnGet(int sqlConnId, string databaseName)
{
ConnId = sqlConnId;
DatabaseName = databaseName;
SqlSearchDto search = new SqlSearchDto()
{
AdminId = AdminDto.Id,
SqlConnId = sqlConnId,
Database = databaseName,
};
DatabaseEntities = await _sqlOnlineApplication.GetDatabaseNames(search);
if (string.IsNullOrEmpty(DatabaseName))
{
if (DatabaseEntities.Count > 0)
{
DatabaseName = DatabaseEntities[0].DatabaseName;
}
}
return(Page());
}
public async Task <IActionResult> OnGetAsync(int sqlConnId = 0, string database = null)
{
if (sqlConnId <= 0)
{
return(Redirect("/NotFound"));
}
ConnId = sqlConnId;
DatabaseName = database;
DatabaseEntities = await _sqlOnlineApplication.GetDatabaseNames(new Dtos.SqlSearchDto()
{
AdminId = AdminDto.Id, SqlConnId = sqlConnId
});
if (string.IsNullOrEmpty(DatabaseName))
{
if (DatabaseEntities.Count > 0)
{
DatabaseName = DatabaseEntities[0].DatabaseName;
}
}
return(Page());
}
public async Task <IActionResult> OnGet(string action, int id, int sqlConnId, string database, string schema, string name)
{
ConnId = sqlConnId;
DatabaseName = database;
SqlSearchDto search = new SqlSearchDto()
{
AdminId = AdminDto.Id,
SqlConnId = sqlConnId,
Database = database,
Schema = schema,
Search = name
};
SqlEditorDto r = null;
if (action == "new")
{
r = await _sqlOnlineApplication.GetSql_New(search);
}
else if (action == "TableSelect100")
{
r = await _sqlOnlineApplication.GetSql_TableSelect100(search);
}
else if (action == "TableInsertSql")
{
r = await _sqlOnlineApplication.GetSql_TableInsert(search);
}
else if (action == "TableUpdateSql")
{
r = await _sqlOnlineApplication.GetSql_TableUpdate(search);
}
else if (action == "TableDeleteSql")
{
r = await _sqlOnlineApplication.GetSql_TableDelete(search);
}
else if (action == "ViewSelect100")
{
r = await _sqlOnlineApplication.GetSql_ViewSelect100(search);
}
else if (action == "ViewCreateSql")
{
r = await _sqlOnlineApplication.GetSql_ViewCreate(search);
}
else if (action == "ViewAlterSql")
{
r = await _sqlOnlineApplication.GetSql_ViewAlter(search);
}
else if (action == "FunctionSelectSql")
{
r = await _sqlOnlineApplication.GetSql_FunctionSelectSql(search);
}
else if (action == "FunctionCreateSql")
{
r = await _sqlOnlineApplication.GetSql_FunctionCreate(search);
}
else if (action == "FunctionAlterSql")
{
r = await _sqlOnlineApplication.GetSql_FunctionAlter(search);
}
else if (action == "ProcedureExecuteSql")
{
r = await _sqlOnlineApplication.GetSql_ProcedureExecuteSql(search);
}
else if (action == "ProcedureCreateSql")
{
r = await _sqlOnlineApplication.GetSql_ProcedureCreate(search);
}
else if (action == "ProcedureAlterSql")
{
r = await _sqlOnlineApplication.GetSql_ProcedureAlter(search);
}
else if (action == "openDoc")
{
var sqlDoc = await _sqlOnlineApplication.GetSelfSqlDoc(AdminDto.Id, id);
if (sqlDoc == null)
{
return(Redirect(UrlSetting.NotFoundUrl));
}
await _sqlOnlineApplication.OpenSqlDoc(AdminDto.Id, id);
DocId = sqlDoc.SqlDocId;
Title = sqlDoc.Title;
SqlString = sqlDoc.Content;
DatabaseName = sqlDoc.DatabaseName;
ConnId = sqlDoc.SqlConnId;
search.SqlConnId = sqlDoc.SqlConnId;
r = _sqlOnlineApplication.GetSql_New(sqlDoc.SqlType);
}
else if (action == "openDocTemp")
{
var sqlDoc = await _sqlOnlineApplication.GetSelfSqlDocTemp(AdminDto.Id, id);
if (sqlDoc == null)
{
return(Redirect(UrlSetting.NotFoundUrl));
}
TempId = sqlDoc.Id;
DocId = sqlDoc.SqlDocId;
Title = sqlDoc.Title;
SqlString = sqlDoc.Content;
DatabaseName = sqlDoc.DatabaseName;
ConnId = sqlDoc.SqlConnId;
search.SqlConnId = sqlDoc.SqlConnId;
r = _sqlOnlineApplication.GetSql_New(sqlDoc.SqlType);
}
else if (action == "openDocShare")
{
var sqlDoc = await _sqlOnlineApplication.GetShareSqlDoc(AdminDto.Id, id);
if (sqlDoc == null)
{
return(Redirect(UrlSetting.NotFoundUrl));
}
Title = sqlDoc.Title;
SqlString = sqlDoc.Content;
DatabaseName = sqlDoc.DatabaseName;
ConnId = sqlDoc.SqlConnId;
search.SqlConnId = sqlDoc.SqlConnId;
r = _sqlOnlineApplication.GetSql_New(sqlDoc.SqlType);
}
if (r == null)
{
return(Redirect(UrlSetting.NotFoundUrl));
}
JsMode = r.JsMode;
if (string.IsNullOrEmpty(SqlString))
{
SqlString = r.SqlString;
}
DatabaseEntities = await _sqlOnlineApplication.GetDatabaseNames(search);
if (string.IsNullOrEmpty(DatabaseName))
{
if (DatabaseEntities.Count > 0)
{
DatabaseName = DatabaseEntities[0].DatabaseName;
}
}
return(Page());
}