/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ToolStripButton3_Click(object sender, EventArgs e) { if (dgvRoom.SelectedRows[0].Cells[2].Value.ToString().Trim() == "占用") { MessageBox.Show("已有顾客!"); return; } RoomInsertAndUpdate riau = new RoomInsertAndUpdate(); riau.frm = this; riau.asd = toolStripButton3.Text; RoomSchedules room = new RoomSchedules() { Floor = dgvRoom.SelectedRows[0].Cells[3].Value.ToString(), RoomNumber = dgvRoom.SelectedRows[0].Cells[1].Value.ToString(), RoomStatus = new RoomStatus() { StatusName = dgvRoom.SelectedRows[0].Cells[2].Value.ToString() }, RoomType = new RoomTypeTable() { Name = dgvRoom.SelectedRows[0].Cells[4].Value.ToString() } }; riau.roo = room; riau.Show(); }
/// <summary> /// 为房间表插入一行数据并返回,需要提供房间对象 /// </summary> /// <param name="room">插入的房间信息</param> /// <returns></returns> public DataTable RoomInsert(RoomSchedules room) { DataRow dr = HotelData.Data.Tables["RoomSchedules"].NewRow(); dr["RoomNumber"] = room.RoomNumber; dr["Floor"] = room.Floor; dr["RoomType"] = room.RoomType.No; dr["RoomStatus"] = room.RoomStatus.No; HotelData.Data.Tables["RoomSchedules"].Rows.Add(dr); HotelData.UploadData(); return(HotelData.Data.Tables["RoomSchedules"]); }
/// <summary> /// 为房间表修改一行数据并返回,需要提供房间编号(名称),以及修改的内容 /// </summary> /// <param name="num"></param> /// <param name="room"></param> /// <returns></returns> public DataTable RoomUpdate(string num, RoomSchedules room) { for (int i = 0; i < HotelData.Data.Tables["RoomSchedules"].Rows.Count; i++) { if (HotelData.Data.Tables["RoomSchedules"].Rows[i]["RoomNumber"].ToString() == num) { HotelData.Data.Tables["RoomSchedules"].Rows[i]["RoomType"] = room.RoomType.No; HotelData.Data.Tables["RoomSchedules"].Rows[i]["RoomStatus"] = room.RoomStatus.No; break; } } HotelData.UploadData(); return(HotelData.Data.Tables["RoomSchedules"]); }
// 修改预定的房间状态 private void AlterRoomStatr() { //新增房间或者预定房间时修改房间状态 RoomSchedules room = new RoomSchedules() { Floor = this.Dgv_RoomList.SelectedRows[0].Cells[2].Value.ToString(), RoomNumber = this.Dgv_RoomList.SelectedRows[0].Cells[0].Value.ToString(), RoomStatus = new RoomStatus { No = 2 }, RoomType = new RoomTypeTable { No = new RoomTypeManager().TypeID(this.Dgv_RoomList.SelectedRows [0].Cells [3].Value.ToString()) } }; new RoomManager().RoomUpdate(room.RoomNumber, room); }
private void Button1_Click(object sender, EventArgs e) { if (PanDuan()) { RoomSchedules room = new RoomSchedules() { Floor = txtLou.Text, RoomNumber = txtRoomName.Text, RoomStatus = new RoomStatus() { No = 1 }, RoomType = new RoomTypeTable() { Name = cbRoomType.Text, No = rtm.TypeID(cbRoomType.Text) } }; rm.RoomInsert(room); frm.ShuaXin(); } }
private void Button1_Click(object sender, EventArgs e) { if (PanDuan()) { if (lblZhu.Visible == false) { RoomSchedules room = new RoomSchedules() { Floor = txtLou.Text, RoomNumber = txtRoomName.Text, RoomStatus = new RoomStatus() { No = 1 }, RoomType = new RoomTypeTable() { Name = cbRoomType.Text, No = rtm.TypeID(cbRoomType.Text) } }; if (asd == "新增") { rm.RoomInsert(room); } else { rm.RoomUpdate(roo.RoomNumber, room); } MessageBox.Show("操作成功"); frm.ShuaXin(); this.Close(); } else { MessageBox.Show("已有此房间"); } } }
/// <summary> /// 为房间表修改一行数据并返回,需要提供房间编号(名称),以及修改的内容 /// </summary> /// <param name="num"></param> /// <param name="room"></param> /// <returns></returns> public DataTable RoomUpdate(string num, RoomSchedules room) { return(service.RoomUpdate(num, room)); }
/// <summary> /// 为房间表插入一行数据并返回,需要提供房间对象 /// </summary> /// <param name="room"></param> /// <returns></returns> public DataTable RoomInsert(RoomSchedules room) { return(service.RoomInsert(room)); }
/// <summary> /// 确定按钮,同时修改用户表,订单表,房间表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button2_Click(object sender, EventArgs e) { UserManager um = new UserManager();//用户表修改 DataTable dt = um.CompareUserIDCard(dgvUser.SelectedRows[0].Cells[10].Value.ToString()); UserTable ut = new UserTable(); ut.Age = int.Parse(dt.Rows[0]["Age"].ToString()); ut.Gender = dt.Rows[0]["Gender"].ToString(); ut.IDCard = dt.Rows[0]["IDCard"].ToString(); ut.Member = new MembershipTable() { MemberNumber = int.Parse(dt.Rows[0]["Member"].ToString()) }; ut.TelephoneNumber = dt.Rows[0]["TelephoneNumber"].ToString(); ut.UserName = dt.Rows[0]["UserName"].ToString(); if (cbFuKuan.Text == "余额支付") { ut.Balance = double.Parse(txtLing.Text) < 0 ? 0 : double.Parse(txtLing.Text); } RoomManager rm = new RoomManager();//房间表修改 RoomSchedules rs = new RoomSchedules(); rs.Floor = dgvUser.SelectedRows[0].Cells[11].Value.ToString(); rs.RoomNumber = dgvUser.SelectedRows[0].Cells[1].Value.ToString(); rs.RoomType = new RoomTypeTable() { No = int.Parse(dgvUser.SelectedRows[0].Cells[12].Value.ToString()) }; rs.RoomStatus = new RoomStatus() { No = 1, StatusName = "空闲" }; OrderManager om = new OrderManager();//订单表修改 DataTable ad = om.SeekOrderRecord(new StatementTable() { OrderNumber = dgvUser.SelectedRows[0].Cells[0].Value.ToString().Trim() }); StatementTable st = new StatementTable(); for (int i = 0; i < ad.Rows.Count; i++) { if (ad.Rows[i]["OrderNumber"].ToString().Trim() == dgvUser.SelectedRows[0].Cells[0].Value.ToString().Trim()) { st = new StatementTable() { CheckInTime = DateTime.Parse(ad.Rows[i]["CheckInTime"].ToString()), CheckoutTime = DateTime.Now, IDCard = ad.Rows[i]["IDCard"].ToString(), OperationManager = int.Parse(ad.Rows[i]["OperationManaer"].ToString()), OrderNumber = ad.Rows[i]["OrderNumber"].ToString(), PaymentMethod = cbFuKuan.Text, Room = new RoomSchedules() { RoomNumber = ad.Rows[i]["RoomNumber"].ToString() }, TotalConsumption = double.Parse(txtYinFu.Text), Status = new OrderStatusTable() { Number = 3, State = "结束" } }; break; } } //集中修改三张表 um.AmendUserRecord(ut); om.AmendOrderRecord(st); rm.RoomUpdate(rs.RoomNumber, rs); //打印订单 string path = string.Format("{0}.txt", dgvUser.Rows[0].Cells[0].Value.ToString().Trim()); using (FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write)) { StreamWriter sw = new StreamWriter(fs); sw.WriteLine("* **************************"); sw.WriteLine("租房客人:{0}", dgvUser.Rows [0].Cells [2].Value.ToString().Trim()); sw.WriteLine("所住房间:{0}", dgvUser.Rows [0].Cells [1].Value.ToString().Trim()); sw.WriteLine("入住时间:{0}", dgvUser.Rows [0].Cells [4].Value.ToString().Trim()); sw.WriteLine("结账时间:{0}", dgvUser.Rows [0].Cells [5].Value.ToString().Trim()); sw.WriteLine("付款方式:{0}", dgvUser.Rows [0].Cells [7].Value.ToString().Trim()); sw.WriteLine("应付金额:{0}", dgvUser.Rows [0].Cells [6].Value.ToString().Trim()); sw.WriteLine("实付金额:{0}", dgvUser.Rows [0].Cells [9].Value.ToString().Trim()); sw.WriteLine("折扣:{0}", dgvUser.Rows [0].Cells [8].Value.ToString().Trim()); sw.WriteLine("* **************************"); sw.Close(); } dgvRoom.DataSource = stm.Statement(txtRoomName.Text.Trim()); dgvUser.DataSource = null; txtLing.Text = ""; txtDingDan.Text = ""; txtYinFu.Text = ""; txtZon.Text = ""; cbFuKuan.Text = ""; txtZon.Enabled = false; }