roominfo.aspx.cs

酒店管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class RoomInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        HotelDBConn hotelDB = new HotelDBConn();
        ArrayList roomInfo = setRoomStatus();
        TableRow row = null;
        TableCell cell = null;
        string roomStatus = null;
        TextBox RoomItem = new TextBox();
        
        int rowNum = 0;
        int roomNum = 0;

        roomNum = hotelDB.getRoomNum();
        int i = 0;
        row = new TableRow();
        Table1.Rows.Add(row);
        rowNum = (roomNum / 8) + 1;

        foreach (Hotel hotel in roomInfo)
        {
            
            if (i % 8 == 0)
            {
                row = new TableRow();
                Table1.Rows.Add(row);
          //      rowNum++;
            }

            i++;

            cell = new TableCell();
            RoomItem = new TextBox();
            RoomItem.Wrap = true;
            RoomItem.Text = hotel.Room.ToString() + Environment.NewLine + " \n" + hotel.Type.ToString();

            switch (hotel.Status)
            { 
                case "空房":
                    RoomItem.BackColor = System.Drawing.Color.LightBlue;
                    break;
                case "有人住":
                    RoomItem.BackColor = System.Drawing.Color.DarkSalmon;
                    break;
                case "今日被预订":
                    RoomItem.BackColor = System.Drawing.Color.DarkSeaGreen;
                    break;
                default:
                    RoomItem.BackColor = System.Drawing.Color.LightBlue;
                    break;
            }

            RoomItem.ToolTip = "房价：" + hotel.Price.ToString() + "元";
            RoomItem.BorderColor = System.Drawing.Color.LemonChiffon;
            RoomItem.BorderStyle = BorderStyle.Outset;
            RoomItem.Width = 100;
            RoomItem.Height = 50;

            RoomItem.ReadOnly = true;
            RoomItem.TextMode = TextBoxMode.SingleLine;
            RoomItem.ReadOnly = true;
            RoomItem.Font.Size = 12;
            RoomItem.BorderWidth = 4;

            Table1.CellPadding = 10;
            Table1.GridLines = GridLines.Both;
            Table1.HorizontalAlign = HorizontalAlign.Justify;
            cell.Controls.Add(RoomItem);
            row.Cells.Add(cell);

            
        }     
    }

    private ArrayList setRoomStatus()
    { 
        HotelDBConn hotelDB = new HotelDBConn ();
        ClientDBConn clientDB = new ClientDBConn ();
        ArrayList roomInfo = hotelDB.getHotelInfo();
        ArrayList emptyRoom = hotelDB.getEmptyRoom();
        ArrayList holdRoom = hotelDB.getHoldRoom();
        ArrayList reservationRoom = hotelDB.getReservationRoom();
        foreach (Hotel hotel in roomInfo)
        {
            foreach (Hotel empty in emptyRoom) 
            {
                if (empty.Room == hotel.Room) { hotel.Status = "空房"; }
            }
            foreach (Hotel hold in holdRoom)
            {
                if (hold.Room == hotel.Room) { hotel.Status = "有人住"; }
            }
            foreach (Hotel res in reservationRoom)
            {
                if (res.Room == hotel.Room) { hotel.Status = "今日被预订"; }
            }
        }
        return roomInfo;
    }
}