OA系统

开发平台：
ASP/ASPX

mail_list_delete.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="mail_list_delete.aspx.cs" Inherits="web_mail_mail_list_delete" %>
<!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>
    <table>
        <tr>
            <td>
            <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="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="BtnRestore" runat="server" CommandName="Restore" 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" BorderStyle="Groove" Style="position: relative"
                Visible="False" Width="680px">
                <table bgcolor="#dcd5cf" style="width: 678px; position: relative">
                    <tr>
                        <td style="width: 60px" valign="top">
                            寄件人</td>
                        <td align="left" style="width: 444px" 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 align="left" colspan="2" valign="top">
                            <asp:Label ID="LblReceivers" runat="server" Style="position: relative"></asp:Label></td>
                    </tr>
                    <tr>
                        <td style="width: 60px" valign="top">
                            主旨</td>
                        <td align="left" colspan="2" 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 align="left" colspan="2" valign="top">
                            <asp:LinkButton ID="BtnAttachment" runat="server" BorderStyle="None" OnClick="BtnAttachment_Click"
                                Style="left: 0px; position: relative"></asp:LinkButton>
                            <asp:Label ID="LblNoAttachment" runat="server" BorderStyle="None" Style="position: relative"
                                Text="無" Visible="False"></asp:Label>
                            <asp:HiddenField ID="ContentLength" runat="server" />
                            <asp:HiddenField ID="AttachmentEnName" runat="server" />
                        </td>
                    </tr>
                    <tr>
                        <td colspan="3">
                            <asp:TextBox ID="TxtContent" runat="server" ReadOnly="true" Rows="20" TextMode="MultiLine"
                                Width="678"></asp:TextBox>
                        </td>
                    </tr>
                </table>
                <br />
                <asp:HiddenField ID="SenderId" runat="server" Value="0" />
                <asp:HiddenField ID="ReceiverIds" runat="server" Value="0" />
            </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 = 1) 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>

						