/// <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); }
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); }