_territories.cs

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

		{
			get { return "Territories"; }
		}
		
		#endregion		
		
		#region String Properties
		public virtual string s_TerritoryID
		{
			get
			{
			    return this.IsColumnNull(TerritoriesSchema.TerritoryID.FieldName) ? string.Empty : base.GetStringAsString(TerritoriesSchema.TerritoryID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(TerritoriesSchema.TerritoryID.FieldName);
			    else
			        this.TerritoryID = base.SetStringAsString(TerritoriesSchema.TerritoryID.FieldName, value);
			}
		}
		public virtual string s_TerritoryDescription
		{
			get
			{
			    return this.IsColumnNull(TerritoriesSchema.TerritoryDescription.FieldName) ? string.Empty : base.GetStringAsString(TerritoriesSchema.TerritoryDescription.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(TerritoriesSchema.TerritoryDescription.FieldName);
			    else
			        this.TerritoryDescription = base.SetStringAsString(TerritoriesSchema.TerritoryDescription.FieldName, value);
			}
		}
		public virtual string s_RegionID
		{
			get
			{
			    return this.IsColumnNull(TerritoriesSchema.RegionID.FieldName) ? string.Empty : base.GetIntegerAsString(TerritoriesSchema.RegionID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(TerritoriesSchema.RegionID.FieldName);
			    else
			        this.RegionID = base.SetIntegerAsString(TerritoriesSchema.RegionID.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 TerritoryID
				{
					get
					{
							WhereParameter wp = new WhereParameter(TerritoriesSchema.TerritoryID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

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

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


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

			public WhereParameter TerritoryDescription
		    {
				get
		        {
					if(_TerritoryDescription_W == null)
	        	    {
						_TerritoryDescription_W = TearOff.TerritoryDescription;
					}
					return _TerritoryDescription_W;
				}
			}

			public WhereParameter RegionID
		    {
				get
		        {
					if(_RegionID_W == null)
	        	    {
						_RegionID_W = TearOff.RegionID;
					}
					return _RegionID_W;
				}
			}

			private WhereParameter _TerritoryID_W = null;
			private WhereParameter _TerritoryDescription_W = null;
			private WhereParameter _RegionID_W = null;

			public void WhereClauseReset()
			{
				_TerritoryID_W = null;
				_TerritoryDescription_W = null;
				_RegionID_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 TerritoryID
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(TerritoriesSchema.TerritoryID);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

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

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


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

			public AggregateParameter TerritoryDescription
		    {
				get
		        {
					if(_TerritoryDescription_W == null)
	        	    {
						_TerritoryDescription_W = TearOff.TerritoryDescription;
					}
					return _TerritoryDescription_W;
				}
			}

			public AggregateParameter RegionID
		    {
				get
		        {
					if(_RegionID_W == null)
	        	    {
						_RegionID_W = TearOff.RegionID;
					}
					return _RegionID_W;
				}
			}

			private AggregateParameter _TerritoryID_W = null;
			private AggregateParameter _TerritoryDescription_W = null;
			private AggregateParameter _RegionID_W = null;

			public void AggregateClauseReset()
			{
				_TerritoryID_W = null;
				_TerritoryDescription_W = null;
				_RegionID_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
	}
}