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

namespace qminoa.Common.Data
{
	/// <summary>
	/// MessageData 的摘要說明。
	/// </summary>
	public class MessageData :DataSet
	{
		//
		// 內存中信息數據表字段常量，該表來自實際數據表MsgCont,MsgAdd表示了一條信息的詳細信息
		// 沒有實際的物理表與之對應。
		//
		/// <value>用于數據表名的常量 </value>
		public const string MESSAGE_TABLE    ="messages";
        
		//---------------------------------------------------------------------
		//以下指明字段常量

		///  <value>指明信息ID號。</value>
		public const string MESSAGEID_FIELD  ="MessageID";

		///  <value>指明信息發出的時間。</value>
		public const string MESSAGESENDTIME_FIELD = "SendDate";

		/// <value>指明此信息被瀏覽的最新時間。</value>
		public const string MESSAGESEETIME_FIELD  = "SeeData";

		///  <value>指明發件人ID號。</value>
		public const string MESSAGEPERSON_FIELD   ="MsgPerson";

		///  <value>指明收件人。</value>
		public const string SENDTO_FIELD = "SendTo";   

		///  <value>指明密送人。</value>
		public const string SECRETTO_FIELD  = "SecretTo";

		///  <value>指明附件。</value>
		public const string ACCESSORY_FIELD = "Accessory";

		///  <value>指明附件編號。</value>
		public const string ACCESSORYID_FIELD = "AccessoryID";

		///  <value>指明信息標題。</value>
		public const string TITLE_FIELD = "Title"; 

		///  <value>指明信息級別。</value>
		public const string Level_FIELD = "SendLevel";

		///  <value>指明信息內容。</value>
		public const string CONTENT_FIELD = "Content";

		///   <value>指明此信息被瀏覽的次數 </value>
		public const string WATCHTIMES_FIELD = "Times";

		///   <value>指明此信息現在的狀態</value>
		public const string STATUS_FIELD = "Status";

		///   <value>指明該條信息的具體接收人</value>
		public const string RESIVE_FIELD = "ResivePerson";

		/// <value> 指明該信息具體接收人ID</value>
		public const string RESIVEID_FIELD = "ResivePersonID";

		/// <value> 指明該信息是否為重要信息 </value>
		public const string IMPORTANT_FIELD = "Important";

		///  <value> 指明該條信息的閱讀代號</value>
		public const string REID_FIELD = "reID";
		public MessageData()
		{
			BuildTable();
		}

		//---------------------------------------------------------------
		//方法：構造內存中的數據表
		//數據表名：message
		//---------------------------------------------------------------
		public void BuildTable()
		{
			DataTable table = new DataTable(MESSAGE_TABLE);

			DataColumnCollection columns = table.Columns;
			
			//開始往數據表中添加列
			columns.Add(MESSAGEID_FIELD,typeof(System.Int32));
			columns.Add(MESSAGESENDTIME_FIELD,typeof(System.DateTime));
			columns.Add(MESSAGESEETIME_FIELD,typeof(System.DateTime));
			columns.Add(MESSAGEPERSON_FIELD,typeof(System.String));
			columns.Add(SENDTO_FIELD,typeof(System.String));
			columns.Add(SECRETTO_FIELD,typeof(System.String));
			columns.Add(ACCESSORY_FIELD,typeof(System.String));
			columns.Add(ACCESSORYID_FIELD,typeof(System.String));
			columns.Add(TITLE_FIELD,typeof(System.String));
			columns.Add(Level_FIELD,typeof(System.Int16));
			columns.Add(CONTENT_FIELD,typeof(System.String));
			columns.Add(WATCHTIMES_FIELD,typeof(System.Int16));
			columns.Add(STATUS_FIELD,typeof(System.Int32));
			columns.Add(RESIVE_FIELD,typeof(System.String));
			columns.Add(REID_FIELD,typeof(System.Int32));
			columns.Add(RESIVEID_FIELD,typeof(System.Int32));
			columns.Add(IMPORTANT_FIELD,typeof(System.Boolean));
			//添加列結束
			this.Tables.Add(table);
		}
	}
}