using System;

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

		private string FRemarkID;
		private string FRemarkAID;
		private int FRemarkSort;
		private DateTime FRemarkTime;
		private string FRemarkName;
		private string FRemarkEmail;
		private string FRemarkTitle;
		private string FRemarkContent;

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

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

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

		/// <summary>
		/// 在數(shù)據(jù)庫中檢索記錄（已重寫）。
		/// </summary>
		public override void Select()
		{
			string strSql= GetSelectString();
			TSqlDB oDB= new TSqlDB(strSql);
			if (!oDB.EOF)
			{
				FRemarkID      = oDB["remark_id"].ToString();
				FRemarkAID     = oDB["remark_aid"].ToString();
				FRemarkSort    = oDB["remark_sort"].ToInt();
				FRemarkTime    = oDB["remark_time"].ToDateTime();
				FRemarkName    = oDB["remark_name"].ToString();
				FRemarkEmail   = oDB["remark_email"].ToString();
				FRemarkTitle   = oDB["remark_title"].ToString();
				FRemarkContent = oDB["remark_content"].ToString();
			}
			oDB.Free();
		}

		/// <summary>
		/// 在數(shù)據(jù)庫中插入記錄。
		/// </summary>
		public void Insert()
		{
			string ExSql = "newid(), '"+FRemarkAID+"', null, getdate(), '"+FRemarkName+"', '"+FRemarkEmail+"', '"+FRemarkTitle+"', '"+FRemarkContent+"'";
			base.Insert(ExSql);
		}

		/// <summary>
		/// 在數(shù)據(jù)庫中更新記錄。
		/// </summary>
		public void Update()
		{
			string ExSql = "remark_time=getdate(), remark_name='"+FRemarkName+"', remark_email='"+FRemarkEmail+"', remark_title='"+FRemarkTitle+"', remark_content='"+FRemarkContent+"'";
			base.Update(ExSql);
		}

		public string RemarkAID
		{
			get
			{
				return FRemarkAID;
			}
			set
			{
				FRemarkAID= value;
			}
		}

		public string RemarkName
		{
			get
			{
				return FRemarkName;
			}
			set
			{
				FRemarkName= value;
			}
		}

		public string RemarkEmail
		{
			get
			{
				return FRemarkEmail;
			}
			set
			{
				FRemarkEmail= value;
			}
		}

		public string RemarkTitle
		{
			get
			{
				return FRemarkTitle;
			}
			set
			{
				FRemarkTitle= value;
			}
		}

		public string RemarkContent
		{
			get
			{
				return FRemarkContent;
			}
			set
			{
				FRemarkContent= value;
			}
		}
	}

	/// <summary>
	/// TCmsRemarkRset 的摘要說明。
	/// </summary>
	public class TCmsRemarkRset : TDataRset
	{
		const string CTableName = "v_remark";
		const string CKeyName   = "remark_id";

		public TCmsRemarkRset()
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			SqlOrderBy = "remark_time desc";
			Load();
		}

		public TCmsRemarkRset(string ArticleID)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			if ((ArticleID!=null)&&(ArticleID.Length>0))
			{
				SqlWhere   = "remark_aid='"+ArticleID+"'";
			}
			SqlOrderBy = "remark_time desc";
			Load();
		}

		/// <summary>
		/// 只取與指定欄目相關(guān)的評(píng)論
		/// </summary>
		/// <param name="ColumnID"></param>
        /// <param name="FuncNo"></param>
		public TCmsRemarkRset(string ColumnID, int FuncNo)
		{
			FTableName = CTableName;
			FKeyName   = CKeyName;
			if ((ColumnID!=null)&&(ColumnID.Length>0))
			{
				SqlWhere   = "Column_id='"+ColumnID+"'";
			}
			SqlOrderBy = "remark_time desc";
			Load();
		}
	}
}