public static bool InsertRoomInfo(CheckInRoom registerRoomInfo)
{
string sqlInsert = @"insert into checkin values(null,@roomId,@price,@foregift,@inTime,@outTime,@clientName,
@sex,@phone,@cerType,@certId,@address,@personNum,@Oper,@deMark)";
MySqlParameter p1 = new MySqlParameter("@roomId", registerRoomInfo.RoomId);
MySqlParameter p2 = new MySqlParameter("@price", registerRoomInfo.Price);
MySqlParameter p3 = new MySqlParameter("@foregift", registerRoomInfo.Foregift);
MySqlParameter p4 = new MySqlParameter("@inTime", registerRoomInfo.InTime);
MySqlParameter p5 = new MySqlParameter("@outTime", registerRoomInfo.OutTime);
MySqlParameter p6 = new MySqlParameter("@clientName", registerRoomInfo.ClientName);
MySqlParameter p7 = new MySqlParameter("@sex", registerRoomInfo.Sex);
MySqlParameter p8 = new MySqlParameter("@phone", registerRoomInfo.Phone);
MySqlParameter p9 = new MySqlParameter("@certType", registerRoomInfo.CertType);
MySqlParameter p10 = new MySqlParameter("@certId", registerRoomInfo.CertId);
MySqlParameter p11 = new MySqlParameter("@address", registerRoomInfo.Address);
MySqlParameter p12 = new MySqlParameter("@personNum", registerRoomInfo.PersonNum);
MySqlParameter p13 = new MySqlParameter("@Oper", registerRoomInfo.Oper);
MySqlParameter p14 = new MySqlParameter("@delMark", registerRoomInfo.DelMark);
MySqlParameter[] paramArray = new MySqlParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14 };
string sqlUpdate = "update room set inPerson=@inPerson where roomId=@roomId";
MySqlParameter n1 = new MySqlParameter("@roomId", registerRoomInfo.RoomId);
MySqlParameter n2 = new MySqlParameter("@inPerson", registerRoomInfo.PersonNum);
if (DBOper.ExecuteCommand(sqlInsert, paramArray) == 1 && DBOper.ExecuteCommand(sqlInsert, n1, n2) == 1)
{
return(true);
}
else
{
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool sex = default(bool);
if (rbMale.Checked)
{
sex = false;
}
else
{
sex = true;
}
CheckInRoom registerInfo = new CheckInRoom();
registerInfo.RoomId = dgvClient.SelectedRows[0].Cells[0].Value.ToString();
registerInfo.Price = double.Parse(dgvClient.SelectedRows[0].Cells[1].Value.ToString());
registerInfo.Foregift = double.Parse(dgvClient.SelectedRows[0].Cells[2].Value.ToString());
registerInfo.InTime = DateTime.Parse(dgvClient.SelectedRows[0].Cells[3].Value.ToString());
registerInfo.OutTime = DateTime.Parse(dgvClient.SelectedRows[0].Cells[4].Value.ToString());
registerInfo.ClientName = txtClientName.Text.ToString();
registerInfo.Sex = sex;
registerInfo.Phone = txtPhone.Text.ToString();
registerInfo.CertType = cmbCertType.SelectedItem.ToString();
registerInfo.CertId = txtCertId.Text.ToString();
registerInfo.PersonNum = int.Parse(txtPersonNum.Text.ToString());
registerInfo.Address = txtAddress.Text.ToString();
registerInfo.Oper = dgvClient.SelectedRows[0].Cells[12].Value.ToString();
registerInfo.DelMark = int.Parse(dgvClient.SelectedRows[0].Cells[13].Value.ToString());
registerInfo.InId = int.Parse(dgvClient.SelectedRows[0].Cells[14].Value.ToString());
if (checkdata())
{
if (ClientManager.UpdateRegister(registerInfo))
{
MessageBox.Show("住客信息修改");
DataTable dt = ClientManager.GetClientInfo();
dgvClient.DataSource = dt;
}
else
{
MessageBox.Show("住客信息修改失败");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string strTimeNow = string.Format("{0:T}", DateTime.Now);
string inTime = dtpInTime.Text.ToString() + strTimeNow;
string outTime = dtpOutTime.Text.ToString() + strTimeNow;
bool sex = true;
if (rbMale.Checked)
{
sex = false;
}
CheckInRoom registerInfo = new CheckInRoom();
registerInfo.RoomId = txtRoomId.Text;
registerInfo.Price = Convert.ToDouble(txtPrice.Text);
registerInfo.Foregift = Convert.ToDouble(txtForegift.Text);
registerInfo.InTime = Convert.ToDateTime(inTime);
registerInfo.OutTime = Convert.ToDateTime(outTime);
registerInfo.ClientName = txtClientName.Text;
registerInfo.Sex = sex;
registerInfo.Phone = txtPhone.Text;
registerInfo.CertId = txtCertId.Text;
registerInfo.CertType = cmbCertType.SelectedItem.ToString();
registerInfo.PersonNum = Convert.ToInt32(txtPersonNum.Text);
registerInfo.Oper = txtOper.Text;
registerInfo.Address = txtAddress.Text;
registerInfo.DelMark = 0;
if (CheckData())
{
if (RoomManager.InsertRoomInfo(registerInfo))
{
MessageBox.Show("入住登记成功！");
}
else
{
MessageBox.Show("入住登记失败!");
}
}
}
public static bool UpdateRegister(CheckInRoom registerRoomInfo)
{
string sqlUpdateRegister = @"update checkin set clientName=@clientName,sex=@sex,phone=@phone,certType=@certType,certId=@certId,
address=@address,personNum=@personNum where inId=@inId";
MySqlParameter p1 = new MySqlParameter("@clientName", registerRoomInfo.ClientName);
MySqlParameter p2 = new MySqlParameter("@clientName", registerRoomInfo.Sex);
MySqlParameter p3 = new MySqlParameter("@clientName", registerRoomInfo.Phone);
MySqlParameter p4 = new MySqlParameter("@clientName", registerRoomInfo.CertType);
MySqlParameter p5 = new MySqlParameter("@clientName", registerRoomInfo.CertId);
MySqlParameter p6 = new MySqlParameter("@clientName", registerRoomInfo.Address);
MySqlParameter p7 = new MySqlParameter("@clientName", registerRoomInfo.PersonNum);
MySqlParameter p8 = new MySqlParameter("@clientName", registerRoomInfo.InId);
MySqlParameter[] paramArray = new MySqlParameter[] { p1, p2, p3, p4, p5, p6, p7, p8 };
if (DBOper.ExecuteCommand(sqlUpdateRegister, paramArray) == 1)
{
return(true);
}
else
{
return(false);
}
}
