mailinfo.cs

内部邮件管理系统

using System;
using System.Data ;
using MailAdmin.COMMON ;
using MailAdmin.DAL ;

namespace MailAdmin.BLL
{
	/// <summary>
	/// MailInfo 的摘要说明。
	/// </summary>
	public class MailInfo
	{
		public MailInfo()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		private int _mailID ;
		private int _usrID ;
		private string _sendTo ;
		private string _ccTo ;
		private string _secretTo ;
		private string _sendToID ;
		private string _ccToID ;
		private string _secretToID ;
		private string _title ;
		private string _content ;
		private DateTime _sendTime ;
		private string _status ;
		private string _attName ;
		private string _attUpName ;
		private string _important ;
		private string _usrName ;

		#region 公共属性
		public int MailID
		{
			set { _mailID = value ;}
			get { return _mailID ; }
		}

		public int UsrID
		{
			set { _usrID = value ;}
			get { return _usrID ;}
		}

		public string SendTo
		{
			set { _sendTo = value ;}
			get { return _sendTo ;}
		}

		public string CcTo
		{
			set { _ccTo = value ;}
			get { return _ccTo ;}
		}

		public string SecretTo
		{
			set { _secretTo = value ;}
			get { return _secretTo ;}
		}


		public string SendToID
		{
			set { _sendToID = value ;}
			get { return _sendToID ;}
		}

		public string CcToID
		{
			set { _ccToID = value ;}
			get { return _ccToID ;}
		}

		public string SecretToID
		{
			set { _secretToID = value ;}
			get { return _secretToID ;}
		}

		public string Title
		{
			set { _title = value ;}
			get { return _title ;}
		}

		public string Content
		{
			set { _content = value ;}
			get { return _content ;}
		}

		public DateTime SendTime
		{
			set { _sendTime = value ;}
			get { return _sendTime ;}
		}

		public string Status
		{
			set { _status = value ;}
			get { return _status ;}
		}

		public string AttName
		{
			set { _attName = value ;}
			get { return _attName ;}
		}

		public string AttUpName
		{
			set { _attUpName = value ;}
			get { return _attUpName ;}
		}

		public string Important
		{
			set { _important = value ;}
			get { return _important ;}
		}

		public string UsrName
		{
			set { _usrName = value ;}
			get { return _usrName ;}
		}
		#endregion

		#region 公共方法
		public int GetMailInfo(int mailID)
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_Get" ;
			//参数
			object[] para = new object[] {mailID} ;

			// 执行存储过程
			DataTable dt = DataAccess.ExecuteDataTable(spName,para) ;
			if(dt.Rows.Count>0)
			{
				DataRow dr = dt.Rows[0] ;

				//邮件信息属性
				Attribute(dr) ;

				ret = 0 ;
			}

			return ret ;
		}

		private void Attribute(DataRow dr)
		{
			this.AttName = dr["AttName"].ToString() ;
			this.AttUpName = dr["AttUpName"].ToString() ;
			this.CcTo = dr["CcTo"].ToString() ;
			this.CcToID = dr["CcToID"].ToString() ;
			this.Content = dr["Content"].ToString() ;
			this.Important = dr["Important"].ToString() ;
			this.MailID = CommHandler.StringToInt(dr["MailID"].ToString()) ;
			this.SecretTo = dr["SecretTo"].ToString() ;
			this.SecretToID = dr["SecretToID"].ToString() ;
			this.SendTime = CommHandler.StringToDateTime(dr["SendTime"].ToString()) ;
			this.SendTo = dr["SendTo"].ToString() ;
			this.SendToID = dr["SendToID"].ToString() ;
			this.Status = dr["Status"].ToString() ;
			this.Title = dr["Title"].ToString() ;
			this.UsrID = CommHandler.StringToInt(dr["UserID"].ToString()) ;	
			this.UsrName = dr["UserName"].ToString() ;
		}


		public int AddMailInfo()
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_Add" ;
			//参数
			object[] para = new object[] {"",_usrID,_sendTo,_ccTo,_secretTo
										 ,_sendToID,_ccToID,_secretToID
										 ,_title,_content,_sendTime,_status
										 ,_attName,_attUpName,_important} ;

			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		public int ModifyMailInfo()
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_Modify" ;
			//参数
			object[] para = new object[] {_mailID,_usrID,_sendTo,_ccTo,_secretTo
											 ,_sendToID,_ccToID,_secretToID
											 ,_title,_content,_sendTime,_status
											 ,_attName,_attUpName,_important} ;

			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;			
		}

		/// <summary>
		/// 彻底删除邮件信息
		/// </summary>
		/// <param name="mailID">邮件ID</param>
		/// <returns>删除结果</returns>
		public int DeleteMailInfo(int mailID)
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_Delete" ;
			//参数
			object[] para = new object[] {mailID} ;

			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;		
		}

		public int ChStatusMailInfo(int mailID)
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_ChStatus" ;
			//参数
			object[] para = new object[] {mailID} ;

			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;		
		}

		/// <summary>
		/// 将邮件信息删除到垃圾箱
		/// </summary>
		/// <param name="mailID">邮件ID</param>
		/// <param name="status">邮件状态</param>
		/// <returns>命令执行结果</returns>
		public int RecycleMailInfo(int mailID,string status)
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_Recycle" ;
			//参数
			object[] para = new object[] {mailID,status} ;

			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;		
		}

		/// <summary>
		/// 还原邮件基本信息
		/// </summary>
		/// <param name="mailID">邮件ID</param>
		/// <param name="status">邮件状态</param>
		/// <returns></returns>
		public int RevertMailInfo(int mailID,string status)
		{
			int ret = -1 ;

			//存储过程名			
			string spName = "Mail_MailInfo_Revert" ;
			//参数
			object[] para = new object[] {mailID,status} ;

			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;		
		}


		#endregion

	}
}