public ContentResult listevent(PlayerOrRefereeEventQueryRequest request) { var data = _eventService.PlayerOrRefereeEvent(request); var res = new ResultDto <PlayerOrRefereeEventResponse> { page = request.PageIndex, total = request.Total, records = request.Records, rows = data }; return(Content(res.Serialize())); }
//选手 裁判查询赛事列表 public List <PlayerOrRefereeEventResponse> PlayerOrRefereeEvent(PlayerOrRefereeEventQueryRequest request) { List <PlayerOrRefereeEventResponse> list = new List <PlayerOrRefereeEventResponse>(); try { StringBuilder join = new StringBuilder(); if (request.ProvinceId.HasValue && request.ProvinceId > 0) { join.Append(" and a.provinceId=@ProvinceId "); } if (request.CityId.HasValue && request.CityId > 0) { join.Append(" and a.cityId=@CityId "); } if (request.EventLevel.HasValue && request.EventLevel > 0) { join.Append(" and a.eventLevel=@EventLevel "); } if (request.StartDate.HasValue) { DateTime dt = Convert.ToDateTime(request.StartDate); join.Append($" and a.starteventdate >='{Utility.FirstDayOfMonth(dt).ToShortDateString()}' and a.starteventdate<='{Utility.LastDayOfMonth(dt).ToShortDateString()}'"); } var sql = $@"select a.id EventId,a.code EventCode, a.name EventName,a.eventType EventType, a.eventLevel EventLevel, a.signfee SignFee, a.eventStatus EventStatus,a.starteventdate StartEventDate, a.endsigndate EndSignDate, b.name ProvinceName,c.name CityName from t_event a left join t_sys_province b on a.provinceId=b.id left join t_sys_city c on a.cityId=c.id where a.isdelete=0 and a.eventStatus in ({ParamsConfig._eventstatus}) {join.ToString()} order by a.createtime desc"; int totalCount = 0; list = _dbContext.Page <PlayerOrRefereeEventResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request); if (list != null && list.Count > 0) { foreach (var item in list) { if (item.EventStatus == EventStatusEm.审核中 || item.EventStatus == EventStatusEm.拒绝) { item.Visiable = 1; continue; } if (item.EventStatus == EventStatusEm.停止报名) { item.Visiable = 2; continue; } if (DateTime.Now > item.EndSignDate) { item.Visiable = 2; continue; } item.Visiable = 3; } } request.Records = totalCount; } catch (Exception ex) { LogUtils.LogError("EventService.PlayerOrRefereeEvent", ex); } return(list); }