📄 useredit.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserEdit.aspx.cs" Inherits="admin_UserEdit" %>
<!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>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td height="50" valign="bottom">
<asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click" CausesValidation="False">用户列表</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" OnClick="LinkButton2_Click" CausesValidation="False">新建用户</asp:LinkButton><br/><br/>
</td>
</tr>
<tr><td>
<asp:Panel ID="Panel1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"
Width="550px" AllowPaging="True" AllowSorting="True">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="UserName" HeaderText="用户名" SortExpression="UserName">
<ItemStyle HorizontalAlign="Center" />
<ControlStyle Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="PassWord" HeaderText="密码" SortExpression="PassWord">
<ItemStyle HorizontalAlign="Center" />
<ControlStyle Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="AlignType" HeaderText="激活" SortExpression="AlignType">
<ItemStyle HorizontalAlign="Center" />
<ControlStyle Width="40px" />
</asp:BoundField>
<asp:BoundField DataField="Controls" HeaderText="仓库" SortExpression="Controls">
<ItemStyle HorizontalAlign="Center" />
<ControlStyle Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="GoodsType" HeaderText="类型" SortExpression="GoodsType">
<ItemStyle HorizontalAlign="Center" />
<ControlStyle Width="60px" />
</asp:BoundField>
<asp:CommandField HeaderText="编辑" ShowEditButton="True" >
<ItemStyle HorizontalAlign="Center" />
</asp:CommandField>
<asp:TemplateField HeaderText="删除" ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" OnClientClick="return confirm('您确定删除该用户？')"
Text="删除"></asp:LinkButton>
</ItemTemplate>
<ControlStyle Width="60px" />
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#C3C3C3" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#A3C5CE" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#A3C5CE" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:al_bysjConnectionString %>"
DeleteCommand="DELETE FROM [UserList] WHERE [ID] = @ID" InsertCommand="INSERT INTO [UserList] ([UserName], [PassWord], [AlignType], [Controls], [GoodsType]) VALUES (@UserName, @PassWord, @AlignType, @Controls, @GoodsType)"
SelectCommand="SELECT [ID], [UserName], [PassWord], [AlignType], [Controls], [GoodsType] FROM [UserList]"
UpdateCommand="UPDATE [UserList] SET [UserName] = @UserName, [PassWord] = @PassWord, [AlignType] = @AlignType, [Controls] = @Controls, [GoodsType] = @GoodsType WHERE [ID] = @ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="PassWord" Type="String" />
<asp:Parameter Name="AlignType" Type="Int32" />
<asp:Parameter Name="Controls" Type="Int32" />
<asp:Parameter Name="GoodsType" Type="Int32" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="PassWord" Type="String" />
<asp:Parameter Name="AlignType" Type="Int32" />
<asp:Parameter Name="Controls" Type="Int32" />
<asp:Parameter Name="GoodsType" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
</asp:Panel>
<asp:Panel ID="Panel2" runat="server">
<table width="550" bgcolor="#a3c5ce" border="0" cellpadding="0" cellspacing="1">
<tr><td colspan="2" height="20" align="center"><b><font color="#ffffff">添加新用户</font></b></td></tr>
<tr>
<td bgcolor="#f0fbfd" align="right" width="200" height="20">用户:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="UserName" runat="server" Width="80px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="用户名不能为空" ControlToValidate="UserName"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" align="right" height="20">密码:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="PassWord" runat="server" Width="120px" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="密码不能为空" ControlToValidate="PassWord"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" align="right" height="20">确认:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="PWD" runat="server" Width="120px" TextMode="Password"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator1" runat="server" ErrorMessage="两次输入密码不一致" ControlToCompare="PWD" ControlToValidate="PassWord"></asp:CompareValidator></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" align="right" style="height: 20px">仓库:</td>
<td bgcolor="#f0fbfd" style="height: 24px"><asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2" DataTextField="KeepName" DataValueField="ID"></asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:al_bysjConnectionString %>"
SelectCommand="SELECT [ID], [KeepName] FROM [KeepNum] ORDER BY [ID]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td bgcolor="#f0fbfd" align="right" height="20">角色:</td>
<td bgcolor="#f0fbfd"><select id="Select1" runat="server">
<option selected="selected">--请选择--</option>
<option value="0">仓库管理员</option>
<option value="1">入库管理员</option>
<option value="2">出库管理员</option>
</select></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" height="20" valign="bottom"></td>
<td bgcolor="#f0fbfd"><asp:Button ID="Button1" runat="server" Text=" 添 加 " UseSubmitBehavior="False" OnClick="Button1_Click" /></td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -