public ContentResult eventscorelist(PlayerEventScoreQueryRequest request)
{
request.MemberId = UserContext.WebUserContext.Id;
var data = _eventScoreService.PlayerList(request);
var res = new ResultDto <EventScoreResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}
//评分单下载
public List <EventScoreResponse> PlayerList(PlayerEventScoreQueryRequest request)
{
List <EventScoreResponse> list = new List <EventScoreResponse>();
try
{
var sql = $@"select * from t_event_score where isdelete=0 and
eventGroupId in (select eventGroupId from t_event_player_signup where memberId=@MemberId and signUpStatus in ({ParamsConfig._signup_in})) order by createtime desc";
int totalCount = 0;
list = _dbContext.Page <EventScoreResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("EventScoreService.PlayerList", ex);
}
return(list);
}
