using System;
using System.Data.OleDb;
//該源碼下載自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
namespace _211
{
	/// <summary>
	/// Admin 的摘要說明。
	/// </summary>
	public class Admin:DBTable
	{
		private uint AdminId;
		private string AdminName;
		private string AdminPws;

		public Admin(string AN,string AP,bool IsReadDataBase):base("Admin")
		{
			AdminName=StringManager.LoginLetterSelected(AN);
			AdminPws=StringManager.String2MD5(AP);

			if(IsReadDataBase)
			{
				cmd=new OleDbCommand("select * from ["+TableName+"] where AdminName='"+AdminName+"' and AdminPws='"+AdminPws+"'",conn);
				OleDbDataReader dr=cmd.ExecuteReader();
				if(dr.HasRows)
				{
					dr.Read();
					HasRecord=true;
					AdminId=Convert.ToUInt32(dr.GetValue(0));
				}
				dr.Close();
				cmd.Dispose();
			}
		}

		public Admin(uint AI):base("Admin")
		{
			AdminId=AI;
			cmd=new OleDbCommand("select * from ["+TableName+"] where AdminId="+AdminId,conn);
			OleDbDataReader dr=cmd.ExecuteReader();
			if(dr.HasRows)
			{
				dr.Read();
				HasRecord=true;
				AdminName=dr.GetValue(1).ToString();
				AdminPws=dr.GetValue(2).ToString();
			}
			dr.Close();
			cmd.Dispose();
		}

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

			cmd=new OleDbCommand("insert into "+TableName+" (AdminName,AdminPws) values ('"+AdminName+"','"+AdminPws+"')",conn);
			try
			{
				cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				throw ex;
			}
			finally
			{
				cmd.Dispose();
			}
		}
//5	1	a	s	p	x.com

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

			if(!HasRecord)throw new Exception("沒有該列，無法更新");

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

		public uint getAdminId()
		{
			return AdminId;
		}

		public string getAdminName()
		{
			return AdminName;
		}

		public void setAdminPws(string AP)
		{
			StringManager.String2MD5(AP);
		}
	}
}