roomdal.cs

酒店管理系统

        public void UpdateRoomByBoomID(Room room)
        { 
            using(SqlConnection conn=new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand("usp_UpdateRoom", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter[] pars = new SqlParameter[]{
                    new SqlParameter("@Number",SqlDbType.NVarChar,50),
                    new SqlParameter("@TypeID",SqlDbType.Int),
                    new SqlParameter("@BedNumber",SqlDbType.Int),
                    new SqlParameter("@Description",SqlDbType.NVarChar,50),
                    new SqlParameter("@StatusID",SqlDbType.Int),
                    new SqlParameter("@GuestNumber",SqlDbType.Int),
                    new SqlParameter("@RoomID",SqlDbType.Int)
                };
                pars[0].Value = room.Number;
                pars[1].Value = room.TypeID;
                pars[2].Value = room.BedNumber;
                pars[3].Value = room.Description;
                pars[4].Value = room.State.ID;
                pars[5].Value = room.GuestNumber;
                pars[6].Value = room.RoomID;
                foreach (SqlParameter par in pars)
                {
                    cmd.Parameters.Add(par);
                }
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        #endregion

        #region 根据房间编号删除房间信息
        /// <summary>
        /// 根据房间编号删除房间信息
        /// </summary>
        /// <param name="roomID">房间编号</param>
        public void DeleteRoomByRoomID(int roomID)
        { 
            using(SqlConnection conn=new SqlConnection(strConn))
            {
                SqlCommand cmd=new SqlCommand("usp_DeleteRoom",conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@RoomID",SqlDbType.Int).Value=roomID;
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally 
                {
                    conn.Close();
                }
            }
        }
        #endregion

        #region 根据客房状态查询房间号
        /// <summary>
        /// 根据客房状态查询房间号
        /// </summary>
        /// <param name="statusID">房间状态</param>
        /// <returns>房间实体</returns>
        public List<Room> SelectRoomsByStatusID(string statusID)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand("usp_SelectRoomsByStatusID", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@StatusID",SqlDbType.Int).Value=statusID;
                List<Room> list = new List<Room>();
                try
                {
                    conn.Open();
                    SqlDataReader dr = cmd.ExecuteReader();
                    while (dr.Read())
                    {
                        Room r = new Room();
                        r.Number = dr[0].ToString();
                        list.Add(r);
                    }
                    return list;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        #endregion

        #region 根据房间号码查询房间编号
        /// <summary>
        /// 根据房间号码查询房间编号
        /// </summary>
        /// <param name="number">房间号码</param>
        /// <returns>房间编号</returns>
        public int SelectRoomIDByRoomNumber(string number)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                List<Room> list = new List<Room>();
                SqlCommand cmd = new SqlCommand("usp_SelectRoomIDByNumber", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@Number", SqlDbType.NVarChar, 50).Value = number;
                try
                {
                    conn.Open();
                    int roomID = Convert.ToInt32(cmd.ExecuteScalar());
                    return roomID;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        #endregion

        #region 修改房间状态为入住
        /// <summary>
        /// 修改房间状态为入住
        /// </summary>
        /// <param name="roomNumber">房间号</param>
        public void UpdateStatusId2ByNumber(string roomNumber,int guestNumber)
        { 
            using(SqlConnection conn=new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand("usp_UpdateStatusId2ByNumber",conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@RoomNumber", SqlDbType.NVarChar, 50).Value = roomNumber;
                cmd.Parameters.Add("@GuestNumber",SqlDbType.Int).Value=guestNumber;
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        #endregion

        #region 修改房间状态为空闲
        /// <summary>
        /// 修改房间状态为空闲
        /// </summary>
        /// <param name="roomNumber">房间号</param>
        public void UpdateStatusId1ByNumber(string roomNumber,int guestNumber)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand("usp_UpdateStatusId1ByNumber", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@RoomNumber", SqlDbType.NVarChar, 50).Value = roomNumber;
                cmd.Parameters.Add("@GuestNumber", SqlDbType.Int).Value = guestNumber;
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        #endregion
    }
}