private static void SetGameLoopMapDetailList(Response result)
{
if (result.Entities.IsNotNullOrEmpty())
{
foreach (GameLoopMap obj in result.Entities)
{
//获取队员的技能积分
obj.User1Score = GameHelper.GetSportScoreByUser(obj.User1Id);
obj.User2Score = GameHelper.GetSportScoreByUser(obj.User2Id);
var filter = new GetGameLoopDetailListFilter
{
LoopId = obj.LoopId,
MapId = obj.Id
};
var detailList = GameHelper.GetGameLoopDetailList(filter).Entities;
if (detailList.IsNotNullOrEmpty())
{
obj.DetailList = detailList.ToList <EntityBase, GameLoopDetail>();
}
//获取头像
GetUserHeadUrl(obj);
}
}
}
public static Response GetGameLoopDetailList(GetGameLoopDetailListFilter filter)
{
var cmd = CommandHelper.CreateProcedure <GameLoopDetail>(text: "sp_GetGameLoopDetailList");
cmd.Params.Add(CommandHelper.CreateParam("@MapId", filter.MapId));
cmd.Params.Add(CommandHelper.CreateParam("@LoopId", filter.LoopId));
var res = DbContext.GetInstance().Execute(cmd);
return(res);
}
/// <summary>
/// 获取某大轮次下面所有比赛场次，正赛/附加赛
/// </summary>
/// <param name="request">Request.GetGameOrderLoopListFilter.Filter</param>
/// <returns>Response.GameLoop</returns>
public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <GetGameOrderLoopListFilter> >(request);
if (string.IsNullOrEmpty(req.Filter.GameId))
{
return(ResultHelper.Fail("赛事ID未上传"));
}
Command cmd = null;
if (req.Filter.PageIndex <= 0)
{
cmd = CommandHelper.CreateProcedure <GameLoop>(text: "sp_GetGameOrderLoopList");
}
else
{
cmd = CommandHelper.CreateProcedure <GameLoop>(text: "sp_GetGameOrderLoopListPage");
cmd.CreateParamPager(req.Filter);
}
cmd.Params.Add(CommandHelper.CreateParam("@gameId", req.Filter.GameId));
cmd.Params.Add(CommandHelper.CreateParam("@knockOutAB", req.Filter.KnockOutAB));
cmd.Params.Add(CommandHelper.CreateParam("@orderId", req.Filter.OrderId));
cmd.Params.Add(CommandHelper.CreateParam("@groupId", req.Filter.GroupId));
cmd.Params.Add(CommandHelper.CreateParam("@isExtra", req.Filter.IsExtra));
cmd.Params.Add(CommandHelper.CreateParam("@groupOrderNo", req.Filter.GroupOrderNo));
cmd.Params.Add(CommandHelper.CreateParam("@orderNo", req.Filter.OrderNo));
cmd.Params.Add(CommandHelper.CreateParam("@startTime", req.Filter.StartTime));
string endTime = req.Filter.EndTime;
if (!string.IsNullOrEmpty(endTime))
{
endTime = DateTime.Parse(endTime).AddDays(1).ToString("yyyy-MM-dd");
}
cmd.Params.Add(CommandHelper.CreateParam("@endTime", endTime));
cmd.Params.Add(CommandHelper.CreateParam("@team1Id", req.Filter.Team1Id));
if (req.Filter.Team1Id == req.Filter.Team2Id)
{
cmd.Params.Add(CommandHelper.CreateParam("@team2Id", ""));
}
else
{
cmd.Params.Add(CommandHelper.CreateParam("@team2Id", req.Filter.Team2Id));
}
cmd.Params.Add(CommandHelper.CreateParam("@tableNo", req.Filter.TableNo));
var result = DbContext.GetInstance().Execute(cmd);
result.SetRowCount();
GetGameLoopDetailListFilter detailFilter = new GetGameLoopDetailListFilter();//查询每次对阵的小局详情模型
foreach (var item in result.Entities)
{
GameLoop gl = item as GameLoop;
if (gl.IsTeam)
{
gl.DetailList = GameHelper.GetLoopMapByLoop(gl.Id);//取LOOPMAP里的大分数据
}
else
{
detailFilter.LoopId = gl.Id;
try
{
var tempResut = GameHelper.GetGameLoopDetailList(detailFilter).Entities;
gl.DetailList = tempResut.ToList <EntityBase, GameLoopDetail>();
}
catch { }
}
}
return(result);
}
