OA系统

开发平台：
ASP/ASPX

report_list_receive.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="report_list_receive.aspx.cs" Inherits="web_report_report_list_receive" %>
<!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:Label ID="Label7" runat="server" Text="已收工作報告列表" Font-Bold="True" Font-Size="Medium"></asp:Label></center><br />
    <table width="95%">
        <tr>
            <td align="center" style="width: 726px">
                <asp:GridView ID="ReportList" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1" GridLines="Vertical" Width="650px" OnRowCommand="ReportList_RowCommand" OnRowCreated="ReportList_RowCreated" OnRowDataBound="ReportList_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>
                <br />
            </td>
        </tr>
        <tr>
            <td align="center" style="width: 726px">
                <asp:Panel ID="PnlReport" runat="server" Visible="False">
                    <table border="1" style="width: 550px; position: relative">
                        <tr>
                            <td align="center" style="width: 151px; height: 18px">
                                <asp:Label ID="Label2" runat="server" Text="接收時間"></asp:Label>
                            </td>
                            <td align="left" style="height: 18px">
                                <asp:Label ID="LblSendDate" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="width: 151px; height: 18px">
                                <asp:Label ID="Label4" runat="server" Text="發送人"></asp:Label>
                            </td>
                            <td align="left" style="height: 18px">
                                <asp:Label ID="LblReceiver" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="width: 151px">
                                <asp:Label ID="Label1" runat="server" Text="標題"></asp:Label>
                            </td>
                            <td align="left">
                                <asp:Label ID="LblTitle" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="width: 151px; height: 18px">
                                <asp:Label ID="Label3" runat="server" Text="內容"></asp:Label>
                            </td>
                            <td align="left" style="height: 18px">
                                <asp:Label ID="LblContent" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="width: 151px; height: 18px">
                                <asp:Label ID="Label6" runat="server" Text="建議"></asp:Label>
                            </td>
                            <td align="left" style="height: 18px">
                                <asp:Label ID="LblProposal" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="width: 151px; height: 18px">
                                <asp:Label ID="Label8" runat="server" Text="總結"></asp:Label>
                            </td>
                            <td align="left" style="height: 18px">
                                <asp:Label ID="LblSummarize" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center">
                                <asp:Label ID="Label5" runat="server" Text="附件"></asp:Label>
                            </td>
                            <td align="left">
                                <asp:LinkButton ID="BtnAttachment" runat="server" Style="left: 0px; position: relative" OnClick="BtnAttachment_Click"></asp:LinkButton>
                                <asp:Label ID="LblNoAttachment" runat="server" Style="position: relative" Text="無"
                                    Visible="False"></asp:Label></td>
                        </tr>
                    </table>
                    <input id="ContentLength" runat="server" style="position: relative" type="hidden" />
                    </asp:Panel>
                <asp:Panel ID="PnlSign" runat="server" Style="left: 0px; position: relative; top: 0px"
                    Width="550px" Visible="False">
                    <table border="1" style="width: 550px; position: relative">
                        <tr>
                            <td align="center" style="width: 151px">
                                <asp:Label ID="Label9" runat="server" Text="簽批"></asp:Label>
                            </td>
                            <td align="left" style="width: 387px">
                                <asp:TextBox ID="TxtSign" Rows="5" TextMode="MultiLine" runat="server" Width="330px"></asp:TextBox>
                                <br />
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TxtSign"
                                    ErrorMessage="簽批內容不能為空" Style="position: relative"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td align="center" colspan="2" style="height: 26px">
                                <asp:Button ID="BtnOk" runat="server" Text="發送" OnClick="BtnOk_Click" />
                            </td>
                        </tr>
                    </table>
                </asp:Panel>
                <asp:Panel ID="Panel1" runat="server" Style="position: relative" Visible="false">
                    <table border="1" style="width: 550px; position: relative">
                        <tr>
                            <td align="center" style="width: 151px">
                                <asp:Label ID="Label10" runat="server" Text="簽批"></asp:Label>
                            </td>
                            <td align="left" style="width: 387px">
                                <asp:Label ID="LblSign" runat="server"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="width: 151px">
                                <asp:Label ID="Label11" runat="server" Text="簽批時間"></asp:Label>
                            </td>
                            <td align="left" style="width: 387px">
                                <asp:Label ID="LblSignDate" runat="server"></asp:Label>
                            </td>
                        </tr>
                    </table>
                </asp:Panel>
            </td>
        </tr>
    </table>
    </div>
        <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>
    </form>
</body>
</html>

						