//确认换房 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 btnEnCheckIn_Click(object sender, EventArgs e) { int roomid = Convert.ToInt32(Request.QueryString["roomid"]); DataTable dt = BLL_Hotel.Cha_OneReserve(roomid);//根据房间编号查询预约信息 int gid = Convert.ToInt32(dt.Rows[0]["gid"]); DateTime intime = Convert.ToDateTime(dt.Rows[0]["intime"]); DateTime outtime = Convert.ToDateTime(dt.Rows[0]["outtime"]); int day = Convert.ToInt32(dt.Rows[0]["daynum"]); double charge = Convert.ToDouble(dt.Rows[0]["charge"]); BLL_Hotel.Add_Record(gid, roomid, intime, outtime, day, charge); //将预约信息表的记录转到入住信息表中 BLL_Hotel.Qu_Reserve(roomid, "已转正入住"); //更换房间信息 BLL_Hotel.Gai_roomstate(roomid, 2); //修改房间状态为已入住 Response.Write("<script>alert('房间转正成功!');location.href='RoomDetail.aspx?roomid='+" + roomid + "</script>"); }
//添加入住信息 protected void btnSubmint_Click(object sender, EventArgs e) { if (Convert.ToInt32(this.txtDays.Text) > 0) { int gid = Convert.ToInt32(this.txtGid.Text); int roomid = Convert.ToInt32(this.ddlRoomName.SelectedValue); int day = Convert.ToInt32(this.txtDays.Text); DateTime intime = Convert.ToDateTime(this.txtInTime.Text); DateTime outtime = Convert.ToDateTime(this.txtOutTime.Text); double charge = Convert.ToInt32(this.txtCharge.Text); BLL_Hotel.Add_Record(gid, roomid, intime, outtime, day, charge); //入住登记(入住信息表插入数据) BLL_Hotel.Gai_roomstate(roomid, 2); //修改房间状态 ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('入住登记成功');location.href='Roomdetail.aspx?roomid=" + roomid + "'", true); } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('天数输入有误!');", true); } }
//添加入住信息 protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(this.TextBox9.Text) > 0) { int gid = Convert.ToInt32(this.TextBox1.Text); int roomid = Convert.ToInt32(this.DropDownList2.SelectedValue); int day = Convert.ToInt32(this.TextBox9.Text); DateTime intime = Convert.ToDateTime(this.TextBox8.Text); DateTime outtime = Convert.ToDateTime(this.TextBox4.Text); double charge = Convert.ToInt32(this.TextBox6.Text); BLL_Hotel.Add_Record(gid, roomid, intime, outtime, day, charge); BLL_Hotel.Gai_roomstate(roomid, 2); ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('入住登记成功');location.href='Roomdetail.aspx?roomid=" + roomid + "'", true); //Response.Write("<script>alert('信息添加成功!');</script>"); } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('天数输入有误!');", true); } }