guestroomaccess.cs

酒店管理系统,您酒店物业管理的好帮手

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using Hotel.DAO;
using Hotel.Entity;
using System.Data.SqlClient;

namespace Hotel.Operation
{
    public class GuestRoomAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;
        GuestRoom guestRoomEntity = null;
        

        public GuestRoomAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //分别获取各类型房间

        public ListView  GetRoom(ListView lv, int ty)
        {

            string sql = "select 客房编号=GuestRoomID,类型=(select RoomType from RoomType where "
                +"TypeNum=GuestRoom.TypeNum),客房位置=area,客房电话=RoomPhone,状态=state,晨唤=MorningCall,"
                +"是否保密=case when state='0' then '是' else '否' end ,备注=remark from GuestRoom where"
                +" TypeNum=" + ty;
            ds = new DataSet();
            ds=objGetDatabase.GetDataSet(sql, "GuestRoom");

            //建表头
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 300;
            }
            
            lv.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());
                    //设置图标
                    if (ds.Tables[0].Rows[i][4].ToString().Trim().Equals("使用"))
                    {
                        lsvItem.ImageIndex = 4;
                    }
                    else if (ds.Tables[0].Rows[i][4].ToString().Trim().Equals("停用"))
                    {
                        lsvItem.ImageIndex = 3;
                    }
                    else if (ds.Tables[0].Rows[i][4].ToString().Trim().Equals("维修"))
                    {
                        lsvItem.ImageIndex = 2;
                    }
                    else if (ds.Tables[0].Rows[i][4].ToString().Trim().Equals("预定"))
                    {
                        lsvItem.ImageIndex = 1;
                    }
                    else
                    {
                        lsvItem.ImageIndex = 0;
                    }
                }
                
                lv.Items.Add(lsvItem);
            }
            return lv;
        }
        //添加房间
        public int AddRoom(GuestRoom en)
        {

           string sql = "insert guestRoom values('" + en.GuestRoomID + "','"+en.TypeNum+"','" +en.Area + "'," + en.RoomPhone + ",'" + en.State + "','2008-5-7',default,'" + en.Remark + "')";
           int k=objGetDatabase.ExecuteSql(sql);
           objGetDatabase.DataClose();
           return k;
        }
        //获取房间信息
        public GuestRoom GetRoomInfo(string roomID)
        {
            
            string sql = "select * from GuestRoom where GuestRoomID='"+roomID+"'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "GuesRoom");
            if (ds.Tables[0].Rows.Count == 0)
            {
                return guestRoomEntity;
            }
            guestRoomEntity = new GuestRoom();
            guestRoomEntity.TypeNum = Convert.ToInt32(ds.Tables[0].Rows[0][1].ToString());
            guestRoomEntity.Area = ds.Tables[0].Rows[0][2].ToString();
            guestRoomEntity.RoomPhone = Convert.ToInt32(ds.Tables[0].Rows[0][3].ToString());
            guestRoomEntity.State = ds.Tables[0].Rows[0][4].ToString();

            guestRoomEntity.MorningCall = ds.Tables[0].Rows[0][5].ToString();
            guestRoomEntity.Secrecy = Convert.ToByte(ds.Tables[0].Rows[0][6]);
            guestRoomEntity.Remark = ds.Tables[0].Rows[0][7].ToString();
            return guestRoomEntity;
        }
        //获取所有房间      可分类型获取
        public ListView GetAllRoom(ListView lv,string type)
        {
            string sql = "select 客房编号=GuestRoomID,类型=(select RoomType from RoomType where "+
                "TypeNum=GuestRoom.TypeNum),位置=Area,房间电话=roomPhone,状态=state,备注=Remark from GuestRoom where TypeNum="+type;
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "GuestRoom");

            //建表头
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 70;
                if (i == 1)
                    ch.Width = 80;
            }

            lv.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());
                    
                }
                lv.Items.Add(lsvItem);
            }
            return lv;
        }
        //修改房间信息
        public int ModifiRoomInfo(GuestRoom en)
        {
            string sql = "update guestRoom set typeNum="+en.TypeNum+",Area='"+en.Area+"',roomPhone="
                +en.RoomPhone+",state='"+en.State+"',remark='"+en.Remark+"' where GuestRoomID='"
                +en.GuestRoomID+"'";
            int k= objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //删除房间
        public int DeleteRoom(string room)
        {
            string sql = "delete from GuestRoom where GuestRoomID='"+room+"'";
            int k=objGetDatabase.ExecuteSql(sql);
            return k;
        }
       

        //获取可用房  以类型,状态
        public ListBox GetCanUseRoom(ListBox lb,string sta,string type)
        {
             string sql = "select 客房编号=GuestRoomID,类型=(select RoomType from RoomType where "+
                "TypeNum=GuestRoom.TypeNum) from GuestRoom where State='" + sta + "' and TypeNum="+type;
             ds = new DataSet();
             ds = objGetDatabase.GetDataSet(sql, "GuesRoom");
             for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
             {
                 lb.Items.Add(ds.Tables[0].Rows[i][0].ToString().Trim() +"----"+ ds.Tables[0].Rows[i][1].ToString().Trim());
             }
             return lb;
        }
        //修改房间状态
        public int ModifiRoomState(string room, string sta)
        {
            string sql = "update GuestRoom set state='"+sta+"' where GuestRoomID='"+room+"'";
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //返回各种状态的房的数据集
        public DataSet GetRooms(string str,string type)
        {
            string sql = "select * from GuestRoom where State='" + str + "' and TypeNum=" + type;
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "GuestRoom");
            return ds;
            
        }
        //通过客房编号获取客房信息
        public DataSet GetRoomInfoPrice(string room)
        {
            string sql = "select 客房编号=GuestRoomID,类型=(select RoomType from RoomType where TypeNum=GuestRoom.TypeNum),"
                +"'价格/天'=(select priceDay from RoomType where TypeNum=GuestRoom.TypeNum),'价格/半天'="
                +"(select halfDay from RoomType where TypeNum=GuestRoom.TypeNum),'价格/小时'=(select pricehour "
                + "from RoomType where TypeNum=GuestRoom.TypeNum),预设押金=(select Deposit from RoomType where TypeNum=GuestRoom.TypeNum)  from GuestRoom where GuestRoomID='" + room + "'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "GuestRoom");
            return ds;


        }
        

    }
}