/// <summary>
/// 加载警告日志列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public async Task <IActionResult> Index(WarningLogPageQueryWhere queryWhere)
{
var operateResult = await _warningLogApplication.GetWarningLogListAsync(queryWhere);
ViewBag.QueryWhere = queryWhere;
return(View(operateResult.Value));
}
/// <summary>
/// 异步查找警告日志列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns>警告日志列表</returns>
public Task <IPageResult <WarningLogListDto> > GetWarningLogListAsync(WarningLogPageQueryWhere queryWhere)
{
SqlWhereBuilder whereBuilder = new SqlWhereBuilder("A.FIsDeleted=0", ReaderDataType);
whereBuilder.AppendEqual("B.FProjectID", queryWhere.ProjectID, nameof(queryWhere.ProjectID))
.AppendEqual("B.FServicerID", queryWhere.ServicerID, nameof(queryWhere.ServicerID))
.AppendLike("B.FCallMemberName", queryWhere.CallMethodName, nameof(queryWhere.CallMethodName))
.AppendEqual("B.FSource", queryWhere.Source, nameof(queryWhere.Source))
.AppendEqual("B.FRequestGuid", queryWhere.RequestGuid, nameof(queryWhere.RequestGuid))
.AppendEqual("A.FNoticeState", queryWhere.NoticeState, nameof(queryWhere.NoticeState))
.AppendEqual("A.FDealState", queryWhere.DealState, nameof(queryWhere.DealState))
;
string selectTable = $"{TABLE_NAME_WARNINGLOG} A {SQLSERVER_WITHNOLOCK} {LeftJoin} {TABLE_NAME_RUNTIMELOG} B {SQLSERVER_WITHNOLOCK} {On} A.FRunTimeLogID=B.FID {LeftJoin} {TABLE_NAME_SERVCER} C {SQLSERVER_WITHNOLOCK} {On} C.FID=B.FServicerID AND C.FIsDeleted=0";
const string selectColumn = "A.FID,A.FOperateAdvice,a.FTreatmentScheme,A.FNoticeState,A.FDealState,ISNULL(A.FLastModifyTime,A.FCreateTime) FLastModifyTime,B.FLogLevel,B.FCallMemberName,B.FContent,B.FSource,B.FExecuteTime,B.FRequestGuid,B.FProjectName,C.FName AS FServicerName ";
const string order = "A.FDealState,ISNULL(A.FLastModifyTime,A.FCreateTime)";
return(QueryPageListAsync <WarningLogListDto>(selectColumn, selectTable, whereBuilder.ToString(), order, queryWhere.PageIndex, queryWhere.PageSize, cmdParms: queryWhere));
}
/// <summary>
/// 异步查找警告日志列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns>警告日志列表</returns>
public Task <OperateResult <IPageResult <WarningLogListDto> > > GetWarningLogListAsync(WarningLogPageQueryWhere queryWhere)
{
return(OperateUtil.ExecuteAsync(() =>
{
return _warningLogRepository.GetWarningLogListAsync(queryWhere);
}, callMemberName: "WarningLogApplication-GetWarningLogListAsync"));
}
