checkoutform.aspx

旅客信息管理、酒店客房管理、各种信息查询

<%--文件名:CheckOutForm.aspx--%>
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="CheckOutForm.aspx.vb" Inherits="RoomManage_CheckOutForm" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 558px; height: 7px">
        <tr>
            <td align="left" colspan="2" style="font-size: 0.8em; width: 584px; font-family: 宋体;
                height: 21px; background-color: slategray">
                &nbsp;结账日期：<asp:TextBox ID="TextBox9" runat="server" Width="57px"></asp:TextBox>
                年<asp:TextBox ID="TextBox10" runat="server" Width="26px"></asp:TextBox>
                月<asp:TextBox ID="TextBox11" runat="server" Width="26px"></asp:TextBox>
                日&nbsp; 酒店房号:<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
                    DataSourceID="SqlDataSource1" DataTextField="房号" DataValueField="房号" Width="70px">
                </asp:DropDownList>
                旅客姓名:<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
                    DataTextField="客人姓名" DataValueField="入住编号" Width="70px">
                </asp:DropDownList><br />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
                <asp:Button ID="Button1" runat="server"  Text="查询" Width="80px" />&nbsp;
                <asp:Button ID="Button2" runat="server"  Text="打印" Width="80px" />&nbsp;
                <asp:Button ID="Button3" runat="server"  Text="保存" Width="80px" /></td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 584px; font-family: 宋体; height: 21px;
                background-color: mediumturquoise">
                旅客发生费用信息</td>
            <td align="center" style="font-size: 0.8em; width: 584px; font-family: 宋体; height: 21px;
                background-color: turquoise">
                旅客离店结账信息</td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 584px; font-family: 宋体; height: 21px;
                background-color: gainsboro">
                店内消费：<asp:TextBox ID="TextBox1" runat="server" BackColor="Silver" ReadOnly="True"></asp:TextBox><br />
                住宿费： &nbsp;<asp:TextBox ID="TextBox2" runat="server" BackColor="Silver" ReadOnly="True"></asp:TextBox><br />
                电话费： &nbsp;<asp:TextBox ID="TextBox3" runat="server" BackColor="Silver" ReadOnly="True"></asp:TextBox><br />
                用餐费： &nbsp;<asp:TextBox ID="TextBox4" runat="server" BackColor="Silver" ReadOnly="True"></asp:TextBox></td>
            <td align="center" style="font-size: 0.8em; width: 584px; font-family: 宋体; height: 21px;
                background-color: gainsboro">
                预收押金:<asp:TextBox ID="TextBox5" runat="server" BackColor="Silver" ReadOnly="True"></asp:TextBox><br />
                费用合计:<asp:TextBox ID="TextBox6" runat="server" BackColor="Silver" ReadOnly="True"></asp:TextBox><br />
                结账金额:<asp:TextBox ID="TextBox7" runat="server"></asp:TextBox><br />
                结账说明:<asp:TextBox ID="TextBox8" runat="server" Width="148px">暂无</asp:TextBox></td>
        </tr>
        <tr>
            <td colspan="2" style="font-size: 0.8em; font-family: 宋体; height: 21px; background-color: gainsboro">
                <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#999999"
                    BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="宋体" Font-Size="Small"
                    GridLines="Vertical" Height="81px" Width="553px">
                    <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                    <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                    <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
                    <AlternatingRowStyle BackColor="Gainsboro" />
                </asp:GridView>
            </td>
        </tr>
    </table>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
        SelectCommand="Select * From 酒店房间 Where 已住人数<>0 "></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
        SelectCommand="SELECT * FROM [客房入住单] WHERE ([入住房号] = @入住房号) AND (入住编号 NOT IN (SELECT 入住编号 FROM 客房结账单)) ">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="入住房号" PropertyName="SelectedValue"
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>