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