roombll.cs

来自「酒店管理系统(三层开发)源码 管理员的功能： 客房类型管理（编辑房间类型、删除房」· CS 代码 · 共 138 行

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