OA系统

开发平台：
ASP/ASPX

report_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="report_list.aspx.cs" Inherits="web_report_report_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>
        <asp:Panel ID="PnlReceive" runat="server">
            <center>
                <asp:Label ID="LblReceiveTitle" runat="server" Text="已收工作報告列表" Font-Bold="True" Font-Size="Medium"></asp:Label>
            </center>
            <center>
                <br />
            <asp:GridView ID="ReportReceiveList" runat="server" AllowPaging="True" AllowSorting="True"
                AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
                BorderWidth="1px" CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1"
                GridLines="Vertical" Style="position: relative" Width="650px" OnRowCommand="ReportReceiveList_RowCommand" OnRowCreated="ReportReceiveList_RowCreated" OnRowDataBound="ReportReceiveList_RowDataBound">
                <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                <Columns>
                    <asp:BoundField DataField="title" HeaderText="標題" SortExpression="title" />
                    <asp:BoundField DataField="emp_name" HeaderText="發送人" SortExpression="emp_name" />
                    <asp:BoundField DataField="send_date" HeaderText="接收時間" SortExpression="send_date" />
                    <asp:TemplateField HeaderText="狀態">
                        <ItemTemplate>
                            <asp:Label ID="LblState" runat="server" Style="position: relative"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="read_date" HeaderText="閱讀時間" SortExpression="read_date" />
                    <asp:TemplateField HeaderText="簽批">
                        <ItemTemplate>
                            <asp:Label ID="LblSign" runat="server" Style="position: relative"></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:LinkButton ID="BtnDelete" runat="server" CommandName="DeleteData" Style="position: relative">刪除</asp:LinkButton>
                        </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="Gainsboro" />
            </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
                    SelectCommand="SELECT r.id, r.read_date, s.send_date, e.emp_name, c.title FROM dbo.OA_REPORT_RECEIVER AS r INNER JOIN dbo.OA_REPORT_SENDER AS s ON r.report_id = s.report_id INNER JOIN dbo.OA_EMPLOYEE AS e ON s.sender = e.id INNER JOIN dbo.OA_REPORT_CONTENT AS c ON r.report_id = c.id WHERE (r.is_del = 0)">
                </asp:SqlDataSource>
            </center>
        </asp:Panel><br />
        <asp:Panel ID="PnlSend" runat="server">
        </asp:Panel>
    </center>
    </div>
    </form>
</body>
</html>

						