OA系统

开发平台：
ASP/ASPX

mail_list_send.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="mail_list_send.aspx.cs" Inherits="web_mail_mail_list_send" %>
<!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" />
    <script language="javascript" type="text/javascript">
        function openStatistics(id)
        {        
            var url = "mail_statistic.aspx?mail_id="+id;
            var features = "width=500,height=400,top=200,left=250,location=no,toolbar=no,status=no,resizable=yes,scrollbars=yes";
            var showStatistic = open(url, 'showStatistic', features);
            showStatistic.focus();
            return false;
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <center>
        <br />
        <asp:Label ID="Label6" runat="server" Text="內部電子郵件寄件備份列表" Font-Bold="True" Font-Size="Medium"></asp:Label></center><br />
    <div>
    <center>
    <table width="95%">
        <tr valign="top">
            <td align="center">
                <asp:GridView ID="MailList" runat="server" AllowPaging="True" AllowSorting="True"
                    AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None"
                    BorderWidth="1px" CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1"
                    ForeColor="Black" OnRowCommand="MailList_RowCommand" OnRowCreated="MailList_RowCreated"
                    OnRowDataBound="MailList_RowDataBound" Style="position: relative" Width="700px">
                    <FooterStyle BackColor="White" ForeColor="#000066" />
                    <RowStyle ForeColor="Black" />
                    <Columns>
                        <asp:TemplateField HeaderText="收件人">
                            <ItemTemplate>
                                <asp:Label ID="LblReceivers" runat="server" Style="position: relative"></asp:Label>&nbsp;
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="主旨">
                            <ItemTemplate>
                                <asp:Label ID="LblSubject" runat="server" Style="position: relative" Text='<%# Eval("title") %>'></asp:Label>
                                <asp:Label ID="LblState" runat="server" Style="position: relative"></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="send_date" HeaderText="收到日期" SortExpression="send_date" />
                        <asp:TemplateField HeaderText="閱讀統計">
                            <ItemTemplate>
                                <asp:Label ID="LblStatistics" runat="server" Style="position: relative"></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField>
                            <ItemTemplate>
                                <asp:LinkButton ID="BtnDelete" runat="server" CommandName="DeleteData" OnClientClick="return confirm('確定要刪除嗎？')">刪除</asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <PagerStyle BackColor="White" BorderStyle="None" ForeColor="Black" HorizontalAlign="Left" />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="ScrollBar" Font-Bold="True" ForeColor="Black" />
                </asp:GridView>
            </td>
        </tr>
        <tr>
            <td><br />
                <asp:Panel ID="PnlMail" runat="server" Style="position: relative" BorderStyle="Groove" Width="680px" Visible="False">
                <table style="width:678px; position: relative" bgcolor="#dcd5cf">
                    <tr>
                        <td style="width: 68px" valign="top">
                            寄件人</td>
                        <td style="width: 400px" align="left" valign="top">
                            <asp:Label ID="LblSender" runat="server" Style="position: relative"></asp:Label></td>
                        <td align="left">
                            寄件日期:<asp:Label ID="LblSendDate" runat="server" BorderStyle="None" style="position: relative"></asp:Label></td>
                    </tr>
                    <tr>
                        <td style="width: 68px" valign="top">
                            收件人</td>
                        <td colspan="2" align="left" valign="top">
                            <asp:Label ID="LblReceivers" runat="server" Style="position: relative"></asp:Label></td>
                    </tr>
                    <tr>
                        <td style="width: 68px" valign="top">
                            主旨</td>
                        <td colspan="2" align="left" valign="top">
                                <asp:Label ID="LblTitle" runat="server" BorderStyle="None" style="position: relative"></asp:Label></td>
                    </tr>
                    <tr>
                        <td style="width: 68px" valign="top">
                            附件</td>
                        <td colspan="2" align="left" valign="top">
                            <asp:LinkButton ID="BtnAttachment" runat="server" Style="left: 0px;
                                position: relative" OnClick="BtnAttachment_Click" BorderStyle="None"></asp:LinkButton>
                            <asp:Label ID="LblNoAttachment" runat="server" Style="position: relative" Text="無"
                                Visible="False" BorderStyle="None"></asp:Label>
                            <asp:HiddenField ID="ContentLength" runat="server" />
                            <asp:HiddenField ID="AttachmentEnName" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td style="width: 68px" valign="top">
                            閱讀統計</td>
                        <td colspan="2" align="left" valign="top">
                            <asp:LinkButton ID="BtnStatistics" runat="server" Style="left: 0px; position: relative"></asp:LinkButton></td>
                    </tr>
                    <tr>
                        <td colspan="3">
                            <asp:TextBox ID="TxtContent" TextMode="MultiLine" Rows="20" Width="678" ReadOnly="True" runat="server"></asp:TextBox>
                        </td>
                    </tr>
                </table><br />
                </asp:Panel>
            </td>
        </tr>
    </table></center>
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
        SelectCommand="SELECT s.id, m.title, s.send_date FROM dbo.OA_MAIL_SENDER AS s INNER JOIN dbo.OA_MAIL_CONTENT AS m ON s.mail_id = m.id WHERE (s.state = 1) AND (s.is_del = 0) AND (s.sender = @sender) order by s.send_date desc">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="0" Name="sender" SessionField="user_id" />
        </SelectParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>

						