开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
mail_statistic.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：6k
源码类别：

OA系统

开发平台：

ASP/ASPX

mail_statistic.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using System.Data.SqlClient;
  13. public partial class web_mail_mail_statistic : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         LoginDAO.CheckLogin(Session, Response, "../", 2);
  18.         if (!IsPostBack)
  19.         {
  20.             if (Request.QueryString["mail_id"] != null)
  21.             {
  22.                 this.AddIsRead(Request.QueryString["mail_id"]);
  23.                 this.AddUnRead(Request.QueryString["mail_id"]);
  24.             }
  25.         }
  26.     }
  28.     public void AddIsRead(string mail_id)
  29.     {
  30.         ArrayList emp_names = new ArrayList();
  31.         ArrayList department_id = new ArrayList();
  32.         ArrayList read_date = new ArrayList();//創建已讀人員信息列表
  34.         SqlConnection conn = dbConnection.getConnection();
  35.         conn.Open();
  36.         SqlCommand cmd = new SqlCommand("select r.id, e.emp_name, e.department_id, r.read_date from " +
  37.             "OA_MAIL_RECEIVER r inner join OA_EMPLOYEE e on r.receiver=e.id where is_read=1 and mail_id=" + mail_id, conn);
  38.         SqlDataReader dr = cmd.ExecuteReader();
  39.         emp_names.Clear();
  40.         department_id.Clear();
  41.         read_date.Clear();
  42.         while (dr.Read())
  43.         {
  44.             emp_names.Add(dr["emp_name"].ToString());
  45.             department_id.Add(dr["department_id"].ToString());
  46.             read_date.Add(dr["read_date"].ToString());
  47.         }
  48.         dr.Close();
  49.         if (emp_names.Count > 0)
  50.         {
  51.             //添加表頭
  52.             TableHeaderRow hr = new TableHeaderRow();
  53.             TableHeaderCell hc = new TableHeaderCell();
  54.             hc.BorderWidth = Unit.Pixel(1);
  55.             hc.ColumnSpan = 3;
  56.             hc.HorizontalAlign = HorizontalAlign.Left;
  57.             Label head = new Label();
  58.             head.Text = "已讀人員列表";
  59.             hc.Controls.Add(head);
  60.             hr.Cells.Add(hc);
  61.             TblIsRead.Rows.Add(hr);
  63.             TableRow tr = new TableRow();
  64.             TableCell cell1 = new TableCell();
  65.             cell1.BorderWidth = Unit.Pixel(1);
  66.             cell1.Text = "員工姓名";
  67.             TableCell cell2 = new TableCell();
  68.             cell2.BorderWidth = Unit.Pixel(1);
  69.             cell2.Text = "所屬部門";
  70.             TableCell cell3 = new TableCell();
  71.             cell3.BorderWidth = Unit.Pixel(1);
  72.             cell3.Text = "最後閱讀時間";
  73.             tr.Cells.Add(cell1);
  74.             tr.Cells.Add(cell2);
  75.             tr.Cells.Add(cell3);
  77.             TblIsRead.Rows.Add(tr);
  78.         }
  79.         for (int i = 0; i < department_id.Count; i++)
  80.         {
  81.             DepartmentDAO departmentDAO = new DepartmentDAO();
  82.             Department department = departmentDAO.queryById(Convert.ToInt32(department_id[i]));
  83.             TableRow tr = new TableRow();
  84.             TableCell cell1 = new TableCell();
  85.             cell1.BorderWidth = Unit.Pixel(1);
  86.             cell1.Text = emp_names[i].ToString();
  87.             TableCell cell2 = new TableCell();
  88.             cell2.BorderWidth = Unit.Pixel(1);
  89.             cell2.Text = department.Full_name;
  90.             TableCell cell3 = new TableCell();
  91.             cell3.BorderWidth = Unit.Pixel(1);
  92.             cell3.Text = read_date[i].ToString();
  94.             tr.Cells.Add(cell1);
  95.             tr.Cells.Add(cell2);
  96.             tr.Cells.Add(cell3);
  98.             TblIsRead.Rows.Add(tr);
  99.         }
  101.         conn.Close();
  102.     }
  103.     public void AddUnRead(string mail_id)
  104.     {
  105.         ArrayList emp_names = new ArrayList();
  106.         ArrayList department_id = new ArrayList();
  107.         ArrayList read_date = new ArrayList();//創建已讀人員信息列表
  109.         SqlConnection conn = dbConnection.getConnection();
  110.         conn.Open();
  111.         SqlCommand cmd = new SqlCommand("select r.id, e.emp_name, e.department_id, r.read_date from " +
  112.             "OA_MAIL_RECEIVER r inner join OA_EMPLOYEE e on r.receiver=e.id where is_read=0 and mail_id=" + mail_id, conn);
  113.         SqlDataReader dr = cmd.ExecuteReader();
  114.         emp_names.Clear();
  115.         department_id.Clear();
  116.         read_date.Clear();
  117.         while (dr.Read())
  118.         {
  119.             emp_names.Add(dr["emp_name"].ToString());
  120.             department_id.Add(dr["department_id"].ToString());
  121.             read_date.Add(dr["read_date"].ToString());
  122.         }
  123.         dr.Close();
  124.         if (emp_names.Count > 0)
  125.         {
  126.             //添加表頭
  127.             TableHeaderRow hr = new TableHeaderRow();
  128.             TableHeaderCell hc = new TableHeaderCell();
  129.             hc.BorderWidth = Unit.Pixel(1);
  130.             hc.ColumnSpan = 2;
  131.             hc.HorizontalAlign = HorizontalAlign.Left;
  132.             Label head = new Label();
  133.             head.Text = "未讀人員列表";
  134.             hc.Controls.Add(head);
  135.             hr.Cells.Add(hc);
  136.             TblUnRead.Rows.Add(hr);
  138.             TableRow tr = new TableRow();
  139.             TableCell cell1 = new TableCell();
  140.             cell1.BorderWidth = Unit.Pixel(1);
  141.             cell1.Text = "員工姓名";
  142.             TableCell cell2 = new TableCell();
  143.             cell2.BorderWidth = Unit.Pixel(1);
  144.             cell2.Text = "所屬部門";
  145.             tr.Cells.Add(cell1);
  146.             tr.Cells.Add(cell2);
  148.             TblUnRead.Rows.Add(tr);
  149.         }
  150.         for (int i = 0; i < department_id.Count; i++)
  151.         {
  152.             DepartmentDAO departmentDAO = new DepartmentDAO();
  153.             Department department = departmentDAO.queryById(Convert.ToInt32(department_id[i]));
  154.             TableRow tr = new TableRow();
  155.             TableCell cell1 = new TableCell();
  156.             cell1.BorderWidth = Unit.Pixel(1);
  157.             cell1.Text = emp_names[i].ToString();
  158.             TableCell cell2 = new TableCell();
  159.             cell2.BorderWidth = Unit.Pixel(1);
  160.             cell2.Text = department.Full_name;
  162.             tr.Cells.Add(cell1);
  163.             tr.Cells.Add(cell2);
  165.             TblUnRead.Rows.Add(tr);
  166.         }
  168.         conn.Close();    
  169.     }
  170. }