signupfinish.aspx

B/S asp.net的C#编的网站

<%@ Page Language="C#" MasterPageFile="~/MasterPage/UserPage.master" AutoEventWireup="true" CodeFile="SignUpFinish.aspx.cs" Inherits="SignUpFinish" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    请记住您的队伍信息中各人员的ID号，以备必要时提交管理员查询修改！<br />
    <br />
    队伍信息<br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
        DataKeyNames="TeamName" DataSourceID="SqlDataSource1" EmptyDataText="没有可显示的数据记录。"
        ForeColor="#333333" GridLines="None" Width="475px">
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <Columns>
            <asp:BoundField DataField="TeamID" HeaderText="TeamID" ReadOnly="True" SortExpression="TeamID" />
            <asp:BoundField DataField="TeamName" HeaderText="TeamName" ReadOnly="True" SortExpression="TeamName" />
            <asp:BoundField DataField="CSchoolName" HeaderText="CSchoolName" SortExpression="CSchoolName" />
            <asp:BoundField DataField="ESchoolName" HeaderText="ESchoolName" SortExpression="ESchoolName" />
            <asp:CheckBoxField DataField="Lodging" HeaderText="Lodging" SortExpression="Lodging" />
            <asp:BoundField DataField="Amount" HeaderText="Amount" SortExpression="Amount" />
            <asp:BoundField DataField="LodgingDay" HeaderText="LodgingDay" SortExpression="LodgingDay" />
        </Columns>
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <EditRowStyle BackColor="#999999" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>"
        DeleteCommand="DELETE FROM [Team] WHERE [TeamName] = @TeamName" InsertCommand="INSERT INTO [Team] ([TeamName], [CSchoolName], [ESchoolName], [Lodging], [Amount], [LodgingDay]) VALUES (@TeamName, @CSchoolName, @ESchoolName, @Lodging, @Amount, @LodgingDay)"
        ProviderName="<%$ ConnectionStrings:ACMConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [Team] WHERE ([TeamID] = @TeamID)"
        UpdateCommand="UPDATE [Team] SET [TeamID] = @TeamID, [CSchoolName] = @CSchoolName, [ESchoolName] = @ESchoolName, [Lodging] = @Lodging, [Amount] = @Amount, [LodgingDay] = @LodgingDay WHERE [TeamName] = @TeamName">
        <DeleteParameters>
            <asp:Parameter Name="TeamName" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="TeamID" Type="Int32" />
            <asp:Parameter Name="CSchoolName" Type="String" />
            <asp:Parameter Name="ESchoolName" Type="String" />
            <asp:Parameter Name="Lodging" Type="Boolean" />
            <asp:Parameter Name="Amount" Type="Int32" />
            <asp:Parameter Name="LodgingDay" Type="Int32" />
            <asp:Parameter Name="TeamName" Type="String" />
        </UpdateParameters>
        <SelectParameters>
            <asp:SessionParameter Name="TeamID" SessionField="teamid" Type="Int32" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="TeamName" Type="String" />
            <asp:Parameter Name="CSchoolName" Type="String" />
            <asp:Parameter Name="ESchoolName" Type="String" />
            <asp:Parameter Name="Lodging" Type="Boolean" />
            <asp:Parameter Name="Amount" Type="Int32" />
            <asp:Parameter Name="LodgingDay" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <br />
    带队老师信息&nbsp;<br />
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4"
        DataKeyNames="TeacherID" DataSourceID="SqlDataSource2" EmptyDataText="没有可显示的数据记录。"
        ForeColor="#333333" GridLines="None">
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <Columns>
            <asp:BoundField DataField="TeacherID" HeaderText="TeacherID" ReadOnly="True" SortExpression="TeacherID" />
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            <asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
            <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
            <asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" />
            <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
            <asp:BoundField DataField="Size" HeaderText="Size" SortExpression="Size" />
            <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
            <asp:BoundField DataField="Code" HeaderText="Code" SortExpression="Code" />
        </Columns>
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <EditRowStyle BackColor="#999999" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>"
        DeleteCommand="DELETE FROM [Teacher] WHERE [TeacherID] = @TeacherID" InsertCommand="INSERT INTO [Teacher] ([TeacherID], [Name], [Sex], [Phone], [Mobile], [Email], [Size], [Address], [Code], [TeamID]) VALUES (@TeacherID, @Name, @Sex, @Phone, @Mobile, @Email, @Size, @Address, @Code, @TeamID)"
        ProviderName="<%$ ConnectionStrings:ACMConnectionString.ProviderName %>" SelectCommand="SELECT [TeacherID], [Name], [Sex], [Phone], [Mobile], [Email], [Size], [Address], [Code], [TeamID] FROM [Teacher] WHERE ([TeamID] = @TeamID)"
        UpdateCommand="UPDATE [Teacher] SET [Name] = @Name, [Sex] = @Sex, [Phone] = @Phone, [Mobile] = @Mobile, [Email] = @Email, [Size] = @Size, [Address] = @Address, [Code] = @Code, [TeamID] = @TeamID WHERE [TeacherID] = @TeacherID">
        <DeleteParameters>
            <asp:Parameter Name="TeacherID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Name" Type="String" />
            <asp:Parameter Name="Sex" Type="String" />
            <asp:Parameter Name="Phone" Type="String" />
            <asp:Parameter Name="Mobile" Type="String" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="Size" Type="String" />
            <asp:Parameter Name="Address" Type="String" />
            <asp:Parameter Name="Code" Type="String" />
            <asp:Parameter Name="TeamID" Type="Int32" />
            <asp:Parameter Name="TeacherID" Type="Int32" />
        </UpdateParameters>
        <SelectParameters>
            <asp:SessionParameter Name="TeamID" SessionField="teamid" Type="Int32" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="TeacherID" Type="Int32" />
            <asp:Parameter Name="Name" Type="String" />
            <asp:Parameter Name="Sex" Type="String" />
            <asp:Parameter Name="Phone" Type="String" />
            <asp:Parameter Name="Mobile" Type="String" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="Size" Type="String" />
            <asp:Parameter Name="Address" Type="String" />
            <asp:Parameter Name="Code" Type="String" />
            <asp:Parameter Name="TeamID" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <br />
    队员信息&nbsp;<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False"
        CellPadding="4" DataKeyNames="PlayID" DataSourceID="SqlDataSource3" EmptyDataText="没有可显示的数据记录。"
        ForeColor="#333333" GridLines="None">
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <Columns>
            <asp:BoundField DataField="PlayID" HeaderText="PlayID" ReadOnly="True" SortExpression="PlayID" />
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            <asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
            <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
            <asp:BoundField DataField="Size" HeaderText="Size" SortExpression="Size" />
            <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
            <asp:BoundField DataField="Mobile" HeaderText="Mobile" SortExpression="Mobile" />
            <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
            <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
            <asp:BoundField DataField="Code" HeaderText="Code" SortExpression="Code" />
            <asp:BoundField DataField="MSchool" HeaderText="MSchool" SortExpression="MSchool" />
            <asp:BoundField DataField="HSchool" HeaderText="HSchool" SortExpression="HSchool" />
            <asp:BoundField DataField="Merit" HeaderText="Merit" SortExpression="Merit" />
        </Columns>
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <EditRowStyle BackColor="#999999" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>"
        DeleteCommand="DELETE FROM [Player] WHERE [PlayID] = @PlayID" InsertCommand="INSERT INTO [Player] ([PlayID], [Name], [Sex], [Age], [Size], [Phone], [Mobile], [Email], [Address], [Code], [MSchool], [HSchool], [TeamID], [Merit]) VALUES (@PlayID, @Name, @Sex, @Age, @Size, @Phone, @Mobile, @Email, @Address, @Code, @MSchool, @HSchool, @TeamID, @Merit)"
        ProviderName="<%$ ConnectionStrings:ACMConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [Player] WHERE ([TeamID] = @TeamID)"
        UpdateCommand="UPDATE [Player] SET [Name] = @Name, [Sex] = @Sex, [Age] = @Age, [Size] = @Size, [Phone] = @Phone, [Mobile] = @Mobile, [Email] = @Email, [Address] = @Address, [Code] = @Code, [MSchool] = @MSchool, [HSchool] = @HSchool, [TeamID] = @TeamID, [Merit] = @Merit WHERE [PlayID] = @PlayID">
        <DeleteParameters>
            <asp:Parameter Name="PlayID" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Name" Type="String" />
            <asp:Parameter Name="Sex" Type="String" />
            <asp:Parameter Name="Age" Type="Int16" />
            <asp:Parameter Name="Size" Type="String" />
            <asp:Parameter Name="Phone" Type="String" />
            <asp:Parameter Name="Mobile" Type="String" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="Address" Type="String" />
            <asp:Parameter Name="Code" Type="Int64" />
            <asp:Parameter Name="MSchool" Type="String" />
            <asp:Parameter Name="HSchool" Type="String" />
            <asp:Parameter Name="TeamID" Type="Int32" />
            <asp:Parameter Name="Merit" Type="String" />
            <asp:Parameter Name="PlayID" Type="String" />
        </UpdateParameters>
        <SelectParameters>
            <asp:SessionParameter Name="TeamID" SessionField="teamid" Type="Int32" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="PlayID" Type="String" />
            <asp:Parameter Name="Name" Type="String" />
            <asp:Parameter Name="Sex" Type="String" />
            <asp:Parameter Name="Age" Type="Int16" />
            <asp:Parameter Name="Size" Type="String" />
            <asp:Parameter Name="Phone" Type="String" />
            <asp:Parameter Name="Mobile" Type="String" />
            <asp:Parameter Name="Email" Type="String" />
            <asp:Parameter Name="Address" Type="String" />
            <asp:Parameter Name="Code" Type="Int64" />
            <asp:Parameter Name="MSchool" Type="String" />
            <asp:Parameter Name="HSchool" Type="String" />
            <asp:Parameter Name="TeamID" Type="Int32" />
            <asp:Parameter Name="Merit" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    <br />
    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="确认" />
</asp:Content>