Пример #1
0
        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);
        }