roombll.cs

酒店管理系统 用C#开发 程序简单明了 应用系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DAL;
using Model;

namespace BLL
{
    public class RoomBLL
    {
        RoomDAO roomdao=new RoomDAO();
        /// <summary>
        /// 查询客房信息视图
        /// </summary>
        /// <returns></returns>
        public DataSet selectView()
        {
            return roomdao.selectView();
        }
        /// <summary>
        /// 根据ID删除客房信息
        /// </summary>
        /// <param name="roomid"></param>
        /// <returns></returns>
        public int delete(int roomid)
        {
            return roomdao.delete(roomid);
        }
        /// <summary>
        /// 查询客房信息所有
        /// </summary>
        /// <returns></returns>
        public DataSet selectall()
        {
            return roomdao.selectall();
        }
        /// <summary>
        /// 根据ID查询信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public DataSet selectwhereid(int id)
        {
            return roomdao.selectwhereid(id);
        }
        /// <summary>
        /// 插入到房间表
        /// </summary>
        /// <param name="room"></param>
        /// <returns></returns>
        public int update(RoomEntity room)
        {
            return roomdao.update(room);
        }
        /// <summary>
        /// 插入客房信息
        /// </summary>
        /// <param name="room"></param>
        /// <returns></returns>
        public int insert(RoomEntity room)
        {
            return roomdao.insert(room);
        }
        /// <summary>
        /// 根据TYPEID查询
        /// </summary>
        /// <returns></returns>
        public DataSet selectwhereTypeID(int typeid)
        {
            return roomdao.selectwhereTypeID(typeid);
        }
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageCount"></param>
        /// <param name="pageIndex"></param>
        /// <returns></returns>
        public DataSet selectPage(int pageCount, int pageIndex)
        {
            return roomdao.selectPage(pageCount, pageIndex);
        }
        public DataSet select3()
        {
            return roomdao.select3();
        }
        public DataSet select4(string State)
        {
            return roomdao.select4(State);
        }
        public DataSet select5(int typeID)
        {
            return roomdao.select5(typeID);
        }
        /// <summary>
        /// 根据房间号修改房间状态
        /// </summary>
        /// <param name="roomid"></param>
        /// <param name="state"></param>
        /// <returns></returns>
        public int updatewhereroomid(int roomid, string state)
        {
            return roomdao.updatewhereroomid(roomid, state);
        }
        /// <summary>
        /// 查询房间记录数
        /// </summary>
        /// <param name="SQLString"></param>
        /// <returns></returns>
        public int selectCount(string SQLString)
        {
            return roomdao.selectCount(SQLString);
        }
        /// <summary>
        /// 根据房间类型和状态查询房间信息
        /// </summary>
        /// <param name="typeID"></param>
        /// <returns></returns>
        public DataSet selectandState(int typeID, string state)
        {
            return roomdao.selectandState(typeID, state);
        }
    }
}