📄 adminedit_2.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AdminEdit_2.aspx.cs" Inherits="AdminEdit_2" %>
<!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>
<tr>
<td align="left" style="width: 755px; height: 92px" valign="top">
<table style="width: 750px">
<tr>
<td style="width: 670px">
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/AdminPage.aspx">返回</asp:HyperLink>
<asp:Label ID="Label1" runat="server" Text="->用户管理" Font-Bold="True"></asp:Label></td>
</tr>
<tr>
<td style="width: 100px; height: 21px">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
BorderWidth="1px" CellPadding="3" DataKeyNames="UserID" DataSourceID="SqlDataSource1"
GridLines="Vertical" Width="745px">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:CommandField ShowDeleteButton="True">
<ItemStyle Font-Size="Smaller" />
</asp:CommandField>
<asp:BoundField DataField="UserID" HeaderText="UserID" ReadOnly="True" SortExpression="UserID" />
<asp:BoundField DataField="UserName" HeaderText="UserName" ReadOnly="True" SortExpression="UserName" />
<asp:BoundField DataField="Age" HeaderText="Age" ReadOnly="True" SortExpression="Age" />
<asp:BoundField DataField="Sex" HeaderText="Sex" ReadOnly="True" SortExpression="Sex" />
<asp:BoundField DataField="Job" HeaderText="Job" ReadOnly="True" SortExpression="Job" />
<asp:BoundField DataField="SchoolName" HeaderText="SchoolName" ReadOnly="True" SortExpression="SchoolName" />
<asp:BoundField DataField="Email" HeaderText="Email" ReadOnly="True" SortExpression="Email" />
<asp:CheckBoxField DataField="Receive" HeaderText="Receive" SortExpression="Receive" />
<asp:BoundField DataField="Power" HeaderText="Power" SortExpression="Power" />
</Columns>
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ACMConnectionString %>" DeleteCommand="DELETE FROM [User] WHERE [UserID] = @original_UserID AND [UserName] = @original_UserName AND [Age] = @original_Age AND [Sex] = @original_Sex AND [Job] = @original_Job AND [SchoolName] = @original_SchoolName AND [Email] = @original_Email AND [Receive] = @original_Receive AND [Power] = @original_Power"
InsertCommand="INSERT INTO [User] ([UserID], [UserName], [Age], [Sex], [Job], [SchoolName], [Email], [Receive], [Power]) VALUES (@UserID, @UserName, @Age, @Sex, @Job, @SchoolName, @Email, @Receive, @Power)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [UserID], [UserName], [Age], [Sex], [Job], [SchoolName], [Email], [Receive], [Power] FROM [User] ORDER BY [UserID]"
UpdateCommand="UPDATE [User] SET [UserName] = @UserName, [Age] = @Age, [Sex] = @Sex, [Job] = @Job, [SchoolName] = @SchoolName, [Email] = @Email, [Receive] = @Receive, [Power] = @Power WHERE [UserID] = @original_UserID AND [UserName] = @original_UserName AND [Age] = @original_Age AND [Sex] = @original_Sex AND [Job] = @original_Job AND [SchoolName] = @original_SchoolName AND [Email] = @original_Email AND [Receive] = @original_Receive AND [Power] = @original_Power">
<DeleteParameters>
<asp:Parameter Name="original_UserID" Type="String" />
<asp:Parameter Name="original_UserName" Type="String" />
<asp:Parameter Name="original_Age" Type="Int16" />
<asp:Parameter Name="original_Sex" Type="String" />
<asp:Parameter Name="original_Job" Type="String" />
<asp:Parameter Name="original_SchoolName" Type="String" />
<asp:Parameter Name="original_Email" Type="String" />
<asp:Parameter Name="original_Receive" Type="Boolean" />
<asp:Parameter Name="original_Power" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="Age" Type="Int16" />
<asp:Parameter Name="Sex" Type="String" />
<asp:Parameter Name="Job" Type="String" />
<asp:Parameter Name="SchoolName" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="Receive" Type="Boolean" />
<asp:Parameter Name="Power" Type="Int32" />
<asp:Parameter Name="original_UserID" Type="String" />
<asp:Parameter Name="original_UserName" Type="String" />
<asp:Parameter Name="original_Age" Type="Int16" />
<asp:Parameter Name="original_Sex" Type="String" />
<asp:Parameter Name="original_Job" Type="String" />
<asp:Parameter Name="original_SchoolName" Type="String" />
<asp:Parameter Name="original_Email" Type="String" />
<asp:Parameter Name="original_Receive" Type="Boolean" />
<asp:Parameter Name="original_Power" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="UserID" Type="String" />
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="Age" Type="Int16" />
<asp:Parameter Name="Sex" Type="String" />
<asp:Parameter Name="Job" Type="String" />
<asp:Parameter Name="SchoolName" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="Receive" Type="Boolean" />
<asp:Parameter Name="Power" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 100px">
<asp:Label ID="Label5" runat="server" Text="用户ID"></asp:Label><asp:TextBox ID="useridtxt"
runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click"
Text="删除" />
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click"
Text="↑提升权限" /><asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="↓降低权限" /></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -