OA系统

开发平台：
ASP/ASPX

employee_list_all1.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="employee_list_all1.aspx.cs" Inherits="web_approvel_employee_list_all" %>
<!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="../../css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <center>
        &nbsp;</center>
        <center>
            &nbsp;<asp:GridView ID="EmployeeList" runat="server" AllowPaging="True" AllowSorting="True"
                AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
                BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1" GridLines="Vertical"
                OnRowCreated="EmployeeList_RowCreated" OnRowDataBound="EmployeeList_RowDataBound"
                PageSize="20" Style="position: relative; left: 0px; top: 0px;"  Width="602px" Height="561px">
                <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
             
                <Columns>
                    <asp:TemplateField HeaderText="部門" 　SortExpression="name">
                        <ItemTemplate >
                            <asp:Label ID="LblDepartment" runat="server" Style="position: relative"></asp:Label>
                        </ItemTemplate>
                        <ItemStyle HorizontalAlign="Center" WIDTH="100px"/>
                        <HeaderStyle BorderStyle="Dotted" />
                        <ControlStyle Width="100px" />
                    </asp:TemplateField>
                    <asp:BoundField DataField="emp_no" HeaderText="工號" SortExpression="emp_no" >
                        <ItemStyle HorizontalAlign="Left" WIDTH="50px"/>
                        <ControlStyle BorderStyle="Dotted"  />
                        <HeaderStyle BorderStyle="Dotted" />                        
                    </asp:BoundField>
                    <asp:BoundField DataField="emp_name" HeaderText="姓名" SortExpression="emp_name" >
                        <ControlStyle BorderStyle="Dotted" />
                        <HeaderStyle BorderStyle="Dotted" /> 
                        <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>                      
                    </asp:BoundField>
                    <asp:BoundField DataField="position" HeaderText="職位" SortExpression="position1" >
                        <ControlStyle BorderStyle="Dotted" />
                        <HeaderStyle BorderStyle="Dotted" /> 
                        <ItemStyle HorizontalAlign="Center" WIDTH="80px"/>                         
                    </asp:BoundField>
                    <asp:BoundField DataField="tel_extension" HeaderText="分機" SortExpression="tel_extension" >
                        <ControlStyle BorderStyle="Dotted"/>
                        <HeaderStyle BorderStyle="Dotted" /> 
                        <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>                         
                    </asp:BoundField>
                    
                    <asp:TemplateField HeaderText="狀態">
                        <ItemTemplate>
                            <asp:LinkButton ID="LbWhere" runat="server" ></asp:LinkButton>
                        </ItemTemplate>
                        <HeaderStyle BorderStyle="Dotted" />  
                        <ItemStyle HorizontalAlign="Center" WIDTH="50px"/>                       
                    </asp:TemplateField>
                    
                </Columns>
                <PagerStyle BackColor="#999999" Font-Overline="False" Font-Strikeout="False" ForeColor="Black"
                    HorizontalAlign="Center" Wrap="True" />
                <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle BackColor="Gainsboro" />
                <PagerSettings FirstPageText="第一頁" LastPageText="最后一頁" Mode="NextPrevious" NextPageText="下一頁"
                    PreviousPageText="上一頁" />
            </asp:GridView>
        <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 p ON e.position = p.id  left join oa_department as d on e.department_id=d.id WHERE e.dimission_date='' and&#13;&#10; p.sequence>=(select sequence from oa_employee_position as a inner join oa_employee as b on a.id=b.position where b.id=@user_id)&#13;&#10; ORDER BY p.sequence asc" ConnectionString="<%$ ConnectionStrings:oaConnection %>">
            <SelectParameters>
                <asp:SessionParameter Name="user_id" SessionField="user_id" />
            </SelectParameters>
        </asp:SqlDataSource>
        </center>
    </div>
    </form>
</body>
</html>

						