_suppliers.cs

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

				return this.GetString(SuppliersSchema.HomePage.FieldName);
	    	}
			set
			{
				this.SetString(SuppliersSchema.HomePage.FieldName, value);
			}
		}

		public override string TableName
		{
			get { return "Suppliers"; }
		}
		
		#endregion		
		
		#region String Properties
		public virtual string s_SupplierID
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.SupplierID.FieldName) ? string.Empty : base.GetIntegerAsString(SuppliersSchema.SupplierID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.SupplierID.FieldName);
			    else
			        this.SupplierID = base.SetIntegerAsString(SuppliersSchema.SupplierID.FieldName, value);
			}
		}
		public virtual string s_CompanyName
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.CompanyName.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.CompanyName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.CompanyName.FieldName);
			    else
			        this.CompanyName = base.SetStringAsString(SuppliersSchema.CompanyName.FieldName, value);
			}
		}
		public virtual string s_ContactName
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.ContactName.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.ContactName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.ContactName.FieldName);
			    else
			        this.ContactName = base.SetStringAsString(SuppliersSchema.ContactName.FieldName, value);
			}
		}
		public virtual string s_ContactTitle
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.ContactTitle.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.ContactTitle.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.ContactTitle.FieldName);
			    else
			        this.ContactTitle = base.SetStringAsString(SuppliersSchema.ContactTitle.FieldName, value);
			}
		}
		public virtual string s_Address
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.Address.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.Address.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.Address.FieldName);
			    else
			        this.Address = base.SetStringAsString(SuppliersSchema.Address.FieldName, value);
			}
		}
		public virtual string s_City
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.City.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.City.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.City.FieldName);
			    else
			        this.City = base.SetStringAsString(SuppliersSchema.City.FieldName, value);
			}
		}
		public virtual string s_Region
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.Region.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.Region.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.Region.FieldName);
			    else
			        this.Region = base.SetStringAsString(SuppliersSchema.Region.FieldName, value);
			}
		}
		public virtual string s_PostalCode
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.PostalCode.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.PostalCode.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.PostalCode.FieldName);
			    else
			        this.PostalCode = base.SetStringAsString(SuppliersSchema.PostalCode.FieldName, value);
			}
		}
		public virtual string s_Country
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.Country.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.Country.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.Country.FieldName);
			    else
			        this.Country = base.SetStringAsString(SuppliersSchema.Country.FieldName, value);
			}
		}
		public virtual string s_Phone
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.Phone.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.Phone.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.Phone.FieldName);
			    else
			        this.Phone = base.SetStringAsString(SuppliersSchema.Phone.FieldName, value);
			}
		}
		public virtual string s_Fax
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.Fax.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.Fax.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.Fax.FieldName);
			    else
			        this.Fax = base.SetStringAsString(SuppliersSchema.Fax.FieldName, value);
			}
		}
		public virtual string s_HomePage
		{
			get
			{
			    return this.IsColumnNull(SuppliersSchema.HomePage.FieldName) ? string.Empty : base.GetStringAsString(SuppliersSchema.HomePage.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(SuppliersSchema.HomePage.FieldName);
			    else
			        this.HomePage = base.SetStringAsString(SuppliersSchema.HomePage.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 SupplierID
				{
					get
					{
							WhereParameter wp = new WhereParameter(SuppliersSchema.SupplierID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

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

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

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

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

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

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

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

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

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

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

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


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

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

			public WhereParameter ContactName
		    {
				get
		        {
					if(_ContactName_W == null)
	        	    {
						_ContactName_W = TearOff.ContactName;
					}
					return _ContactName_W;
				}
			}

			public WhereParameter ContactTitle
		    {
				get
		        {
					if(_ContactTitle_W == null)
	        	    {
						_ContactTitle_W = TearOff.ContactTitle;
					}
					return _ContactTitle_W;
				}
			}

			public WhereParameter Address
		    {
				get
		        {
					if(_Address_W == null)
	        	    {
						_Address_W = TearOff.Address;
					}
					return _Address_W;
				}
			}

			public WhereParameter City
		    {
				get
		        {
					if(_City_W == null)
	        	    {
						_City_W = TearOff.City;
					}
					return _City_W;
				}
			}

			public WhereParameter Region
		    {
				get
		        {
					if(_Region_W == null)
	        	    {
						_Region_W = TearOff.Region;
					}
					return _Region_W;
				}
			}

			public WhereParameter PostalCode
		    {
				get
		        {
					if(_PostalCode_W == null)
	        	    {
						_PostalCode_W = TearOff.PostalCode;
					}
					return _PostalCode_W;
				}
			}

			public WhereParameter Country
		    {
				get
		        {
					if(_Country_W == null)
	        	    {
						_Country_W = TearOff.Country;
					}
					return _Country_W;
				}