Example #1
0
        //确认换房
        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>");
        }
Example #3
0
        //添加入住信息
        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);
            }
        }
Example #4
0
        //添加入住信息
        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);
            }
        }