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