protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int reid = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex][0]); BLL_Hotel.Del_Record(reid); bind(); }
//对客户进行修改、删除、升级会员等级 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() { DataTable dt = BLL_Hotel.Img_Table(1); this.DataList1.DataSource = dt; this.DataList1.DataBind(); DataTable dt1 = BLL_Hotel.Cha_OutDay(); if (dt1.Rows.Count >= 1) { this.Label1.Text = "①:" + dt1.Rows[0]["number"].ToString() + "号房即将在" + dt1.Rows[0]["outtime"].ToString() + "过期,请及时提醒用户续交押金或办理退房手续。"; } if (dt1.Rows.Count >= 2) { this.Label2.Text = "②:" + dt1.Rows[1]["number"].ToString() + "号房即将在" + dt1.Rows[1]["outtime"].ToString() + "过期,请及时提醒用户续交押金或办理退房手续。"; } if (dt1.Rows.Count >= 3) { this.Label3.Text = "③:" + dt1.Rows[2]["number"].ToString() + "号房即将在" + dt1.Rows[2]["outtime"].ToString() + "过期,请及时提醒用户续交押金或办理退房手续。"; } if (dt1.Rows.Count >= 4) { this.Label4.Text = "④:" + dt1.Rows[3]["number"].ToString() + "号房即将在" + dt1.Rows[3]["outtime"].ToString() + "过期,请及时提醒用户续交押金或办理退房手续。"; } }
public string last() { int year = Convert.ToInt32(Request.QueryString["year"]); StringBuilder sb = new StringBuilder(); for (int i = 1; i < 13; i++) { DataTable dt3 = BLL_Hotel.Cha_MonthChargeCount(i, year - 1); if (dt3.Rows.Count != 0) { if (i != 12) { sb.Append(dt3.Rows[0][1].ToString() + ","); } else { sb.Append(dt3.Rows[0][1].ToString()); } } else { if (i != 12) { sb.Append("0,"); } else { sb.Append("0"); } } } return(sb.ToString()); }
protected void Page_Load(object sender, EventArgs e) { //判断用户点击的房间信息 进行跳转到相应的页面 int roomid = int.Parse(Request.QueryString["roomid"].ToString()); DataTable dt = BLL_Hotel.Cha_One(roomid); if (dt.Rows[0]["stateid"].ToString() == "1") //如果房间状态为已预定 { Response.Redirect("ReserveDetail.aspx?roomid=" + roomid); } else if (dt.Rows[0]["stateid"].ToString() == "2") //如果房间状态为 已入住 { Response.Redirect("roomdetail.aspx?roomid=" + roomid); } else if (dt.Rows[0]["stateid"].ToString() == "3") //如果房间状态为 未入住 { Response.Redirect("Guestinfo.aspx?roomid=" + roomid); } else if (dt.Rows[0]["stateid"].ToString() == "6") //如果房间 状态为"未开通" { Response.Redirect("CreRoom.aspx?roomid=" + roomid); } else //如果房间状态为维修中或者打扫中 { BLL_Hotel.Gai_roomstate(roomid, 3); Response.Write("<script>alert('房间状态已更新为未入住!');location.href='right.aspx';</script>"); } }
public void bind() { this.DropDownList1.DataSource = BLL_Hotel.Bind_DropDwonListBindYear(); this.DropDownList1.DataTextField = "year"; this.DropDownList1.DataValueField = "year"; this.DropDownList1.DataBind(); }
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(); } }
protected void Button3_Click(object sender, EventArgs e) { int hehe = Convert.ToInt32(this.TextBox7.Text); DataTable dt = BLL_Hotel.Img_Table(hehe); this.DataList1.DataSource = dt; this.DataList1.DataBind(); }
//将查询到的图标方式展示房间信息(分页)/即将到期的客房绑定到表格 public void bind() { DataTable dt = BLL_Hotel.Img_Table(1);//图标方式展示房间信息(分页) this.DataList1.DataSource = dt; this.DataList1.DataBind(); DataTable dt1 = BLL_Hotel.Cha_OutDay();//即将到期的客房 }
protected void Button4_Click(object sender, EventArgs e) { int hehe = Convert.ToInt32(this.TextBox7.Text); DataTable dt = BLL_Hotel.LiveMark("record", hehe); this.GridView1.DataSource = dt; this.GridView1.DataBind(); }
public void bind() { DataTable dt = BLL_Hotel.LiveMark("record", 1); this.GridView1.DataSource = dt; this.GridView1.DataBind(); hehe(); }
public void bind() { DataTable dt = BLL_Hotel.Cha_CusFenYe(1); this.GridView1.DataSource = dt; this.GridView1.DataBind(); hehe(); }
//取消预约 protected void btnNoReserve_Click(object sender, EventArgs e) { int roomid = Convert.ToInt32(Request.QueryString["roomid"]); BLL_Hotel.Qu_Reserve(roomid, "已取消离开"); //更换房间信息 BLL_Hotel.Gai_roomstate(roomid, 3); //房间状态更新为空房 Response.Write("<script>alert('预约已取消!');location.href='right.aspx'</script>"); }
// 分页划分数据 protected void btnPaging_Click(object sender, EventArgs e) { int hehe = Convert.ToInt32(this.txtCPage.Text);//获取当前页 DataTable dt = BLL_Hotel.Img_Table(hehe); this.DataList1.DataSource = dt; this.DataList1.DataBind(); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "$('.tcdPageCode').createPage({pageCount:" + ye() + ",current:" + this.txtCPage.Text + "});", true);//注册分页js脚本 }
public void bind() { DataTable dt = BLL_Hotel.bind_GuestTname(); this.DropDownList1.DataSource = dt; this.DropDownList1.DataValueField = "GTid"; this.DropDownList1.DataTextField = "Tname"; this.DropDownList1.DataBind(); }
protected void btnPaging_Click(object sender, EventArgs e) { int hehe = Convert.ToInt32(this.TextBox7.Text); DataTable dt = BLL_Hotel.LiveMark("reserve", hehe); this.GridView1.DataSource = dt; this.GridView1.DataBind(); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "$('.tcdPageCode').createPage({pageCount:" + ye() + ",current:" + this.TextBox7.Text + "});", true); }
// 提交房间开通信息到数据库 protected void btnSubmit_Click(object sender, EventArgs e) { int rommid = Convert.ToInt32(this.txtRoomId.Text); //房间编号 string mark = this.TextBox7.Text; //房间备注 int louceng = Convert.ToInt32(this.ddlFName.SelectedValue); //楼层 string name = this.txtRoomName.Text; //房间名称 BLL_Hotel.Add_Room(name, louceng, mark, rommid); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('房间新增成功');location.href='Right.aspx'", true); }
//改变房间类型时自动选择相应的房间类型 public void dpbind() { int idd = Convert.ToInt32(this.ddlRTName.SelectedValue); DataTable dt1 = BLL_Hotel.bind_roominfo(idd); this.ddlRoomName.DataSource = dt1; this.ddlRoomName.DataTextField = "number"; this.ddlRoomName.DataValueField = "roomid"; this.ddlRoomName.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { int rommid = Convert.ToInt32(this.TextBox1.Text); string mark = this.TextBox7.Text; int louceng = Convert.ToInt32(this.DropDownList1.SelectedValue); string name = this.TextBox2.Text; BLL_Hotel.Add_Room(name, louceng, mark, rommid); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('房间新增成功');location.href='Right.aspx'", true); }
public void dpbind() //改变房间类型时自动选择相应的房间类型 { int idd = Convert.ToInt32(this.DropDownList1.SelectedValue); DataTable dt1 = BLL_Hotel.bind_roominfo(idd); this.DropDownList2.DataSource = dt1; this.DropDownList2.DataTextField = "number"; this.DropDownList2.DataValueField = "roomid"; this.DropDownList2.DataBind(); }
public void bind() { int roomid = Convert.ToInt32(Request.QueryString["roomid"]); DataTable dt = BLL_Hotel.Cha_OneRecord(roomid); this.TextBox1.Text = dt.Rows[0]["gid"].ToString(); this.TextBox2.Text = dt.Rows[0]["gname"].ToString(); this.TextBox3.Text = dt.Rows[0]["tname"].ToString(); this.TextBox4.Text = dt.Rows[0]["rtname"].ToString(); this.TextBox5.Text = dt.Rows[0]["trate"].ToString() + "折"; this.TextBox6.Text = dt.Rows[0]["number"].ToString(); this.TextBox8.Text = dt.Rows[0]["charge"].ToString() + "元"; this.TextBox9.Text = dt.Rows[0]["intime"].ToString(); this.TextBox11.Text = dt.Rows[0]["outtime"].ToString(); now = DateTime.Now; DateTime intime = Convert.ToDateTime(this.TextBox9.Text); //获取入住日期 factnum = (now - intime).Days; //计算入住的实际天数 int daynum = Convert.ToInt32(dt.Rows[0]["daynum"]); this.TextBox12.Text = factnum.ToString() + "天"; this.TextBox13.Text = now.ToString(); price = Convert.ToDouble(dt.Rows[0]["rtprice"]) * factnum * Convert.ToDouble(dt.Rows[0]["trate"]); //实际收费 //当天入住不满6个小时按半天收费,超过6个小时按一天收费。 int hour = (now - intime).Hours; if (hour <= 6) { price = price + ((Convert.ToDouble(dt.Rows[0]["rtprice"])) * 0.5); } else { price = price + ((Convert.ToDouble(dt.Rows[0]["rtprice"]))); } double tui = Convert.ToDouble(dt.Rows[0]["charge"]) - price; double jiao = price - Convert.ToDouble(dt.Rows[0]["charge"]); this.TextBox10.Text = price.ToString() + "元"; if (daynum >= factnum) { this.TextBox7.Text = "用户登记入住天数为【" + daynum + "天】,实际入住天数为【" + factnum + "】天。该客户本次消费需退还押金【" + tui + "】元。"; } else { this.TextBox7.Text = "用户登记入住天数为【" + daynum + "天】,实际入住天数为【" + factnum + "】天。该客户本次消费需缴纳押金【" + jiao + "】元。"; } }
//续房 protected void btnSubmit_Click(object sender, EventArgs e) { int gid = Convert.ToInt32(this.txtGid.Text); int roomid = Convert.ToInt32(Request.QueryString["roomid"]); int day = Convert.ToInt32(this.txtAddDay.Text); DateTime intime = Convert.ToDateTime(this.txtInTime.Text); DateTime outtime = Convert.ToDateTime(this.txtOutTime.Text); int charge = Convert.ToInt32(this.txtAddCharge.Text); BLL_Hotel.Gai_AddDay(intime, outtime, day, charge, roomid);//用户房间续费该表 ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('房间续费成功');location.href='Roomdetail.aspx?roomid=" + roomid + "'", true); }
public string pie() { int year = Convert.ToInt32(Request.QueryString["year"].ToString()); StringBuilder sb = new StringBuilder(); DataTable dt = BLL_Hotel.Cha_YearChargeCount(year); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("['" + dt.Rows[i][0] + "月', " + dt.Rows[i][1] + "],"); } return(sb.ToString()); }
//确认换房 protected void Button1_Click(object sender, EventArgs e) { if (this.DropDownList2.Text != "") { int inday = 1; double price1 = 1; int overday = 1; int addmoney = 1; price(ref inday, ref price1, ref overday, ref addmoney); //-------先退房后添加新的入住信息---------- //修改入住信息表(先退房) int roomid = Convert.ToInt32(Request.QueryString["roomid"]); DataTable dt = BLL_Hotel.Cha_OneRecord(roomid); DateTime now = DateTime.Now; int reid = Convert.ToInt32(dt.Rows[0]["reid"]); BLL_Hotel.Gai_Record(now.ToString(), inday, price1, reid); //退房时 修改房间状 ,如果是房间损坏而换房,则修改状态为“维修中” if (this.DropDownList3.SelectedValue.ToString() == "1") { BLL_Hotel.Gai_roomstate(roomid, 4); } else { BLL_Hotel.Gai_roomstate(roomid, 5); } //客户本次消费金额更新到客户信息表里 BLL_Hotel.Gai_GuestChargeSum(Convert.ToInt32(dt.Rows[0]["gid"]), price1); //更新交易额统计表 BLL_Hotel.Gai_TradeCount(price1); //添加新的入住信息(重新开房) int gid = Convert.ToInt32(this.TextBox1.Text); int newroomid = Convert.ToInt32(this.DropDownList2.SelectedValue); DateTime outtime = Convert.ToDateTime(this.TextBox4.Text); BLL_Hotel.Add_Record(gid, newroomid, DateTime.Now, outtime, overday, addmoney); //添加新房时,修改新房的房间状态为“已入住” BLL_Hotel.Gai_roomstate(newroomid, 2); // Response.Write("<script>alert('换房成功!');location.href='Roomdetail.aspx?roomid=" + newroomid + "';</script>"); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('换房成功');location.href='Roomdetail.aspx?roomid=" + newroomid + "'", true); } else { this.Label1.Text = "请选择需要更换的房间号"; } }
//查询顾客 protected void Button1_Click(object sender, EventArgs e) { if (this.TextBox1.Text != "" && this.TextBox2.Text == "" && this.TextBox5.Text == "" && this.TextBox6.Text == "") { this.Label1.Text = "Gid"; int idd = Convert.ToInt32(this.TextBox1.Text); DataTable dt = BLL_Hotel.Cha_GuestInfoByGid(idd); this.GridView1.DataSource = BLL_Hotel.Cha_GuestInfoByGid(idd, 1);; int ye = fenye(dt.Rows.Count); this.TextBox3.Text = ye.ToString(); this.GridView1.DataBind(); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "$('.tcdPageCode').createPage({pageCount:" + ye + ",current:1,});", true); } else if (this.TextBox1.Text == "" && this.TextBox2.Text != "" && this.TextBox5.Text == "" && this.TextBox6.Text == "") { string Gname = this.TextBox2.Text; this.Label1.Text = "Gname"; DataTable dt = BLL_Hotel.Cha_GuestInfoByGname(Gname); this.GridView1.DataSource = BLL_Hotel.Cha_GuestInfoByGname(Gname, 1); int ye = fenye(dt.Rows.Count); this.TextBox3.Text = ye.ToString(); this.GridView1.DataBind(); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "$('.tcdPageCode').createPage({pageCount:" + ye + ",current:1,});", true); } else if (this.TextBox1.Text == "" && this.TextBox2.Text == "" && this.TextBox5.Text != "" && this.TextBox6.Text == "") { string Mobile = this.TextBox5.Text; this.Label1.Text = "Mobile"; DataTable dt = BLL_Hotel.Cha_GuestInfoByMobile(Mobile); this.GridView1.DataSource = BLL_Hotel.Cha_GuestInfoByMobile(Mobile, 1); int ye = fenye(dt.Rows.Count); this.TextBox3.Text = ye.ToString(); this.GridView1.DataBind(); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "$('.tcdPageCode').createPage({pageCount:" + ye + ",current:1,});", true); } else if (this.TextBox1.Text == "" && this.TextBox2.Text == "" && this.TextBox5.Text == "" && this.TextBox6.Text != "") { string pid = this.TextBox6.Text; this.Label1.Text = "Pid"; DataTable dt = BLL_Hotel.Cha_GuestInfoByPid(pid); this.GridView1.DataSource = BLL_Hotel.Cha_GuestInfoByPid(pid, 1); int ye = fenye(dt.Rows.Count); this.TextBox3.Text = ye.ToString(); this.GridView1.DataBind(); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "$('.tcdPageCode').createPage({pageCount:" + ye + ",current:1,});", true); } else { bind(); } }
//根据天数计算押金金额 public void price() { if (this.txtDayNum.Text != "") { int day = Convert.ToInt32(this.txtDayNum.Text); int Roomid = Convert.ToInt32(this.ddlRoomName.SelectedValue); DataTable dt = BLL_Hotel.Cha_One(Roomid);//查询该房间每日金额以计算押金 int DP = Convert.ToInt32(dt.Rows[0]["rtprice"]); this.txtCharge.Text = ((day + 0) * DP).ToString(); DateTime inttime = Convert.ToDateTime(this.txtInTime.Text); this.txtOutTime.Text = inttime.AddDays(+day).ToString(); } }
public void hehe() { int allye = Convert.ToInt32(BLL_Hotel.Live_Mark("record").Rows.Count.ToString()); if (allye % 10 == 0) { this.TextBox7.Text = (allye / 10).ToString(); } else { this.TextBox7.Text = (allye / 10 + 1).ToString(); } }
//添加入住信息 protected void Button1_Click(object sender, EventArgs e) { int gid = Convert.ToInt32(this.TextBox1.Text); int roomid = Convert.ToInt32(Request.QueryString["roomid"]); int day = Convert.ToInt32(this.TextBox9.Text); DateTime intime = Convert.ToDateTime(this.TextBox8.Text); DateTime outtime = Convert.ToDateTime(this.TextBox4.Text); int charge = Convert.ToInt32(this.TextBox6.Text); BLL_Hotel.Gai_AddDay(intime, outtime, day, charge, roomid); //Response.Write("<script>alert('房间续费成功!');location.href='Roomdetail.aspx?roomid=" + roomid + "';</script>"); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('房间续费成功');location.href='Roomdetail.aspx?roomid=" + roomid + "'", true); }
public void imgtype(int type) { this.Image1.ImageUrl = "images/ico/type" + type + ".jpg"; this.Image2.ImageUrl = "images/ico/type" + type + ".jpg"; this.Image3.ImageUrl = "images/ico/type" + type + ".jpg"; this.Image4.ImageUrl = "images/ico/type" + type + ".jpg"; this.Image5.ImageUrl = "images/ico/type" + type + ".jpg"; this.Image6.ImageUrl = ""; DataTable dt = BLL_Hotel.image_TableType(type); this.DataList1.DataSource = dt; this.DataList1.DataBind(); }
public void hehe() { int allye = Convert.ToInt32(BLL_Hotel.Cha_Cus().Rows.Count.ToString()); if (allye % 6 == 0) { this.TextBox7.Text = (allye / 6).ToString(); } else { this.TextBox7.Text = (allye / 6 + 1).ToString(); } }