employee_list_search.aspx
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:5k
源码类别:

OA系统

开发平台:

ASP/ASPX

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="employee_list_search.aspx.cs" Inherits="web_approvel_employee_list_search" %>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml" >
  4. <head runat="server">
  5.     <title>无标题页</title>
  6.     <link href="../../css/style.css" rel="stylesheet" type="text/css" />
  7. </head>
  8. <body>
  9.     <form id="form1" runat="server" defaultbutton="BtnOk">
  10.     <div>
  11.     <center>
  12.         <asp:RadioButtonList ID="RbType" runat="server" RepeatDirection="Horizontal" style="left: -120px; position: relative; top: 17px">
  13.             <asp:ListItem Text="工號" Value="emp_no" Selected="True"></asp:ListItem>
  14.             <asp:ListItem Text="姓名" Value="emp_name"></asp:ListItem>            
  15.         </asp:RadioButtonList>
  16.         <asp:TextBox ID="TxtValue" runat="server" style="left: 118px; position: relative; top: -11px"></asp:TextBox>&nbsp;
  17.         <asp:Button ID="BtnOk" runat="server" Text="查詢" OnClick="BtnOk_Click" style="left: 119px; position: relative; top: -9px" />
  18.         <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="TxtValue" runat="server" 
  19.             ErrorMessage="請輸入查詢內容" style="left: 127px; position: relative; top: -12px"></asp:RequiredFieldValidator><br />
  20.         <br />
  21.         <asp:GridView style="POSITION: relative" id="EmployeeList" runat="server" OnRowDataBound="EmployeeList_RowDataBound" 
  22.             OnRowCreated="EmployeeList_RowCreated" Width="600px" GridLines="Vertical" DataSourceID="SqlDataSource1" CellPadding="3" BorderWidth="1px" BorderStyle="None" BorderColor="#999999" BackColor="White" AutoGenerateColumns="False" PageSize="20" AllowPaging="True" AllowSorting="True">
  23.             <FooterStyle BackColor="#CCCCCC" ForeColor="Black"  />
  24.             <RowStyle BackColor="#EEEEEE" ForeColor="Black"  />
  25.             <Columns>
  26.                 <asp:TemplateField HeaderText="部門">
  27.                     <ItemTemplate>
  28.                         <asp:Label ID="LblDepartment" runat="server" Style="position: relative"></asp:Label>
  29.                     </ItemTemplate>
  30.                      <ItemStyle HorizontalAlign="Center" WIDTH="100px"/>   
  31.                 </asp:TemplateField>
  32.                 <asp:BoundField DataField="emp_no" HeaderText="工號" SortExpression="emp_no" >
  33.                  <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>   
  34.                 </asp:BoundField>
  35.                 <asp:BoundField DataField="emp_name" HeaderText="姓名" SortExpression="emp_name" >
  36.                  <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>   
  37.                 </asp:BoundField>
  38.                 <asp:BoundField DataField="position" HeaderText="職位" SortExpression="position" >
  39.                  <ItemStyle HorizontalAlign="Center" WIDTH="80px"/>   
  40.                 </asp:BoundField>
  41.                 <asp:BoundField DataField="tel_extension" HeaderText="分機" SortExpression="tel_extension" >
  42.                  <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>   
  43.                 </asp:BoundField>
  44.                 <asp:TemplateField HeaderText="狀態">
  45.                     <ItemTemplate>
  46.                         <asp:LinkButton ID="LbWhere" runat="server" Style="position: relative"></asp:LinkButton>
  47.                     </ItemTemplate>
  48.                      <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>   
  49.                 </asp:TemplateField>
  50.             </Columns>
  51.             <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" Font-Overline="False" Font-Strikeout="False" Wrap="True"  />
  52.             <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White"  />
  53.             <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White"  />
  54.             <AlternatingRowStyle BackColor="Gainsboro"  />
  55.             <PagerSettings FirstPageText="第一頁" LastPageText="最后一頁" Mode="NextPrevious" NextPageText="下一頁"
  56.                 PreviousPageText="上一頁" />
  57.         </asp:GridView>
  58.         <asp:SqlDataSource id="SqlDataSource1" runat="server" SelectCommand="SELECT d.name,e.id, e.emp_no, e.emp_name, p.name AS position,p.sequence ,&#13;&#10; e.tel, e.smart_phone, e.tel_extension FROM dbo.OA_EMPLOYEE AS e INNER JOIN dbo.OA_EMPLOYEE_POSITION AS &#13;&#10;p ON e.position = p.id  left join oa_department as d on e.department_id=d.id WHERE e.dimission_date=''&#13;&#10; ORDER BY p.sequence asc" ConnectionString="<%$ ConnectionStrings:oaConnection %>">
  59.         </asp:SqlDataSource>
  60.     </center>
  61.     </div>
  62.     </form>
  63. </body>
  64. </html>