public ContentResult mail(MailQueryRequest request) { var userContext = UserContext.WebUserContext; if (userContext == null) { var res = new ResultDto <MailResponse> { page = request.PageIndex, total = request.Total, records = request.Records, rows = null }; return(Content(res.Serialize())); } else { request.MemberId = UserContext.WebUserContext.Id; var data = _mailService.List(request); var res = new ResultDto <MailResponse> { page = request.PageIndex, total = request.Total, records = request.Records, rows = data }; return(Content(res.Serialize())); } }
// 站内信列表 public List <MailResponse> List(MailQueryRequest request) { List <MailResponse> list = new List <MailResponse>(); try { var sql = $@"select a.*,b.Head from t_sys_mail a left join t_member b on a.sendMemberId=b.id where a.isdelete=0 and a.memberId={request.MemberId} order by a.createtime desc"; int totalCount = 0; list = _dbContext.Page <MailResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request); request.Records = totalCount; } catch (Exception ex) { LogUtils.LogError("MailService.List", ex); } return(list); }