//选手积分列表
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);
}
