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();
}
}
