/// <summary>
        /// 通过结束日期查找正在进行中的活动
        /// </summary>
        /// <param name="args"></param>
        /// <returns></returns>
        public GetItemListResult GetLotteryEndedPeriodList(GetLotteryPeriodListArgs args)
        {
            List <CommandParameter> parameterList = new List <CommandParameter>();

            parameterList.Add(new CommandParameter("@campaignId", args.CampaignId));
            parameterList.Add(new CommandParameter("@page", args.Page));
            parameterList.Add(new CommandParameter("@pageSize", args.PageSize));
            parameterList.Add(new CommandParameter("@endTime", args.EndTime));
            parameterList.Add(new CommandParameter("@type", 2));

            DataSet dsResult =
                _campaignManager.DataBase.ExecuteDataSet(CommandType.StoredProcedure, "GetCampaign_LotteryPeriodListByEndTime", parameterList, new string[] { "result" });

            if (dsResult.Tables[0].Rows.Count == 0 && args.Page > 1)
            {
                args.Page--;
                return(GetLotteryEndedPeriodList(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);
        }
Пример #2
0
        public ActionResult GetLotteryOngoingPeriodList()
        {
            GetLotteryPeriodListArgs args = RequestArgs<GetLotteryPeriodListArgs>();
            if (args == null)
            {
                return RespondResult(false, "参数无效。");
            }

            args.EndTime = DateTime.Now;

            GetItemListResult result = _campaignManager.Lottery.GetLotteryOngoingPeriodList(args);
            return RespondDataResult(result);
        }