public static Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <GetGameListFilter> >(request); var cmd = CommandHelper.CreateProcedure <Game>(text: "sp_GetGameTVList"); cmd.Params.Add(CommandHelper.CreateParam("@clubId", req.Filter.ClubId)); cmd.Params.Add(CommandHelper.CreateParam("@cityId", req.Filter.CityId)); cmd.Params.Add(CommandHelper.CreateParam("@gameName", req.Filter.GameName)); cmd.Params.Add(CommandHelper.CreateParam("@isOnlySelf", req.Filter.IsOnlySelf)); cmd.Params.Add(CommandHelper.CreateParam("@state", req.Filter.State)); cmd.CreateParamPager(req.Filter); cmd.CreateParamUser("001001");//写死超级管理员 var result = DbContext.GetInstance().Execute(cmd); result.SetRowCount(); if (result.Entities.IsNotNullOrEmpty()) { foreach (Game obj in result.Entities) { GameHelper.SetGameTeamList(obj); } } return(result); }
public Response Execute(User currentUser, string request) { var req = JsonConvert.DeserializeObject <Request <Game> >(request); var cmd = CommandHelper.CreateProcedure <Game>(text: "sp_GetGame"); cmd.Params.Add(CommandHelper.CreateParam("@userId", currentUser.Id)); cmd.Params.Add(CommandHelper.CreateParam("@gameId", req.Filter.Id)); var result = DbContext.GetInstance().Execute(cmd); if (result.Entities.IsNotNullOrEmpty()) { var game = result.FirstEntity <Game>(); SetHeadAndFiles(game); GameHelper.SetGameTeamList(game); game.SocketIpAndPort = UserHelper.GetConfig().IntranetSocketIpAndPort;//返回局域网内的地址 game.IsInLive = LiveHelper.Instance.IsInLive(game.Id); game.IsAudit = game.AuditId == null || !game.AuditId.Contains(currentUser.Id) ? false : true; game.IsManage = game.ManageId == null || !game.ManageId.Contains(currentUser.Id) ? false : true; game.AuditName = UserHelper.GetMultiUserName(game.AuditId); //返回名称 game.ManageName = UserHelper.GetMultiUserName(game.ManageId); game.WinGameArr = new int[] { 2, 3, 4 }; //小局胜局数 } return(result); }
public Response Execute(string request) { var req = JsonConvert.DeserializeObject <Request <Game> >(request); var cmd = CommandHelper.CreateProcedure <Game>(text: "sp_GetGame"); cmd.Params.Add(CommandHelper.CreateParam("@userId", "tourist")); cmd.Params.Add(CommandHelper.CreateParam("@gameId", req.Filter.Id)); var result = DbContext.GetInstance().Execute(cmd); if (result.Entities.IsNotNullOrEmpty()) { var game = result.FirstEntity <Game>(); GetGame.SetHeadAndFiles(game); GameHelper.SetGameTeamList(game); game.SocketIpAndPort = UserHelper.GetConfig().IntranetSocketIpAndPort;//返回局域网内的地址 } return(result); }