_orders.cs

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

			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.OrderID.FieldName);
			    else
			        this.OrderID = base.SetIntegerAsString(OrdersSchema.OrderID.FieldName, value);
			}
		}
		public virtual string s_CustomerID
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.CustomerID.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.CustomerID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.CustomerID.FieldName);
			    else
			        this.CustomerID = base.SetStringAsString(OrdersSchema.CustomerID.FieldName, value);
			}
		}
		public virtual string s_EmployeeID
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.EmployeeID.FieldName) ? string.Empty : base.GetIntegerAsString(OrdersSchema.EmployeeID.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.EmployeeID.FieldName);
			    else
			        this.EmployeeID = base.SetIntegerAsString(OrdersSchema.EmployeeID.FieldName, value);
			}
		}
		public virtual string s_OrderDate
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.OrderDate.FieldName) ? string.Empty : base.GetDateTimeAsString(OrdersSchema.OrderDate.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.OrderDate.FieldName);
			    else
			        this.OrderDate = base.SetDateTimeAsString(OrdersSchema.OrderDate.FieldName, value);
			}
		}
		public virtual string s_RequiredDate
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.RequiredDate.FieldName) ? string.Empty : base.GetDateTimeAsString(OrdersSchema.RequiredDate.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.RequiredDate.FieldName);
			    else
			        this.RequiredDate = base.SetDateTimeAsString(OrdersSchema.RequiredDate.FieldName, value);
			}
		}
		public virtual string s_ShippedDate
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShippedDate.FieldName) ? string.Empty : base.GetDateTimeAsString(OrdersSchema.ShippedDate.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShippedDate.FieldName);
			    else
			        this.ShippedDate = base.SetDateTimeAsString(OrdersSchema.ShippedDate.FieldName, value);
			}
		}
		public virtual string s_ShipVia
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipVia.FieldName) ? string.Empty : base.GetIntegerAsString(OrdersSchema.ShipVia.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipVia.FieldName);
			    else
			        this.ShipVia = base.SetIntegerAsString(OrdersSchema.ShipVia.FieldName, value);
			}
		}
		public virtual string s_Freight
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.Freight.FieldName) ? string.Empty : base.GetDecimalAsString(OrdersSchema.Freight.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.Freight.FieldName);
			    else
			        this.Freight = base.SetDecimalAsString(OrdersSchema.Freight.FieldName, value);
			}
		}
		public virtual string s_ShipName
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipName.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.ShipName.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipName.FieldName);
			    else
			        this.ShipName = base.SetStringAsString(OrdersSchema.ShipName.FieldName, value);
			}
		}
		public virtual string s_ShipAddress
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipAddress.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.ShipAddress.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipAddress.FieldName);
			    else
			        this.ShipAddress = base.SetStringAsString(OrdersSchema.ShipAddress.FieldName, value);
			}
		}
		public virtual string s_ShipCity
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipCity.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.ShipCity.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipCity.FieldName);
			    else
			        this.ShipCity = base.SetStringAsString(OrdersSchema.ShipCity.FieldName, value);
			}
		}
		public virtual string s_ShipRegion
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipRegion.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.ShipRegion.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipRegion.FieldName);
			    else
			        this.ShipRegion = base.SetStringAsString(OrdersSchema.ShipRegion.FieldName, value);
			}
		}
		public virtual string s_ShipPostalCode
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipPostalCode.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.ShipPostalCode.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipPostalCode.FieldName);
			    else
			        this.ShipPostalCode = base.SetStringAsString(OrdersSchema.ShipPostalCode.FieldName, value);
			}
		}
		public virtual string s_ShipCountry
		{
			get
			{
			    return this.IsColumnNull(OrdersSchema.ShipCountry.FieldName) ? string.Empty : base.GetStringAsString(OrdersSchema.ShipCountry.FieldName);
			}
			set
			{
			    if(string.Empty == value)
			        this.SetColumnNull(OrdersSchema.ShipCountry.FieldName);
			    else
			        this.ShipCountry = base.SetStringAsString(OrdersSchema.ShipCountry.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 OrderID
				{
					get
					{
							WhereParameter wp = new WhereParameter(OrdersSchema.OrderID);
							this._clause._entity.Query.AddWhereParameter(wp);
							return wp;
					}
				}

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

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

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

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

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

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

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

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

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

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

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

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

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


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

			public WhereParameter CustomerID
		    {
				get
		        {
					if(_CustomerID_W == null)
	        	    {
						_CustomerID_W = TearOff.CustomerID;
					}
					return _CustomerID_W;
				}
			}

			public WhereParameter EmployeeID
		    {
				get
		        {
					if(_EmployeeID_W == null)
	        	    {
						_EmployeeID_W = TearOff.EmployeeID;
					}
					return _EmployeeID_W;
				}
			}

			public WhereParameter OrderDate
		    {
				get
		        {
					if(_OrderDate_W == null)
	        	    {
						_OrderDate_W = TearOff.OrderDate;
					}
					return _OrderDate_W;
				}
			}

			public WhereParameter RequiredDate
		    {
				get
		        {
					if(_RequiredDate_W == null)
	        	    {
						_RequiredDate_W = TearOff.RequiredDate;
					}
					return _RequiredDate_W;
				}
			}

			public WhereParameter ShippedDate
		    {
				get
		        {
					if(_ShippedDate_W == null)
	        	    {
						_ShippedDate_W = TearOff.ShippedDate;
					}
					return _ShippedDate_W;
				}
			}

			public WhereParameter ShipVia
		    {
				get
		        {
					if(_ShipVia_W == null)
	        	    {
						_ShipVia_W = TearOff.ShipVia;
					}
					return _ShipVia_W;
				}
			}

			public WhereParameter Freight
		    {
				get
		        {
					if(_Freight_W == null)
	        	    {
						_Freight_W = TearOff.Freight;
					}
					return _Freight_W;
				}
			}

			public WhereParameter ShipName
		    {
				get
		        {
					if(_ShipName_W == null)
	        	    {
						_ShipName_W = TearOff.ShipName;
					}
					return _ShipName_W;
				}
			}

			public WhereParameter ShipAddress
		    {
				get
		        {
					if(_ShipAddress_W == null)
	        	    {
						_ShipAddress_W = TearOff.ShipAddress;
					}
					return _ShipAddress_W;
				}
			}

			public WhereParameter ShipCity
		    {
				get
		        {
					if(_ShipCity_W == null)
	        	    {
						_ShipCity_W = TearOff.ShipCity;
					}
					return _ShipCity_W;
				}
			}