about.aspx.cs

来自「物业管理系统」· CS 代码 · 共 107 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

//该源码首发自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

public partial class about : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["code"])==""&&Convert.ToString(Session["UID"])=="")
        {
            Response.Write("<script language=javascript>alert('请先登陆！');location='default.aspx'</script>");
        }
        if (!IsPostBack)
        {
              this.bind();
        }
       
    }
    //protected void bind()
    //{

    //   // string sql = "select * from employee";
    //    DataSet ds = bc.ExecDS(sql);
    //    this.DataList1.DataSource = ds;
    //    this.DataList1.DataBind();

    //}
    protected void bind()
    {

       

        //也以下代码是绑定数据到公告列表控件上面

        int curpage = Convert.ToInt32(labNewPage.Text);//肖前页索引

        PagedDataSource ps = new PagedDataSource();//页绑定数据，因为Datalist没有分页显示的功能，用page实现分页
        string sql = "select * from employee";
        DataSet ds = bc.ExecDS(sql);

        ps.DataSource = ds.Tables[0].DefaultView;
        ps.AllowPaging = true;//是否可以分页
        ps.PageSize = 10;//每页显示的公告数目
        ps.CurrentPageIndex = curpage - 1;
        lnkbtnprve.Enabled = true;
        lnkbtnTop.Enabled = true;
        lnkbtnNext.Enabled = true;
        lnkbtnlast.Enabled = true;
        if (curpage == 1)
        {
            lnkbtnTop.Enabled = false;//不显示第一页按钮
            lnkbtnprve.Enabled = false;//不显示上一页按钮
        }

        if (curpage == ps.PageCount)
        {
            lnkbtnNext.Enabled = false;//不显示下一页按钮
            lnkbtnlast.Enabled = false;//不显示最后一页按钮
        }
        this.labcount.Text = Convert.ToString(ps.PageCount);
        DataList1.DataSource = ps;
        this.DataList1.DataKeyField = "ID";
        this.DataList1.DataBind();


    }
    //返回首页
    protected void lnkbtnTop_Click(object sender, EventArgs e)
    {
        this.labNewPage.Text = "1";
        this.bind();
    }
    //上一页
    protected void lnkbtnprve_Click(object sender, EventArgs e)
    {
        this.labNewPage.Text = Convert.ToString(Convert.ToInt32(this.labNewPage.Text) - 1);
        this.bind();

    }
    //下一页
    protected void lnkbtnNext_Click(object sender, EventArgs e)
    {
        this.labNewPage.Text = Convert.ToString(Convert.ToInt32(this.labNewPage.Text) + 1);
        this.bind();
    }
    //尾页
    protected void lnkbtnlast_Click(object sender, EventArgs e)
    {
        this.labNewPage.Text = this.labcount.Text;
        this.bind();

    }


}