default_c.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 default_c : 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()
    {
        SqlConnection conn = db.createconn();

        SqlDataAdapter Da = new SqlDataAdapter("select * from user1 where u_qu ='C区'", 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;
        newsguli.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;
        }
        newsguli.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();
    }
    protected void DelComm_Click(object sender, CommandEventArgs e)
    {
        int ID = Convert.ToInt32(e.CommandName);

        SqlConnection Conn = db.createconn();
        Conn.Open();

        SqlCommand Cmd = new SqlCommand("delete from news where newsid=" + ID, Conn);


        Cmd.ExecuteNonQuery();

        Conn.Close();
        Response.Redirect("./adminnews.aspx");
    }
}