//临时裁判数据列表
public List <MemberTempResponse> ListReferee(TempMemberQueryRequest request)
{
List <MemberTempResponse> list = new List <MemberTempResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.TempStatus.HasValue && request.TempStatus > 0)
{
join.Append(" and a.tempStatus=@TempStatus");
}
if (request.TempType.HasValue && request.TempType > 0)
{
join.Append(" and a.tempType=@TempType");
}
var sql = $@"select a.*,b.completename MemberName,c.name EventName from t_member_temp a
inner join t_member_referee b on a.memberId=b.memberId
inner join t_event c on a.eventId=c.Id
where a.isdelete=0 {join.ToString()} order by a.createtime
";
int totalCount = 0;
list = _dbContext.Page <MemberTempResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("MemberTempService.ListReferee", ex);
}
return(list);
}
public ContentResult listtempplayer(TempMemberQueryRequest request)
{
var data = _memberTempService.ListPlayer(request);
var res = new ResultDto <MemberTempResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}