/// <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; }