//选手积分列表 public List <PlayerPointsRecordResponse> PlayerPointsRecord(PlayerPointsRecordQueryRequest request) { List <PlayerPointsRecordResponse> list = new List <PlayerPointsRecordResponse>(); try { StringBuilder sqljoin = new StringBuilder(); if (request.StartDate != null) { sqljoin.Append(" and a.createtime>=@StartDate "); } if (request.EndDate != null) { request.EndDate = request.EndDate.Value.AddDays(1).AddSeconds(-1); sqljoin.Append(" and a.createtime<=@EndDate "); } var sql = $@"select b.name EventName,b.code EventCode,a.points,a.Id,c.name EventGroupName,b.eventType EventType,b.eventTypeName EventTypeName from t_member_points_record a inner join t_event b on a.eventId=b.id inner join t_event_group c on a.eventGroupId=c.id where a.isdelete=0 and a.memberId=@memberId {sqljoin.ToString()} order by a.createtime desc "; int totalCount = 0; list = _dbContext.Page <PlayerPointsRecordResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request); request.Records = totalCount; } catch (Exception ex) { LogUtils.LogError("MemberPointsService.PlayerPointsRecord", ex); } return(list); }
public ContentResult pointsrecord(PlayerPointsRecordQueryRequest request) { request.MemberId = UserContext.WebUserContext.Id; var data = _memberPointsService.PlayerPointsRecord(request); var res = new ResultDto <PlayerPointsRecordResponse> { page = request.PageIndex, total = request.Total, records = request.Records, rows = data }; return(Content(res.Serialize())); }
//选手积分列表(返回总积分) public List <PlayerPointsRecordResponse> PlayerPointsRecord(PlayerPointsRecordQueryRequest request, out decimal totalPoints) { totalPoints = 0m; List <PlayerPointsRecordResponse> list = new List <PlayerPointsRecordResponse>(); try { StringBuilder sqljoin = new StringBuilder(); if (request.StartDate != null) { sqljoin.Append(" and createtime>=@StartDate "); } if (request.EndDate != null) { request.EndDate = request.EndDate.Value.AddDays(1).AddSeconds(-1); sqljoin.Append(" and createtime<=@EndDate "); } var sqlTotalPoints = $@"select IFNULL(sum(points),0) from t_member_points_record where memberId=@MemberId and isdelete=0 {sqljoin.ToString()}"; totalPoints = _dbContext.ExecuteScalar(sqlTotalPoints, request).ToObjDecimal(); if (totalPoints > 0)//有积分再查询列表 { var sql = $@"select b.starteventtime StartDate,b.endeventtime EndDate,b.name EventName, a.points,c.name ProvinceName,d.name CityName,a.Id from t_member_points_record a inner join t_event b on a.eventId=b.id left join t_sys_province c on b.provinceId=c.id left join t_sys_city d on b.cityId = d.id where a.isdelete=0 and a.memberId=@memberId {sqljoin.ToString()} order by a.createtime desc "; int totalCount = 0; list = _dbContext.Page <PlayerPointsRecordResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request); request.Records = totalCount; } } catch (Exception ex) { LogUtils.LogError("MemberPointsService.PlayerPointsRecord", ex); } return(list); }