public static bool InsertCheckOutRoomInfo(CheckOutRoom checkOutRoomInfo)
{
string sqlInsert = @"insert into checkout values(@outId,@inId,@outTime,@roomId,@clientName,@inTime,@price,@foregift,@account,@note,@oper)";
string sqlUpdateRegister = "update checkin set delMark=1 where inId=@inId";
string sqlUpdateRoom = "update room set inPerson=0 where roomId=@roomId";
MySqlParameter p1 = new MySqlParameter("@outId", checkOutRoomInfo.OutId);
MySqlParameter p2 = new MySqlParameter("@inId", checkOutRoomInfo.InId);
MySqlParameter p3 = new MySqlParameter("@roomId", checkOutRoomInfo.RoomId);
MySqlParameter p4 = new MySqlParameter("@price", checkOutRoomInfo.Price.ToString());
MySqlParameter p5 = new MySqlParameter("@foregift", checkOutRoomInfo.Foregift.ToString());
MySqlParameter p6 = new MySqlParameter("@total", checkOutRoomInfo.Total.ToString());
MySqlParameter p7 = new MySqlParameter("@account", checkOutRoomInfo.Account.ToString());
MySqlParameter p8 = new MySqlParameter("@inTime", checkOutRoomInfo.InTime);
MySqlParameter p9 = new MySqlParameter("@outTime", checkOutRoomInfo.OutTime);
MySqlParameter p10 = new MySqlParameter("@clientName", checkOutRoomInfo.ClietnName);
MySqlParameter p11 = new MySqlParameter("@oper", checkOutRoomInfo.Oper);
MySqlParameter p12 = new MySqlParameter("@note", checkOutRoomInfo.Note);
MySqlParameter[] paramArray = new MySqlParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12 };
MySqlParameter n1 = new MySqlParameter("@inId", checkOutRoomInfo.InId);
MySqlParameter n2 = new MySqlParameter("@roomId", checkOutRoomInfo.RoomId);
if (DBOper.ExecuteCommand(sqlInsert, paramArray) == 1 &&
DBOper.ExecuteCommand(sqlUpdateRegister, n1) == 1 &&
DBOper.ExecuteCommand(sqlUpdateRoom, n2) == 1)
{
return(true);
}
else
{
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (checkdata() == false)
{
return;
}
string inTime = txtInTime.Text.ToString();
string strTimeNow = string.Format("{0:T}", DateTime.Now);
string outTime = dtpOutTime.Text.ToString() + strTimeNow;
int inId = int.Parse(RoomManager.GetInID(cmbRoomId.SelectedItem.ToString()).Rows[0][0].ToString());
CheckOutRoom checkOutRoom = new CheckOutRoom();
checkOutRoom.OutId = DateTime.Now.ToString("yyyyMMddHHmmss");
checkOutRoom.InId = inId;
checkOutRoom.RoomId = cmbRoomId.SelectedItem.ToString();
checkOutRoom.Price = double.Parse(txtPrice.Text.ToString());
checkOutRoom.Foregift = double.Parse(txtForegift.Text.ToString());
checkOutRoom.Total = double.Parse(txtTotal.Text.ToString());
checkOutRoom.Account = double.Parse(txtAccount.Text.ToString());
checkOutRoom.InTime = DateTime.Parse(inTime);
checkOutRoom.OutTime = DateTime.Parse(outTime);
checkOutRoom.ClietnName = txtClientName.Text.ToString();
checkOutRoom.Oper = RoleManager.curUser.Name;
checkOutRoom.Note = txtNote.Text.ToString();
if (RoomManager.InsertCheckOutRoomInfo(checkOutRoom))
{
MessageBox.Show("退房信息保存成功");
return;
}
else
{
MessageBox.Show("退房信息保存失败");
return;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
CheckOutRoom checkOutRoom = GetCheckOutRoom();
if (RoomManager.InsertCheckOutRoomInfo(checkOutRoom))
{
MessageBox.Show("插入数据成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("插入数据失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private CheckOutRoom GetCheckOutRoom()
{
CheckOutRoom info = new CheckOutRoom();
info.OutId = DateTime.Now.ToString("yyyyMMddHHmmss");
info.InId = Convert.ToInt32(RoomManager.GetInID(cmbRoomId.SelectedItem.ToString()).Rows[0][0].ToString());
info.RoomId = cmbRoomId.SelectedItem.ToString();
info.Price = Convert.ToDouble(txtPrice.Text);
info.Foregift = Convert.ToDouble(txtForegift.Text);
info.Total = Convert.ToDouble(txtTotal.Text);
info.Account = Convert.ToDouble(txtAccount.Text);
info.InTime = DateTime.Parse(txtInTime.Text);
info.OutTime = dtpOutTime.Value;
info.ClientName = txtClientName.Text;
info.Oper = RoleManager.curUser.UserName;
info.Note = txtNote.Text;
return(info);
}
