bookingregform.aspx

C# + MYSQL 课程设计 ASP.NET 2.0数据库开发《餐饮消费管理系统》功能完整

<%--文件名：BookingRegForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="BookingRegForm.aspx.cs" Inherits="BookingManage_BookingRegForm" Title="当前位置：预订管理->预订登记管理" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 558px; height: 1px">
        <tr>
            <td align="left" style="font-size: 0.8em; width: 550px; font-family: 宋体; height: 17px;
                background-color: deepskyblue">
                &nbsp;请输入需要查询的预订编号：<asp:TextBox ID="TextBox5" runat="server" Width="173px">%%</asp:TextBox>
                <asp:Button ID="Button3" runat="server" Text="查询预订" Width="90px" />
                <asp:Button ID="Button4" runat="server" Text="打印预订" Width="90px" OnClick="Button4_Click" /></td>
        </tr>
        <tr>
            <td align="left" style="font-size: 0.8em; width: 550px; font-family: 宋体; height: 17px;
                background-color: lightseagreen">
                &nbsp;预订编号：<asp:TextBox ID="TextBox1" runat="server" BackColor="Silver" ReadOnly="True"
                    Width="148px"></asp:TextBox>
                预订日期：<asp:TextBox ID="TextBox2" runat="server" Width="87px"></asp:TextBox>
                用餐日期：<asp:TextBox ID="TextBox3" runat="server" Width="80px">2007-10-1</asp:TextBox><br />
                &nbsp;用餐人数：<asp:TextBox ID="TextBox4" runat="server" Width="51px">20</asp:TextBox>
                餐次名称：<asp:DropDownList ID="DropDownList1" runat="server" Width="60px">
                    <asp:ListItem>晚餐</asp:ListItem>
                    <asp:ListItem>中餐</asp:ListItem>
                    <asp:ListItem>早餐</asp:ListItem>
                </asp:DropDownList>
                用餐要求：<asp:TextBox ID="TextBox6" runat="server" Width="210px">每人50元标准</asp:TextBox><br />
                &nbsp;预交订金(元)：<asp:TextBox ID="TextBox7" runat="server" Width="51px">0</asp:TextBox>
                联系电话：<asp:TextBox ID="TextBox8" runat="server" Width="120px"></asp:TextBox>
                联系人员：<asp:TextBox ID="TextBox9" runat="server" Width="116px"></asp:TextBox><br />
                &nbsp;补充说明：<asp:TextBox ID="TextBox10" runat="server" Width="272px">暂无</asp:TextBox>&nbsp;<asp:Button
                    ID="Button1" runat="server" Text="新增预订" Width="90px" OnClick="Button1_Click" />&nbsp;<asp:Button ID="Button2"
                        runat="server" Text="取消预订" Width="90px" OnClick="Button2_Click" />
            </td>
        </tr>
        <tr>
            <td style="overflow: auto; width: 550px; height: 103px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="250px" ScrollBars="Auto" Width="555px">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1"
                        DataKeyNames="预订编号" DataSourceID="SqlDataSource1" Font-Names="宋体" Font-Size="Small"
                        GridLines="None" Width="950px" OnRowDataBound="GridView1_RowDataBound">
                        <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
                        <Columns>
                            <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
                            <asp:BoundField DataField="预订编号" HeaderText="预订编号" 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="#DEDFDE" ForeColor="Black" />
                        <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
                        <HeaderStyle BackColor="Navy" Font-Bold="True" ForeColor="#E7E7FF" HorizontalAlign="Center" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyEateryDBConnectionString %>"
                        DeleteCommand="DELETE FROM [预订信息] WHERE [预订编号] = @预订编号" InsertCommand="INSERT INTO [预订信息] ([预订编号], [预订日期], [用餐日期], [用餐人数], [餐次名称], [用餐要求], [预交订金], [联系电话], [联系人员], [当前状态], [补充说明]) VALUES (@预订编号, @预订日期, @用餐日期, @用餐人数, @餐次名称, @用餐要求, @预交订金, @联系电话, @联系人员, @当前状态, @补充说明)"
                        SelectCommand="SELECT * FROM [预订信息] WHERE (([预订编号] LIKE '%' + @预订编号 + '%') AND ([当前状态] = '已经预订'))"
                        UpdateCommand="UPDATE [预订信息] SET [预订日期] = @预订日期, [用餐日期] = @用餐日期, [用餐人数] = @用餐人数, [餐次名称] = @餐次名称, [用餐要求] = @用餐要求, [预交订金] = @预交订金, [联系电话] = @联系电话, [联系人员] = @联系人员, [当前状态] = @当前状态, [补充说明] = @补充说明 WHERE [预订编号] = @预订编号">
                        <DeleteParameters>
                            <asp:Parameter Name="预订编号" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="预订日期" Type="DateTime" />
                            <asp:Parameter Name="用餐日期" Type="DateTime" />
                            <asp:Parameter Name="用餐人数" Type="Int32" />
                            <asp:Parameter Name="餐次名称" Type="String" />
                            <asp:Parameter Name="用餐要求" Type="String" />
                            <asp:Parameter Name="预交订金" Type="Double" />
                            <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>
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox5" Name="预订编号" PropertyName="Text" Type="String" />
                        </SelectParameters>
                        <InsertParameters>
                            <asp:ControlParameter ControlID="TextBox1" Name="预订编号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox2" Name="预订日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox3" Name="用餐日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox4" Name="用餐人数" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="DropDownList1" Name="餐次名称" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox6" Name="用餐要求" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox7" Name="预交订金" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox8" Name="联系电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox9" Name="联系人员" PropertyName="Text" Type="String" />
                            <asp:Parameter Name="当前状态" Type="String" DefaultValue="已经预订" />
                            <asp:ControlParameter ControlID="TextBox10" DefaultValue="" Name="补充说明" PropertyName="Text"
                                Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                    &nbsp; &nbsp; &nbsp;
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>