consumeform.aspx

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

<%--文件名:ConsumeForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ConsumeForm.aspx.cs" Inherits="ConsumeManage_ConsumeForm" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 557px; height: 2px">
        <tr>
            <td align="center" style="font-size: 0.8em; width: 1193px; font-family: 宋体; height: 16px;
                background-color: gainsboro">
                消费编号:<asp:TextBox ID="TextBox4" runat="server" BackColor="#E0E0E0" Width="338px"></asp:TextBox>
                <asp:Button ID="Button5" runat="server" OnClick="Button4_Click" Text="随机生成消费编号" Width="132px" /></td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 1193px; font-family: 宋体; height: 16px;
                background-color: gainsboro">
                酒店房号：<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
                    DataTextField="房号" DataValueField="房号">
                </asp:DropDownList>
                旅客姓名:<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
                    DataTextField="客人姓名" DataValueField="入住编号">
                </asp:DropDownList>
                商品名称:<asp:DropDownList ID="DropDownList3" runat="server" Width="94px" DataSourceID="SqlDataSource3" DataTextField="名称" DataValueField="名称" AutoPostBack="True" OnSelectedIndexChanged="DropDownList3_SelectedIndexChanged">
                </asp:DropDownList>
                折扣价格：<asp:TextBox ID="TextBox2" runat="server" Width="48px">0.00</asp:TextBox></td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 1193px; font-family: 宋体; height: 16px;
                background-color: gainsboro">
                &nbsp;消费数量:<asp:TextBox ID="TextBox1" runat="server" Width="54px"></asp:TextBox>说明:<asp:TextBox ID="TextBox3" runat="server" Width="112px">暂无</asp:TextBox>
                操作人员:<asp:TextBox ID="TextBox5" runat="server" BackColor="#E0E0E0" Width="41px"></asp:TextBox>
                记账时间:<asp:TextBox ID="TextBox6" runat="server" BackColor="#E0E0E0" Width="85px"></asp:TextBox></td>
        </tr>
        <tr>
            <td align="center" style="font-size: 0.8em; width: 1193px; font-family: 宋体; height: 16px;
                background-color: gainsboro">
                <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="新增" Width="80px" />
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="打印" Width="80px" />
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="保存" Width="80px" /></td>
        </tr>
        <tr>
            <td align="left" style="font-size: 0.8em; width: 1193px; font-family: 宋体; height: 10px;
                background-color: gainsboro">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
                    SelectCommand="Select 房号 From 酒店房间 Where 已住人数>0"></asp:SqlDataSource>
                &nbsp; &nbsp;<asp:GridView ID="GridView1" runat="server">
                    <HeaderStyle HorizontalAlign="Center" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
                    SelectCommand="SELECT * FROM [消费商品]"></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>
            </td>
        </tr>
    </table>
</asp:Content>