//对客户进行修改、删除、升级会员等级
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "bj") //如果用户点击“修改用户信息”
{
int gid = Convert.ToInt32(e.CommandArgument);
Response.Redirect("ChangeGuest.aspx?gid=" + gid); //重定向到客户信息修改页面ChangeGuest.aspx
}
if (e.CommandName == "sc") //如果用户点击删除
{
int gid = Convert.ToInt32(e.CommandArgument);
BLL_Hotel.Del_GuestInfo(gid);//删除顾客
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('删除成功！');", true);
bind();
}
if (e.CommandName == "sj")//如果用户点击"升级顾客"
{
int gid = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL_Hotel.Cha_Guestinfo(gid);//根据顾客编号查询该顾客的个人信息
if (dt.Rows[0]["gtid"].ToString() == "4")
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('当前顾客等级为顶级钻石会员，暂无法升级！');", true);
}
else
{
BLL_Hotel.UpdateGuest(gid);//顾客升级
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('顾客升级成功！');", true);
bind();
}
}
}
public void bind()
{
int roomid = Convert.ToInt32(Request.QueryString["roomid"]);
int gid = Convert.ToInt32(Request.QueryString["gid"]);
DataTable dt2 = BLL_Hotel.Cha_Guestinfo(gid);
this.txtGid.Text = dt2.Rows[0]["Gid"].ToString();
this.txtGname.Text = dt2.Rows[0]["gname"].ToString();
this.txtMobile.Text = dt2.Rows[0]["mobile"].ToString();
this.txtTName.Text = dt2.Rows[0]["Tname"].ToString();
this.txtInTime.Text = DateTime.Now.ToString();
DataTable dt = BLL_Hotel.bind_roomtype();
this.ddlRTName.DataSource = dt;
this.ddlRTName.DataTextField = "rtname";
this.ddlRTName.DataValueField = "rtid";
this.ddlRTName.DataBind();
DataTable dt1 = BLL_Hotel.bind_roominfo(1);
this.ddlRoomName.DataSource = dt1;
this.ddlRoomName.DataTextField = "number";
this.ddlRoomName.DataValueField = "roomid";
this.ddlRoomName.DataBind();
if (roomid != 0) //如果是直接通过欢迎页面已选好房间时，登记时自动选择相应的房间
{
DataTable dt3 = BLL_Hotel.Cha_One(roomid);
this.ddlRTName.SelectedValue = dt3.Rows[0]["rtid"].ToString();
DataTable dt4 = BLL_Hotel.bind_roominfo(Convert.ToInt32(dt3.Rows[0]["rtid"]));
this.ddlRoomName.DataSource = dt4;
this.ddlRoomName.DataTextField = "number";
this.ddlRoomName.DataValueField = "roomid";
this.ddlRoomName.DataBind();
this.ddlRoomName.SelectedValue = roomid.ToString();
}
}
//数据绑定
public void bind()
{
DataTable dt = BLL_Hotel.bind_GuestTname();
this.ddlTName.DataSource = dt;
this.ddlTName.DataValueField = "GTid";
this.ddlTName.DataTextField = "Tname";
this.ddlTName.DataBind();
int idd = Convert.ToInt32(Request.QueryString["gid"]);//顾客编号
DataTable dt1 = BLL_Hotel.Cha_Guestinfo(idd);
this.txtGname.Text = dt1.Rows[0]["gname"].ToString();
this.txtMobile.Text = dt1.Rows[0]["mobile"].ToString();
this.txtPid.Text = dt1.Rows[0]["pid"].ToString();
this.txtChargeSum.Text = dt1.Rows[0]["chargesum"].ToString();
if (dt1.Rows[0]["sex"].ToString() == "女")
{
this.rdoFemaile.Checked = true;
}
this.ddlTName.SelectedValue = dt1.Rows[0]["gtid"].ToString();
}
public void bind()
{
DataTable dt = BLL_Hotel.bind_GuestTname();
this.DropDownList1.DataSource = dt;
this.DropDownList1.DataValueField = "GTid";
this.DropDownList1.DataTextField = "Tname";
this.DropDownList1.DataBind();
int idd = Convert.ToInt32(Request.QueryString["gid"]);
DataTable dt1 = BLL_Hotel.Cha_Guestinfo(idd);
this.TextBox1.Text = dt1.Rows[0]["gname"].ToString();
this.TextBox3.Text = dt1.Rows[0]["mobile"].ToString();
this.TextBox8.Text = dt1.Rows[0]["pid"].ToString();
this.TextBox9.Text = dt1.Rows[0]["chargesum"].ToString();
if (dt1.Rows[0]["sex"].ToString() == "女")
{
this.RadioButton2.Checked = true;
}
this.DropDownList1.SelectedValue = dt1.Rows[0]["gtid"].ToString();
}
