userrecord.aspx.cs

酒店管理系统项目需求说明 第一部分 引言 1 1.1编写目的 1 1.2背景 1 第二部分 任务概述 2 3.1实现目标 2 3.1.1客房类型模块： 2 3.1.2客房信息

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using BLL;
using Entity;

public partial class UserRecord : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["Name"] == null)
            {
                Response.Redirect("Index.aspx");
            }
            MultiView5.ActiveViewIndex = 0;
            MultiView4.ActiveViewIndex = 0;
            Bind();
        }
    }

    /// <summary>
    /// 查询所有
    /// </summary>
    void Bind()
    {
        List<HotelUserEntity> HUE = HotelUserBLL.GetHotelUser();
        GridView1.DataSource = HUE;
        GridView1.DataBind();
    }

    /// <summary>
    /// 条件查询
    /// </summary>
    void Bind1()
    { 
        if (ddl.Text == "用户ID")
        {
            DataTable dt = HotelUserBLL.GetHotelUserByUserName(txtfilter.Text);
            MultiView4.ActiveViewIndex = 1;
            GridView2.DataSource = dt;
            GridView2.DataBind();
        }
        else
        {
            DataTable dt = HotelUserBLL.GetHotelUserByName(txtfilter.Text);
            MultiView4.ActiveViewIndex = 1;
            GridView2.DataSource = dt;
            GridView2.DataBind();
        }  
    }
    void Show(int UserID)
    {
        DataTable dt = HotelUserBLL.GetHotelUserByUserID(UserID);
        lbladdress.Text = dt.Rows[0]["Address"].ToString();
        lblemail.Text = dt.Rows[0]["Email"].ToString();
        lblname.Text = dt.Rows[0]["Name"].ToString();
        lblphone.Text = dt.Rows[0]["Phone"].ToString();
        if (Convert.ToInt32(dt.Rows[0]["Status"]) == 0)
        {
            lblstatus.Text = "普通用户";
            ddl2.Text = "普通用户";
        }
        else
        {
            lblstatus.Text = "管理员";
            ddl2.Text = "管理员";
        }
        lbluserid.Text = dt.Rows[0]["UserID"].ToString();
        lblusername.Text = dt.Rows[0]["UserName"].ToString();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        Bind();
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        MultiView5.ActiveViewIndex = 1;
        int UserID = Convert.ToInt32(GridView1.DataKeys[GridView1.SelectedIndex].Value);
        Show(UserID);
    }
    protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView2.PageIndex = e.NewPageIndex;
        Bind1();
    }
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
    {
        MultiView5.ActiveViewIndex = 1;
        int UserID = Convert.ToInt32(GridView2.DataKeys[GridView2.SelectedIndex].Value);
        Show(UserID);
    }
    protected void LinkButton5_Click(object sender, EventArgs e)
    {

        if (lblstatus.Text != ddl2.Text)
        {
            int Status = 0;
            if(ddl2.Text == "管理员")
                Status = 1;
            int flag = HotelUserBLL.UpdateStatusByUserName(Status, lblusername.Text,Session["Name"].ToString());
            if (flag == 1)
            {
                
                Session["flag"] = "成功的将用户 " + lblusername.Text + "  的身份由“" + lblstatus.Text + "”修改成“" + ddl2.Text + "”";
                Response.Redirect("success.aspx");
                lblstatus.Text = ddl2.Text;
            }
            else if (flag == 0)
            {
                Label7.Visible = true;
                Label7.Text = "修改失败，不能修改自己的身份...";
                ddl2.Text = lblstatus.Text;
            }
            else
            {}
        }
        else
        {
            MultiView5.ActiveViewIndex = 0;
        }
    }
    protected void LinkButton6_Click(object sender, EventArgs e)
    {
        MultiView5.ActiveViewIndex = 0;
    }

    protected void LinkButton7_Click(object sender, EventArgs e)
    {
        int flag = HotelUserBLL.DeleteHotelUserByUserID(Convert.ToInt32(lbluserid.Text));
        if (flag == 1)
        {
            Session["flag"] = "成功删除账号为:"+lblusername.Text+"  的用户！";
            Response.Redirect("success.aspx");
            MultiView5.ActiveViewIndex = 0;
            if (MultiView4.ActiveViewIndex == 0)
                Bind();
            else
                Bind1();
        }
        else if (flag == 0)
        {
            Label7.Visible = true;
            if (lblstatus.Text == "管理员")
            {
                Label7.Text = "删除失败，不能删除管理员的账号...";
            }
            else
                Label7.Text = "删除失败，该用户已入住或已预订房间...";
        }
        else
        { }
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "current=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=current");
        }
    }
    protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "current=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=current");
        }
    }
    protected void LinkButton11_Click(object sender, EventArgs e)
    {
        Bind1();
    }
    protected void LinkButton12_Click(object sender, EventArgs e)
    {
        MultiView5.ActiveViewIndex = 0;
        MultiView4.ActiveViewIndex = 0;
        Bind();
    }
    protected void Timer1_Tick(object sender, EventArgs e)
    {
        Label7.Visible = false;
    }
}