mailread.cs

内部邮件管理系统 &#61656 读者须安装好IIS和Microsoft Visual Stutio.NET相关开发环境

using System;
using MailAdmin.DAL ;

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

		
		private int _readID ;
		private int _mailID ;
		private int _readUsrID ;
		private int _times ;
		private string _status ;
		private DateTime _lastReadTime ;
		private string _sendType ;
		private DateTime _sendTime ;
		private string _important ;

		#region 公共属性

		public int ReadID
		{
			set { _readID = value ;}
			get { return _readID ; }
		}

		public int MailID
		{
			set { _mailID = value ;}
			get { return _mailID ; }
		}

		public int ReadUsrID
		{
			set { _readUsrID = value ;}
			get { return _readUsrID ;}
		}

		public int Times
		{
			set { _times = value ;}
			get { return _times ;}
		}

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

		public DateTime LastReadTime
		{
			set { _lastReadTime = value ;}
			get { return _lastReadTime ;}
		}

		public string SendType
		{
			set { _sendType = value ;}
			get { return _sendType ;}
		}

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

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

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

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

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

			return ret ;			
		}

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

			//存储过程名			
			string spName = "Mail_Read_Add" ;
			//参数
			object[] para = new object[] {"",_mailID,_readUsrID,_sendTime,_important
										 } ;

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

			return ret ;
		}

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

			//存储过程名			
			string spName = "Mail_Read_Modify" ;
			//参数
			object[] para = new object[] {_readID,_mailID,_readUsrID,_times,_status,_lastReadTime
											 ,_sendType,_sendTime,_important
											} ;

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

			return ret ;			
		}

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

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

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

			return ret ;		
		}

	
		/// <summary>
		/// 将邮件查看信息删除到垃圾箱
		/// </summary>
		/// <param name="readID">邮件查看信息ID</param>
		/// <returns>删除结果</returns>
		public int RecycleMailRead(int readID)
		{
			int ret = -1 ;

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

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

			return ret ;		
		}

		/// <summary>
		/// 还原邮件查看信息
		/// </summary>
		/// <param name="readID">邮件查看信息ID</param>
		/// <returns>还原结果</returns>
		public int RevertMailRead(int readID)
		{
			int ret = -1 ;

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

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

			return ret ;		
		}

		#endregion

	}
}