public GetItemListResult GetGiftWinningList(GetCampaign_ShakingLotteryGiftWinningListArgs args) { List <CommandParameter> parameterList = new List <CommandParameter>(); parameterList.Add(new CommandParameter("@domainId", args.DomainId)); parameterList.Add(new CommandParameter("@appId", args.AppId)); parameterList.Add(new CommandParameter("@page", args.Page)); parameterList.Add(new CommandParameter("@pageSize", args.PageSize)); parameterList.Add(new CommandParameter("@campaignId", args.CampaignId)); if (args.PeriodId.HasValue) { parameterList.Add(new CommandParameter("@periodId", args.PeriodId.Value)); } else { parameterList.Add(new CommandParameter("@periodId", DBNull.Value)); } DataSet dsResult = _campaignManager.DataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetCampaign_ShakingLotteryGiftWinningList", parameterList, new string[] { "result" }); if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1) { args.Page--; return(GetGiftWinningList(args)); } GetItemListResult result = new GetItemListResult(); result.ItemList = dsResult.Tables[0]; int totalCount = int.Parse(dsResult.Tables[1].Rows[0][0].ToString()); result.TotalPage = totalCount / args.PageSize; if (totalCount % args.PageSize > 0) { result.TotalPage++; } result.Page = args.Page; return(result); }
public ShakingLotteryGiftProjectiveData GetProjectiveData(GetCampaign_ShakingLotteryGiftWinningListArgs args) { ShakingLotteryGiftProjectiveData data = new ShakingLotteryGiftProjectiveData(); Campaign_ShakingLotteryEntity campaign = Get(args.CampaignId); if (campaign.Mode == EnumCampaign_ShakingLotteryMode.Period) { args.PeriodId = campaign.Period; if (campaign.Period.HasValue) { data.CurrentPeriod = GetPeriod(campaign.Period.Value); } } GetItemListResult winningList = GetGiftWinningList(args); data.WinningList = winningList; return(data); }