public ContentResult signuplist(RefereeSignUpQueryRequest request)
{
request.MemberId = UserContext.WebUserContext.Id;
var data = _refereeSignUpService.RefereeSignUpList(request);
var res = new ResultDto <RefereeSignUpListResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}
//裁判报名列表
public List <RefereeSignUpListResponse> RefereeSignUpList(RefereeSignUpQueryRequest request)
{
List <RefereeSignUpListResponse> list = new List <RefereeSignUpListResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.ProvinceId.HasValue && request.ProvinceId > 0)
{
join.Append(" and b.provinceId=@ProvinceId ");
}
if (request.CityId.HasValue && request.CityId > 0)
{
join.Append(" and b.cityId=@CityId ");
}
if (request.StartDate.HasValue)
{
DateTime dt = Convert.ToDateTime(request.StartDate);
join.Append($" and b.starteventdate >='{Utility.FirstDayOfMonth(dt).ToShortDateString()}' and b.starteventdate<='{Utility.LastDayOfMonth(dt).ToShortDateString()}'");
}
var sql = $@"select b.starteventdate StartEventDate,b.eventLevel EventLevel,a.id Id,b.id EventId,b.name EventName,b.code EventCode,refereeSignUpStatus,
b.EventType,c.name ProvinceName,d.name CityName
from t_event_referee_signup 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 b.isdelete=0
and a.memberId=@MemberId {join.ToString()} order by a.createtime desc
";
int totalCount = 0;
list = _dbContext.Page <RefereeSignUpListResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("RefereeSignUpService.RefereeSignUpList", ex);
}
return(list);
}
