OA系统

开发平台：
ASP/ASPX

mail_list_receive.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="mail_list_receive.aspx.cs" Inherits="web_mail_mail_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" />
    <script type="text/javascript" language="javascript">
        function selectEmployee()
        {
            var url = "../personnel/curricula_vitae/employee_select_index.aspx";
            var features = "width=1010,height=710,top=0,left=0,location=no,toolbar=no,status=no,resizable=yes,scrollbars=yes";
            var employee = open(url, 'selectDepartment', features);
            employee.focus();
        }
    </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>
    <div>
    <center>
    <table width="700">
        <tr valign="top">
            <td align="center">
                <br />
                <asp:GridView ID="MailList" runat="server" AutoGenerateColumns="False" BackColor="White"
                    BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="id"
                    DataSourceID="SqlDataSource1" ForeColor="Black" Style="position: relative" AllowPaging="True" AllowSorting="True" Width="700px" OnRowCreated="MailList_RowCreated" OnRowDataBound="MailList_RowDataBound" OnRowCommand="MailList_RowCommand">
                    <FooterStyle BackColor="White" ForeColor="#000066" />
                    <RowStyle ForeColor="Black" />
                    <Columns>
                        <asp:TemplateField HeaderText="寄件人">
                            <ItemTemplate>
                                <asp:Label ID="LblSenderNo" runat="server" Style="position: relative" Text='<%# Eval("emp_no") %>'></asp:Label>
                                <asp:Label ID="LblSenderName" runat="server" Style="position: relative" Text='<%# Eval("emp_name") %>'></asp:Label><asp:Label
                                    ID="LblPosition" runat="server" Style="position: relative" Text='<%# Eval("postion") %>'></asp:Label>
                            </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>
                            <ItemTemplate>
                                <asp:LinkButton ID="BtnDelete" CommandName="DeleteData" runat="server" OnClientClick="return confirm('確定要刪除嗎？')">刪除</asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" BorderStyle="None" />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="ScrollBar" Font-Bold="True" ForeColor="Black" />
                </asp:GridView><br />
            </td>
        </tr>
        <tr>
            <td align="center">
                <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 align="left" colspan="3">
                            <asp:Button ID="BtnReply" runat="server" Text="回覆" OnClick="BtnReply_Click" />
                            <asp:Button ID="BtnReplyAll" runat="server" Text="全部回覆" OnClick="BtnReplyAll_Click" />
                            <asp:Button ID="BtnFw" runat="server" Text="轉寄" OnClick="BtnFw_Click" />
                            <asp:ImageButton ID="ImageButton1" runat="server" Height="18px" ImageUrl="~/images/delete.gif"
                                Style="position: relative" Width="17px" OnClick="ImageButton1_Click" OnClientClick='return confirm("確定要刪除嗎？")' /></td>
                    </tr>
                    <tr>
                        <td style="width: 60px" valign="top">
                            寄件人</td>
                        <td style="width: 444px" 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: 60px" 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: 60px" 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: 60px" 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 colspan="3">
                            <asp:TextBox ID="TxtContent" TextMode="MultiLine" Rows="20" Width="678" ReadOnly="true" runat="server"></asp:TextBox>
                        </td>
                    </tr>
                </table><br />
                    <asp:HiddenField ID="SenderId" runat="server" Value="0" />
                    <asp:HiddenField ID="ReceiverIds" runat="server" Value="0" />
                </asp:Panel>
                <asp:Panel ID="PnlReply" runat="server" Style="position: relative" BorderStyle="Groove" Visible="false" Width="680px">
                <table style="width:678px; position: relative" bgcolor="#dcd5cf">
                    <tr>
                        <td align="left" colspan="2">
                            <asp:Button ID="BtnReplyOk" runat="server" Text="傳送" OnClick="BtnReplyOk_Click" />
                            <input type="button" value="取消" onclick="history.go(-1)" />
                            <hr />
                        </td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            收件人</td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtReplyReceiver" runat="server" ReadOnly="True" Style="position: relative"
                                Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            主旨</td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtReplyTitle" runat="server" Style="position: relative" Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            附件</td>
                        <td align="left" valign="top">
                            <asp:FileUpload ID="FileUpload1" runat="server" Style="position: relative" Width="600px" />
                            <asp:HiddenField ID="ContentLength1" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" valign="middle">
                            <asp:TextBox ID="TxtReplyContent" runat="server" Rows="20" TextMode="MultiLine" Width="678"></asp:TextBox>
                        </td>
                    </tr>
                </table><br />
                </asp:Panel>
                <asp:Panel ID="PnlReplyAll" runat="server" Style="position: relative" BorderStyle="Groove" Visible="false" Width="680px"><table style="width:678px; position: relative" bgcolor="#dcd5cf">
                    <tr>
                        <td align="left" colspan="2">
                            <asp:Button ID="BtnReplyAllOk" runat="server" Text="傳送" OnClick="BtnReplyAllOk_Click" />
                            <input type="button" value="取消" onclick="history.go(-1)" />
                            <hr />
                        </td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            收件人</td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtReplyAllReceiver" TextMode="MultiLine" runat="server" ReadOnly="True" Style="position: relative"
                                Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            主旨</td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtReplyAllTitle" runat="server" Style="position: relative" Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            附件</td>
                        <td align="left" valign="top">
                            <asp:FileUpload ID="FileUpload2" runat="server" Style="position: relative" Width="600px" />
                            <asp:HiddenField ID="ContentLength2" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" valign="middle">
                            <asp:TextBox ID="TxtReplyAllContent" runat="server" Rows="20" TextMode="MultiLine" Width="678"></asp:TextBox>
                        </td>
                    </tr>
                </table>
                <br />
                </asp:Panel>
                <asp:Panel ID="PnlFw" runat="server" Style="position: relative" BorderStyle="Groove" Width="680px" Visible="false"><table style="width:678px; position: relative" bgcolor="#dcd5cf">
                    <tr>
                        <td align="left" colspan="2">
                            <asp:Button ID="BtnFwOk" runat="server" Text="傳送" OnClick="BtnFwOk_Click" />
                            <asp:Button ID="BtnReceiver2" runat="server" Text="收件人" OnClientClick="selectEmployee()" />
                            <input type="button" value="取消" onclick="history.go(-1)" />
                            <hr />
                        </td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            <asp:LinkButton ID="BtnReceiver" runat="server" OnClientClick="selectEmployee()">收件人</asp:LinkButton>
                            </td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtEmployees" runat="server" ReadOnly="True" Style="position: relative"
                                TextMode="MultiLine" Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            主旨</td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtFwTitle" runat="server" Style="position: relative" Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td valign="middle" style="width: 122px">
                            附件</td>
                        <td align="left" valign="top">
                            <asp:TextBox ID="TxtFile" runat="server" ReadOnly="True" Style="position: relative"
                                Width="600px"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td colspan="2" valign="middle">
                            <asp:TextBox ID="TxtFwContent" runat="server" Rows="20" TextMode="MultiLine" Width="678"></asp:TextBox>
                        </td>
                    </tr>
                </table>
                    <asp:HiddenField ID="Employee_ids" runat="server" />
                <br />
                </asp:Panel>
            </td>
        </tr>
    </table></center>
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
        SelectCommand="SELECT r.id, m.title, r.is_read, s.send_date, e.emp_no, e.emp_name, p.name postion FROM dbo.OA_MAIL_RECEIVER AS r INNER JOIN dbo.OA_MAIL_SENDER AS s ON r.mail_id = s.mail_id INNER JOIN dbo.OA_EMPLOYEE AS e ON s.sender = e.id INNER JOIN dbo.OA_MAIL_CONTENT AS m ON r.mail_id = m.id inner join OA_EMPLOYEE_POSITION p on e.position=p.id WHERE (r.is_del = 0) and r.receiver=@receiver order by s.send_date desc">
        <SelectParameters>
            <asp:SessionParameter DefaultValue="0" Name="receiver" SessionField="user_id" />
        </SelectParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>

						