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);
}
