depositform.aspx

一个关于宾馆酒店管理系统的源代码

<%--文件名:DepositForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="DepositForm.aspx.cs" Inherits="RoomManage_DepositForm" 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:DropDownList ID="DropDownList1" runat="server" Width="70px" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="房号" DataValueField="房号">
                </asp:DropDownList>
                姓名:<asp:DropDownList ID="DropDownList2" runat="server" Width="70px" DataSourceID="SqlDataSource2" DataTextField="客人姓名" DataValueField="入住编号">
                </asp:DropDownList>&nbsp;日期：<asp:TextBox ID="TextBox9" runat="server" Width="33px"></asp:TextBox>年<asp:TextBox
                    ID="TextBox10" runat="server" Width="17px"></asp:TextBox>月<asp:TextBox ID="TextBox11"
                        runat="server" Width="14px"></asp:TextBox>日<asp:Button ID="Button1" runat="server" Text="查询" Width="50px" OnClick="Button1_Click" />
                <asp:Button ID="Button2" runat="server" Text="打印" Width="50px" OnClick="Button2_Click" />
                <asp:Button ID="Button3" runat="server" Text="保存" Width="50px" OnClick="Button3_Click" /></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" ReadOnly="True" BackColor="Silver"></asp:TextBox><br />
                住宿费： &nbsp;<asp:TextBox ID="TextBox2" runat="server" ReadOnly="True" BackColor="Silver"></asp:TextBox><br />
                电话费： &nbsp;<asp:TextBox ID="TextBox3" runat="server" ReadOnly="True" BackColor="Silver"></asp:TextBox><br />
                用餐费： &nbsp;<asp:TextBox ID="TextBox4" runat="server" ReadOnly="True" BackColor="Silver"></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" ReadOnly="True" BackColor="Silver"></asp:TextBox><br />
                费用合计:<asp:TextBox ID="TextBox6" runat="server" ReadOnly="True" BackColor="Silver"></asp:TextBox><br />
                补交押金:<asp:TextBox ID="TextBox7" runat="server"></asp:TextBox><br />
                说明: &nbsp; &nbsp;<asp:TextBox ID="TextBox8" runat="server">旅客曾经补交押金</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" GridLines="Vertical" Height="81px"
                    Width="553px" Font-Names="宋体" Font-Size="Small">
                    <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>