bookingeatform.aspx

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

<%--文件名：BookingEatForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="BookingEatForm.aspx.cs" Inherits="BookingManage_BookingEatForm" Title="当前位置：预订管理->预订开台管理" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 558px; height: 1px">
        <tr>
            <td align="left" style="overflow: auto; width: 550px; height: 103px; background-color: gainsboro"><table style="width: 558px; height: 1px">
                <tr>
                    <td style="overflow: auto; width: 550px; height: 103px; background-color: gainsboro">
                        <asp:Panel ID="Panel3" runat="server" Height="100px" ScrollBars="Auto" Width="555px">
                            <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" BackColor="White"
                                    BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1"
                                    DataKeyNames="预订编号" DataSourceID="SqlDataSource5" Font-Names="宋体" Font-Size="Small"
                                    GridLines="None" OnRowDataBound="GridView3_RowDataBound" OnSelectedIndexChanged="GridView3_SelectedIndexChanged"
                                    Width="1250px">
                                <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="补充说明" />
                                </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="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:MyEateryDBConnectionString %>"
                                SelectCommand="SELECT [预订编号], [预订日期], [用餐日期], [用餐人数], [餐次名称], [用餐要求], [预交订金], [联系电话], [联系人员], [补充说明] FROM [预订信息] WHERE ([当前状态] = @当前状态)">
                                <SelectParameters>
                                    <asp:Parameter DefaultValue="已经预订" Name="当前状态" Type="String" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyEateryDBConnectionString %>"
                                    DeleteCommand="DELETE FROM [用餐信息] WHERE [用餐单号] = @用餐单号" InsertCommand="INSERT INTO [用餐信息] ([用餐单号], [入座台位], [宾客人数], [用餐日期], [用餐类别], [服务人员], [补充说明], [当前状态]) VALUES (@用餐单号, @入座台位, @宾客人数, @用餐日期, @用餐类别, @服务人员, @补充说明, @当前状态)"
                                    SelectCommand="SELECT [用餐单号], [入座台位], [宾客人数], [用餐日期], [用餐类别], [服务人员], [补充说明], [当前状态] FROM [用餐信息] WHERE ([用餐日期] = @用餐日期) AND ([当前状态] = '正在用餐')"
                                    UpdateCommand="UPDATE [用餐信息] SET [入座台位] = @入座台位, [宾客人数] = @宾客人数, [用餐日期] = @用餐日期, [用餐类别] = @用餐类别, [服务人员] = @服务人员, [补充说明] = @补充说明, [当前状态] = @当前状态 WHERE [用餐单号] = @用餐单号">
                                <DeleteParameters>
                                    <asp:Parameter Name="用餐单号" Type="String" />
                                </DeleteParameters>
                                <UpdateParameters>
                                    <asp:Parameter Name="入座台位" Type="String" />
                                    <asp:Parameter Name="宾客人数" Type="Int32" />
                                    <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="String" />
                                </UpdateParameters>
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="TextBox4" Name="用餐日期" PropertyName="Text" Type="DateTime" />
                                </SelectParameters>
                                <InsertParameters>
                                    <asp:Parameter Name="用餐单号" Type="String" />
                                    <asp:Parameter Name="入座台位" Type="String" />
                                    <asp:Parameter Name="宾客人数" Type="Int32" />
                                    <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" />
                                </InsertParameters>
                            </asp:SqlDataSource>
                            &nbsp; &nbsp;
                        </asp:Panel>
                    </td>
                </tr>
            </table>
            </td>
        </tr>
        <tr>
            <td align="left" style="font-size: 0.8em; width: 550px; font-family: 宋体; height: 17px;
                background-color: deepskyblue">
                &nbsp;请先在上面的表格中选择客人的预订编号，再在下面的表格中选择客人的入座台位：<asp:Button ID="Button1" runat="server"
                    Text="刷新" Width="54px" /></td>
        </tr>
        <tr>
            <td style="overflow: auto; width: 550px; height: 103px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="100px" 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" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="650px">
                        <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
                        <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" />
                        <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="当前状态" />