📄 adminedit_3.aspx.exclude
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AdminEdit_3.aspx.cs" Inherits="AdminEdit_3" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div style="text-align: center">
<table style="width: 745px">
<tr>
<td align="left" style="width: 670px;" valign="top">
<asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="~/AdminPage.aspx">返回</asp:HyperLink>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Text="->报名管理"></asp:Label></td>
</tr>
<tr>
<td align="left" style="width: 670px" valign="top">
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/DateToExcel.aspx">下载报名信息Excel表格文件</asp:HyperLink></td>
</tr>
<tr>
<td align="left" style="width: 670px" valign="top">
</td>
</tr>
<tr>
<td style="width: 670px" align="left" valign="top">
队伍ID<asp:TextBox ID="teamidtxt" runat="server"></asp:TextBox><br />
队伍名<asp:TextBox ID="teamnametxt" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" /></td>
</tr>
<tr>
<td style="width: 670px" align="left" valign="top">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="TeamName"
DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<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>
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>"
DeleteCommand="DELETE FROM [Team] WHERE [TeamName] = @original_TeamName AND [TeamID] = @original_TeamID AND [CSchoolName] = @original_CSchoolName AND [ESchoolName] = @original_ESchoolName AND [Lodging] = @original_Lodging AND [Amount] = @original_Amount AND [LodgingDay] = @original_LodgingDay" InsertCommand="INSERT INTO [Team] ([TeamName], [CSchoolName], [ESchoolName], [Lodging], [Amount], [LodgingDay]) VALUES (@TeamName, @CSchoolName, @ESchoolName, @Lodging, @Amount, @LodgingDay)"
ProviderName="<%$ ConnectionStrings:ACMConnectionString1.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] = @original_TeamName AND [TeamID] = @original_TeamID AND [CSchoolName] = @original_CSchoolName AND [ESchoolName] = @original_ESchoolName AND [Lodging] = @original_Lodging AND [Amount] = @original_Amount AND [LodgingDay] = @original_LodgingDay" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="original_{0}">
<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>
<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="original_TeamName" Type="String" />
<asp:Parameter Name="original_TeamID" Type="Int32" />
<asp:Parameter Name="original_CSchoolName" Type="String" />
<asp:Parameter Name="original_ESchoolName" Type="String" />
<asp:Parameter Name="original_Lodging" Type="Boolean" />
<asp:Parameter Name="original_Amount" Type="Int32" />
<asp:Parameter Name="original_LodgingDay" Type="Int32" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="original_TeamName" Type="String" />
<asp:Parameter Name="original_TeamID" Type="Int32" />
<asp:Parameter Name="original_CSchoolName" Type="String" />
<asp:Parameter Name="original_ESchoolName" Type="String" />
<asp:Parameter Name="original_Lodging" Type="Boolean" />
<asp:Parameter Name="original_Amount" Type="Int32" />
<asp:Parameter Name="original_LodgingDay" Type="Int32" />
</DeleteParameters>
<SelectParameters>
<asp:SessionParameter Name="TeamID" SessionField="id" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="TeacherID" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:CommandField ShowEditButton="True" />
<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="#E3EAEB" />
<EditRowStyle BackColor="#7C6F57" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -