//对客户进行修改、删除、升级会员等级 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(); }