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

namespace note
{
    /// <summary>
    /// _default 的摘要說明。
    /// </summary>
    public class _default : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Repeater rpt_sword_list;
        protected System.Web.UI.WebControls.Label lbl_count;
        protected System.Web.UI.WebControls.Label lbl_current_page;
        protected System.Web.UI.WebControls.Label lbl_total_page;
        protected System.Web.UI.WebControls.LinkButton lb_frist;
        protected System.Web.UI.WebControls.LinkButton lb_p;
        protected System.Web.UI.WebControls.LinkButton lb_n;
        protected System.Web.UI.WebControls.LinkButton lb_last;

        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此處放置用戶代碼以初始化頁面
            if(!this.IsPostBack)
            {
                this.DB_Bind();
            }
        }

        private void DB_Bind()
        {
            int ipageindex = Convert.ToInt32(this.lbl_current_page.Text);
            OleDbConnection conn = dbconn.CreateConn();
            OleDbCommand cmd = new OleDbCommand("select * from a where flag=true order by cdate desc",conn);
            OleDbDataAdapter oda = new OleDbDataAdapter();
            oda.SelectCommand = cmd;
            DataSet ds = new DataSet();
            oda.Fill(ds,"sword_list");
            PagedDataSource pds = new PagedDataSource();
            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();
        }

        #region Web 窗體設(shè)計器生成的代碼
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 該調(diào)用是 ASP.NET Web 窗體設(shè)計器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
        /// 此方法的內(nèi)容。
        /// </summary>
        private void InitializeComponent()
        {    
            this.lb_frist.Click += new System.EventHandler(this.lb_frist_Click);
            this.lb_p.Click += new System.EventHandler(this.lb_p_Click);
            this.lb_n.Click += new System.EventHandler(this.lb_n_Click);
            this.lb_last.Click += new System.EventHandler(this.lb_last_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void lb_frist_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = "1";
            this.DB_Bind();
        }

        private void lb_p_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = Convert.ToString(Convert.ToInt32(this.lbl_current_page.Text)-1);
            this.DB_Bind();
        }

        private void lb_n_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = Convert.ToString(Convert.ToInt32(this.lbl_current_page.Text)+1);
            this.DB_Bind();
        }

        private void lb_last_Click(object sender, System.EventArgs e)
        {
            this.lbl_current_page.Text = this.lbl_total_page.Text;
            this.DB_Bind();
        }
    }
}

最新評論