partial void UpdateTable_Hotel(Table_Hotel instance);
partial void DeleteTable_Hotel(Table_Hotel instance);
partial void InsertTable_Hotel(Table_Hotel instance);
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { reservation = (Table_HotelReservation)Session["Reservation"]; if (reservation.Id != -1) { TextBox1.Text = reservation.name.Substring(0, reservation.name.IndexOf(".", 0)); TextBox2.Text = reservation.name.Substring(reservation.name.IndexOf(".", 0) + 1, reservation.name.Length - reservation.name.IndexOf(".", 0) - 1); TextBox3.Text = reservation.PhoneNum.ToString(); TextBox5.Text = reservation.EmailAddress; if (reservation.sex == "male") DropDownList1.SelectedIndex = 0; else DropDownList1.SelectedIndex = 1; } //如果用户已经登陆则textbox1-5依次填入用户信息。 else if (Session["Customer"] != null) { Table_Customer customer = dbc.GetCustomer(Session["Customer"].ToString()); TextBox1.Text = customer.FirstName; TextBox2.Text = customer.LastName; TextBox3.Text = customer.PhoneNumber; TextBox5.Text = customer.EmailAddress; if (customer.Sex == "male") DropDownList1.SelectedIndex = 0; else DropDownList1.SelectedIndex = 1; TextBox1.Enabled = TextBox2.Enabled = TextBox3.Enabled = TextBox5.Enabled = false; DropDownList1.Enabled = false; } //如果用户没有登陆,则textbook1-5为空 //加载右边订单信息 hotel = dbc.GetHotelById(reservation.HotelId); room = dbc.GetRoomByHotelIdAndRoomType(reservation.HotelId, reservation.RoomType); TimeSpan t=reservation.CheckOut-reservation.CheckIn; // Label10.Text = "$" + room.FullRate.ToString(); Label1.Text = t.Days.ToString(); Label2.Text = reservation.RoomNum.ToString(); Label3.Text = reservation.GuestNum.ToString(); Label4.Text = "$" + reservation.Value.ToString(); Label_cost.InnerText = "$" + reservation.Value.ToString(); Label5.Text = hotel.Name; Label6.Text = hotel.Address; Label7.Text = reservation.RoomType; Label8.Text = reservation.CheckIn.ToString("yyyy/MM/dd"); Label9.Text = reservation.CheckOut.ToString("yyyy/MM/dd"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { Room = dbc.GetRoomByHotelId(Convert.ToInt32(Request["hotelId"])); hotel = dbc.GetHotelById(Convert.ToInt32(Request["hotelId"])); price = dbc.GetHotelPrice(Convert.ToInt32(Request["hotelId"])); var q = from s in data.Table_Comment where s.HotelId == hotel.Id select s; comment = q.ToList(); AvaRating = 0; if (comment.Count != 0) { foreach (Table_Comment c in comment) AvaRating += c.Score; AvaRating /= comment.Count; } AvaRatingString = Rating(AvaRating); CheckIn = Request["CheckIn"]; CheckOut = Request["CheckOut"]; RoomNum = Convert.ToInt32(Request["RoomNum"]); GuestNum = Convert.ToInt32(Request["GuestNum"]); TotalRoomNum = 0; foreach (Table_Room r in Room) { TotalRoomNum += r.TotalNumber; } } catch (Exception) { } Calendar1.SelectedDate = System.DateTime.Now; Calendar2.SelectedDate = System.DateTime.Now.AddDays(1); Button2.Text = Calendar1.SelectedDate.ToString("yyyy/MM/dd"); Button3.Text = Calendar2.SelectedDate.ToString("yyyy/MM/dd"); Label1.Text = CheckIn; Label2.Text = CheckOut; Label3.Text = RoomNum.ToString() + "Room," + GuestNum.ToString() + "Guest"; } }
//添加新酒店 public void AddHotel(Table_Hotel hotel) { data.Table_Hotel.InsertOnSubmit(hotel); data.SubmitChanges(); }
//更新酒店信息 public void UpdateHotel(Table_Hotel hotel) { var q = from s in data.Table_Hotel where s.Id==hotel.Id select s; foreach (Table_Hotel c in q) { c.Address = hotel.Address; c.ContactNumber = hotel.ContactNumber; c.ImageUrl = hotel.ImageUrl; c.Name = hotel.Name; c.StarLevel = hotel.StarLevel; } data.SubmitChanges(); }