userroombll.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 DAL;
using Entity;
using System.Data;

namespace BLL
{
    public class UserRoomBLL
    {
        public static int GetUserIDByHotelUser_UserNameRoom_Number(string UserName,string Number)
        {
            DataTable dt = UserRoomDAL.GetUserRoomByHotelUser_UserNameRoom_Number(UserName,Number);
            return Convert.ToInt32(dt.Rows[0][0]);
        }

        public static DataTable GetReceptionTable()
        {
            return UserRoomDAL.GetUserReceptionTable();
        }

        public static DataTable GetUserReceptionByUserName(string UserName)
        {
            return UserRoomDAL.GetUserReceptionByUserName(UserName);  
        }
        public static DataTable GetUserReceptionByName(string Name)
        {
            return UserRoomDAL.GetUserReceptionByName(Name);
        }
        public static DataTable GetUserReceptionStateByRoomID(int RoomID)
        {
            return UserRoomDAL.GetUserReceptionStateByRoomID(RoomID);
        }


        public static int AddUserRoom(UserRoomEntity URE)
        {
            return UserRoomDAL.AddUserRoom(URE);
        }

        public static int UpdateUserReceptionStateByRoomID(int RoomID)
        {
            return UserRoomDAL.UpdateUserReceptionStateByRoomID(RoomID);
        }

        public static int DeleteUserRoomByUserID(int UserID,int RoomID)
        {
            return UserRoomDAL.DeleteUserRoomByUserID(UserID,RoomID);
        }
    }
}