_categories.cs

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

			    if(string.Empty == value)
			        this.SetColumnNull(CategoriesSchema.CategoryID.FieldName);
			    else
			        this.CategoryID = base.SetIntegerAsString(CategoriesSchema.CategoryID.FieldName, value);
			}
		}
		public virtual string s_CategoryName
		{
			get
			{
			    return this.IsColumnNull(CategoriesSchema.CategoryName.FieldName) ? string.Empty : base.GetStringAsString(CategoriesSchema.CategoryName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CategoriesSchema.CategoryName.FieldName);
			    else
			        this.CategoryName = base.SetStringAsString(CategoriesSchema.CategoryName.FieldName, value);
			}
		}
		public virtual string s_Description
		{
			get
			{
			    return this.IsColumnNull(CategoriesSchema.Description.FieldName) ? string.Empty : base.GetStringAsString(CategoriesSchema.Description.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(CategoriesSchema.Description.FieldName);
			    else
			        this.Description = base.SetStringAsString(CategoriesSchema.Description.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 CategoryID
				{
					get
					{
							WhereParameter wp = new WhereParameter(CategoriesSchema.CategoryID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

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

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

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


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

			public WhereParameter CategoryName
		    {
				get
		        {
					if(_CategoryName_W == null)
	        	    {
						_CategoryName_W = TearOff.CategoryName;
					}
					return _CategoryName_W;
				}
			}

			public WhereParameter Description
		    {
				get
		        {
					if(_Description_W == null)
	        	    {
						_Description_W = TearOff.Description;
					}
					return _Description_W;
				}
			}

			public WhereParameter Picture
		    {
				get
		        {
					if(_Picture_W == null)
	        	    {
						_Picture_W = TearOff.Picture;
					}
					return _Picture_W;
				}
			}

			private WhereParameter _CategoryID_W = null;
			private WhereParameter _CategoryName_W = null;
			private WhereParameter _Description_W = null;
			private WhereParameter _Picture_W = null;

			public void WhereClauseReset()
			{
				_CategoryID_W = null;
				_CategoryName_W = null;
				_Description_W = null;
				_Picture_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 CategoryID
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(CategoriesSchema.CategoryID);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

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

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

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


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

			public AggregateParameter CategoryName
		    {
				get
		        {
					if(_CategoryName_W == null)
	        	    {
						_CategoryName_W = TearOff.CategoryName;
					}
					return _CategoryName_W;
				}
			}

			public AggregateParameter Description
		    {
				get
		        {
					if(_Description_W == null)
	        	    {
						_Description_W = TearOff.Description;
					}
					return _Description_W;
				}
			}

			public AggregateParameter Picture
		    {
				get
		        {
					if(_Picture_W == null)
	        	    {
						_Picture_W = TearOff.Picture;
					}
					return _Picture_W;
				}
			}

			private AggregateParameter _CategoryID_W = null;
			private AggregateParameter _CategoryName_W = null;
			private AggregateParameter _Description_W = null;
			private AggregateParameter _Picture_W = null;

			public void AggregateClauseReset()
			{
				_CategoryID_W = null;
				_CategoryName_W = null;
				_Description_W = null;
				_Picture_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
	}
}