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); }