OA系统

开发平台：
ASP/ASPX

blank.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="blank.aspx.cs" Inherits="web_personnel_curricula_vitae_blank" %>
<!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>
        <div>
            &nbsp;<center>
                <asp:Label ID="LblTitle1" runat="server" Font-Bold="True" Font-Size="Medium" Style="position: relative;
                    top: 0px"></asp:Label>&nbsp;</center>
            <center>
                <br />
                <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"
                    Style="position: relative" Width="500px">
                    <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:BoundField DataField="active_date" HeaderText="入職日期" SortExpression="active_date" />
                        <asp:TemplateField HeaderText="人在哪里">
                            <ItemTemplate>
                                <asp:LinkButton ID="LbWhere" runat="server" Style="position: relative"></asp:LinkButton>
                            </ItemTemplate>
                        </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" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
                    SelectCommand="SELECT e.id, e.emp_no, e.emp_name, e.active_date, 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.department_id = @department_id) and e.dimission_date='' ORDER BY e.emp_no">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="0" Name="department_id" SessionField="p_department_id" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </center>
           
            <center><br />
                <asp:Label ID="LblTitle2" runat="server" Font-Bold="True" Font-Size="Medium" Style="position: relative;
                    top: 0px" Visible="False"></asp:Label>&nbsp;</center>
            <center>
                &nbsp;</center>
            <center>
                <asp:GridView ID="EmployeeDimissionList" runat="server" AllowPaging="True" AllowSorting="True"
                    AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
                    BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource2" GridLines="Vertical" OnRowDataBound="EmployeeDimissionList_RowDataBound"
                    Style="position: relative" Width="500px" Visible="False">
                <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:BoundField DataField="active_date" HeaderText="入職日期" SortExpression="active_date" />
                    <asp:BoundField DataField="dimission_date" HeaderText="離職日期" />
                </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="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
                    SelectCommand="SELECT e.id, e.emp_no, e.emp_name, e.active_date, e.dimission_date, 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.department_id = @department_id) and e.dimission_date<>'' ORDER BY e.emp_no">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="0" Name="department_id" SessionField="p_department_id" />
                    </SelectParameters>
                </asp:SqlDataSource>
                &nbsp;</center>
        </div>
    
    </div>
    </form>
</body>
</html>

						