mail.cs

asp.net 办公自动化系统 人事管理 公文管理 内部邮件管理以及办公自动化系统中不可或缺的模块

using System;
using System.Data;
using System.Data.SqlClient;

namespace eOA
{
	/// <summary>
	/// Mail 的摘要说明。
	/// </summary>
	public class Mail
	{
		public Mail()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public DataSet GetAllRecvMail(int RecvID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@RecvID", RecvID)
								  };
			return SqlAccess.ExecuteDataset(SqlAccess .CONN_STRING, CommandType.StoredProcedure,"GetAllRecvMail",para);

		}

		public SqlDataReader GetMailByID(int MailID)
		{			
			SqlParameter[] para = {
									  new SqlParameter("@MailID", MailID)
								  };
			return SqlAccess.ExecuteReader(SqlAccess.CONN_STRING,CommandType.StoredProcedure, "GetMailByID", para);
		}

		public void DeleteMail(int MailID)
		{
			SqlParameter[] para = {
									  new SqlParameter("@MailID", MailID)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "DeleteMail", para);
		}

		public void AddMail(int SendID,string SendEmp,int RecvID,string RecvEmp,string Subject,string Content,DateTime CreateDate)
		{
			SqlParameter[] para = {
									  new SqlParameter("@SendID", SendID),
									  new SqlParameter("@SendEmp", SendEmp),
									  new SqlParameter("@RecvID", RecvID),
									  new SqlParameter("@RecvEmp", RecvEmp),
									  new SqlParameter("@Subject", Subject),
									  new SqlParameter("@Content", Content),
									  new SqlParameter("@CreateDate", CreateDate)
								  };

			SqlAccess.ExecuteNonQuery(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "AddMail", para);
		}

		public int GetMailSendID(string SendEmp)
		{
			SqlParameter[] Para = {
											new SqlParameter("@SendEmp", SendEmp),
			};
			return Convert.ToInt32  (SqlAccess.ExecuteScalar(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "GetMailSendID", Para));
		}

		public int GetMailRecvID(string RecvEmp)
		{
			SqlParameter[] Para = {
									  new SqlParameter("@RecvEmp", RecvEmp),
			};
			return Convert.ToInt32  (SqlAccess.ExecuteScalar(SqlAccess.CONN_STRING, CommandType.StoredProcedure, "GetMailRecvID", Para));
		}
	}
}