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