using System;
using System.Data.OleDb;

namespace _211
{
	/// <summary>
	/// Down 的摘要說明。
	/// </summary>
	public class Down:DBTable
	{
		private uint DownId;
		private string DownName;
		private string DownUrl;

		public Down(uint DI):base("Down")
		{
			DownId=DI;
			cmd=new OleDbCommand("select * from ["+TableName+"] where DownId="+DownId,conn);
			OleDbDataReader dr=cmd.ExecuteReader();
			if(dr.HasRows)
			{
				dr.Read();
				HasRecord=true;
				DownName=dr["DownName"].ToString();
				DownUrl=dr["DownUrl"].ToString();
			}
			dr.Close();
			cmd.Dispose();
		}

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

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

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

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

			cmd=new OleDbCommand("update "+TableName+" set DownName='"+DownName+"',DownUrl='"+DownUrl+"' where DownId="+DownId,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 DownId="+DownId,conn);
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				cmd.Dispose();
			}
		}

		public uint getDownId()
		{
			return DownId;
		}

		public string getDownName()
		{
			return DownName;
		}

		public string getDownUrl()
		{
			return DownUrl;
		}

		public void setDownName(string DN)
		{
			DownName=StringManager.LoginLetterSelected(DN);
		}

		public void setDownUrl(string DU)
		{
			DownUrl=DU;
		}
	}
}