_products.cs

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

					}
					return _UnitsInStock_W;
				}
			}

			public WhereParameter UnitsOnOrder
		    {
				get
		        {
					if(_UnitsOnOrder_W == null)
	        	    {
						_UnitsOnOrder_W = TearOff.UnitsOnOrder;
					}
					return _UnitsOnOrder_W;
				}
			}

			public WhereParameter ReorderLevel
		    {
				get
		        {
					if(_ReorderLevel_W == null)
	        	    {
						_ReorderLevel_W = TearOff.ReorderLevel;
					}
					return _ReorderLevel_W;
				}
			}

			public WhereParameter Discontinued
		    {
				get
		        {
					if(_Discontinued_W == null)
	        	    {
						_Discontinued_W = TearOff.Discontinued;
					}
					return _Discontinued_W;
				}
			}

			private WhereParameter _ProductID_W = null;
			private WhereParameter _ProductName_W = null;
			private WhereParameter _SupplierID_W = null;
			private WhereParameter _CategoryID_W = null;
			private WhereParameter _QuantityPerUnit_W = null;
			private WhereParameter _UnitPrice_W = null;
			private WhereParameter _UnitsInStock_W = null;
			private WhereParameter _UnitsOnOrder_W = null;
			private WhereParameter _ReorderLevel_W = null;
			private WhereParameter _Discontinued_W = null;

			public void WhereClauseReset()
			{
				_ProductID_W = null;
				_ProductName_W = null;
				_SupplierID_W = null;
				_CategoryID_W = null;
				_QuantityPerUnit_W = null;
				_UnitPrice_W = null;
				_UnitsInStock_W = null;
				_UnitsOnOrder_W = null;
				_ReorderLevel_W = null;
				_Discontinued_W = null;

				this._entity.Query.FlushWhereParameters();

			}
	
			private EasyObject _entity;
			private TearOffWhereParameter _tearOff;
			
		}
	
		public WhereClause Where
		{
			get
			{
				if(_whereClause == null)
				{
					_whereClause = new WhereClause(this);
				}
		
				return _whereClause;
			}
		}
		
		private WhereClause _whereClause = null;	
		#endregion
		
		#region Aggregate Clause
		public class AggregateClause
		{
			public AggregateClause(EasyObject entity)
			{
				this._entity = entity;
			}
			
			public TearOffAggregateParameter TearOff
			{
				get
				{
					if(_tearOff == null)
					{
						_tearOff = new TearOffAggregateParameter(this);
					}

					return _tearOff;
				}
			}

			#region TearOff's
			public class TearOffAggregateParameter
			{
				public TearOffAggregateParameter(AggregateClause clause)
				{
					this._clause = clause;
				}
				
				
				public AggregateParameter ProductID
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.ProductID);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter ProductName
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.ProductName);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter SupplierID
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.SupplierID);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter CategoryID
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.CategoryID);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter QuantityPerUnit
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.QuantityPerUnit);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter UnitPrice
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.UnitPrice);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter UnitsInStock
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.UnitsInStock);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter UnitsOnOrder
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.UnitsOnOrder);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter ReorderLevel
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.ReorderLevel);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

				public AggregateParameter Discontinued
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ProductsSchema.Discontinued);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}


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

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

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

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

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

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

			public AggregateParameter UnitsInStock
		    {
				get
		        {
					if(_UnitsInStock_W == null)
	        	    {
						_UnitsInStock_W = TearOff.UnitsInStock;
					}
					return _UnitsInStock_W;
				}
			}

			public AggregateParameter UnitsOnOrder
		    {
				get
		        {
					if(_UnitsOnOrder_W == null)
	        	    {
						_UnitsOnOrder_W = TearOff.UnitsOnOrder;
					}
					return _UnitsOnOrder_W;
				}
			}

			public AggregateParameter ReorderLevel
		    {
				get
		        {
					if(_ReorderLevel_W == null)
	        	    {
						_ReorderLevel_W = TearOff.ReorderLevel;
					}
					return _ReorderLevel_W;
				}
			}

			public AggregateParameter Discontinued
		    {
				get
		        {
					if(_Discontinued_W == null)
	        	    {
						_Discontinued_W = TearOff.Discontinued;
					}
					return _Discontinued_W;
				}
			}

			private AggregateParameter _ProductID_W = null;
			private AggregateParameter _ProductName_W = null;
			private AggregateParameter _SupplierID_W = null;
			private AggregateParameter _CategoryID_W = null;
			private AggregateParameter _QuantityPerUnit_W = null;
			private AggregateParameter _UnitPrice_W = null;
			private AggregateParameter _UnitsInStock_W = null;
			private AggregateParameter _UnitsOnOrder_W = null;
			private AggregateParameter _ReorderLevel_W = null;
			private AggregateParameter _Discontinued_W = null;

			public void AggregateClauseReset()
			{
				_ProductID_W = null;
				_ProductName_W = null;
				_SupplierID_W = null;
				_CategoryID_W = null;
				_QuantityPerUnit_W = null;
				_UnitPrice_W = null;
				_UnitsInStock_W = null;
				_UnitsOnOrder_W = null;
				_ReorderLevel_W = null;
				_Discontinued_W = null;

				this._entity.Query.FlushAggregateParameters();

			}
	
			private EasyObject _entity;
			private TearOffAggregateParameter _tearOff;
			
		}
	
		public AggregateClause Aggregate
		{
			get
			{
				if(_aggregateClause == null)
				{
					_aggregateClause = new AggregateClause(this);
				}
		
				return _aggregateClause;
			}
		}
		
		private AggregateClause _aggregateClause = null;	
		#endregion
	}
}