OA系统

开发平台：
ASP/ASPX

mail_list_send.aspx.cs：源码内容
							﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
public partial class web_mail_mail_list_send : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        LoginDAO.CheckLogin(Session, Response, "../", 2);
        //設置主鍵
        MailList.DataKeyNames = new string[] { "id" };
        if (!IsPostBack)
        {
            if (Request.QueryString["s_id"] != null)
            {
                PnlMail.Visible = true;
                this.setMail(Request.QueryString["s_id"]);
            }
        }
    }
    protected void setMail(string s_id)
    {
        try
        {
            SqlConnection conn = dbConnection.getConnection();
            conn.Open();
            SqlCommand cmd = new SqlCommand("SELECT s.mail_id, m.title, m.content, s.send_date, "+
                "e.emp_no, e.emp_name, p.name position FROM dbo.OA_MAIL_SENDER AS s INNER JOIN "+
                "dbo.OA_EMPLOYEE AS e ON s.sender = e.id INNER JOIN dbo.OA_MAIL_CONTENT AS m ON "+
                "s.mail_id = m.id inner join OA_EMPLOYEE_POSITION p on e.position=p.id WHERE s.id=" + 
                s_id, conn);
            SqlDataReader dr = cmd.ExecuteReader();
            string mail_id = "0";
            if (dr.Read())
            {
                mail_id = dr["mail_id"].ToString();
                LblTitle.Text = dr["title"].ToString();
                TxtContent.Text = dr["content"].ToString().Replace("<br>", "n").Replace("&nbsp;", " ");
                LblSendDate.Text = dr["send_date"].ToString();
                LblSender.Text = dr["emp_no"].ToString() + " " + dr["emp_name"].ToString() + dr["position"].ToString();
            }
            dr.Close();
            BtnStatistics.OnClientClick = "return openStatistics('"+mail_id+"')";
            cmd = new SqlCommand("select  e.emp_no, e.emp_name, p.name from OA_MAIL_RECEIVER r inner join " +
                "OA_EMPLOYEE e on r.receiver=e.id inner join OA_EMPLOYEE_POSITION p on e.position=p.id " +
                "where mail_id=" + mail_id, conn);
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                LblReceivers.Text = LblReceivers.Text + dr["emp_no"].ToString() + " " +
                    dr["emp_name"].ToString() + dr["name"].ToString() + "; ";
            }
            dr.Close();
            if (!LblReceivers.Text.Equals(""))
            {
                LblReceivers.Text = LblReceivers.Text.Substring(0, LblReceivers.Text.Length - 2);
            }
            cmd = new SqlCommand("select cn_name, en_name, content_length from OA_MAIL_ATTACHMENT where mail_id=" + mail_id, conn);
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                BtnAttachment.Text = dr["cn_name"].ToString();
                AttachmentEnName.Value = dr["en_name"].ToString();
                ContentLength.Value = dr["content_length"].ToString();
            }
            else
            {
                //沒有附件
                LblNoAttachment.Visible = true;
                BtnAttachment.Visible = false;
            }
            dr.Close();
            cmd = new SqlCommand("select count(id) from OA_MAIL_RECEIVER where mail_id=" + mail_id +
                " and is_read=1", conn);
            BtnStatistics.Text = Convert.ToInt32(cmd.ExecuteScalar()) + "人已讀;";
            cmd = new SqlCommand("select count(id) from OA_MAIL_RECEIVER where mail_id=" + mail_id +
                " and is_read=0", conn);
            BtnStatistics.Text = BtnStatistics.Text + Convert.ToInt32(cmd.ExecuteScalar()) + "人未讀";
            conn.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
    }
    protected void DownLoadFile(string name)
    {
        string server_ip = "";
        string root = "";
        string folder = "";
        if (Application["FILE_SERVER_IP"] != null)
        {
            server_ip = Application["FILE_SERVER_IP"].ToString();
        }
        if (Application["FILE_SERVER_ROOT"] != null)
        {
            root = Application["FILE_SERVER_ROOT"].ToString();
        }
        if (Application["MAIL_FOLDER"] != null)
        {
            folder = Application["MAIL_FOLDER"].ToString();
        }
        //string directory = "\\" + server_ip + "\" + root + "\" + folder + "\";
        string directory = "\web\oa_upload\mail\";
        try
        {
            Response.Clear();
            Response.ClearHeaders();
            Response.Buffer = false;
            Response.ContentType = "application/octet-stream";
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(BtnAttachment.Text, System.Text.Encoding.UTF8));
            Response.AppendHeader("Content-Length", ContentLength.Value);
            Response.WriteFile(directory + name);
            Response.Flush();
            Response.End();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
    }
    protected void MailList_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //行高亮
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "this.style.cursor='pointer';");
            e.Row.Attributes.Add("onclick", "location.href='mail_list_send.aspx?s_id=" + MailList.DataKeys[e.Row.RowIndex].Value.ToString() + "'");
        }
    }
    protected void BtnAttachment_Click(object sender, EventArgs e)
    {
        this.DownLoadFile(AttachmentEnName.Value);
    }
    protected void MailList_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("DeleteData"))
        { 
            string id = e.CommandArgument.ToString();
            //點擊刪除按鈕
            try
            {
                SqlConnection conn = dbConnection.getConnection();
                conn.Open();
                SqlCommand cmd = new SqlCommand("update OA_MAIL_SENDER set is_del=1 where id=" + id, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                MailList.DataBind();
                PnlMail.Visible = false;
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
    }
    protected void MailList_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LinkButton btnDelete = (LinkButton)e.Row.FindControl("BtnDelete");
            btnDelete.CommandArgument = MailList.DataKeys[e.Row.RowIndex].Value.ToString();
            SqlConnection conn = dbConnection.getConnection();
            conn.Open();
            Label label = (Label)e.Row.FindControl("LblStatistics");
            string mail_id = "0";
            SqlCommand cmd = new SqlCommand("SELECT mail_id FROM dbo.OA_MAIL_SENDER where id=" + MailList.DataKeys[e.Row.RowIndex].Value.ToString(), conn);
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                mail_id = dr["mail_id"].ToString();
            }
            dr.Close();
            
            cmd = new SqlCommand("select count(id) from OA_MAIL_RECEIVER where mail_id=" + mail_id +
                " and is_read=1", conn);
            label.Text = Convert.ToInt32(cmd.ExecuteScalar()) + "人已讀;";
            cmd = new SqlCommand("select count(id) from OA_MAIL_RECEIVER where mail_id=" + mail_id +
                " and is_read=0", conn);
            label.Text = label.Text + Convert.ToInt32(cmd.ExecuteScalar()) + "人未讀";
            label = (Label)e.Row.FindControl("LblReceivers");
            cmd = new SqlCommand("select e.emp_name, e.emp_no, p.name postion from OA_MAIL_RECEIVER r "+
                "inner join OA_EMPLOYEE e on r.receiver=e.id inner join OA_EMPLOYEE_POSITION p on "+
                "e.position=p.id where r.mail_id="+mail_id, conn);
            dr = cmd.ExecuteReader();
            int count = 0;
            while (dr.Read())
            {
                if (count < 2)
                {
                    count = count + 1;
                    label.Text = label.Text + dr["emp_no"].ToString() +
                        dr["emp_name"].ToString() + " " + dr["postion"].ToString() + "; ";
                }
                else
                {
                    break;
                }
            }
            if(!label.Text.Equals(""))
            {
                label.Text = label.Text.Substring(0, label.Text.Length - 2);
                label.Text = label.Text + "...";
            }
            conn.Close();
        }
    }
}

						