public bool Edit(CountryRequest request, int sysUserId, out string msg) { bool flag = false; msg = string.Empty; try { if (request.Name.IsEmpty()) { msg = "名称不能为空"; return(flag); } t_sys_country country = _dbContext.Get <t_sys_country>(request.Id); if (country != null) { country.name = request.Name; _dbContext.Update(country); flag = true; } else { msg = "数据信息不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("CountryService.Edit", ex); } return(flag); }
//1.1 处理留言 public bool Process(int id, int sysUserId, out string msg) { bool flag = false; msg = string.Empty; try { var detail = _dbContext.Get <t_sys_leavingmsg>(id); if (detail != null) { detail.leavingStatus = LeavingStatusEm.已处理; detail.updatetime = DateTime.Now; _dbContext.Update(detail); flag = true; } else { msg = "数据不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("LeavingMsgService.Insert", ex); } return(flag); }
//删除学校 public bool Delete(int id, int sysUserId, out string msg) { bool flag = false; msg = string.Empty; try { var school = _dbContext.Get <t_sys_school>(id); if (school != null) { school.isdelete = true; school.updatetime = DateTime.Now; _dbContext.Update(school); flag = true; } else { msg = "学校信息不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("SchoolService.Delete", ex); } return(flag); }
public bool Edit(ProvinceRequest request, int sysUserId, out string msg) { bool flag = false; msg = string.Empty; try { if (request.Name.IsEmpty()) { msg = "名称不能为空"; return(flag); } t_sys_province province = _dbContext.Get <t_sys_province>(request.Id); if (province != null) { province.name = request.Name; province.isInter = request.IsInter; province.updatetime = DateTime.Now; _dbContext.Update(province); flag = true; } else { msg = "数据信息不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("ProvinceService.Edit", ex); } return(flag); }
public bool Edit(MemberTrainerRequest request, out string msg) { bool flag = false; msg = string.Empty; try { var memberTrainer = _dbContext.Get <t_member_trainer>(request.Id); if (memberTrainer != null && memberTrainer.memberId == request.MemberId) { memberTrainer.objMemberId = request.ObjMemberId; memberTrainer.startdate = request.StartDate; memberTrainer.enddate = request.EndDate; memberTrainer.memberTrainerStatus = MemberTrainerStatusEm.待确认; memberTrainer.updatetime = DateTime.Now; _dbContext.Update(memberTrainer); } else { msg = "数据不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("MemberTrainerService.Edit", ex); } return(flag); }
//删除资料 public bool Delete(int id, int sysUserId, out string msg) { bool flag = false; msg = string.Empty; try { var detail = _dbContext.Get <t_sys_datasource>(id); if (detail != null) { detail.isdelete = true; detail.updatetime = DateTime.Now; _dbContext.Update(detail); flag = true; } else { msg = "数据不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("DataSourceService.Delete", ex); } return(flag); }
//1.1 修改教育经历 public bool Edit(MemberEduExperRequest request, out string msg) { bool flag = false; msg = string.Empty; try { var membereduexper = _dbContext.Get <t_membereduexper>(request.Id); if (membereduexper != null) { membereduexper.schoolId = request.SchoolId; membereduexper.startdate = request.StartDate; membereduexper.enddate = request.EndDate; membereduexper.reserveName = request.ReserveName; membereduexper.updatetime = DateTime.Now; _dbContext.Update(membereduexper); } else { msg = "教育经历不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("MemberEduExperService.Edit", ex); } return(flag); }
//临时裁判绑定 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 OrderDetailResponse Detail(int id) { OrderDetailResponse response = null; try { t_order order = _dbContext.Get <t_order>(id); if (order != null) { response = new OrderDetailResponse { CreateTime = order.createtime, Id = order.id, IsNeedInvoice = order.isNeedInvoice, MainOrderId = order.mainOrderId, MemberId = order.memberId, Money = order.money, OrderStatus = order.orderStatus, OrderType = order.orderType, PayExpiryDate = order.payExpiryDate, Remark = order.remark, TotalCoupon = order.totalcoupon, TotalDiscount = order.totaldiscount, SourceId = order.sourceId, UpdateTime = order.updatetime }; var data = _dbContext.Select <t_order_detail>(c => c.orderId == id).ToList(); if (data != null && data.Count > 0) { foreach (var item in data) { response.OrderDetail.Add(new OrderDetail { Id = item.id, Coupon = item.coupon, UpdateTime = item.updatetime, CreateTime = item.createtime, DiscountPrice = item.discountprice, MemberId = item.memberId, Money = item.money, Name = item.name, Number = item.number, OrderId = item.orderId, ProductId = item.productId, UnitPrice = item.unitprice }); } } } } catch (Exception ex) { LogUtils.LogError("OrderService.RefundList", ex); } return(response); }
//编辑奖项 public bool Edit(EventPrizeRequest request, out string msg) { bool flag = false; msg = string.Empty; try { if (request.Name.IsEmpty()) { msg = "奖项名称不能为空"; return(flag); } if (request.Num.IsEmpty()) { msg = "获奖队伍/会员编号不能为空"; return(flag); } if (request.PrizeType == Model.enums.PrizeTypeEm.个人) { //查询会员编号是否正确 } else { //查询队伍编码是否正确 } var eventPrize = _dbContext.Get <t_event_prize>(request.Id); if (eventPrize != null) { eventPrize.remark = request.Remark; eventPrize.name = request.Name; eventPrize.prizeType = request.PrizeType; eventPrize.num = request.Num; eventPrize.updatetime = DateTime.Now; _dbContext.Update(eventPrize); flag = true; } else { msg = "未找到奖项信息"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("EventPrizeService.Edit", ex); } return(flag); }
//裁判 选手签到 public bool Sign(int id, int memberId, out string msg) { bool flag = false; msg = string.Empty; try { t_event_sign eventsign = _dbContext.Get <t_event_sign>(id); if (eventsign == null || eventsign.memberId != memberId || eventsign.isStop) { msg = "签到信息有误"; } else { eventsign.signtime = DateTime.Now; eventsign.eventSignStatus = EventSignStatusEm.已签到; _dbContext.Update(eventsign); flag = true; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("EventSignService.Sign", ex); } return(flag); }
//申请当裁判 public bool Apply(int eventId, int memberId, out string msg) { bool flag = false; msg = string.Empty; try { if (eventId <= 0) { msg = "请选择赛事"; return(flag); } t_event t_event = _dbContext.Get <t_event>(eventId); if (t_event != null && t_event.eventStatus != EventStatusEm.审核中 && t_event.eventStatus != EventStatusEm.拒绝 && t_event.endsigndate > DateTime.Now) { var data = _dbContext.Select <t_event_referee_signup>(c => c.eventId == eventId && c.memberId == memberId).ToList(); if (data != null && data.Count > 0) { msg = "您已提交过申请"; return(flag); } _dbContext.Insert(new t_event_referee_signup { eventId = eventId, isTemp = false, memberId = memberId, eventGroupId = 0, refereeSignUpStatus = RefereeSignUpStatusEm.待审核, isFlag = false }); flag = true; } else { msg = "赛事有误"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("RefereeSignUpService.Apply", ex); } return(flag); }
//修改教育经历 public bool Edit(PlayerEduRequest request, out string msg) { bool flag = false; msg = string.Empty; try { if (request.SchoolId <= 0) { msg = "请选择学校"; return(flag); } if (request.StartDate.IsEmpty()) { msg = "请选择开始时间"; return(flag); } var playerEdu = _dbContext.Get <t_player_edu>(request.Id); if (playerEdu != null) { playerEdu.schoolId = request.SchoolId; playerEdu.startdate = request.StartDate; playerEdu.enddate = request.EndDate; playerEdu.updatetime = DateTime.Now; _dbContext.Update(playerEdu); flag = true; } else { msg = "教育经历不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("PlayerEduService.Edit", ex); } return(flag); }
//替换教室 public bool ReplaceRoom(int cyclingMatchId, int roomId, int memberId, out string msg) { bool flag = false; msg = string.Empty; try { t_event_cycling_match tmatch = _dbContext.Get <t_event_cycling_match>(cyclingMatchId); if (tmatch != null) { t_event_room room = _dbContext.Get <t_event_room>(roomId); if (room != null && room.roomStatus == RoomStatusEm.闲置) { tmatch.roomId = roomId; tmatch.updatetime = DateTime.Now; _dbContext.Update(tmatch); flag = true; } else { msg = "教室信息有误"; } } else { msg = "对垒信息有误"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("EventCyclingMatchService.ReplaceRoom", ex); } return(flag); }
//编辑绑定教练/学生 public bool Edit(PlayerCoachRequest request, out string msg) { bool flag = false; msg = string.Empty; try { if (request.StartDate.IsEmpty()) { msg = "开始时间不能为空"; return(flag); } var playerCoach = _dbContext.Get <t_player_coach>(request.Id); if (playerCoach != null && playerCoach.memberId == request.MemberId) { playerCoach.startdate = request.StartDate; playerCoach.enddate = request.EndDate; playerCoach.playerCoachStatus = PlayerCoachStatusEm.待同意; playerCoach.updatetime = DateTime.Now; _dbContext.Update(playerCoach); flag = true; } else { msg = "数据不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("PlayerCoachService.Edit", ex); } return(flag); }
// 支付回调 public void Callback(int orderId, string paytransaction) { try { var order = _dbContext.Get <t_order>(orderId); if (order != null && (order.orderStatus == OrderStatusEm.等待支付 || order.orderStatus == OrderStatusEm.支付失败)) { try { _dbContext.BeginTransaction(); //修改订单状态 order.orderStatus = OrderStatusEm.支付成功; order.updatetime = DateTime.Now; _dbContext.Update(order); //修改支付流水信息 _dbContext.Execute($"update t_order_paylog set paytransaction='{paytransaction}',notifyTime='{DateTime.Now}',payStatus={(int)PayStatusEm.支付成功} where orderId={orderId} and isdelete=0"); _dbContext.CommitChanges(); Task.Factory.StartNew(() => { if (order.orderType == OrderTypeEm.实名认证) { _memberService.CallBack(order.memberId); } else if (order.orderType == OrderTypeEm.临时选手绑定) { _memberTempService.Callback(order.memberId, order.sourceId); } else if (order.orderType == OrderTypeEm.赛事报名) { _playerSignUpService.Callback(order.memberId, order.sourceId); } }); } catch (Exception ex) { LogUtils.LogError("PayCallBackService.CallbackTran", ex); _dbContext.Rollback(); } } } catch (Exception ex) { LogUtils.LogError("PayCallBackService.Callback", ex); } }
//选手积分详情 public List <PlayerPointsRecordDetailResponse> PointsRecordDetail(int recordId, int memberId) { //参照赛果 List <PlayerPointsRecordDetailResponse> list = new List <PlayerPointsRecordDetailResponse>(); try { var record = _dbContext.Get <t_member_points_record>(recordId); if (record != null && memberId == record.memberId) { //根据赛事 组别 选手id 查询此次比赛获奖次数 } } catch (Exception ex) { LogUtils.LogError("MemberPointsService.PointsRecordDetail", ex); } return(list); }
//新增教室 public bool Insert(EventRoomRequest request, out string msg) { bool flag = false; msg = string.Empty; try { if (request.Name.IsEmpty()) { msg = "教室名不能为空"; return(flag); } if (request.EventId <= 0) { msg = "赛事信息有误"; return(flag); } //教练赛事 t_event t_event = _dbContext.Get <t_event>(request.EventId); if (t_event == null) { msg = "赛事信息有误"; return(flag); } _dbContext.Insert(new t_event_room { eventgroupId = request.EventGroupId, code = _dataRepository.EventRoomRepo.RenderCode(request.EventId), eventId = request.EventId, roomStatus = RoomStatusEm.闲置, name = request.Name }); flag = true; } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("EventRoomService.Insert", ex); } return(flag); }
//1.2 修改 public bool Edit(SysUserRequest request, int sysUserId, out string msg) { bool flag = false; msg = string.Empty; try { if (request.Account.IsEmpty()) { msg = "账号不能为空"; return(flag); } if (request.Name.IsEmpty()) { msg = "姓名不能为空"; return(flag); } var sysuser = _dbContext.Get <t_sys_user>(request.Id); if (sysuser != null) { sysuser.name = request.Name; sysuser.mobile = request.Mobile; sysuser.updatetime = DateTime.Now; _dbContext.Update(sysuser); flag = true; } else { msg = "管理员信息不存在"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("SysUserService.Edit", ex); } return(flag); }
//编辑赛事 public bool Edit(EventRequest request, out string msg) { bool flag = false; msg = string.Empty; try { if (request.Name.IsEmpty()) { msg = "赛事名不能为空"; return(flag); } if (request.EventDate == null || request.EventDate.Count == 0) { msg = "请设置赛事时间"; return(flag); } request.EventDate = request.EventDate.Distinct().OrderBy(c => true).ToList(); request.StartEventDate = request.EventDate.FirstOrDefault(); if (request.StartEventDate == DateTime.MinValue || request.StartEventDate == DateTime.MaxValue) { msg = "赛事开始时间有误"; return(flag); } request.EndEventDate = request.EventDate.LastOrDefault(); if (request.EndEventDate == DateTime.MinValue || request.EndEventDate == DateTime.MaxValue) { msg = "赛事结束时间有误"; return(flag); } if (request.StartEventDate > request.EndEventDate) { msg = "赛事结束时间不能早于开始时间"; return(flag); } if (request.EndRefundDate > request.EndEventDate) { msg = "退费截止日期不能超过赛事结束日期"; } if (request.Maxnumber <= 0) { msg = "报名队伍上限有误"; return(flag); } if (request.EventType <= 0 || request.EventTypeName <= 0) { msg = "请选择赛事类型"; return(flag); } if (request.Address.IsEmpty()) { msg = "赛事地址不能为空"; return(flag); } t_event tevent = _dbContext.Get <t_event>(request.Id); if (tevent != null && tevent.memberId == request.MemberId) { try { _dbContext.BeginTransaction(); tevent.address = request.Address; tevent.cityId = request.CityId; tevent.endeventdate = request.EndEventDate; tevent.endrefunddate = request.EndRefundDate; tevent.endsigndate = request.EndSignDate; tevent.remark = request.Remark; tevent.eventStatus = tevent.eventStatus == EventStatusEm.拒绝 ? EventStatusEm.审核中 : tevent.eventStatus; tevent.eventType = request.EventType; tevent.filepath = request.Filepath; tevent.isInter = request.IsInter; tevent.maxnumber = request.Maxnumber; tevent.starteventdate = request.StartEventDate; tevent.memberId = request.MemberId; tevent.name = request.Name; tevent.provinceId = request.ProvinceId; tevent.signfee = request.Signfee; tevent.eventTypeName = request.EventTypeName; tevent.updatetime = DateTime.Now; _dbContext.Update(tevent); _dbContext.Execute($"delete from t_event_matchdate where eventId={request.Id}"); foreach (var item in request.EventDate) { _dbContext.Insert(new t_event_matchdate { eventId = request.Id, eventMatchDate = item }); } _dbContext.CommitChanges(); flag = true; } catch (Exception ex) { _dbContext.Rollback(); flag = false; msg = "服务异常"; LogUtils.LogError("EventService.EditTran", ex); } } else { msg = "未找到赛事信息"; } } catch (Exception ex) { flag = false; msg = "服务异常"; LogUtils.LogError("EventService.Edit", ex); } return(flag); }