reservationoperater.cs

酒店管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Collections;

public struct HotelRoomInfo
{
    public string roomtype;
    public int roomNO;
    public int roomPrice;
};
[Serializable()]
public struct OrderInfo
{
    public int id;
    public string cusName;
    public string contact;
    public string enterTime;
    public string leaveTime;
    public bool isGroup;
}
/// <summary>
/// ReservationOperater 的摘要说明
/// </summary>
public class ReservationOperater
{
    private string errortext;
    private detailDBconn dbAccess;
	public ReservationOperater()
	{
        dbAccess = new detailDBconn();
	    
	}
    public void initDB()
    {
        if (dbAccess.isOpen == false)
            dbAccess.openDB();
    }

    public string errorMessage
    {
        get
        {
            return errortext;
        }
    }

    private int getRecordID()
    {
        if (dbAccess.isOpen == false)
            dbAccess.openDB();
        int retID=0;
        string[] nullparm ={ };
        dbAccess.CallStoredProcedure("GetRevervationRecordID", nullparm, nullparm, ref retID);
        return retID;
    }

    public bool orderARomm(string room,int orderId)
    {
        StringBuilder sqlcommand = new StringBuilder();
        sqlcommand.Append(
            "insert into RoomOrdered(roomNo,orderID) values (");
        sqlcommand.Append("'"+room+"',");
        sqlcommand.Append("'"+orderId+"')");
        dbAccess.insertCommand = sqlcommand.ToString();
        //if (dbAccess.isOpen == false)
        dbAccess.openDB();
        try
        {
            if (!dbAccess.executeCommand())
            {
                errortext = dbAccess.errorMessage;
                return false;
            }
            else
            {
                return true;
            }
        }
        finally
        {
            dbAccess.closeDB();
        }
    }
    /// <summary>
    /// 插入一条记录，返回记录id
    /// </summary>
    /// <param name="name"></param>
    /// <param name="contact"></param>
    /// <param name="room"></param>
    /// <param name="starttime"></param>
    /// <param name="endtime"></param>
    /// <param name="isgroup"></param>
    /// <param name="engaged"></param>
    /// <param name="memo"></param>
    /// <returns></returns>
    public int InsertAnOrder(string name,string telePhoneNo,
                    string starttime,string endtime,string isgroup,string memo)
    {
        StringBuilder sqlcommand = new StringBuilder();
        sqlcommand.Append(
            "insert into engageinfo(id,name,telePhoneNo,startTime,endTime,isGroup,memo) values (");
        int id = getRecordID();
        if (id <= 0)
        {
            errortext = "can not get record";
            return -1;
        }
        sqlcommand.Append("'"+id.ToString()+"'");
        sqlcommand.Append(",'" + name + "',");
        sqlcommand.Append("'" + telePhoneNo + "',");
        sqlcommand.Append("'" + starttime + "',");
        sqlcommand.Append("'" + endtime + "',");
        sqlcommand.Append("'" + isgroup + "',");
        sqlcommand.Append("'" + memo + "')");

        dbAccess.insertCommand = sqlcommand.ToString();
        if(dbAccess.isOpen==false)
            dbAccess.openDB();
        try
        {
            if (!dbAccess.executeCommand())
            {
                errortext = dbAccess.errorMessage;
                return -1;
            }
            else
            {
                return id;
            }
        }
        finally
        {
            dbAccess.closeDB();
        }
    }
    /// <summary>
    /// 加入一行订房记录
    /// </summary>
    /// <param name="name"></param>
    /// <param name="contact"></param>
    /// <param name="room"></param>
    /// <param name="starttime"></param>
    /// <param name="endtime"></param>
    /// <param name="isgroup"></param>
    /// <returns></returns>
    public bool InsertAnOrder(string name,string contact,
                    string starttime,string endtime,string isgroup)
    {
        return false;
    }
    /// <summary>
    /// 
    /// </summary>
    /// <param name="name"></param>
    /// <param name="contact"></param>
    /// <param name="room"></param>
    /// <param name="starttime"></param>
    /// <param name="endtime"></param>
    /// <param name="isgroup"></param>
    /// <param name="engaged"></param>
    /// <returns></returns>

    public ArrayList GetAvailableRoom(string theStartTime,string theEndTime)
    {
        ArrayList resultSet=new ArrayList();
        try
        {
            if(dbAccess.isOpen==false)
                dbAccess.openDB();
            dbAccess.selectDataSetCommand = "select * from HotelInfo";
            DataSet ds = dbAccess.getSelectDataSet();
            string[] parmInfos ={ "@roomNO", "@theStartTime", "@theEndTime" };
           
            object[] hotelInfo;
            HotelRoomInfo aRoom;
            object[] parms=new object[3];
            for(int i=0;i<ds.Tables[0].Rows.Count;i++)
            {
                hotelInfo=ds.Tables[0].Rows[i].ItemArray;
                aRoom = new HotelRoomInfo();
                aRoom.roomNO = int.Parse(hotelInfo[0].ToString());
                aRoom.roomtype = hotelInfo[2].ToString();

                aRoom.roomPrice = System.Decimal.ToInt32((decimal)hotelInfo[1]);
                int retvalue=0;
                parms.SetValue(aRoom.roomNO.ToString(), 0);
                parms.SetValue(theStartTime, 1);
                parms.SetValue(theEndTime, 2);
                dbAccess.CallStoredProcedure("IsAvailable", parmInfos, parms, ref retvalue);

                if (retvalue != 0)
                {
                    resultSet.Add(aRoom);
                }
            }
        }
        catch (Exception e)
        {
            errortext = e.Message;
        }
        return resultSet;
    }

    public double GetRoomDiscount(string roomNo)
    {
        if (roomNo == "")
        {
            return 1.0;
        }
        if (dbAccess.isOpen == false)
            dbAccess.openDB();
        dbAccess.selectDataSetCommand = "select discount from HotelInfo where room = '"
                                + roomNo+ "'";
        DataSet ds = dbAccess.getSelectDataSet();
        if (ds == null)
            return 1.0;
        double discount = double.Parse(ds.Tables[0].Rows[0].ItemArray[0].ToString());
        return discount;
    } 
    public double GetGroupDiscount(string groupName)
    {
        if (groupName == "")
        {
            return 1.0;
        }
        if (dbAccess.isOpen == false)