link.cs

中国海洋大学211工程网站的全部源码

using System;
using System.Data.OleDb;

namespace _211
{
	/// <summary>
	/// Link 的摘要说明。
	/// </summary>
	public class Link:DBTable
	{
		private uint LinkId;
		private string LinkName;
		private string LinkUrl;

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

		public Link(uint LI):base("Link")
		{
			LinkId=LI;
			cmd=new OleDbCommand("select * from ["+TableName+"] where LinkId="+LinkId,conn);
			OleDbDataReader dr=cmd.ExecuteReader();
			if(dr.HasRows)
			{
				dr.Read();
				HasRecord=true;
				LinkName=dr["LinkName"].ToString();
				LinkUrl=dr["LinkUrl"].ToString();
			}
			dr.Close();
			cmd.Dispose();
		}

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

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

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

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

		public uint getLinkId()
		{
			return LinkId;
		}

		public string getLinkName()
		{
			return LinkName;
		}

		public string getLinkUrl()
		{
			return LinkUrl;
		}

		public void setLinkName(string LN)
		{
			LinkName=StringManager.LoginLetterSelected(LN);
		}

		public void setLinkUrl(string LU)
		{
			LinkUrl=LU;
		}
	}
}