frombooktoregisterform.aspx

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

<%--文件名:FromBookToRegisterForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="FromBookToRegisterForm.aspx.cs" Inherits="RoomManage_FromBookToRegisterForm" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 556px; height: 192px">
        <tr>
            <td align="left" colspan="4" style="font-size: 0.8em; font-family: 宋体;
                height: 101px; background-color: slategray">
                入住编号:<asp:TextBox ID="TextBox1" runat="server" BackColor="Silver" ReadOnly="True"
                    Width="113px"></asp:TextBox>
                入住房号:<asp:TextBox ID="TextBox2" runat="server" BackColor="Silver" ReadOnly="True"
                    Width="62px"></asp:TextBox>
                折扣价格:<asp:TextBox ID="TextBox3" runat="server" Width="39px">50</asp:TextBox>
                预收押金:<asp:TextBox ID="TextBox4" runat="server" Width="51px">100</asp:TextBox>入住日期:<asp:TextBox
                    ID="TextBox5" runat="server" Width="113px"></asp:TextBox>
                离开日期:<asp:TextBox ID="TextBox6" runat="server" Width="113px"></asp:TextBox>
                客人姓名:<asp:TextBox ID="TextBox7" runat="server" Width="110px"></asp:TextBox>&nbsp;<br />
                证件名称:<asp:DropDownList ID="DropDownList2" runat="server" Width="91px">
                    <asp:ListItem>居民身份证</asp:ListItem>
                    <asp:ListItem>军官证</asp:ListItem>
                    <asp:ListItem>警官证</asp:ListItem>
                    <asp:ListItem>学生证</asp:ListItem>
                    <asp:ListItem>工作证</asp:ListItem>
                </asp:DropDownList>
                证件号码:<asp:TextBox ID="TextBox9" runat="server" Width="107px"></asp:TextBox>
                证件地址:<asp:TextBox ID="TextBox10" runat="server" Width="143px"></asp:TextBox>&nbsp;<br />
                住宿人数:
                <asp:TextBox ID="TextBox8" runat="server" Width="29px"></asp:TextBox>客人性别:<asp:TextBox
                    ID="TextBox11" runat="server" Width="39px"></asp:TextBox>
                联系电话:<asp:TextBox ID="TextBox13" runat="server" Width="107px">13983115123</asp:TextBox>
                操作人员:<asp:TextBox ID="TextBox14" runat="server" BackColor="Silver" ReadOnly="True"
                    Width="87px"></asp:TextBox>&nbsp;<br />
                登记说明:<asp:TextBox ID="TextBox15" runat="server" Width="322px">暂无</asp:TextBox><asp:Button
                    ID="Button1" runat="server" OnClick="Button1_Click" Text="打印" Width="80px" /><asp:Button
                        ID="Button2" runat="server" OnClick="Button2_Click" Text="保存" Width="80px" /></td>
        </tr>
        <tr>
            <td align="left" colspan="4" rowspan="1" style="height: 135px; background-color: gainsboro">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
                    CellPadding="3" DataKeyNames="自编号" DataSourceID="SqlDataSource1" Font-Names="宋体"
                    Font-Size="Small" GridLines="Vertical" HorizontalAlign="Center" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
                    PageSize="2" Width="552px">
                    <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                    <Columns>
                        <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
                        <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                            SortExpression="自编号" />
                        <asp:BoundField DataField="预约房号" HeaderText="预约房号" SortExpression="预约房号" />
                        <asp:BoundField DataField="预收押金" HeaderText="预收押金" SortExpression="预收押金" />
                        <asp:BoundField DataField="入住日期" HeaderText="入住日期" SortExpression="入住日期" />
                        <asp:BoundField DataField="离开日期" HeaderText="离开日期" SortExpression="离开日期" />
                        <asp:BoundField DataField="客人姓名" HeaderText="客人姓名" SortExpression="客人姓名" />
                        <asp:BoundField DataField="住宿人数" HeaderText="住宿人数" SortExpression="住宿人数" />
                        <asp:BoundField DataField="客人性别" HeaderText="客人性别" SortExpression="客人性别" />
                        <asp:BoundField DataField="联系电话" HeaderText="联系电话" SortExpression="联系电话" />
                        <asp:BoundField DataField="操作人员" HeaderText="操作人员" SortExpression="操作人员" />
                        <asp:BoundField DataField="预约说明" HeaderText="预约说明" SortExpression="预约说明" />
                    </Columns>
                    <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" Font-Size="Small" ForeColor="White"
                        HorizontalAlign="Center" />
                    <AlternatingRowStyle BackColor="#DCDCDC" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
                    ProviderName="<%$ ConnectionStrings:MyHotelDBConnectionString.ProviderName %>"
                    SelectCommand="SELECT [自编号], [预约房号], [预收押金], [入住日期], [离开日期], [客人姓名], [住宿人数], [客人性别], [联系电话], [操作人员], [预约说明] FROM [客房预约单] WHERE ([入住编号] IS NULL)">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyHotelDBConnectionString %>"
                    DeleteCommand="DELETE FROM [客房入住单] WHERE [入住编号] = @入住编号" InsertCommand="INSERT INTO [客房入住单] ([入住编号], [入住房号], [折扣价格], [预收押金], [入住日期], [离开日期], [客人姓名], [证件名称], [证件号码], [证件地址], [住宿人数], [客人性别], [联系电话], [操作人员], [登记说明]) VALUES (@入住编号, @入住房号, @折扣价格, @预收押金, @入住日期, @离开日期, @客人姓名, @证件名称, @证件号码, @证件地址, @住宿人数, @客人性别, @联系电话, @操作人员, @登记说明)"
                    SelectCommand="SELECT * FROM [客房入住单]" UpdateCommand="UPDATE [客房入住单] SET [入住房号] = @入住房号, [折扣价格] = @折扣价格, [预收押金] = @预收押金, [入住日期] = @入住日期, [离开日期] = @离开日期, [客人姓名] = @客人姓名, [证件名称] = @证件名称, [证件号码] = @证件号码, [证件地址] = @证件地址, [住宿人数] = @住宿人数, [客人性别] = @客人性别, [联系电话] = @联系电话, [操作人员] = @操作人员, [登记说明] = @登记说明 WHERE [入住编号] = @入住编号">
                    <DeleteParameters>
                        <asp:Parameter Name="入住编号" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="入住房号" Type="String" />
                        <asp:Parameter Name="折扣价格" Type="Double" />
                        <asp:Parameter Name="预收押金" Type="Double" />
                        <asp:Parameter Name="入住日期" Type="DateTime" />
                        <asp:Parameter Name="离开日期" Type="DateTime" />
                        <asp:Parameter Name="客人姓名" Type="String" />
                        <asp:Parameter Name="证件名称" Type="String" />
                        <asp:Parameter Name="证件号码" Type="String" />
                        <asp:Parameter Name="证件地址" Type="String" />
                        <asp:Parameter Name="住宿人数" Type="Int32" />
                        <asp:Parameter Name="客人性别" Type="String" />
                        <asp:Parameter Name="联系电话" Type="String" />
                        <asp:Parameter Name="操作人员" Type="String" />
                        <asp:Parameter Name="登记说明" Type="String" />
                        <asp:Parameter Name="入住编号" Type="String" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:ControlParameter ControlID="TextBox1" Name="入住编号" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox2" Name="入住房号" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox3" Name="折扣价格" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox4" Name="预收押金" PropertyName="Text" Type="Double" />
                        <asp:ControlParameter ControlID="TextBox5" Name="入住日期" PropertyName="Text" Type="DateTime" />
                        <asp:ControlParameter ControlID="TextBox6" Name="离开日期" PropertyName="Text" Type="DateTime" />
                        <asp:ControlParameter ControlID="TextBox7" Name="客人姓名" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="DropDownList2" Name="证件名称" PropertyName="SelectedValue"
                            Type="String" />
                        <asp:ControlParameter ControlID="TextBox9" Name="证件号码" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox10" Name="证件地址" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox8" Name="住宿人数" PropertyName="Text" Type="Int32" />
                        <asp:ControlParameter ControlID="TextBox11" Name="客人性别" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox13" Name="联系电话" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox14" Name="操作人员" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="TextBox15" Name="登记说明" PropertyName="Text" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</asp:Content>