roomtypebll.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 System.Data;
using Entity;
using DAL;
//该源码下载自www.51aspx.com(５1aｓｐｘ．ｃｏｍ)

namespace BLL
{
    public class RoomTypeBLL
    {
        /// <summary>
        /// 查询RoomType表中的数据
        /// </summary>
        /// <returns>RoomtTypeEntity泛型集合</returns>
        public static List<RoomTypeEntity> GetRoomType()
        {
            return RoomTypeDAL.GetRoomType();
        }

        public static RoomTypeEntity GetRoomTypeByTypeID(int TypeID)
        {
            return RoomTypeDAL.GetRoomTypeByTypeID(TypeID);
        }

        public static int GetTypeIDByTypeName(string TypeName)
        {
            return RoomTypeDAL.GetTypeIDByTypeName(TypeName);
        }

        public static int GetCountTypeNameByTypeName(string TypeName)
        {
            return RoomTypeDAL.GetCountTypeNameByTypeName(TypeName);
        }

        public static DataTable GetRoomTypeByFilter(string TypeName)
        {
            return RoomTypeDAL.GetRoomTypeByFilter(TypeName);
        }

        public static DataTable GetRoomTypeByFilter()
        {
            return RoomTypeDAL.GetRoomTypeByFilter();
        }

        public static DataTable GetImageURL()
        {
            return RoomTypeDAL.GetImageURL();
        }
        public static DataTable GetImageURL(int TypeID)
        {
            return RoomTypeDAL.GetImageURL(TypeID);
        }


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

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

        public static int UpdateRoomTypeByTypeName(RoomTypeEntity RTE)
        {
            return RoomTypeDAL.UpdateRoomTypeByTypeName(RTE);
        }

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

        public static bool GetRoomTypeByRoom_TypeID(int TypeID)
        {
            DataTable dt = RoomTypeDAL.GetRoomTypeByRoom_TypeID(TypeID);
            if (dt != null && Convert.ToInt32(dt.Rows[0][0]) > 0)
            {
                return true;
            }
            else 
            {
                return false;
            }
        }
    }
}