using System;

namespace _lib
{
	/// <summary>
	/// TCmsArticle 的摘要說明。
	/// </summary>
	public class TCmsArticle : TData
	{
		const string CTableName = "t_article";
		const string CKeyName   = "article_id";

		private string FArticleID;
		private string FArticleCID;
		private int FArticleSort;
		private DateTime FArticleTime;
		private string FArticleTitle;
		private string FArticleContent;
		private string FArticleAuthor;
		private int FArticleHit;
		private int FArticleStatus;

		public TCmsArticle()
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
		}

		public TCmsArticle(string ID)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			FKeyValue  = ID;
		}

		/// <summary>
		/// （靜態）根據編號在數據庫中刪除記錄。
		/// </summary>
		public static void DeleteByID(string ID)
		{
			TData.DeleteByID(ID, CTableName, CKeyName);
		}

		/// <summary>
		/// （靜態）文章點擊數自增。
		/// </summary>
		public static void IncHit(string ID)
		{
			string strSql = "update "+CTableName+" set article_hit=article_hit+1 where "+CKeyName+"='"+ID+"'";
			TSqlDB.ExecuteNonQuery(strSql);
		}

		/// <summary>
		/// 在數據庫中檢索記錄（已重寫）。
		/// </summary>
		public override void Select()
		{
			string strSql= GetSelectString();
			TSqlDB oDB= new TSqlDB(strSql);
			if (!oDB.EOF)
			{
				FArticleID      = oDB["article_id"     ].ToString();
				FArticleCID     = oDB["article_cid"    ].ToString();
				FArticleSort    = oDB["article_sort"   ].ToInt();
				FArticleTime    = oDB["article_time"   ].ToDateTime();
				FArticleTitle   = oDB["article_title"  ].ToString();
				FArticleContent = oDB["article_content"].ToString();
				FArticleAuthor  = oDB["article_author" ].ToString();
				FArticleHit     = oDB["article_hit"    ].ToInt();
				FArticleStatus  = oDB["article_status" ].ToInt();
			}
			oDB.Free();
		}

		/// <summary>
		/// 在數據庫中插入記錄。
		/// </summary>
		public void Insert()
		{
			string ExSql = "newid(), '"+FArticleCID+"', null, getdate(), '"+FArticleTitle+"', '"+FArticleContent+"', '"+FArticleAuthor+"', 0, 1";
			base.Insert(ExSql);
		}

		/// <summary>
		/// 在數據庫中更新記錄。
		/// </summary>
		public void Update()
		{
			string ExSql = "article_time=getdate(), article_title='"+FArticleTitle+"', article_content='"+FArticleContent+"', article_author='"+FArticleAuthor+"', article_hit="+FArticleHit+", article_status="+FArticleStatus;
			base.Update(ExSql);
		}

		public string ArticleCID
		{
			get
			{
				return FArticleCID;
			}
			set
			{
				FArticleCID= value;
			}
		}

		public string ArticleTitle
		{
			get
			{
				return FArticleTitle;
			}
			set
			{
				FArticleTitle= value;
			}
		}

		public string ArticleContent
		{
			get
			{
				return FArticleContent;
			}
			set
			{
				FArticleContent= value;
			}
		}

		public string ArticleAuthor
		{
			get
			{
				return FArticleAuthor;
			}
			set
			{
				FArticleAuthor= value;
			}
		}

		public string ArticleTime
		{
			get
			{
				return FArticleTime.ToString("yy-M-d h:m");
			}
		}
	}

	/// <summary>
	/// TCmsArticleRset 的摘要說明。
	/// </summary>
	public class TCmsArticleRset : TDataRset
	{
		const string CTableName = "v_article";	// 文章及相關圖片視圖
		const string CKeyName   = "article_id";

		private string FColumnID;	// 所屬欄目編號

		public TCmsArticleRset()
		{
			Init();
		}

		public TCmsArticleRset(int ResultSum)
		{
			Init();
			LoadWith(ResultSum);
		}

		public TCmsArticleRset(string ColumnID)
		{
			Init();
			FColumnID = ColumnID;
			Load();
		}

		public TCmsArticleRset(int ResultSum, string ColumnID)
		{
			Init();
			FColumnID = ColumnID;
			FTopSum = ResultSum;
			Load();
		}

		private void Init()
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			FSqlOrderBy= "article_time desc";
		}

		/// <summary>
		/// 裝載數據集
		/// </summary>
		public override void Load()
		{
			if ((FColumnID!=null)&&(FColumnID.Length>0))
			{
				FSqlWhere = "article_cid='"+FColumnID+"'";
			}
			base.Load();
		}
	}
}