employee.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 admin_Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            if (Convert.ToString(Session["UID"]) == "")
            {
                Response.Redirect("login.aspx");

            }
            else
            {
                this.bind();

            }
        }
    }
    protected void bind()
    {
       int curpage=Convert.ToInt32(labNewPage.Text);
        PagedDataSource ps=new PagedDataSource();
        SqlConnection mycon=new SqlConnection(ConfigurationManager.ConnectionStrings["SmallHouseConn"].ToString());
        mycon.Open();
        SqlDataAdapter sda=new SqlDataAdapter("select * from employee",mycon);
        DataSet ds=new DataSet();
        sda.Fill(ds,"employee");
        ps.DataSource=ds.Tables["employee"].DefaultView;
        ps.AllowPaging=true;//是否可以分页
        ps.PageSize=4;
        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);
        this.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();
    }
 

    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string strid = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();//获取当前DataList1控件列
        string sql = "delete from employee where ID='" + strid + "'";
        //Response.Write(sql);
        //Response.End();
        BaseClass bc = new BaseClass();
        
        
        if (bc.ExecSql(sql))
        {
            Response.Write("<script language=javascript>alert('删除物业管理人员成功！');location='baseinfo.aspx'</script>");
            
        }
        else
        {
            Response.Write("<script>alert('删除失败，请重试！');</script>");
        }
    }
    
}