notice.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 web_notice : 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 sql3 = "select top 5 * from notice order by noticeDate desc";//从数据库公告表中取前5条记录
     Circular.DataSource = bc.ExecDS(sql3);//绑定到Datalist控件上面
     Circular.DataBind();

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

     int curpage = Convert.ToInt32(labNewPage.Text);//肖前页索引
    
     PagedDataSource ps = new PagedDataSource();//页绑定数据，因为Datalist没有分页显示的功能，用page实现分页
    string sql="select * from notice notice order by noticeDate desc";
     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);
     noticelist.DataSource = ps;
     this.noticelist.DataKeyField = "ID";
     this.noticelist.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();

    }
}