db_employees.cs

一个快速的数据库访问框架。可根据需要灵活的扩展。

using System;

namespace MyORM
{
	/// <summary>
	/// 数据库表 Employees 操作对象
	/// </summary>
	/// <remark>
	/// 该表有21个字段
	///</remark>
	[System.Serializable()]
	[BindTable("Employees")]
	public class DB_Employees
	{   

		/// <summary>
		/// 人员全名
		/// </summary>
		public string FullName
		{
			get
			{
				return this.LastName + this.FirstName ;
			}
		}

		#region 定义数据库字段变量及属性 //////////////////////////////////////////

	
		///<summary>
		/// 字段值 EmployeeID
		///</summary>
		private System.Int32 m_EmployeeID = 0 ;
		///<summary>
		/// 字段值 EmployeeID
		///</summary>
		[BindField("EmployeeID" , Key = true )]
		public System.Int32 EmployeeID
		{
			get
			{
				return m_EmployeeID ;
			}
			set
			{
				m_EmployeeID = value;
			}
		}

		///<summary>
		/// 字段值 LastName
		///</summary>
		private System.String m_LastName = null ;
		///<summary>
		/// 字段值 LastName
		///</summary>
		[BindField("LastName")]
		public System.String LastName
		{
			get
			{
				return m_LastName ;
			}
			set
			{
				m_LastName = value;
			}
		}

		///<summary>
		/// 字段值 FirstName
		///</summary>
		private System.String m_FirstName = null ;
		///<summary>
		/// 字段值 FirstName
		///</summary>
		[BindField("FirstName")]
		public System.String FirstName
		{
			get
			{
				return m_FirstName ;
			}
			set
			{
				m_FirstName = value;
			}
		}

		///<summary>
		/// 字段值 Title
		///</summary>
		private System.Int32 m_Title = 0 ;
		///<summary>
		/// 字段值 Title
		///</summary>
		[BindField("Title")]
		public System.Int32 Title
		{
			get
			{
				return m_Title ;
			}
			set
			{
				m_Title = value;
			}
		}

		///<summary>
		/// 字段值 TitleOfCourtesy
		///</summary>
		private System.String m_TitleOfCourtesy = null ;
		///<summary>
		/// 字段值 TitleOfCourtesy
		///</summary>
		[BindField("TitleOfCourtesy")]
		public System.String TitleOfCourtesy
		{
			get
			{
				return m_TitleOfCourtesy ;
			}
			set
			{
				m_TitleOfCourtesy = value;
			}
		}

		///<summary>
		/// 字段值 Address
		///</summary>
		private System.String m_Address = null ;
		///<summary>
		/// 字段值 Address
		///</summary>
		[BindField("Address")]
		public System.String Address
		{
			get
			{
				return m_Address ;
			}
			set
			{
				m_Address = value;
			}
		}

		///<summary>
		/// 字段值 BirthDate
		///</summary>
		private System.DateTime m_BirthDate = DateTime.Now ;
		///<summary>
		/// 字段值 BirthDate
		///</summary>
		[BindField("BirthDate" , WriteFormat="yyyy-MM-dd")]
		public System.DateTime BirthDate
		{
			get
			{
				return m_BirthDate ;
			}
			set
			{
				m_BirthDate = value;
			}
		}

		///<summary>
		/// 字段值 City
		///</summary>
		private System.String m_City = null ;
		///<summary>
		/// 字段值 City
		///</summary>
		[BindField("City")]
		public System.String City
		{
			get
			{
				return m_City ;
			}
			set
			{
				m_City = value;
			}
		}

		///<summary>
		/// 字段值 Country
		///</summary>
		private System.String m_Country = null ;
		///<summary>
		/// 字段值 Country
		///</summary>
		[BindField("Country")]
		public System.String Country
		{
			get
			{
				return m_Country ;
			}
			set
			{
				m_Country = value;
			}
		}

		///<summary>
		/// 字段值 EducationalLevel
		///</summary>
		private System.Int32 m_EducationalLevel = 0 ;
		///<summary>
		/// 字段值 EducationalLevel
		///</summary>
		[BindField("EducationalLevel")]
		public System.Int32 EducationalLevel
		{
			get
			{
				return m_EducationalLevel ;
			}
			set
			{
				m_EducationalLevel = value;
			}
		}

