mail.cs

全自动办公软件

									   data.MakeInParam("@FileVisualPath",  SqlDbType.NVarChar, 200, att.FileVisualPath),
									   data.MakeInParam("@FileAuthor",  SqlDbType.NVarChar, 50, att.FileAuthor),
									   data.MakeInParam("@FileCatlog",  SqlDbType.NVarChar, 20, att.FileCatlog)
								   };
			try 
			{
				data.RunProc("SP_AddMailAttFile", prams);
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("邮件附件发送出错!",ex);
			}
			
		}
		#endregion

		#region 获取邮件的内容	
		/// <summary>
		/// Get  sqldatareader  from TabMailList
		/// </summary>
		public SqlDataReader GetMailCompleteInfoDbreader(string MailID) 
		{
			// create data object and params
			SqlDataReader dataReader = null;
			Database data = new Database();
			SqlParameter[] prams = {
									   data.MakeInParam("@MailID",      SqlDbType.NVarChar, 100, MailID)
								   };
			
   
			try 
			{
				// run the stored procedure
				data.RunProc("SP_MailGetCompleteInfo",prams,out dataReader);
				return dataReader;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("邮件读取出错!",ex);
			}
		}
		#endregion

		#region 获取邮件附件的内容	
		/// <summary>
		/// Get  sqldatareader  from TabMailAttFiles
		/// </summary>
		public SqlDataReader GetMailAttInfoDbreader(string MailID) 
		{
			// create data object and params
			SqlDataReader dataReader = null;
			Database data = new Database();
			SqlParameter[] prams = {
									   data.MakeInParam("@MailID",      SqlDbType.NVarChar, 100, MailID)
								   };
			
   
			try 
			{
				// run the stored procedure
				data.RunProc("SP_MailGetAttachFilesInfo",prams,out dataReader);
				return dataReader;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("邮件读取出错!",ex);
			}
		}
		#endregion

		#region 根据邮件ID字符串获取邮件附件的内容	
		/// <summary>
		/// Get  sqldatareader  from TabMailAttFiles
		/// </summary>
		public SqlDataReader GetMailAttInfoByMailIDDbreader(string FileIDStr) 
		{
			// create data object and params
			SqlDataReader dataReader = null;
			Database data = new Database();
			SqlParameter[] prams = {
									   data.MakeInParam("@FileIDStr",      SqlDbType.NVarChar, 4000, FileIDStr)
								   };
			
   
			try 
			{
				// run the stored procedure
				data.RunProc("SP_MailGetAttachFilesInfoByMailID",prams,out dataReader);
				return dataReader;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				throw new Exception("邮件读取出错!",ex);
			}
		}
		#endregion

		

	}


	public class MailMainBody
	{
		private int m_MailFolderType;
		private string m_MailReceiverStr;
		private int m_MailSendLevel;
		private string m_MailSendDate;
		private string m_MailReceiver;
		private string m_MailSender;
		private string m_MailSubject;
		private string m_MailBody;
		private string m_MailCcToAddr;
		private string m_MailBccToAddr;
		private int m_MailReadFlag;
		private int m_MailTypeFlag;
		private int m_MailClassID;
		private int m_MailImportance;
		//外部邮件用
		private string m_ExtHeadersText;
		private string m_ExtHtmlContent;
		private string m_ExtFromName;
		private string m_ExtFromEmail;
		private string m_ExtReplyTo;
		private string m_ExtMailID;


		public int MailFolderType
		{	
			//邮箱类型
			get { return m_MailFolderType; }
			set { m_MailFolderType = value; }
		}

		public string MailReceiverStr 
		{	
			//收件人字符串，用逗号隔开
			get { return m_MailReceiverStr; }
			set { m_MailReceiverStr = value; }
		}
		
		public string MailSendDate 
		{	
			//发送日期
			get { return m_MailSendDate; }
			set { m_MailSendDate = value; }
		}
		
		public int MailSendLevel 
		{	
			//发送级别
			get { return m_MailSendLevel; }
			set { m_MailSendLevel = value; }
		}

		public string MailSender 
		{	
			//发件人登录名
			get { return m_MailSender; }
			set { m_MailSender = value; }
		}

		public string MailReceiver
		{	
			//收件件人登录名
			get { return m_MailReceiver; }
			set { m_MailReceiver = value; }
		}
		
		public string MailSubject 
		{	
			//邮件主题
			get { return m_MailSubject; }
			set { m_MailSubject = value; }
		}
	
		public string MailBody 
		{	
			//邮件主体
			get { return m_MailBody; }
			set { m_MailBody = value; }
		}
				
		public string MailCcToAddr 
		{	
			//抄送地址
			get { return m_MailCcToAddr; }
			set { m_MailCcToAddr = value; }
		}

		public string MailBccToAddr 
		{	
			//秘密抄送地址
			get { return m_MailBccToAddr; }
			set { m_MailBccToAddr = value; }
		}

		public int MailReadFlag 
		{	
			//是否已读标志 0 未读 1已读
			get { return m_MailReadFlag; }
			set { m_MailReadFlag = value; }
		}

		public int MailTypeFlag 
		{	
			//邮件类型 0 为内部 1为外部
			get { return m_MailTypeFlag; }
			set { m_MailTypeFlag = value; }
		}

		public int MailClassID
		{	
			//所属项目ID
			get { return m_MailClassID; }
			set { m_MailClassID = value; }
		}

		public int MailImportance
		{	
			//邮件重要性 
			get { return m_MailImportance; }
			set { m_MailImportance = value; }
		}

		public string ExtHeadersText 
		{	
			//邮件头信息
			get { return m_ExtHeadersText; }
			set { m_ExtHeadersText = value; }
		}

		public string ExtHtmlContent 
		{	
			//Html格式邮件内容
			get { return m_ExtHtmlContent; }
			set { m_ExtHtmlContent = value; }
		}

		public string ExtFromName 
		{	
			//发送人姓名
			get { return m_ExtFromName; }
			set { m_ExtFromName = value; }
		}

		public string ExtFromEmail 
		{	
			//发送人Email
			get { return m_ExtFromEmail; }
			set { m_ExtFromEmail = value; }
		}

		public string ExtReplyTo 
		{	
			//回复至
			get { return m_ExtReplyTo; }
			set { m_ExtReplyTo = value; }
		}

		public string ExtMailID 
		{	
			//邮件的唯一标识
			get { return m_ExtMailID; }
			set { m_ExtMailID = value; }
		}

	}

	public class MailAttachFile
	{
		private int m_FileID;
		private int m_DocID;
		private string m_FileName;
		private int m_FileSize;
		private int m_FileAttribute;
		private string m_FileVisualPath;
		private string m_FileAuthor;
		private string m_FileCatlog;
		
		public int FileID 
		{	
			//文件ID
			get { return m_FileID; }
			set { m_FileID = value; }
		}

		public int DocID 
		{	
			//文档ID
			get { return m_DocID; }
			set { m_DocID = value; }
		}

		public string FileName 
		{	
			//文件名
			get { return m_FileName; }
			set { m_FileName = value; }
		}

		public int FileSize 
		{	
			//文件大小
			get { return m_FileSize; }
			set { m_FileSize = value; }
		}

		public int FileAttribute 
		{	
			//文件属性
			get { return m_FileAttribute; }
			set { m_FileAttribute = value; }
		}

		public string FileVisualPath
		{	
			//文件虚拟路径
			get { return m_FileVisualPath; }
			set { m_FileVisualPath = value; }
		}

		public string FileAuthor
		{	
			//文件作者
			get { return m_FileAuthor; }
			set { m_FileAuthor = value; }
		}

		public string FileCatlog 
		{	
			//文件类别
			get { return m_FileCatlog; }
			set { m_FileCatlog = value; }
		}
	}
}