OA系统

开发平台：
ASP/ASPX

authority_employee_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="authority_employee_list.aspx.cs" Inherits="web_system_authority_employee_list" %>
<!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>
        <asp:GridView ID="EmployeeList" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1" GridLines="Vertical" OnRowCreated="EmployeeList_RowCreated" PageSize="20" Width="600px" OnRowDataBound="EmployeeList_RowDataBound">
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
            <Columns>
                <asp:BoundField DataField="emp_no" HeaderText="員工工號" SortExpression="emp_no" />
                <asp:BoundField DataField="emp_name" HeaderText="員工姓名" SortExpression="emp_name" />
                <asp:BoundField DataField="position" HeaderText="職位" SortExpression="position" />
                <asp:TemplateField HeaderText="所屬部門">
                    <ItemTemplate>
                        <asp:Label ID="LblDepartment" runat="server" Style="position: relative"></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="#DCDCDC" />
        </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
                SelectCommand="SELECT e.id, e.emp_no, e.emp_name, p.name AS position FROM dbo.OA_EMPLOYEE AS e INNER JOIN dbo.OA_EMPLOYEE_POSITION AS p ON e.position = p.id WHERE (e.user_group = @group_id)">
                <SelectParameters>
                    <asp:QueryStringParameter DefaultValue="0" Name="group_id" QueryStringField="g_id" />
                </SelectParameters>
            </asp:SqlDataSource>
            <br />
        <input type="button" onclick="javascript:history.go(-1);" value="返回" />
        </center>
    </div>
    </form>
</body>
</html>

						