public List <MemberOperLogResponse> List(MemberOperLogQueryRequest request) { List <MemberOperLogResponse> list = new List <MemberOperLogResponse>(); try { StringBuilder join = new StringBuilder(); if (request.OperData.IsNotEmpty()) { request.OperData = $"%{request.OperData}%"; join.Append(" and a.operdata like @OperData"); } if (request.CreateStart.HasValue) { join.Append(" and a.createtime >= @CreateStart"); } if (request.CreateEnd.HasValue) { request.CreateEnd = request.CreateEnd.Value.AddDays(1).AddSeconds(-1); join.Append(" and a.createtime<=@CreateEnd"); } var sql = $@"select a.*,b.account from t_member_operlog a inner join t_member b on a.memberId=b.id where isdelete=0 {join.ToString()} order by a.createtime desc"; int totalCount = 0; list = _dbContext.Page <MemberOperLogResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request); request.Records = totalCount; } catch (Exception ex) { LogUtils.LogError("MemberOperLogService.List", ex); } return(list); }
public ContentResult memberoperloglist(MemberOperLogQueryRequest request) { var data = _memberOperLogService.List(request); var res = new ResultDto <MemberOperLogResponse> { page = request.PageIndex, total = request.Total, records = request.Records, rows = data }; return(Content(res.Serialize())); }