📄 workerslist.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="WorkersList.aspx.cs" Inherits="WorkKind_WorkersList" %>
<!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>
<link href="../style/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<strong>员工信息列表</strong>
<br />
查询条件：<asp:DropDownList ID="DrDpSeaLei" runat="server" Width="175px">
<asp:ListItem Value="all" Selected="True">==显示所有＝＝</asp:ListItem>
<asp:ListItem Value="workerid">员工编号</asp:ListItem>
<asp:ListItem Value="workername">员工姓名</asp:ListItem>
<asp:ListItem Value="workkind">工作类型</asp:ListItem>
<asp:ListItem Value="workersalary">工资</asp:ListItem>
<asp:ListItem Value="workerphone">电话号码</asp:ListItem>
<asp:ListItem Value="workeraddress">居住地址</asp:ListItem>
</asp:DropDownList>
关键字：
<asp:TextBox ID="TbSeaDetail" runat="server" Width="292px"></asp:TextBox>
<asp:Button ID="BtSearch" runat="server" Text="Search" OnClick="BtSearch_Click" />
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
BorderWidth="1px" CellPadding="3" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"
GridLines="Vertical" Width="952px" Height="1px" DataKeyNames="WorkersListId">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<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="Gainsboro" />
<Columns>
<asp:BoundField DataField="WorkersListId" HeaderText="员工编号"
SortExpression="WorkersListId" />
<asp:BoundField DataField="WorkerName" HeaderText="姓名" SortExpression="WorkerName" />
<asp:TemplateField HeaderText="员工工作">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("WorkKinds") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" Width="141px" DataSourceID="SqlDataSource3"
DataTextField="WorkKinds" DataValueField="WorkKindListId">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="select WorkKindList.WorkKindListId,WorkKindList.WorkKinds from WorkKindList ">
</asp:SqlDataSource>
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="WorkerPwd" HeaderText="密码" SortExpression="WorkerPwd" />
<asp:BoundField DataField="Salary" HeaderText="工资" SortExpression="Salary" />
<asp:BoundField DataField="WorkerPhone" HeaderText="联系电话" SortExpression="WorkerPhone" />
<asp:BoundField DataField="WorkerAddress" HeaderText="居住地址" SortExpression="WorkerAddress" />
<asp:BoundField DataField="WorkerMoreInfo" HeaderText="备注信息" SortExpression="WorkerMoreInfo" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
</asp:GridView>
<br />
共有
<asp:Label ID="label1" runat="server"></asp:Label>
条记录 总页数
<asp:Label ID="lblPageCount" runat="server" ForeColor="Red" Width="30"></asp:Label>当前页<asp:Label
ID="lblCurrentIndex" runat="server" ForeColor="red" Width="30"></asp:Label>
<asp:LinkButton ID="btnPrev" runat="server" CommandArgument="前一项" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="上一页"></asp:LinkButton>
<asp:LinkButton ID="btnNext" runat="server" CommandArgument="Next" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="下一页"></asp:LinkButton>
<asp:LinkButton ID="btnFirst" runat="server" CommandArgument="0" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="转到第一页"></asp:LinkButton>
<asp:LinkButton ID="btnLast" runat="server" CommandArgument="最后一项" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="转到最后一页"></asp:LinkButton>
<asp:LinkButton ID="btnPage8" runat="server" CommandArgument="X" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="转到第"></asp:LinkButton><asp:TextBox
ID="No" runat="server" Width="20"></asp:TextBox><font style="font-size: 8pt; color: navy">页</font>
<br>
<strong>添加新员工</strong>
<br>
<br>
<table width="414" height="217" border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="width: 108px"> 员工编号：</td>
<td> <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px"> 员工名称：</td>
<td> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px"> 工作类型</td>
<td> <asp:DropDownList ID="DropDownList2" runat="server" Width="141px" DataSourceID="SqlDataSource4"
DataTextField="WorkKinds" DataValueField="WorkKindListId">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="select WorkKindList.WorkKindListId,WorkKindList.WorkKinds from WorkKindList ">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 108px; height: 7px;"> 员工密码：</td>
<td style="height: 7px"> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px"> 员工工资：</td>
<td> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px"> 员工电话：</td>
<td> <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px"> 员工居住地址：</td>
<td> <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px; height: 38px;"> 备注</td>
<td style="height: 38px"> <asp:TextBox ID="TextBox6" runat="server" Height="81px" TextMode="MultiLine" Width="295px"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 108px; height: 20px;"> </td>
<td style="height: 20px"> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -