public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <GetUserRelatedFilter> >(request); //首先判断手机号是否绑定 var user = UserHelper.GetUserById(req.Filter.UserId); if (string.IsNullOrEmpty(user.Mobile)) { //提示用户先绑定手机(这是重要基础数据) return(ResultHelper.Fail("请先绑定手机")); } //如果有WeiXinTempCode 就获取 unionId if (!string.IsNullOrEmpty(req.Filter.WeiXinTempCode)) { //获取WeiXinUnionId var weiXinUser = SystemHelper.Instance.getWeiXinUserInfo(req.Filter.WeiXinTempCode); if (weiXinUser.unionid == null) { weiXinUser.unionid = ""; } req.Filter.WeiXinUnionId = weiXinUser.unionid; } //检查此qq或微信是否和已有账户绑定 var result = getUserByQQWeiXinId(req); if (result.Entities.Count == 0) { //不存在就绑定到传来的账户上 if (!string.IsNullOrEmpty(req.Filter.QQOpenId)) //qq绑定 { result = updateUserSetOpenId(req); } else if (!string.IsNullOrEmpty(req.Filter.WeiXinUnionId))//微信绑定 { result = updateUserSetUnionId(req); } } else { //存在就提示用户去解除绑定 return(ResultHelper.Fail("已绑定其他账号,绑定失败")); } return(result); }
/// <summary> /// 保存充值配送比率 /// </summary> /// <param name="request">实体VipRechargeScale</param> /// <returns></returns> public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <VipRechargeScale> >(request); var temp = req.Entities.OrderBy(p => p.Min).ToList(); if (temp.Count == 0) { return(ResultHelper.Fail("无数据。")); } for (int i = 0; i < temp.Count; i++) { var obj = temp[i]; if (obj.Min >= obj.Max) { return(ResultHelper.Fail("开始金额必须小于结束金额。")); } if (i > 0 && obj.Min != temp[i - 1].Max + 1) { return(ResultHelper.Fail("开始金额必须等于前一区间的结束金额加1。")); } obj.CreatorId = obj.CreatorId.GetId(); obj.RowState = RowState.Added; if (obj.Id.IsNullOrEmpty()) { obj.TrySetNewEntity(); obj.LastDate = (DateTime)obj.CreateDate; } else { obj.LastDate = DateTime.Now; } } var cmd = CommandHelper.CreateSave(req.Entities); var cmdDelete = CommandHelper.CreateText(FetchType.Execute, "DELETE FROM VipRechargeScale"); cmd.PreCommands = new List <Command> { cmdDelete }; var result = DbContext.GetInstance().Execute(cmd); return(result); }
public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <Guess> >(request); var guess = req.FirstEntity(); Response rsp = ResultHelper.CreateResponse(); //判断庄家的余额是否够 var amount = guess.VictoryDefeatDeclarerDeposit + guess.ScoreDeclarerDeposit;//庄家押的悦豆 int declarerAmount = Convert.ToInt32(amount); if (!GuessHelper.Instance.IsBalanceSufficient(guess.CreatorId, declarerAmount)) { return(ResultHelper.Fail(ErrorCode.YUEDOU_INSUFFICIENT, "没有足够的悦豆余额, 请充值")); } //保存竞猜 List <EntityBase> entites = new List <EntityBase>(); entites.Add(guess); if (guess.RowState == RowState.Added) { guess.State = GuessDic.NotSettlement; guess.TrySetNewEntity(); } //庄家押金相关处理 if (guess.RowState == RowState.Added) { AddDeclarerDeposit(guess); } if (guess.RowState == RowState.Modified) { ModifiedDeclarerDeposit(guess); } //保存竞猜 rsp = DbContext.GetInstance().Execute(CommandHelper.CreateSave(entites)); //保存比分列表 if (guess.GuessType == GuessDic.Score || guess.GuessType == GuessDic.VictoryDefeatAndScore) { rsp = SaveScoreList(guess); } return(rsp); }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <LimitRole> >(request); var obj = req.FirstEntity(); List <EntityBase> entites = new List <EntityBase>(); entites.Add(obj); Response response = null; //string sqlStr = @"INSERT INTO [LimitRole] ([Name], [IsDefault]) VALUES (@name, @default)"; if (obj.RowState == RowState.Added) { obj.SetNewEntity(); obj.IsDefault = false; var cmd = CommandHelper.CreateSave(entites); response = DbContext.GetInstance().Execute(cmd); } else //删除\更新 { string sqlStr = @"SELECT * FROM LimitRole Where Id=@id AND IsDefault=0"; var cmd1 = CommandHelper.CreateText <LimitRole>(FetchType.Fetch, sqlStr); cmd1.Params.Add("@id", obj.Id); var existResult = DbContext.GetInstance().Execute(cmd1); var existObj = existResult.FirstEntity <LimitRole>(); if (existObj != null) { var cmd = CommandHelper.CreateSave(entites); response = DbContext.GetInstance().Execute(cmd); if (RowState.Deleted == obj.RowState)//删除角色时,删除角色用户表中的相应数据 { if (response.IsSuccess) { string delSql = @"DELETE FROM LimitRoleUserMap WHERE RoleId=@id"; var cmd2 = CommandHelper.CreateText <LimitRoleUserMap>(FetchType.Execute, delSql); cmd2.Params.Add("@id", obj.Id); response = DbContext.GetInstance().Execute(cmd2); } } } else { response = ResultHelper.Fail("默认用户不能操作"); } } return(response); }
/// <summary> /// 封闭机构教练处理 /// </summary> /// <param name="obj"></param> /// <returns></returns> public Response SaveSealedOrganizationCoach(Coach obj) { Response rsp = ResultHelper.CreateResponse(); if (IsInYDLAuditFlow(obj.Id)) { return(ResultHelper.Fail("悦动力审核中的教练,不允许添加")); } if (obj.RowState == RowState.Added) { //先删除 rsp = DeleteCoach(obj.Id); if (rsp.IsSuccess) { //后添加 obj.RowState = RowState.Added; rsp = AddCoach(obj); } } else if (obj.RowState == RowState.Modified) { //从数据库查询出原始教练信息 Coach originalCoach = CoachHelper.Instance.GetCoach(obj.Id); //赋新修改的值 originalCoach.HeadUrl = obj.HeadUrl; originalCoach.Name = obj.Name; originalCoach.IdCardBackUrl = obj.IdCardBackUrl; originalCoach.IdCardFrontUrl = obj.IdCardFrontUrl; originalCoach.CardId = obj.CardId; originalCoach.VenueId = obj.VenueId; originalCoach.BeginTeachingDate = obj.BeginTeachingDate; originalCoach.Qualification = obj.Qualification; //先删除 rsp = DeleteCoach(originalCoach.Id); if (rsp.IsSuccess) { //后添加 originalCoach.RowState = RowState.Added; rsp = AddCoach(originalCoach); } } return(rsp); }
public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <CoachApply> >(request); var obj = req.FirstEntity(); //审核中的教练不能再申请 var coacher = GetCoacher(obj.Id); if (coacher.State != null) { if (coacher.State == AuditState.PROCESSING.Id) { return(ResultHelper.Fail("审核中的教练不能再申请")); } } //将之前的拒绝记录删除 DeleteReject(currentUser.Id, coacher.Id); //添加教练申请 List <EntityBase> entites = new List <EntityBase>(); entites.Add(obj); if (obj.RowState == RowState.Added) { obj.State = AuditState.PROCESSING.Id; obj.IsEnabled = true; obj.FileId = Ext.NewId(); obj.OrganizationId = "ydl"; //默认ydl机构, id赋ydl可以关联机构表的预制数据(预制了一个ydl机构) obj.CommissionPercentage = 100; //默认分成比例 obj.CreateDate = DateTime.Now; } obj.SealedOrganizationId = ""; //头像保存 obj.ModifyHeadIcon(); //获取将要保存的图片列表 obj.GetWillSaveFileListByModule(entites, BusinessType.CoachApply.Id); //保存身份证正面反面图片 SaveIdCardImage(obj); var result = DbContext.GetInstance().Execute(CommandHelper.CreateSave(entites)); return(result); }
public JsonResult GameOrderTakeoutSave(List <GameGroup> groups) { try { Request <GameGroup> request = new Request <GameGroup>(); request.Token = CurrentUser.Token; request.Entities = groups; var result = ServiceBuilder.GetInstance().Execute(ServiceType.SaveGameGroup, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <User> >(request); if (req.Filter.Id.IsNotNullOrEmpty() && req.Filter.Mobile.IsNullOrEmpty()) { User temp = UserHelper.GetUserById(req.Filter.Id); if (temp != null) { req.Filter.Mobile = temp.Mobile; } } if (req.Filter.Mobile.IsNotNullOrEmpty()) { ValCode val = new ValCode(); string code = val.CreateValidateCode(4); var cmd = CommandHelper.CreateProcedure(FetchType.Execute, "sp_UpdateValCode"); cmd.Params.Add("@mobile", req.Filter.Mobile); cmd.Params.Add("@code", code); var result = DbContext.GetInstance().Execute(cmd); if (!result.IsSuccess) { return(ResultHelper.Fail("发送验证码失败。")); } var sendResult = SmsHelper.SendValCode(req.Filter.Mobile, code); if (sendResult.result == 0) { return(ResultHelper.Success("发送成功。")); } else { return(ResultHelper.Fail(string.Format("发送验证码失败,错误代码:{0}。", sendResult.errMsg))); } } else { return(ResultHelper.Fail("请输入手机号码。")); } }
public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <CoachCourse> >(request); var obj = req.FirstEntity(); var coachCourse = CoachHelper.Instance.GetCoachCourseById(obj.Id); //课程进行中或已完成, 不能取消 if (coachCourse.State != CoachDic.CourseNotStart) { return(ResultHelper.Fail("课程进行中或已完成, 不能取消!")); } var list = GetPersonInfoListByCourseId(coachCourse.Id);//提前获取到数据不然删除了就没有了 var sql = @" DELETE FROM dbo.CoachCourse WHERE Id=@Id DELETE FROM dbo.CoachCoursePersonInfo WHERE CourseId=@Id "; var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql); cmd.Params.Add("@Id", coachCourse.Id); var result = DbContext.GetInstance().Execute(cmd); //返回余额 if (result.IsSuccess == true) { foreach (var item in list) { //有多少个人头就返回多少次 result = CoachHelper.Instance.AddOne(coachCourse); if (result.IsSuccess == false) { break; } } } if (result.IsSuccess == true) { //极光推送 SendJG(coachCourse.ReservedPersonId, coachCourse.CoachId, currentUser.Id); } return(result); }
private Response UnBindWeiXin(Request <GetUserRelatedFilter> req, User user) { //解绑逻辑: 同UnBindQQ 方法 if (string.IsNullOrEmpty(user.QQOpenId)) { if (string.IsNullOrEmpty(user.Mobile)) { return(ResultHelper.Fail("请绑定手机号后再解绑")); } if (user.Password.Contains("default") && user.Password.Length == 32) { //默认系统生成的密码需要修改 return(ResultHelper.Fail("请修改密码后再解绑")); } } //解绑WeiXin return(updateUserSetUnionId("", req.Filter.UserId)); }
public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <SysDic> >(request); var obj = req.FirstEntity(); if (IsInUse(obj.Id)) { return(ResultHelper.Fail("此技术类别已使用, 不能删除")); } var sql = @"DELETE FROM dbo.SysDic WHERE Id=@Id"; var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql); cmd.Params.Add("@Id", obj.Id); var result = DbContext.GetInstance().Execute(cmd); return(result); }
public JsonResult SelectUserIndexData(string keywords, int pageIndex = 1) { try { Request <GetUserListFilter> request = new Request <GetUserListFilter>(); request.Filter = new GetUserListFilter { Keywords = keywords, PageIndex = pageIndex, PageSize = ViewHelper.PageSize }; request.Token = CurrentUser.Token; var result = ServiceBuilder.GetInstance().Execute(ServiceType.GetUserList, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <GameRankFilter> >(request); Game game = GameHelper.GetSingleGame(req.Filter.GameId); if (game == null || game.KnockoutOption != KnockoutOption.ROUND.Id) { return(ResultHelper.Fail("此比赛不是单循环模式")); } var cmd = CommandHelper.CreateProcedure <GameTeam>(text: "sp_GetGameRankListByOrder"); cmd.Params.Add("@gameId", req.Filter.GameId); cmd.Params.Add("@startOrderNo", req.Filter.StartOrderNo); cmd.Params.Add("@endOrderNo", req.Filter.EndOrderNo); var result = DbContext.GetInstance().Execute(cmd); return(result); }
public JsonResult SameunitSave(GameTeam team) { try { Request <GameTeam> request = new Request <GameTeam>(); request.Token = CurrentUser.Token; request.Entities = new List <GameTeam> { team }; var result = ServiceBuilder.GetInstance().Execute(ServiceType.UpdateGameCorpTeamId, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
/// <summary> /// 自动创建测试参赛队伍 /// </summary> /// <param name="currentUser">忽略</param> /// <param name="request">Request.Game</param> /// <returns>Response.EmptyEntity</returns> public Response Execute(string request) { var app = UserHelper.GetAppVersion(); if (app.IsRelease) { return(ResultHelper.Fail("本功能只能在测试数据库使用。")); } var req = JsonConvert.DeserializeObject <Request <Game> >(request); var cmd = CommandHelper.CreateProcedure(FetchType.Execute, "sp_AutoCreateTestGameTeam"); cmd.Params.Add("@gameId", req.Filter.Id); var result = DbContext.GetInstance().Execute(cmd); return(result); }
public JsonResult GameTeamListData(string gameId, string state = "", int pageIndex = 1) { try { var request = new Request <GetGameTeamListFilter>(); request.Token = CurrentUser.Token; request.Filter = new GetGameTeamListFilter { GameId = gameId, State = state, OnlyNotGroup = false, PageIndex = pageIndex, PageSize = ViewHelper.PageSize }; var result = ServiceBuilder.GetInstance().Execute(ServiceType.GetGameTeamList, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public JsonResult GameListFilter(string gameName, string clubId = "", int pageIndex = 1) { try { Request <GetGameListFilter> request = new Request <GetGameListFilter>(); request.Token = CurrentUser.Token; request.Filter = new GetGameListFilter { ClubId = clubId, GameName = gameName, IsOnlySelf = false, PageIndex = pageIndex, PageSize = ViewHelper.PageSize }; var result = ServiceBuilder.GetInstance().Execute(ServiceType.GetGameList, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public JsonResult GetVenueListByCity(string cityId) { try { Request <GetVenueListFilter> req = new Request <GetVenueListFilter>(); req.Filter = new GetVenueListFilter { Name = string.Empty, CityId = cityId, PageIndex = 1, PageSize = 1000 }; req.Token = CurrentUser.Token; var result = ServiceBuilder.GetInstance().Execute(ServiceType.GetVenueList, req); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public JsonResult GameGroupList(string gameId) { try { Request <GetGameGroupListFilter> request = new Request <GetGameGroupListFilter>(); request.Token = CurrentUser.Token; request.Filter = new GetGameGroupListFilter { GameId = gameId, IsContainMember = false }; var result = ServiceBuilder.GetInstance().Execute(ServiceType.GetGameGroupList, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <User> >(request); var user = req.Entities.FirstOrDefault(); if (user.PayNoPwdAmount < 0) { return(ResultHelper.Fail("免密额度不能为负数。")); } var sql = @"UPDATE dbo.UserAccount SET PayNoPwdAmount=@PayNoPwdAmount WHERE Id=@Id "; var cmd = CommandHelper.CreateText <User>(FetchType.Execute, sql); cmd.Params.Add("@PayNoPwdAmount", user.PayNoPwdAmount); cmd.Params.Add("@Id", user.Id); var result = DbContext.GetInstance().Execute(cmd); return(result); }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <User> >(request); var user = req.Entities.FirstOrDefault(); if (user.Id.IsNullOrEmpty() || user.PayPassword.IsNullOrEmpty()) { return(ResultHelper.Fail("请输入新支付密码。")); } var sql = @"UPDATE dbo.UserAccount SET PayPassword=@PayPassword WHERE Id=@Id "; var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql); cmd.Params.Add("@PayPassword", user.PayPassword); cmd.Params.Add("@Id", user.Id); var result = DbContext.GetInstance().Execute(cmd); return(result); }
/// <summary> /// 场馆签到 /// </summary> /// <param name="request">实体UserSign</param> /// <returns></returns> public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <UserSign> >(request); var obj = req.Entities.FirstOrDefault(); obj.MasterType = obj.MasterType.GetId(); obj.MasterId = obj.MasterId.GetId(); obj.CreatorId = obj.CreatorId.GetId(); obj.TrySetNewEntity(); string errorMsg = ValidateUserSign(obj); if (errorMsg.IsNotNullOrEmpty()) { return(ResultHelper.Fail(errorMsg)); } return(DbContext.GetInstance().Execute(CommandHelper.CreateSave(req.Entities))); }
public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <SysDic> >(request); var obj = req.FirstEntity(); if (CoachHelper.Instance.IsExistCategory(obj)) { return(ResultHelper.Fail("已存在此技术类别名称, 请重新输入一个新的名称")); } var sql = @"UPDATE dbo.SysDic SET Name=@Name WHERE Id=@Id"; var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql); cmd.Params.Add("@Name", obj.Name); cmd.Params.Add("@Id", obj.Id); var result = DbContext.GetInstance().Execute(cmd); return(result); }
public JsonResult TransferSettingsSave(Transfer transfer) { try { transfer.RowState = RowState.Added; Request <Transfer> request = new Request <Transfer>(); request.Token = CurrentUser.Token; request.Entities = new List <Transfer> { transfer }; var result = ServiceBuilder.GetInstance().Execute(ServiceType.SaveTransfer, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public Response GetUserInfo(string userId, string CurrentUserId, string ClubId, string UserCode) { var cmd = CommandHelper.CreateProcedure <User>(text: "sp_GetUser"); cmd.Params.Add(CommandHelper.CreateParam("@userId", userId)); var result = DbContext.GetInstance().Execute(cmd); User user = result.FirstEntity <User>(); if (user == null) { return(ResultHelper.Fail("未找到此用户, 请检测 用户id是否传对")); } user.CityId = user.CityIdCombine; user.IsYDLCoach = CoachHelper.Instance.IsYDLCoach(userId); //处理俱乐部相关 DealClubRelated(user, CurrentUserId, ClubId, UserCode); return(result); }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <Organization> >(request); var obj = req.FirstEntity(); Organization org = OrgHelper.GetOrg(obj.TypeId); if (org.IsDefault) { return(ResultHelper.Fail("默认机构不能修改")); } string sqlStr = @"UPDATE Organization SET Name=@name WHERE TypeId=@typeid"; //obj.RowState = Core.RowState.Modified; //List<EntityBase> entities = new List<EntityBase>(); //entities.Add(obj); //var cmd = CommandHelper.CreateSave(entities); var cmd = CommandHelper.CreateText <Organization>(FetchType.Execute, sqlStr); cmd.Params.Add("@name", obj.Name); cmd.Params.Add("@typeid", obj.TypeId); return(DbContext.GetInstance().Execute(cmd)); }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <Organization> >(request); var obj = req.FirstEntity(); if (string.IsNullOrEmpty(obj.ParentTypeId)) { return(ResultHelper.Fail("上级机构TypeId不能为空")); } if (obj.ParentTypeId == "00000") { return(ResultHelper.Fail("不能添加顶级机构")); } string newTypeId = OrgHelper.GetNewOrgTypeid(obj.ParentTypeId, OrgHelper.GetSonCounter(obj.ParentTypeId)); var cmd = CommandHelper.CreateProcedure <Organization>(FetchType.Execute, "sp_SaveOrg"); cmd.Params.Add("@name", obj.Name); cmd.Params.Add("@typeId", newTypeId); cmd.Params.Add("@parenetTypeId", obj.ParentTypeId); return(DbContext.GetInstance().Execute(cmd)); }
public JsonResult GameTeamUpdateSave(GameTeam team) { try { team.RowState = RowState.Modified; Request <GameTeam> request = new Request <GameTeam>(); request.Token = CurrentUser.Token; request.Entities = new List <GameTeam> { team }; var result = ServiceBuilder.GetInstance().Execute(ServiceType.AuditGameTeam, request); return(ToJson(result)); } catch (Exception ex) { var errResult = ResultHelper.Fail(ex.Message); return(ToJson(errResult)); } }
public Response SetSealedOrganizationId(Coach obj) { Response rsp = ResultHelper.CreateResponse(); if (obj.RowState == RowState.Added) { var sql = @" UPDATE dbo.Coach SET SealedOrganizationId=@SealedOrganizationId WHERE Id=@Id "; var cmd = CommandHelper.CreateText <ClubUser>(FetchType.Execute, sql); cmd.Params.Add("@SealedOrganizationId", obj.SealedOrganizationId); cmd.Params.Add("@Id", obj.Id); rsp = DbContext.GetInstance().Execute(cmd); } else if (obj.RowState == RowState.Modified) { return(ResultHelper.Fail("悦动力教练不允许修改")); } return(rsp); }
/// <summary> /// 保存笔记回复 /// </summary> /// <param name="currentUser"></param> /// <param name="request">NoteReply</param> /// <returns></returns> public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <NoteReply> >(request); var note = req.Entities.FirstOrDefault(); if (note.RowState != RowState.Deleted && note.MasterType.IsNullOrEmpty()) { return(ResultHelper.Fail("关联类型字段 MasterType 的值为空, 请传该字段值")); } note.UserId = note.UserId.GetId(); note.NoteId = note.NoteId.GetId(); List <EntityBase> entites = new List <EntityBase>(); entites.Add(note); if (note.RowState == RowState.Added) { note.TrySetNewEntity(); } return(DbContext.GetInstance().Execute(CommandHelper.CreateSave(entites))); }