bookingeatform.aspx

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

                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyEateryDBConnectionString %>"
                        SelectCommand="SELECT [台位编号], [容纳人数], [所在位置], [台位类型], [当前状态] FROM [台位信息] WHERE ([当前状态] = '空置')">
                    </asp:SqlDataSource>
                    &nbsp; &nbsp;
                </asp:Panel>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MyEateryDBConnectionString %>"
                    SelectCommand="SELECT * FROM [员工信息] WHERE ([所属部门] = '服务生组')"></asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td 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="179px"></asp:TextBox>
                入座台位：<asp:TextBox ID="TextBox2" runat="server" BackColor="Silver" ReadOnly="True"
                    Width="97px"></asp:TextBox>
                宾客人数：<asp:TextBox ID="TextBox3" runat="server" Width="39px">0</asp:TextBox><br />
                &nbsp;用餐日期：<asp:TextBox ID="TextBox4" runat="server" Width="157px"></asp:TextBox>
                餐别：<asp:DropDownList ID="DropDownList1" runat="server" Width="82px">
                    <asp:ListItem>晚餐</asp:ListItem>
                    <asp:ListItem>中餐</asp:ListItem>
                    <asp:ListItem>早餐</asp:ListItem>
                </asp:DropDownList>&nbsp; 服务人员：<asp:DropDownList ID="DropDownList3" runat="server"
                    DataSourceID="SqlDataSource3" DataTextField="员工姓名" DataValueField="员工编号" Width="107px">
                </asp:DropDownList><br />
                &nbsp;补充说明：<asp:TextBox ID="TextBox7" runat="server" Width="235px">暂无</asp:TextBox>
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="开台" Width="71px" />
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="打印" Width="71px" />
                <asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text="删除" Width="71px" /></td>
        </tr>
        <tr>
            <td 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="Panel2" runat="server" Height="100px" ScrollBars="Auto" Width="555px">
                                <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" BackColor="White"
                                    BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1"
                                    DataKeyNames="用餐单号" DataSourceID="SqlDataSource4" Font-Names="宋体" Font-Size="Small"
                                    GridLines="None" OnRowDataBound="GridView2_RowDataBound" OnSelectedIndexChanged="GridView2_SelectedIndexChanged"
                                    Width="750px">
                                    <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="用餐类别" />
                                        <asp:BoundField DataField="服务人员" HeaderText="服务人员" SortExpression="服务人员" />
                                        <asp:BoundField DataField="补充说明" HeaderText="补充说明" SortExpression="补充说明" />
                                        <asp:BoundField DataField="当前状态" HeaderText="当前状态" SortExpression="当前状态" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource4" 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>
    </table>
</asp:Content>