//临时裁判绑定 public bool BindTempReferee(BindTempRefereeRequest request, out string msg) { bool flag = false; msg = string.Empty; try { //校验数据的真实性 if (request.TempRefereeNum.IsEmpty()) { msg = "临时裁判编码不能为空"; return(flag); } if (request.ContactMobile.IsEmpty()) { msg = "手机号码不能为空"; return(flag); } var data = _dbContext.Select <t_member_temp>(c => c.contactmobile == request.ContactMobile && c.code == request.TempRefereeNum && c.tempType == Model.enums.TempTypeEm.临时裁判 && c.tempStatus == TempStatusEm.待绑定).FirstOrDefault(); if (data == null) { msg = "数据不存在或已绑定过,请核对后再操作"; return(flag); } t_event t_event = _dbContext.Get <t_event>(data.eventId); if (t_event.eventStatus != EventStatusEm.比赛完成) { msg = "赛事未完成不能进行绑定"; return(flag); } try { _dbContext.BeginTransaction(); t_member_points points = _dbContext.Select <t_member_points>(c => c.memberId == data.memberId).FirstOrDefault(); _dbContext.Execute($"update t_member_points set playerPoints=playerPoints+{points.playerPoints},coachPoints=coachPoints+{points.coachPoints},refereePoints=refereePoints+{points.refereePoints} where memberId={request.MemberId}"); _dbContext.Execute($"update t_member_temp set tomemberId={request.MemberId},updateTime='{DateTime.Now}',tempStatus={(int)TempStatusEm.已绑定} where id={data.id}"); _dbContext.Execute($"update t_member_points_record set memberId={request.MemberId} where memberId={data.memberId} and isdelete=0"); _dbContext.Execute($"update t_event_referee_signup set memberId={request.MemberId} where memberId={data.memberId} and isdelete=0"); _dbContext.Execute($"update t_event_cycling_match set refereeId={request.MemberId} where refereeId={data.memberId} and isdelete=0"); _dbContext.Execute($"update t_event_cycling_match_playerresult set refereeId={request.MemberId} where refereeId={data.memberId} and isdelete=0"); _dbContext.CommitChanges(); flag = true; } catch (Exception ex) { _dbContext.Rollback(); LogUtils.LogError("MemberTempService.BindTempRefereeTran", ex); } } catch (Exception ex) { LogUtils.LogError("MemberTempService.BindTempReferee", ex); } return(flag); }
public ContentResult bindreferee(BindTempRefereeRequest request) { request.MemberId = UserContext.WebUserContext.Id; string msg = string.Empty; var flag = _memberTempService.BindTempReferee(request, out msg); return(Result <string>(flag, msg)); }