roombll.cs

酒店管理系统项目需求说明 第一部分 引言 1 1.1编写目的 1 1.2背景 1 第二部分 任务概述 2 3.1实现目标 2 3.1.1客房类型模块： 2 3.1.2客房信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entity;
using DAL;
using System.Data;


namespace BLL
{
    public class RoomBLL
    {
        /// <summary>
        /// 查询Room表中的数据
        /// </summary>
        /// <returns>RoomEntity泛型集合</returns>
        public static List<RoomEntity> GetRoom()
        {
            return RoomDAL.GetRoom();
        }

        public static RoomEntity GetRoomByRoomID(int RoomID)
        {
            return RoomDAL.GetRoomByRoomID(RoomID);
        }

        public static string GetStateByRoomID(int RoomID)
        {
            DataTable dt = RoomDAL.GetStateByRoomID(RoomID);
            return dt.Rows[0][0].ToString();
        }

        public static DataTable GetRoom_RoomTypeInfo(string TypeName,int BedNumber,int GuestNumber)
        {
            return RoomDAL.GetRoom_RoomTypeInfo(TypeName,BedNumber,GuestNumber);
        }
        public static DataTable GetRoom_RoomTypeInfo()
        {
            return RoomDAL.GetRoom_RoomTypeInfo();
        }

        public static DataTable GetRoom_RoomTypeInfoByRoomID(int RoomID)
        {
            return RoomDAL.GetRoom_RoomTypeInfoByRoomID(RoomID);
        }

        public static string GetStateByNumber(string Number)
        {
            DataTable dt = RoomDAL.GetStateByNumber(Number);
            return dt.Rows[0][0].ToString();
        }

        public static DataTable GetRoomByFilter(string TypeName, string Number)
        {
            return RoomDAL.GetUserByFilter(TypeName, Number);
        }

        public static DataTable GetRoomByFilter()
        {
            return RoomDAL.GetUserByFilter();
        }
        public static int GetRoomIDByNumber(string Number)
        {
            return RoomDAL.GetRoomIDByNumber(Number);
        }


        public static bool SelectRoom(string number)
        {
            return RoomDAL.SelectRoom(number);
        }



        /// <summary>
        /// 增加Room表中的数据
        /// </summary>
        /// <param name="RE">RoomEntity对象</param>
        /// <returns>返回结果：
        ///          1   执行SQL语句成功
        ///         -1   SQL语句执行错误
        ///         -2   数据库连接失败
        /// </returns>
        public static int AddRoom(RoomEntity RE)
        {
            return RoomDAL.AddRoom(RE);
        }

        /// <summary>
        /// 修改Room表中的数据
        /// </summary>
        /// <param name="RE">RoomEntity对象</param>
        /// <returns>返回结果：
        ///          1   执行SQL语句成功
        ///         -1   SQL语句执行错误
        ///         -2   数据库连接失败
        /// </returns>
        public static int UpdateRoom(RoomEntity RE)
        {
            return RoomDAL.UpdateRoom(RE);
        }

        public static int UpdateRoomByNumber(RoomEntity RE)
        {
            return RoomDAL.UpdateRoomByNumber(RE);
        }

        public static int UpdateStateByRoomID(int RoomID)
        {
            return RoomDAL.UpdateStateByRoomID(RoomID);
        }

        public static int UpdateStateByNumber(string Number)
        {
            return RoomDAL.UpdateStateByNumber(Number);
        }





        /// <summary>
        /// 删除Room表中的数据
        /// </summary>
        /// <param name="RE">RoomEntity对象</param>
        /// <returns>返回结果：
        ///          1   执行SQL语句成功
        ///         -1   SQL语句执行错误
        ///         -2   数据库连接失败
        /// </returns>
        public static int DeleteRoom(RoomEntity RE)
        {
            return RoomDAL.DeleteRoom(RE);
        }
    }
}