示例#1
0
        //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);
        }
示例#2
0
        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);
        }