clientinfohistory.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 ClientInfoHistory : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ClientDBConn clientDB = new ClientDBConn ();
        ArrayList clientInfo = clientDB.getClientInfoHistory ();

        TableRow row = null;
        TableCell cell1 = null;
        TableCell cell2 = null;
        TextBox txt = null;
        Label lbl = null;
        int rowNum = 0;

        foreach (Client client in clientInfo)
        {
            row = new TableRow();
            rowNum++;

            //顾客姓名
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Name;
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //入住房间
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Room.ToString();
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //房间类型
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Type;
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //房间价格
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Price.ToString();
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //入住时间
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.StartTime.ToString();
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //离开时间
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.EndTime.ToString();
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //折扣
            cell1 = new TableCell();
            txt = new TextBox();
            if (client.Discount != null)
            {
                double discount = client.Discount;    //折扣 = 团体折扣
                discount = discount * 100;
                txt.Text = discount.ToString();
            }
            txt.Enabled = true;
            txt.Width = 25;
            lbl = new Label();
            lbl.Text = "%";
            cell1.Controls.Add(txt);
            cell1.Controls.Add(lbl);
            row.Cells.Add(cell1);

            //身份证号
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.IdentityNO;
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            //电话号码
            cell1 = new TableCell();
            txt = new TextBox();
            txt.Text = client.TelephoneNO;
            txt.Enabled = true;
            cell1.Controls.Add(txt);
            row.Cells.Add(cell1);

            Table1.Rows.Add(row);
        }

        ArrayList groupClient = clientDB.getGroupClientHistory();

        foreach (Client client in groupClient)
        {
            row = new TableRow();
            rowNum++;

            //团体名称
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Groupname;
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);
            
            //顾客姓名
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Name;
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //入住房间
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Room.ToString();
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //房间类型
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Type;
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //房间价格
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Price.ToString();
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //入住时间
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.StartTime.ToString();
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //离开时间
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.EndTime.ToString();
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //折扣
            cell2 = new TableCell();
            txt = new TextBox();
            if (client.Discount != null)
            {
                double discount = client.Discount;    //折扣 = 团体折扣
                discount = discount * 100;
                txt.Text = discount.ToString();
            }
            txt.Enabled = true;
            txt.Width = 25;
            lbl = new Label();
            lbl.Text = "%";
            cell2.Controls.Add(txt);
            cell2.Controls.Add(lbl);
            row.Cells.Add(cell2);

            //联系人
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Linkman;
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            //联系电话
            cell2 = new TableCell();
            txt = new TextBox();
            txt.Text = client.Linktelephone;
            txt.Enabled = true;
            cell2.Controls.Add(txt);
            row.Cells.Add(cell2);

            Table2.Rows.Add(row);
        }
    }
}