示例#1
0
    //News_Calculate_Page_Category
    public int GetNewsPageCountCategory(int categoryId, int pageSize)
    {
        if (1 > categoryId || 1 > pageSize)
        {
            return(0);
        }

        NewsDAO newsDao = new NewsDAO();

        return(newsDao.GetNewsPageCountCategory(categoryId, pageSize));
    }
示例#2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string categoryType = Request.QueryString["type"];
            int    categoryId   = Convert.ToInt32(categoryType);
            if (null == categoryType || categoryType.Equals(string.Empty))
            {
                this.showFalseMessage("请输入正确的请求代号!");
                return;
            }

            string pageRequestString = Request.QueryString["page_request"];
            int    pageRequest       = Convert.ToInt32(pageRequestString);
            if (null == pageRequestString || pageRequestString.Equals(string.Empty))
            {
                this.showFalseMessage("请输入正确的页码!");
                return;
            }

            NewsDAO newsDao   = new NewsDAO();
            int     pageCount = newsDao.GetNewsPageCountCategory(categoryId, 20);
            if (0 == pageCount)
            {
                this.showOverflowMessage("该栏目目前还没有资源!");
                this.initPageNumber(pageCount, pageRequest, categoryId);
                return;
            }

            DataSet dataset = newsDao.GetSingleCategoryNewsListWithPageNumber(categoryId, 20, pageRequest);
            if (null == dataset || 0 == dataset.Tables.Count || 0 == dataset.Tables[0].Rows.Count)
            {
                this.showOverflowMessage("页码超出范围!");
                return;
            }

            this.initPageNumber(pageCount, pageRequest, categoryId);

            foreach (DataRow dr in dataset.Tables[0].Rows)
            {
                this.addNewsToList(dr["id"].ToString(), dr["title"].ToString(), Convert.ToDateTime(dr["update_time"]).ToShortDateString());
            }
        }
    }