result.aspx.cs

大中型酒店管理系统

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class result : System.Web.UI.Page
{
  
    protected void Page_Load(object sender, EventArgs e)
    {
        //if (Session["Admin"] == null)
        //{
        //    Response.Redirect("./Default.Aspx");
        //}
        if (!IsPostBack)
        {
            this.labPage.Text = "1";
            this.contrlRepeater();
        }
    }
    public void contrlRepeater()
    {
        string name = Request.QueryString["id"].ToString();
        SqlConnection conn = db.createconn();
        conn.Open();
        SqlCommand cmd = new SqlCommand("select count(*) from user1 where u_name like '%" + name + "%'", conn);
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        if (count == 0)
        {
            Response.Write("<script language='javascript'>alert('没有符合的数据');history.back(-1);</script>");
        }

        SqlDataAdapter Da = new SqlDataAdapter("select * from user1 where u_name like '%" + name + "%'", conn);

        DataSet Ds = new DataSet();

        Da.Fill(Ds, "news");

        //分页 

        PagedDataSource pds = new PagedDataSource();

        pds.DataSource = Ds.Tables["news"].DefaultView;

        pds.AllowPaging = true;

        pds.PageSize = 16;

        pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
        Repeater1.DataSource = pds;

        LabCountPage.Text = pds.PageCount.ToString();

        labPage.Text = (pds.CurrentPageIndex + 1).ToString();

        this.lbtnpritPage.Enabled = true;

        this.lbtnFirstPage.Enabled = true;

        this.lbtnNextPage.Enabled = true;

        this.lbtnDownPage.Enabled = true;

        if (pds.CurrentPageIndex < 1)
        {
            this.lbtnpritPage.Enabled = false;
            this.lbtnFirstPage.Enabled = false;
        }
        if (pds.CurrentPageIndex == pds.PageCount - 1)
        {
            this.lbtnNextPage.Enabled = false;
            this.lbtnDownPage.Enabled = false;
        }
        Repeater1.DataBind();
    }
    protected void lbtnFirstPage_Click(object sender, EventArgs e)
    {
        this.labPage.Text = "1";
        this.contrlRepeater();
    }
    protected void lbtnpritPage_Click(object sender, EventArgs e)
    {
        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
        this.contrlRepeater();
    }
    protected void lbtnNextPage_Click(object sender, EventArgs e)
    {
        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
        this.contrlRepeater();
    }
    protected void lbtnDownPage_Click(object sender, EventArgs e)
    {
        this.labPage.Text = this.LabCountPage.Text;
        this.contrlRepeater();
    }

}