_products.cs

EasyObjects 是ORM的典型应用的例子是学习研究的很好的范例

		public virtual short UnitsOnOrder
		{
			get
			{
				return this.GetShort(ProductsSchema.UnitsOnOrder.FieldName);
	    	}
			set
			{
				this.SetShort(ProductsSchema.UnitsOnOrder.FieldName, value);
			}
		}
		public virtual short ReorderLevel
		{
			get
			{
				return this.GetShort(ProductsSchema.ReorderLevel.FieldName);
	    	}
			set
			{
				this.SetShort(ProductsSchema.ReorderLevel.FieldName, value);
			}
		}
		public virtual bool Discontinued
		{
			get
			{
				return this.GetBoolean(ProductsSchema.Discontinued.FieldName);
	    	}
			set
			{
				this.SetBoolean(ProductsSchema.Discontinued.FieldName, value);
			}
		}

		public override string TableName
		{
			get { return "Products"; }
		}
		
		#endregion		
		
		#region String Properties
		public virtual string s_ProductID
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.ProductID.FieldName) ? string.Empty : base.GetIntegerAsString(ProductsSchema.ProductID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.ProductID.FieldName);
			    else
			        this.ProductID = base.SetIntegerAsString(ProductsSchema.ProductID.FieldName, value);
			}
		}
		public virtual string s_ProductName
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.ProductName.FieldName) ? string.Empty : base.GetStringAsString(ProductsSchema.ProductName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.ProductName.FieldName);
			    else
			        this.ProductName = base.SetStringAsString(ProductsSchema.ProductName.FieldName, value);
			}
		}
		public virtual string s_SupplierID
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.SupplierID.FieldName) ? string.Empty : base.GetIntegerAsString(ProductsSchema.SupplierID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.SupplierID.FieldName);
			    else
			        this.SupplierID = base.SetIntegerAsString(ProductsSchema.SupplierID.FieldName, value);
			}
		}
		public virtual string s_CategoryID
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.CategoryID.FieldName) ? string.Empty : base.GetIntegerAsString(ProductsSchema.CategoryID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.CategoryID.FieldName);
			    else
			        this.CategoryID = base.SetIntegerAsString(ProductsSchema.CategoryID.FieldName, value);
			}
		}
		public virtual string s_QuantityPerUnit
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.QuantityPerUnit.FieldName) ? string.Empty : base.GetStringAsString(ProductsSchema.QuantityPerUnit.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.QuantityPerUnit.FieldName);
			    else
			        this.QuantityPerUnit = base.SetStringAsString(ProductsSchema.QuantityPerUnit.FieldName, value);
			}
		}
		public virtual string s_UnitPrice
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.UnitPrice.FieldName) ? string.Empty : base.GetDecimalAsString(ProductsSchema.UnitPrice.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.UnitPrice.FieldName);
			    else
			        this.UnitPrice = base.SetDecimalAsString(ProductsSchema.UnitPrice.FieldName, value);
			}
		}
		public virtual string s_UnitsInStock
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.UnitsInStock.FieldName) ? string.Empty : base.GetShortAsString(ProductsSchema.UnitsInStock.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.UnitsInStock.FieldName);
			    else
			        this.UnitsInStock = base.SetShortAsString(ProductsSchema.UnitsInStock.FieldName, value);
			}
		}
		public virtual string s_UnitsOnOrder
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.UnitsOnOrder.FieldName) ? string.Empty : base.GetShortAsString(ProductsSchema.UnitsOnOrder.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.UnitsOnOrder.FieldName);
			    else
			        this.UnitsOnOrder = base.SetShortAsString(ProductsSchema.UnitsOnOrder.FieldName, value);
			}
		}
		public virtual string s_ReorderLevel
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.ReorderLevel.FieldName) ? string.Empty : base.GetShortAsString(ProductsSchema.ReorderLevel.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.ReorderLevel.FieldName);
			    else
			        this.ReorderLevel = base.SetShortAsString(ProductsSchema.ReorderLevel.FieldName, value);
			}
		}
		public virtual string s_Discontinued
		{
			get
			{
			    return this.IsColumnNull(ProductsSchema.Discontinued.FieldName) ? string.Empty : base.GetBooleanAsString(ProductsSchema.Discontinued.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ProductsSchema.Discontinued.FieldName);
			    else
			        this.Discontinued = base.SetBooleanAsString(ProductsSchema.Discontinued.FieldName, value);
			}
		}
		#endregion		
	
		#region Where Clause
		public class WhereClause
		{
			public WhereClause(EasyObject entity)
			{
				this._entity = entity;
			}
			
			public TearOffWhereParameter TearOff
			{
				get
				{
					if(_tearOff == null)
					{
						_tearOff = new TearOffWhereParameter(this);
					}

					return _tearOff;
				}
			}

			#region TearOff's
			public class TearOffWhereParameter
			{
				public TearOffWhereParameter(WhereClause clause)
				{
					this._clause = clause;
				}
				
				
				public WhereParameter ProductID
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.ProductID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter ProductName
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.ProductName);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter SupplierID
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.SupplierID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter CategoryID
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.CategoryID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter QuantityPerUnit
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.QuantityPerUnit);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter UnitPrice
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.UnitPrice);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter UnitsInStock
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.UnitsInStock);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter UnitsOnOrder
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.UnitsOnOrder);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter ReorderLevel
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.ReorderLevel);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

				public WhereParameter Discontinued
				{
					get
					{
							WhereParameter wp = new WhereParameter(ProductsSchema.Discontinued);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}


				private WhereClause _clause;
			}
			#endregion
		
			public WhereParameter ProductID
		    {
				get
		        {
					if(_ProductID_W == null)
	        	    {
						_ProductID_W = TearOff.ProductID;
					}
					return _ProductID_W;
				}
			}

			public WhereParameter ProductName
		    {
				get
		        {
					if(_ProductName_W == null)
	        	    {
						_ProductName_W = TearOff.ProductName;
					}
					return _ProductName_W;
				}
			}

			public WhereParameter SupplierID
		    {
				get
		        {
					if(_SupplierID_W == null)
	        	    {
						_SupplierID_W = TearOff.SupplierID;
					}
					return _SupplierID_W;
				}
			}

			public WhereParameter CategoryID
		    {
				get
		        {
					if(_CategoryID_W == null)
	        	    {
						_CategoryID_W = TearOff.CategoryID;
					}
					return _CategoryID_W;
				}
			}

			public WhereParameter QuantityPerUnit
		    {
				get
		        {
					if(_QuantityPerUnit_W == null)
	        	    {
						_QuantityPerUnit_W = TearOff.QuantityPerUnit;
					}
					return _QuantityPerUnit_W;
				}
			}

			public WhereParameter UnitPrice
		    {
				get
		        {
					if(_UnitPrice_W == null)
	        	    {
						_UnitPrice_W = TearOff.UnitPrice;
					}
					return _UnitPrice_W;
				}
			}

			public WhereParameter UnitsInStock
		    {
				get
		        {
					if(_UnitsInStock_W == null)
	        	    {
						_UnitsInStock_W = TearOff.UnitsInStock;