downtype.cs

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

using System;
using System.Data.OleDb;

namespace _211
{
	/// <summary>
	/// DownType 的摘要说明。
	/// </summary>
	public class DownType:DBTable
	{
		private uint DownTypeId;
		private string DownTypeName;

		public DownType(uint DTI):base("DownType")
		{
			DownTypeId=DTI;
			cmd=new OleDbCommand("select * from ["+TableName+"] where DownTypeId="+DownTypeId,conn);
			OleDbDataReader dr=cmd.ExecuteReader();
			if(dr.HasRows)
			{
				dr.Read();
				HasRecord=true;
				DownTypeName=dr.GetValue(1).ToString();
			}
			dr.Close();
			cmd.Dispose();
		}

		public DownType(string DTN,bool IsReadDataBase):base("DownType")
		{
			DownTypeName=StringManager.LoginLetterSelected(DTN);
			if(IsReadDataBase)
			{
				cmd=new OleDbCommand("select * from ["+TableName+"] where DownTypeName='"+DownTypeName+"'",conn);
				OleDbDataReader dr=cmd.ExecuteReader();
				if(dr.HasRows)
				{
					dr.Read();
					HasRecord=true;
					DownTypeId=Convert.ToUInt32(dr.GetValue(0));
				}
				dr.Close();
				cmd.Dispose();
			}
		}

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

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

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

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

		public uint getDownTypeId()
		{
			return DownTypeId;
		}

		public string getDownTypeName()
		{
			return DownTypeName;
		}

		public void setDownTypeName(string DTN)
		{
			DownTypeName=StringManager.LoginLetterSelected(DTN);
		}
	}
}