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