CmsWeb/htm/副本 news.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using Cms.DBUtility;

public partial class htm_news : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int classId = Convert.ToInt32(this.Request.QueryString["classId"] ?? "0");//ID
            if (new Cms.BLL.C_Column().Exists(classId))
            {
                string where = "select * from C_article where parentId=" + classId + " order by ordernumber desc ,articleId desc";
                this.AspNetPager1.AlwaysShow = true;
                this.AspNetPager1.PageSize = 6;
                this.AspNetPager1.RecordCount = new Cms.BLL.C_article().GetRecordCount("parentId=" + classId + "");
                this.RepeaterDataBind(where);

            }
            else
            {
                Response.Redirect("/");
            }
        }
       
    }

    #region 数据读取===================================================
    public void RepeaterDataBind(string whereStr)
    {
        SqlDataAdapter dr = new SqlDataAdapter(whereStr, DbHelperSQL.connectionString);
        DataSet ds = new DataSet();
        dr.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "C_article");
        this.RepeaterNewlist.DataSource = ds.Tables["C_article"];
        this.RepeaterNewlist.DataBind();
    }
    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        int classid = Convert.ToInt32(this.Request.QueryString["classId"] ?? "0");//栏目ID
        this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        string where = "select * from C_article where parentId=" + classid + " order by ordernumber desc ,articleId desc";
        this.RepeaterDataBind(where.ToString());

    }
    #endregion
    
}