Beispiel #1
0
        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);
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
        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);
        }
Beispiel #5
0
        /// <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);
        }
Beispiel #6
0
        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);
        }
Beispiel #7
0
        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));
            }
        }
Beispiel #8
0
        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);
        }
Beispiel #10
0
        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));
        }
Beispiel #11
0
        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);
        }
Beispiel #12
0
        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);
        }
Beispiel #14
0
        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);
        }
Beispiel #16
0
        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));
            }
        }
Beispiel #17
0
        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));
            }
        }
Beispiel #18
0
        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));
            }
        }
Beispiel #19
0
        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);
        }
Beispiel #21
0
        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);
        }
Beispiel #22
0
        /// <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);
        }
Beispiel #24
0
        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));
            }
        }
Beispiel #25
0
        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);
        }
Beispiel #26
0
        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));
        }
Beispiel #27
0
        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));
        }
Beispiel #28
0
        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));
            }
        }
Beispiel #29
0
        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);
        }
Beispiel #30
0
        /// <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)));
        }