roomtypeaccess.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

using Hotel.DAO;
using Hotel.Entity;

namespace Hotel.Operation
{
    public class RoomTypeAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;
        RoomType roomTypeEntity=null;
        
        public RoomTypeAccess()
        {
             objGetDatabase= new GetDatabase();
        }
        //获取房间类型
        public ComboBox GetRoomType(ComboBox obj)
        {
            ds = new DataSet();
            string sql = "select RoomType from RoomType";
            ds=objGetDatabase.GetDataSet(sql,"RoomType");
            obj.Items.Clear();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                obj.Items.Add(ds.Tables[0].Rows[i][0].ToString());
            }
            return obj;
        }
        //获得房价
        public float GetRoomPrice(int type)
        {
            string sql = "select PriceDay from RoomType where typenum="+type;
            SqlDataReader dr=objGetDatabase.GetDataReader(sql);
            float ty =0;
            if (dr.HasRows)
            {
                dr.Read();
                ty = float.Parse(dr[0].ToString());
            }
            dr.Close();
            return ty;
        }

        //获取各类型信息
        public ListView GetAllType(ListView lv)
        {
            string sql = "select 编号=typenum,类型名称=roomtype,'价格/天'=priceDay,'价格/半天'=halfDay,'"
                +"价格/小时'=priceHour,预设押金=deposit,床位=bedconut from roomtype";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql,"roomType");
            //建表头
            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 == 0)
                    ch.Width = 40;
                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 RoomType GetTypeInfo(int num)
        {
            roomTypeEntity = new RoomType();
            string sql = "select * from RoomType where TypeNum="+num;
            SqlDataReader dr=objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                roomTypeEntity.PriceDay =float.Parse( dr.GetValue(2).ToString());
                roomTypeEntity.HalfDay = float.Parse(dr.GetValue(3).ToString()) ;
                roomTypeEntity.PriceHour =float.Parse( dr.GetValue(4).ToString());
                roomTypeEntity.Deposit =float.Parse( dr.GetValue(5).ToString());
                roomTypeEntity.BedCount =int.Parse( dr.GetValue(6).ToString());
            }
            dr.Close();
            return roomTypeEntity;
        }

        //通过编号获取类型名称
        public string GetRoomTypeName(int k)
        {
            string sql = "select RoomType from RoomType where TypeNum="+k;
            string name = "";
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                name = dr.GetValue(0).ToString();
            }
            dr.Close();
            return name;
        }
        //修改房价格
        public int ModifiRoomPrice(RoomType rt)
        {
            string sql = "update RoomType set priceDay="+rt.PriceDay+",halfDay="+rt.HalfDay
                +",priceHour="+rt.PriceHour+",Deposit="+rt.Deposit+",BedConut="+rt.BedCount
                +" where TypeNum="+rt.TypeNum;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //返回客房类型的数据集
        public DataSet GetRoomType()
        {
            string sql = "select * from roomType";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "RoomType");
            return ds;
        }
        //查询各种房价
        public float GetMoreRoomprice(string str,string name)
        {
            string sql = "select "+str+" from RoomType where RoomType='"+name+"'";
            float k = 0;
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                k = float.Parse( dr[0].ToString());
            }
            return k;
 
        }
    }
}