using System;
using System.Data.OleDb;

namespace _211
{
	/// <summary>
	/// Article 的摘要說明。
	/// </summary>
	public class Article:DBTable
	{
		private uint ArticleId;
		private string ArticleTitle;
		private string ArticleContent;
		private int ItemId;
		private string AdminName;
		private string AddTime;

		public Article(uint AI):base("Article")
		{
			ArticleId=AI;
			cmd=new OleDbCommand("select * from ["+TableName+"] where ArticleId="+ArticleId,conn);
			OleDbDataReader dr=cmd.ExecuteReader();
			if(dr.HasRows)
			{
				dr.Read();
				HasRecord=true;
				ArticleTitle=dr["ArticleTitle"].ToString();
				ArticleContent=dr["ArticleContent"].ToString();
				ItemId=Convert.ToInt32(dr["ItemId"].ToString());
				AdminName=dr["AdminName"].ToString();
				AddTime=dr["AddTime"].ToString();
			}
			dr.Close();
			cmd.Dispose();
		}

		public Article():base("Article")
		{
		}

		public override void Add()
		{
			base.Add();

			cmd=new OleDbCommand("insert into "+TableName+" (ArticleTitle,ArticleContent,ItemId,AdminName) values ('"+ArticleTitle+"','"+ArticleContent+"',"+ItemId+",'"+AdminName+"')",conn);
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				cmd.Dispose();
			}
		}

		public override void Update()
		{
			base.Update();

			cmd=new OleDbCommand("update "+TableName+" set ArticleTitle='"+ArticleTitle+"',ArticleContent='"+ArticleContent+"',ItemId="+ItemId+" where ArticleId="+ArticleId,conn);
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				cmd.Dispose();
			}
		}

		public override void Del()
		{
			base.Del();

			cmd=new OleDbCommand("Delete from "+TableName+" where ArticleId="+ArticleId,conn);
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				cmd.Dispose();
			}
		}

		public uint getArticleId()
		{
			return ArticleId;
		}

		public string getArticleTitle()
		{
			return ArticleTitle;
		}

		public string getArticleContent()
		{
			return ArticleContent;
		}

		public string getAdminName()
		{
			return AdminName;
		}

		public int getItemId()
		{
			return ItemId;
		}

		public string getAddTime()
		{
			return AddTime;
		}

		public int getClassId()
		{
			return (int)DBQuery.ExecuteScalar("select ClassId from [Item] where ItemId="+ItemId);
		}

		public void setArticleTitle(string AT)
		{
			ArticleTitle=StringManager.StringSelected(AT);
		}

		public void setArticleContent(string AC)
		{
			ArticleContent=StringManager.StringSelected(AC);
		}

		public void setAdminName(string AN)
		{
			AdminName=StringManager.LoginLetterSelected(AN);
		}

		public void setItemId(int II)
		{
			ItemId=II;
		}
	}
}