/// <summary>
/// 加载运行SQL列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public async Task <IActionResult> Index(RuntimeSqlPageQueryWhere queryWhere)
{
var operateResult = await _runtimeSqlApplication.GetRuntimSqlListAsync(queryWhere);
ViewBag.QueryWhere = queryWhere;
return(View(operateResult.Value));
}
/// <summary>
/// 加载sql运行列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public Task <IPageResult <RuntimeSqlListDto> > GetRuntimSqlListAsync(RuntimeSqlPageQueryWhere queryWhere)
{
SqlWhereBuilder whereBuilder = new SqlWhereBuilder("A.FIsDeleted=0", ReaderDataType);
whereBuilder.AppendEqual("A.FProjectID", queryWhere.ProjectID, nameof(queryWhere.ProjectID))
.AppendEqual("A.FServicerID", queryWhere.ServicerID, nameof(queryWhere.ServicerID))
.AppendEqual("A.FDatabeseID", queryWhere.FDatabeseID, nameof(queryWhere.FDatabeseID))
.AppendEqual("A.FSource", queryWhere.Source, nameof(queryWhere.Source))
.AppendEqual("A.FRequestGuid", queryWhere.RequestGuid, nameof(queryWhere.RequestGuid))
.AppendMoreThanOrEqual("A.FTimeElapsed", queryWhere.MinTimeElapsed, nameof(queryWhere.MinTimeElapsed))
.AppendLessThan("A.FTimeElapsed", queryWhere.MaxTimeElapsed, nameof(queryWhere.MaxTimeElapsed))
.AppendMoreThanOrEqual("A.FExecutedTime", queryWhere.ExecuteTimeStart, nameof(queryWhere.ExecuteTimeStart))
.AppendLessThan("A.FExecuteTime", queryWhere.ExecuteTimeEndValue, nameof(queryWhere.ExecuteTimeEndValue))
;
string selectTable = $"{TABLE_NAME_RUNTIMESQL} A {SQLSERVER_WITHNOLOCK} LEFT JOIN {TABLE_NAME_SERVCER} B {SQLSERVER_WITHNOLOCK} ON A.FServicerID=B.FID AND B.FIsDeleted=0";
const string selectColumn = "A.FID,A.FProjectName,B.FName AS FServicerName,A.FDatabaseName,A.FSqlDbType,A.FSqlText,A.FMemberName,A.FRequestGuid,A.FTimeElapsed,A.FSource,A.FIsSuccess,A.FExecutedTime";
const string order = "A.FExecutedTime DESC";
return(QueryPageListAsync <RuntimeSqlListDto>(selectColumn, selectTable, whereBuilder.ToString(), order, queryWhere.PageIndex, queryWhere.PageSize, cmdParms: queryWhere));
}
/// <summary>
/// 加载sql运行列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public Task <OperateResult <IPageResult <RuntimeSqlListDto> > > GetRuntimSqlListAsync(RuntimeSqlPageQueryWhere queryWhere)
{
return(OperateUtil.ExecuteAsync(async() =>
{
return await _runtimeSqlRepository.GetRuntimSqlListAsync(queryWhere);
}));
}