		///<summary>
		/// 字段值 EMail
		///</summary>
		private System.String m_EMail = null ;
		///<summary>
		/// 字段值 EMail
		///</summary>
		[BindField("EMail")]
		public System.String EMail
		{
			get
			{
				return m_EMail ;
			}
			set
			{
				m_EMail = value;
			}
		}


		///<summary>
		/// 字段值 Extension
		///</summary>
		private System.String m_Extension = null ;
		///<summary>
		/// 字段值 Extension
		///</summary>
		[BindField("Extension")]
		public System.String Extension
		{
			get
			{
				return m_Extension ;
			}
			set
			{
				m_Extension = value;
			}
		}

	

		///<summary>
		/// 字段值 Goal
		///</summary>
		private System.Int32 m_Goal = 0 ;
		///<summary>
		/// 字段值 Goal
		///</summary>
		[BindField("Goal")]
		public System.Int32 Goal
		{
			get
			{
				return m_Goal ;
			}
			set
			{
				m_Goal = value;
			}
		}

		///<summary>
		/// 字段值 HireDate
		///</summary>
		private System.DateTime m_HireDate = DateTime.Now ;
		///<summary>
		/// 字段值 HireDate
		///</summary>
		[BindField("HireDate" , WriteFormat="yyyy-MM-dd")]
		public System.DateTime HireDate
		{
			get
			{
				return m_HireDate ;
			}
			set
			{
				m_HireDate = value;
			}
		}

		///<summary>
		/// 字段值 HomePage
		///</summary>
		private System.String m_HomePage = null ;
		///<summary>
		/// 字段值 HomePage
		///</summary>
		[BindField("HomePage")]
		public System.String HomePage
		{
			get
			{
				return m_HomePage ;
			}
			set
			{
				m_HomePage = value;
			}
		}

		///<summary>
		/// 字段值 HomePhone
		///</summary>
		private System.String m_HomePhone = null ;
		///<summary>
		/// 字段值 HomePhone
		///</summary>
		[BindField("HomePhone")]
		public System.String HomePhone
		{
			get
			{
				return m_HomePhone ;
			}
			set
			{
				m_HomePhone = value;
			}
		}

	

		///<summary>
		/// 字段值 Notes
		///</summary>
		private System.String m_Notes = null ;
		///<summary>
		/// 字段值 Notes
		///</summary>
		[BindField("Notes")]
		public System.String Notes
		{
			get
			{
				return m_Notes ;
			}
			set
			{
				m_Notes = value;
			}
		}

		///<summary>
		/// 字段值 PostalCode
		///</summary>
		private System.String m_PostalCode = null ;
		///<summary>
		/// 字段值 PostalCode
		///</summary>
		[BindField("PostalCode")]
		public System.String PostalCode
		{
			get
			{
				return m_PostalCode ;
			}
			set
			{
				m_PostalCode = value;
			}
		}

		///<summary>
		/// 字段值 Region
		///</summary>
		private System.String m_Region = null ;
		///<summary>
		/// 字段值 Region
		///</summary>
		[BindField("Region")]
		public System.String Region
		{
			get
			{
				return m_Region ;
			}
			set
			{
				m_Region = value;
			}
		}

		///<summary>
		/// 字段值 ReportsTo
		///</summary>
		private System.Int32 m_ReportsTo = 0 ;
		///<summary>
		/// 字段值 ReportsTo
		///</summary>
		[BindField("ReportsTo")]
		public System.Int32 ReportsTo
		{
			get
			{
				return m_ReportsTo ;
			}
			set
			{
				m_ReportsTo = value;
			}
		}

		///<summary>
		/// 字段值 Sex
		///</summary>
		private System.Int32 m_Sex = 0 ;
		///<summary>
		/// 字段值 Sex
		///</summary>
		[BindField("Sex")]
		public System.Int32 Sex
		{
			get
			{
				return m_Sex ;
			}
			set
			{
				m_Sex = value;
			}
		}
		#endregion
	}// 数据库操作类 DB_Employees 定义结束
}