public ContentResult listrefereesignup(EventRefereeSignUpQueryRequest request)
{
request.MemberId = UserContext.WebUserContext.Id;
var data = _refereeSignUpService.EventRefereeList(request);
var res = new ResultDto <EventRefereeSignUpListResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}
//裁判申请列表
public List <EventRefereeSignUpListResponse> EventRefereeList(EventRefereeSignUpQueryRequest request)
{
List <EventRefereeSignUpListResponse> list = new List <EventRefereeSignUpListResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.KeyValue.IsNotEmpty())
{
request.KeyValue = $"%{request.KeyValue}%";
join.Append(" and (b.code like @KeyValue or b.completename like @KeyValue)");
}
if (request.RefereeSignUpStatus != null && request.RefereeSignUpStatus > 0)
{
if ((int)request.RefereeSignUpStatus == 9)//临时裁判
{
join.Append($" and a.isTemp=1 ");
}
else if ((int)request.RefereeSignUpStatus == 8)//标记
{
join.Append($" and a.isFlag=1 ");
}
else
{
join.Append(" and a.refereeSignUpStatus=@RefereeSignUpStatus ");
}
}
var sql = $@"select a.*,b.code MemberCode,b.completename MemberName,c.account Email,b.contactmobile ContactMobile from t_event_referee_signup a
inner join t_member_referee b on a.memberId=b.memberId
inner join t_member c on a.memberId=c.id
inner join t_event d on a.eventId=d.id
where a.isdelete=0 and b.isdelete=0 and c.isdelete=0 and d.isdelete=0
and d.memberId=@MemberId and a.eventId=@EventId
{join.ToString()} order by a.createtime desc
";
int totalCount = 0;
list = _dbContext.Page <EventRefereeSignUpListResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("RefereeSignUpService.EventRefereeList", ex);
}
return(list);
}
