//public ActionResult PrizeOrders(int revealType, int pageIndex, string keywords) //{ // var model = GetLotteries(revealType, pageIndex, keywords); // return PartialView(model); //} /// <summary> /// 获取最新的可抽奖信息 /// </summary> private PagedList <PrizeOrderDetailView> GetLotteries(int?rtype, int pageIndex, string keywords = null) { ViewBag.UserId = this.UserId ?? 0; PropertySortCondition[] sortConditions = new[] { new PropertySortCondition("SortOrder") }; int pageSize = int.Parse(System.Configuration.ConfigurationManager.AppSettings["PageCount"]); string orderbyString = "SortOrder asc"; int totalCount; int totalPageCount; string whereString = GetWhereStringOfPrizeOrderDetail(keywords); whereString += string.IsNullOrEmpty(whereString) ? " RevealType <> 4 and RevealType <> 5 " : " and RevealType <> 4 and RevealType <> 5 "; IEnumerable <PrizeOrderDetailView> rlist = null; OperationResult result = PrizeOrderSiteContract.GetLotteries(pageSize, pageIndex, whereString, orderbyString, out totalCount, out totalPageCount, rtype ?? 0); ViewBag.TotalCount = totalCount; ViewBag.PageIndex = pageIndex; ViewBag.PageCount = totalPageCount; if (result.ResultType == OperationResultType.Success) { DataSet ds = (DataSet)result.AppendData; if (ds != null && ds.Tables.Count > 0) { //DataTable dt = ds.Tables[0]; //DataRow[] rowarray = new DataRow[dt.Rows.Count]; //dt.Rows.CopyTo(rowarray, 0); ////所有 //ViewBag.AllPrizeOrders = rowarray; DataTable dt = ds.Tables[0]; rlist = dt.ToPrizeOrderDetailList(); if (rlist != null) { PagedList <PrizeOrderDetailView> model = new PagedList <PrizeOrderDetailView>(rlist, pageIndex, pageSize, totalCount); return(model); } } } ViewBag.Message = result.Message; return(null); }
public PagedList <PrizeOrderDetailView> GetPagedListOfPrizeOrderDetailView(int pageIndex, string keywords = null) { PropertySortCondition[] sortConditions = new[] { new PropertySortCondition("SortOrder") }; string orderbyString = "SortOrder asc"; int totalCount; int totalPageCount; string whereString = string.Empty; whereString = GetWhereStringOfPrizeOrderDetail(keywords); IEnumerable <PrizeOrderDetailView> rlist = null; OperationResult result = PrizeOrderSiteContract.GetLotteries(this.PageSize, pageIndex, whereString, orderbyString, out totalCount, out totalPageCount, 0, (int)RevealState.UnDrawn); ViewBag.TotalCount = totalCount; ViewBag.PageIndex = pageIndex; ViewBag.PageCount = totalPageCount; if (result.ResultType == OperationResultType.Success) { DataSet ds = (DataSet)result.AppendData; if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; rlist = dt.ToPrizeOrderDetailList(); if (rlist != null) { PagedList <PrizeOrderDetailView> model = new PagedList <PrizeOrderDetailView>(rlist, pageIndex, this.PageSize, totalCount); return(model); } } } return(null); }