message.cs

在线 图书网上购物系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Common;
using System.Web.Management;
	
#region Message
	/// <summary>
	/// This object represents the properties and methods of a Message.
	/// </summary>
	public class Message
	{
		protected int _id;
		protected string _iDFrom = String.Empty;
		protected string _iDTo = String.Empty;
		protected string _context = String.Empty;
		protected bool _isRead;
		protected DateTime _dateTime;
		
		public Message()
		{
		}
		
		public Message(int id)
		{
            DbDataReader reader = DataAccess.ExecuteDataReader("usp_SelectMessage", false, new object[] { id });
			if (reader.Read()) 
			{
				this.LoadFromReader(reader);
				reader.Close();
			}
			else
			{
				if (!reader.IsClosed) reader.Close();
				throw new ApplicationException("Message does not exist.");
			}
		}
		
		public Message(DbDataReader reader)
		{
			this.LoadFromReader(reader);
		}
		
		protected void LoadFromReader(DbDataReader reader)
		{
			if (reader != null && !reader.IsClosed)
			{
				_id = reader.GetInt32(0);
				if (!reader.IsDBNull(1)) _iDFrom = reader.GetString(1);
				if (!reader.IsDBNull(2)) _iDTo = reader.GetString(2);
				if (!reader.IsDBNull(3)) _context = reader.GetString(3);
				if (!reader.IsDBNull(4)) _isRead = reader.GetBoolean(4);
				if (!reader.IsDBNull(5)) _dateTime = reader.GetDateTime(5);
			}
		}
		
		#region Public Properties
		public int Id
		{
			get {return _id;}
		}
		
		public string IDFrom
		{
			get {return _iDFrom;}
			set {_iDFrom = value;}
		}

		public string IDTo
		{
			get {return _iDTo;}
			set {_iDTo = value;}
		}

		public string Context
		{
			get {return _context;}
			set {_context = value;}
		}

		public bool IsRead
		{
			get {return _isRead;}
			set {_isRead = value;}
		}

		public DateTime DateTime
		{
			get {return _dateTime;}
			set {_dateTime = value;}
		}
		#endregion
		
		public static Message GetMessage(int id)
		{
			return new Message(id);
		}

        public static DataTable GetUnReadMessages(string strIdTo)
        {
            return DataAccess.ExecuteDataTable("usp_SelectUnMsgs", false, new object[] { strIdTo });
        }

        public static DataTable GetAllMessages(string strIdTo)
        {
            return DataAccess.ExecuteDataTable("usp_SelectAllMsgs", false, new object[] { strIdTo });
        }

        public static int DeleteMessage(int mid)
        {
            return DataAccess.ExecuteNonQuery("usp_DeleteMessage", false, new object[] { mid });
        }

        public static int InsertMessage(Message msg)
        {
            return DataAccess.ExecuteNonQuery("usp_InsertMessage", false, new object[]{
                                                                              msg.IDFrom,
                                                                              msg.IDTo,
                                                                              msg.Context,msg.IsRead,msg.DateTime});
        }


        public static DataTable SelectMessage(int msgid)
        {
            string sql = "select msgid,fromname,idfrom,toname,view_SElallMsg.idto,context,isread,[datetime]" + 
                         " from view_SelallMsg,View_SelUserName "+
                         " where view_selallmsg.idto = view_selusername.idto" + 
                         " and msgid= " + msgid;
            return DataAccess.ExecuteDataTable(sql);
        }
        
        public static int SetMessageReadMark(int msgid)
        {
            string sql = "update Message set IsRead=1 where MsgID=" + msgid;
            return DataAccess.ExecuteNonQuery(sql);
        }
	}
	#endregion