/// <summary> /// 加载运行日志列表 /// </summary> /// <param name="queryWhere">查询条件</param> /// <returns></returns> public async Task <IActionResult> Index(RuntimeLogPageQueryWhere queryWhere) { var operateResult = await _runtimeLogApplication.GetRuntimeLogListAsync(queryWhere); ViewBag.QueryWhere = queryWhere; return(View(operateResult.Value)); }
/// <summary> /// 加载运行时日志信息 /// </summary> /// <param name="queryWhere">查询条件</param> /// <returns></returns> public Task <IPageResult <RuntimeLogListDto> > GetRuntimeLogListAsync(RuntimeLogPageQueryWhere queryWhere) { SqlWhereBuilder whereBuilder = new SqlWhereBuilder("A.FIsDeleted=0", ReaderDataType); whereBuilder.AppendEqual("A.FLogLevel", queryWhere.LogLevel, nameof(queryWhere.LogLevel)) .AppendEqual("A.FProjectID", queryWhere.ProjectID, nameof(queryWhere.ProjectID)) .AppendEqual("A.FServicerID", queryWhere.ServicerID, nameof(queryWhere.ServicerID)) .AppendEqual("A.FSource", queryWhere.Source, nameof(queryWhere.Source)) .AppendEqual("A.FRequestGuid", queryWhere.RequestGuid, nameof(queryWhere.RequestGuid)) .AppendMoreThanOrEqual("A.FExecuteTime", queryWhere.ExecuteTimeStart, nameof(queryWhere.ExecuteTimeStart)) .AppendLessThan("A.FExecuteTime", queryWhere.ExecuteTimeEndValue, nameof(queryWhere.ExecuteTimeEndValue)) ; string selectTable = $"{TABLE_NAME_RUNTIMELOG} 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.FLogLevel,A.FProjectName,B.FName AS FServicerName,A.FCallMemberName,A.FContent,A.FSource,A.FRequestGuid,A.FExecuteTime,A.FCreateTime"; const string order = "A.FExecuteTime DESC"; return(QueryPageListAsync <RuntimeLogListDto>(selectColumn, selectTable, whereBuilder.ToString(), order, queryWhere.PageIndex, queryWhere.PageSize, cmdParms: queryWhere)); }
/// <summary> /// 加载运行日志列表 /// </summary> /// <param name="queryWhere">查询条件</param> /// <returns></returns> public Task <OperateResult <IPageResult <RuntimeLogListDto> > > GetRuntimeLogListAsync(RuntimeLogPageQueryWhere queryWhere) { return(OperateUtil.ExecuteAsync(() => { return _runtimeLogRepository.GetRuntimeLogListAsync(queryWhere); }, callMemberName: "RuntimeLogApplication-GetRuntimeLogListAsync")); }