roomuseaccess.cs

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

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


namespace Hotel.Operation
{
    public class RoomUseAccess
    {
        GetDatabase objGetDatabase = null;
        RoomUse roomUseEntity=null;
        DataSet ds = null;

        public RoomUseAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //通过房间ID获取帐单的相关信息(最后的使用者)
        public DataSet GetRoomInfo(string roomID)
        {
            roomUseEntity = new RoomUse();
            string sql="select * from RoomUse where RoomUseID=(select max(RoomUseID)"
                +" from RoomUse where GuestRoomID='"+roomID+"')";
            ds = new DataSet();
            ds=objGetDatabase.GetDataSet(sql, "RoomUse");
            objGetDatabase.DataClose();
            return ds;
         
        }
        //储存过程
        public int AddRoomUseInfo(SqlParameter [] para)
        {
            int k = objGetDatabase.ExecuteProc("proc_RoomUse", para);
            objGetDatabase.DataClose();
            return k;
 
        }
        ////通过客房编号获取帐号
        public int GetRoomUseID(string room)
        {
            string sql = "select max(RoomUseID) from RoomUse where GuestRoomID='" + room + "'";
            int k = 0;
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                try
                {
                    k = int.Parse(dr[0].ToString());
                }
                catch
                {
                    Console.WriteLine("没有值");
                }
            }
            dr.Close();
            return k;
        }
        //获取最大编号
        public int GetMaxRoomUseID()
        {
            string sql = "select max(RoomUseID) from RoomUse";
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            int k = 0;
            if (dr.HasRows)
            {
                if (dr[0].ToString().Equals(""))
                {
                    return k;
                }
                k = int.Parse(dr[0].ToString());
            }
            dr.Close();
            return k;
        }
        //通过帐号获取客房信息
        public DataSet GetRoomUseInfo(int num)
        {
            string sql = "select * from RoomUse where RoomUseID="+num;
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "RoomUse");
            return ds;

        }
       //结帐
        public int ModifiRooUse(float other, float foregift, float en, string state, string use, string reck, string remark)
        {
            string sql = "update Roomuse set otherExpenses='" + other + "',outForegift=" + foregift + ",endcharge=" 
                + en + ",State='" + state + "',UserID='" + use + "',ReckoningTime='"+reck+"',remark='"+remark+"'";
            int k = 0;
            k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
    }
}