_shippers.cs

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

		public override string TableName
		{
			get { return "Shippers"; }
		}
		
		#endregion		
		
		#region String Properties
		public virtual string s_ShipperID
		{
			get
			{
			    return this.IsColumnNull(ShippersSchema.ShipperID.FieldName) ? string.Empty : base.GetIntegerAsString(ShippersSchema.ShipperID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ShippersSchema.ShipperID.FieldName);
			    else
			        this.ShipperID = base.SetIntegerAsString(ShippersSchema.ShipperID.FieldName, value);
			}
		}
		public virtual string s_CompanyName
		{
			get
			{
			    return this.IsColumnNull(ShippersSchema.CompanyName.FieldName) ? string.Empty : base.GetStringAsString(ShippersSchema.CompanyName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ShippersSchema.CompanyName.FieldName);
			    else
			        this.CompanyName = base.SetStringAsString(ShippersSchema.CompanyName.FieldName, value);
			}
		}
		public virtual string s_Phone
		{
			get
			{
			    return this.IsColumnNull(ShippersSchema.Phone.FieldName) ? string.Empty : base.GetStringAsString(ShippersSchema.Phone.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(ShippersSchema.Phone.FieldName);
			    else
			        this.Phone = base.SetStringAsString(ShippersSchema.Phone.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 ShipperID
				{
					get
					{
							WhereParameter wp = new WhereParameter(ShippersSchema.ShipperID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

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

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


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

			public WhereParameter CompanyName
		    {
				get
		        {
					if(_CompanyName_W == null)
	        	    {
						_CompanyName_W = TearOff.CompanyName;
					}
					return _CompanyName_W;
				}
			}

			public WhereParameter Phone
		    {
				get
		        {
					if(_Phone_W == null)
	        	    {
						_Phone_W = TearOff.Phone;
					}
					return _Phone_W;
				}
			}

			private WhereParameter _ShipperID_W = null;
			private WhereParameter _CompanyName_W = null;
			private WhereParameter _Phone_W = null;

			public void WhereClauseReset()
			{
				_ShipperID_W = null;
				_CompanyName_W = null;
				_Phone_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 ShipperID
				{
					get
					{
							AggregateParameter ap = new AggregateParameter(ShippersSchema.ShipperID);
							this._clause._entity.Query.AddAggregateParameter(ap);
							return ap;
					}
				}

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

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


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

			public AggregateParameter CompanyName
		    {
				get
		        {
					if(_CompanyName_W == null)
	        	    {
						_CompanyName_W = TearOff.CompanyName;
					}
					return _CompanyName_W;
				}
			}

			public AggregateParameter Phone
		    {
				get
		        {
					if(_Phone_W == null)
	        	    {
						_Phone_W = TearOff.Phone;
					}
					return _Phone_W;
				}
			}

			private AggregateParameter _ShipperID_W = null;
			private AggregateParameter _CompanyName_W = null;
			private AggregateParameter _Phone_W = null;

			public void AggregateClauseReset()
			{
				_ShipperID_W = null;
				_CompanyName_W = null;
				_Phone_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
	}
}