/// <summary>
/// 根据房间编号获取入住信息
/// </summary>
/// <param name="fjbh"></param>
/// <returns></returns>
public static CheckInfoVo GetRecordInfo(string fjbh)
{
CheckInfoVo checkInfoVo = new CheckInfoVo();
string sql = "select a.fjbh,b.yhxm,b.sfzhm,a.rzrq from roomrecord a LEFT JOIN guestrecord b on a.lsh = b.lsh where a.fjbh = @fjbh and a.rzzt = '1'";
MySqlParameter[] para =
{
new MySqlParameter("@fjbh", fjbh)
};
MySqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, para);
reader.Read();
checkInfoVo.fjbh = reader["fjbh"].ToString();
checkInfoVo.yhxm = reader["yhxm"].ToString();
checkInfoVo.sfzhm = reader["sfzhm"].ToString();
checkInfoVo.rzrq = Convert.ToDateTime(reader["rzrq"].ToString());
return(checkInfoVo);
}
/// <summary>
/// 根据房间编号获取状态为1的入住记录
/// </summary>
private void GetGuestInfoWifhFjbh()
{
try
{
checkInfoVo = Bll_Guset.GetRecordInfo(fjbh);
lb_khxm.Text = checkInfoVo.yhxm;
lb_sfzmhm.Text = checkInfoVo.sfzhm;
lb_rzrq.Text = checkInfoVo.rzrq.ToString();
}
catch (MySqlException ex)
{
MessageBox.Show("数据库异常：" + ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("其它异常：" + ex.Message);
}
}
