usingSystem;
usingSystem.Collections;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Web;
usingSystem.Web.SessionState;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.HtmlControls;
usingSystem.Data.OleDb;

namespacenote
{
///<summary>
///_default的摘要说明。
///</summary>
publicclass_default:System.Web.UI.Page
{
protectedSystem.Web.UI.WebControls.Repeaterrpt_sword_list;
protectedSystem.Web.UI.WebControls.Labellbl_count;
protectedSystem.Web.UI.WebControls.Labellbl_current_page;
protectedSystem.Web.UI.WebControls.Labellbl_total_page;
protectedSystem.Web.UI.WebControls.LinkButtonlb_frist;
protectedSystem.Web.UI.WebControls.LinkButtonlb_p;
protectedSystem.Web.UI.WebControls.LinkButtonlb_n;
protectedSystem.Web.UI.WebControls.LinkButtonlb_last;

privatevoidPage_Load(objectsender,System.EventArgse)
{
//在此处放置用户代码以初始化页面
if(!this.IsPostBack)
{
this.DB_Bind();
}
}

privatevoidDB_Bind()
{
intipageindex=Convert.ToInt32(this.lbl_current_page.Text);
OleDbConnectionconn=dbconn.CreateConn();
OleDbCommandcmd=newOleDbCommand("select*fromawhereflag=trueorderbycdatedesc",conn);
OleDbDataAdapteroda=newOleDbDataAdapter();
oda.SelectCommand=cmd;
DataSetds=newDataSet();
oda.Fill(ds,"sword_list");
PagedDataSourcepds=newPagedDataSource();
pds.DataSource=ds.Tables["sword_list"].DefaultView;
pds.AllowPaging=true;
pds.PageSize=5;
pds.CurrentPageIndex=ipageindex-1;
this.lbl_total_page.Text=pds.PageCount.ToString();
this.lbl_count.Text=pds.Count.ToString();
this.lb_frist.Enabled=true;
this.lb_p.Enabled=true;
this.lb_n.Enabled=true;
this.lb_last.Enabled=true;
if(this.lbl_current_page.Text=="1")
{
this.lb_frist.Enabled=false;
this.lb_p.Enabled=false;
}
if(this.lbl_current_page.Text==pds.PageCount.ToString())
{
this.lb_n.Enabled=false;
this.lb_last.Enabled=false;
}
this.rpt_sword_list.DataSource=pds;
this.rpt_sword_list.DataBind();
conn.Close();
}

#regionWeb窗体设计器生成的代码
overrideprotectedvoidOnInit(EventArgse)
{
//
//CODEGEN:该调用是ASP.NETWeb窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

///<summary>
///设计器支持所需的方法-不要使用代码编辑器修改
///此方法的内容。
///</summary>
privatevoidInitializeComponent()
{
this.lb_frist.Click+=newSystem.EventHandler(this.lb_frist_Click);
this.lb_p.Click+=newSystem.EventHandler(this.lb_p_Click);
this.lb_n.Click+=newSystem.EventHandler(this.lb_n_Click);
this.lb_last.Click+=newSystem.EventHandler(this.lb_last_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);

}
#endregion

privatevoidlb_frist_Click(objectsender,System.EventArgse)
{
this.lbl_current_page.Text="1";
this.DB_Bind();
}

privatevoidlb_p_Click(objectsender,System.EventArgse)
{
this.lbl_current_page.Text=Convert.ToString(Convert.ToInt32(this.lbl_current_page.Text)-1);
this.DB_Bind();
}

privatevoidlb_n_Click(objectsender,System.EventArgse)
{
this.lbl_current_page.Text=Convert.ToString(Convert.ToInt32(this.lbl_current_page.Text)+1);
this.DB_Bind();
}

privatevoidlb_last_Click(objectsender,System.EventArgse)
{
this.lbl_current_page.Text=this.lbl_total_page.Text;
this.DB_Bind();
}
}
}