areafac.aspx.cs

物业管理系统

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;


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 dbo.areaFacility INNER JOIN dbo.areaFacType ON dbo.areaFacility.typeID = dbo.areaFacType.ID";

      
    //    bc.ExecDatalist(DataList1, sql);

    //}

    protected void bind()
    {


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

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

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

        ps.DataSource = ds.Tables[0].DefaultView;
        ps.AllowPaging = true;//是否可以分页
        ps.PageSize = 2;//每页显示的公告数目
        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();

    }


}