/// <summary>
        /// 获取非包月付费用户数数据列表
        /// </summary>
        /// <returns></returns>
        public ExtentionNBP GetNBPList(int PageSize, int PageIndex, out int totalCount, NBPParam pra)
        {
            var query = from s in _db.Admin_NBPAccumulative orderby s.CountTime select new Admin_NBPAccumulative { CountTime=s.CountTime,CpName=s.CpName,NBPCount=s.NBPCount,Province=s.Province,ID=s.ID};

            #region 查询条件过滤
            //cp名称
            if (!string.IsNullOrEmpty(pra.cpName))//关键词非空
            {
                query = query.Where(s => s.CpName.Contains(pra.cpName));
            }
            //选择时间
            if (pra.seltime != new DateTime(1970, 1, 1))
            {
                query = query.Where(s => s.CountTime == pra.seltime);
            }
            #endregion
            totalCount = query.Count();
            var cbag = new ExtentionNBP();
            if (PageIndex < 0 || PageSize < 0)
            {
                return null;
            }
            if (PageIndex == 1 && PageSize > totalCount)
            {
                cbag.list = query.ToList<Admin_NBPAccumulative>();
            }
            else if (PageIndex == 1 && PageSize > 0)
            {
                cbag.list = query.Take(PageSize).ToList();
            }
            else
            {
                cbag.list = query.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
            }
            cbag.par = pra;

            return cbag;
        }
Exemple #2
0
        public ActionResult NBPManage(FormCollection form)
        {
            ExtentionNBP cbag = new ExtentionNBP();
            if (form.Count != 0 || Request.QueryString.Count != 0)//有选择条件
            {
                NBPParam pra = new NBPParam();
                //post请求
                if (Request.HttpMethod.Equals("POST", StringComparison.OrdinalIgnoreCase))
                {
                    if (form["SelTime"] != "" && form["SelTime"] != null)
                    {
                        pra.seltime = Convert.ToDateTime(form["SelTime"]);
                    }
                    else
                    {
                        pra.seltime = new DateTime(1970, 1, 1);
                    }
                }
                else if (DTRequest.GetQueryString("seltime") != "")
                {
                    pra.seltime = Convert.ToDateTime(DTRequest.GetQueryString("seltime"));
                }
                else
                {
                    pra.seltime = new DateTime(1970, 1, 1);
                }

                //post请求
                if (Request.HttpMethod.Equals("POST", StringComparison.OrdinalIgnoreCase))
                {
                    if (form["selCPName"] != "" && form["selCPName"] != null)
                    {
                        pra.cpName = form["selCPName"];
                    }
                    else
                    {
                        pra.cpName = "";
                    }
                }
                else if (DTRequest.GetQueryString("selCPName") != "")
                {
                    pra.cpName = DTRequest.GetQueryString("selCPName");
                }
                else
                {
                    pra.cpName = "";
                }

                this.pageSize = GetPageSize(25); //每页数量
                //post请求,点击查询返回第一页
                if (Request.HttpMethod.Equals("POST", StringComparison.OrdinalIgnoreCase))
                {
                    this.page = 1;
                }
                else
                {
                    this.page = DTRequest.GetQueryInt("page", 1);
                }
                ViewBag.txtKeywords = this.keywords;
                cbag = new Admin_NBPAccumulativeLogic().GetNBPList(this.pageSize, this.page, out this.totalCount, pra);
                //绑定页码
                ViewBag.txtPageNum = this.pageSize.ToString();
                string pageUrl = Utils.CombUrlTxt("../admin/NBPManage", "SelTime={0}&selOpusName={1}&selCPName={2}&page={3}", pra.seltime.ToString(), pra.cpName, pra.cpName, "__id__");
                ViewBag.PageContent = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
                return View(cbag);
            }
            else
            {
                NBPParam pra = new NBPParam();
                pra.seltime = form["SelTime"] == "" || form["SelTime"] == null ? new DateTime(1970, 1, 1) : Convert.ToDateTime(form["SelTime"]);
                pra.cpName = "";

                this.pageSize = GetPageSize(25); //每页数量
                this.page = DTRequest.GetQueryInt("page", 1);
                ViewBag.txtKeywords = this.keywords;
                cbag = new Admin_NBPAccumulativeLogic().GetNBPList(this.pageSize, this.page, out this.totalCount, pra);
                //绑定页码
                ViewBag.txtPageNum = this.pageSize.ToString();
                string pageUrl = Utils.CombUrlTxt("../admin/NBPManage", "SelTime={0}&selOpusName={1}&selCPName={2}&page={3}", pra.seltime.ToString(), pra.cpName, pra.cpName, "__id__");
                ViewBag.PageContent = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
                return View(cbag);
            }
        }