public static bool InsertCheckOutRoomInfo(Mouse_2017101992.CheckOutRoom checkOutRoomInfo)
{
string sqlInsert = @"INSERT INTO CheckOutRoom VALUES(@outId, @inId, @outTime, @roomId, @clientName, @inTime,@price, @foregift, @total, @account, @note, @oper)";
string sqlUpdateRegister = @"UPDATE RegisterRoom SET delMark=1 WHERE inId=@inId";
string sqlUpdateRoom = @"UPDATE Room SET inPerson=0 WHERE roomId=@roomId";
SqlParameter p1 = new SqlParameter("@outId", checkOutRoomInfo.OutId);
SqlParameter p2 = new SqlParameter("@inId", checkOutRoomInfo.InId);
SqlParameter p3 = new SqlParameter("@roomId", checkOutRoomInfo.RoomId);
SqlParameter p4 = new SqlParameter("@price", double.Parse(Convert.ToString(checkOutRoomInfo.Price)));
SqlParameter p5 = new SqlParameter("@foregift", double.Parse(Convert.ToString(checkOutRoomInfo.Foregift)));
SqlParameter p6 = new SqlParameter("@total", double.Parse(Convert.ToString(checkOutRoomInfo.Total)));
SqlParameter p7 = new SqlParameter("@account", double.Parse(Convert.ToString(checkOutRoomInfo.Account)));
SqlParameter p8 = new SqlParameter("@inTime", checkOutRoomInfo.InTime);
SqlParameter p9 = new SqlParameter("@outTime", checkOutRoomInfo.OutTime);
SqlParameter p10 = new SqlParameter("@clientName", checkOutRoomInfo.ClientName);
SqlParameter p11 = new SqlParameter("@oper", checkOutRoomInfo.Oper);
SqlParameter p12 = new SqlParameter("@note", checkOutRoomInfo.Note);
Mouse_2017101992.RegisterRoom registerInfo = new Mouse_2017101992.RegisterRoom();
registerInfo.InId = checkOutRoomInfo.InId;
SqlParameter n1 = new SqlParameter("@inId", registerInfo.InId);
SqlParameter n2 = new SqlParameter("@roomId", checkOutRoomInfo.RoomId.ToString());
if (DAL.DBOper.ExecuteCommmand(sqlInsert, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12) == 1 &&
DAL.DBOper.ExecuteCommmand(sqlUpdateRegister, n1) == 1 &&
DAL.DBOper.ExecuteCommmand(sqlUpdateRoom, n2) == 1)
{
return(true);
}
else
{
return(false);
}
}
//存储按钮
public void SaveBtn_Click(object sender, EventArgs e)
{
if (checkdata() == false)
{
return;
}
string strTimeNow = string.Format("{0:T}", DateTime.Now);
string inTime = dtpIn.Text.ToString();
string outTime = dtpOut.Text.ToString() + strTimeNow;
int inId = int.Parse(BLL_2017101992.RoomManager.GetInID(HouseNumberBox.SelectedItem.ToString()).Rows[0][0].ToString());
Mouse_2017101992.CheckOutRoom checkOutRoom = new Mouse_2017101992.CheckOutRoom();
checkOutRoom.OutId = DateTime.Now.ToString("yyyyMMddHHmmss");
checkOutRoom.InId = inId;
checkOutRoom.RoomId = Convert.ToInt32(HouseNumberBox.SelectedItem.ToString());
checkOutRoom.Price = double.Parse(ciMoneyBox.Text);
checkOutRoom.Foregift = double.Parse(riaMoneyBox.Text.ToString());
checkOutRoom.Total = double.Parse(TotalMoneyBox.Text.ToString());
checkOutRoom.Account = double.Parse(AccountMoneyBox.Text.ToString());
checkOutRoom.InTime = DateTime.Parse(inTime);
checkOutRoom.OutTime = DateTime.Parse(outTime);
checkOutRoom.ClientName = TextName.Text.ToString();
checkOutRoom.Oper = BLL_2017101992.RoleManager_2017101992.curUser.Name;
checkOutRoom.Note = SomethingBox.Text.ToString();
if (BLL_2017101992.RoomManager.InsertCheckOutRoomInfo(checkOutRoom))
{
MessageBox.Show("插入数据成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
MessageBox.Show("插入数据失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
