roomdao.cs

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

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

namespace DAL
{
    public class RoomDAO
    {
        SQLHelper sqlhelper = new SQLHelper();
        /// <summary>
        /// 查询客房信息视图
        /// </summary>
        /// <returns></returns>
        public DataSet selectView()
        {
            DataSet ds = sqlhelper.GetDateSet("select * from view_select");
            return ds;
        }
        /// <summary>
        /// 根据ID删除客房信息
        /// </summary>
        /// <param name="roomid"></param>
        /// <returns></returns>
        public int delete(int roomid)
        {
            int count = sqlhelper.RunSQL("delete Room where RoomID="+roomid);
            return count;
        }
        /// <summary>
        /// 查询客房信息所有
        /// </summary>
        /// <returns></returns>
        public DataSet selectall()
        {
            DataSet ds = sqlhelper.GetDateSet("select * from Room");
            return ds;
        }
        /// <summary>
        /// 根据TYPEID查询
        /// </summary>
        /// <returns></returns>
        public DataSet selectwhereTypeID(int typeid)
        {
            DataSet ds = sqlhelper.GetDateSet("select * from Room where TypeID="+typeid);
            return ds;
        }
        /// <summary>
        /// 根据ID查询信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public DataSet selectwhereid(int id)
        {
            DataSet ds = sqlhelper.GetDateSet("select * from Room where RoomId="+id);
            return ds;
        }
        /// <summary>
        /// 根据房间号修改房间信息
        /// </summary>
        /// <param name="room"></param>
        /// <returns></returns>
        public int update(RoomEntity room)
        {
            int count = sqlhelper.RunSQL("update Room set TypeID=" + room.TypeID + ",BedNumber=" + room.BedNumber + ",Description='" + room.Description + "',State='" + room.State + "',GuestNumber=" + room.GuestNumber + " where Number='" + room.Number + "'");
            return count;
        }
        

        /// <summary>
        /// 插入客房信息
        /// </summary>
        /// <param name="room"></param>
        /// <returns></returns>
        public int insert(RoomEntity room)
        {
            int count = sqlhelper.RunSQL("insert into Room values('" + room.Number + "'," + room.TypeID + "," + room.BedNumber + ",'" + room.Description + "','" + room.State + "'," + room.GuestNumber + ")");
            return count;
        }
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pageCount"></param>
        /// <param name="pageIndex"></param>
        /// <returns></returns>
        public DataSet selectPage(int pageCount, int pageIndex)
        {
            int sum = (pageIndex - 1) * pageCount;
            DataSet ds = sqlhelper.GetDateSet("select top 10 * from view_page where Number not in( select top " + sum + " Number from view_page )");
            return ds;
        }

        /// <summary>
        /// 查询房间信息
        /// </summary>
        /// <returns></returns>
        public DataSet select3()
        {
            DataSet ds = sqlhelper.GetDateSet("select RoomID,TypeID,Number,State from Room");
            return ds;
        }

        /// <summary>
        /// 根据房间状态查询房间信息
        /// </summary>
        /// <param name="State"></param>
        /// <returns></returns>
        public DataSet select4(string State)
        {
            DataSet ds = sqlhelper.GetDateSet("select RoomID,TypeID,Number,State from Room where State='" + State + "'");
            return ds;
        }
        /// <summary>
        /// 根据房间类型查询房间信息
        /// </summary>
        /// <param name="typeID"></param>
        /// <returns></returns>
        public DataSet select5(int typeID)
        {
            DataSet ds = sqlhelper.GetDateSet("select RoomID,TypeID,Number,State from Room where TypeID=" + typeID);
            return ds;
        }

        /// <summary>
        /// 根据房间号修改房间状态
        /// </summary>
        /// <param name="roomid"></param>
        /// <param name="state"></param>
        /// <returns></returns>
        public int updatewhereroomid(int roomid, string state)
        {
            int count = sqlhelper.RunSQL("update Room set State='"+state+"' where RoomID="+roomid);
            return count;
        }
        /// <summary>
        /// 查询房间记录数
        /// </summary>
        /// <param name="SQLString"></param>
        /// <returns></returns>
        public int selectCount(string SQLString)
        {
            DataSet ds = sqlhelper.GetDateSet("select count(*) from Room where "+SQLString);
            int count = int.Parse(ds.Tables[0].Rows[0][0].ToString());
            return count;
        }
        /// <summary>
        /// 根据房间类型和状态查询房间信息
        /// </summary>
        /// <param name="typeID"></param>
        /// <returns></returns>
        public DataSet selectandState(int typeID,string state)
        {
            DataSet ds = sqlhelper.GetDateSet("select RoomID,TypeID,Number,State from Room where TypeID=" + typeID + " and State='" + state + "'");
            return ds;
        }
    }
}