//存储过称为News_Get_List_Category
public DataSet GetSingleCategoryNewsListWithPageNumber(int categoryId, int pageSize, int pageRequest)
{
if (1 > categoryId || 1 > pageSize || 1 > pageRequest)
{
return(new DataSet());
}
NewsDAO newsDao = new NewsDAO();
return(newsDao.GetSingleCategoryNewsListWithPageNumber(categoryId, pageSize, pageRequest));
}
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());
}
}
}
