C# WsProxy.AdventureWorksServices类代码示例

		/// <summary>
		/// 	Gets rows from the datasource based on the IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID index.
		/// </summary>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="_referenceOrderId">Purchase order, sales order, or work order identification number.</param>
		/// <param name="_referenceOrderLineId">Line number associated with the purchase order, sales order, or work order.</param>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="count">out parameter to get total records for query</param>	
		/// <remarks></remarks>
		/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList&lt;TransactionHistoryArchive&gt;"/> class.</returns>
		public override Nettiers.AdventureWorks.Entities.TList<TransactionHistoryArchive> GetByReferenceOrderIdReferenceOrderLineId(TransactionManager transactionManager, System.Int32 _referenceOrderId, System.Int32 _referenceOrderLineId, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			WsProxy.TransactionHistoryArchive[] items = proxy.TransactionHistoryArchiveProvider_GetByReferenceOrderIdReferenceOrderLineId(_referenceOrderId, _referenceOrderLineId, start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		/// Gets a page of rows from the DataSource.
		/// </summary>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
		/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="count">Number of rows in the DataSource.</param>
		/// <remarks></remarks>
		/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.ErrorLog objects.</returns>
		public override Nettiers.AdventureWorks.Entities.TList<ErrorLog> GetPaged(TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, out int count)
		{
			try
			{
			whereClause = whereClause ?? string.Empty;
			orderBy = orderBy ?? string.Empty;
			
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			
			WsProxy.ErrorLog[] items = proxy.ErrorLogProvider_GetPaged(whereClause, orderBy, start, pageLength, out count);
			
			// Create a collection and fill it with the dataset
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		/// Lets you efficiently bulk many entity to the database.
		/// </summary>
		/// <param name="transactionManager">NOTE: The transaction manager should be null for the web service client implementation.</param>
		/// <param name="entityList">The entities.</param>
		/// <remarks>
		/// After inserting into the datasource, the Nettiers.AdventureWorks.Entities.ErrorLog object will be updated
		/// to refelect any changes made by the datasource. (ie: identity or computed columns)
		/// </remarks>
		public override void BulkInsert(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.TList<ErrorLog> entityList)
		{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			try
			{
				proxy.ErrorLogProvider_BulkInsert(Convert(entityList));
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch (Exception ex)
			{	
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		/// 	Gets rows from the datasource based on the IX_ProductReview_ProductID_Name index.
		/// </summary>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="_productId">Product identification number. Foreign key to Product.ProductID.</param>
		/// <param name="_reviewerName">Name of the reviewer.</param>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="count">out parameter to get total records for query</param>	
		/// <remarks></remarks>
		/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList&lt;ProductReview&gt;"/> class.</returns>
		public override Nettiers.AdventureWorks.Entities.TList<ProductReview> GetByProductIdReviewerName(TransactionManager transactionManager, System.Int32 _productId, System.String _reviewerName, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			WsProxy.ProductReview[] items = proxy.ProductReviewProvider_GetByProductIdReviewerName(_productId, _reviewerName, start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

			/// <summary>
			/// 	Deletes a row from the DataSource.
			/// </summary>
			/// <param name="_errorLogId">Primary key for ErrorLog records.. Primary Key.</param>	
            
			/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
			/// <remarks>Deletes based on primary key(s).</remarks>
			/// <returns>Returns true if operation suceeded.</returns>
			public override bool Delete(TransactionManager transactionManager, System.Int32 _errorLogId)
			{
				try
				{
				// call the proxy
				WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
				proxy.Url = Url;
				
				bool result = proxy.ErrorLogProvider_Delete(_errorLogId);				
				return result;
				}
				catch(SoapException soex)
				{
					System.Diagnostics.Debug.WriteLine(soex);
					throw soex;
				}
				catch(Exception ex)
				{
					System.Diagnostics.Debug.WriteLine(ex);
					throw ex;
				}
			}

		/// <summary>
		/// 	Gets rows from the datasource based on the FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID key.
		///		FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID Description: Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.
		/// </summary>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="_specialOfferId">Promotional code. Foreign key to SpecialOffer.SpecialOfferID.</param>
		/// <param name="_productId">Product sold to customer. Foreign key to Product.ProductID.</param>
		/// <param name="count">out parameter to get total records for query</param>	
		/// <remarks></remarks>		
		/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.SalesOrderDetail objects.</returns>
		public override Nettiers.AdventureWorks.Entities.TList<SalesOrderDetail> GetBySpecialOfferIdProductId(TransactionManager transactionManager, System.Int32 _specialOfferId, System.Int32 _productId, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			WsProxy.SalesOrderDetail[] items = proxy.SalesOrderDetailProvider_GetBySpecialOfferIdProductId(_specialOfferId, _productId, start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		/// 	Gets All rows from the DataSource.
		/// </summary>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="count">out parameter to get total records for query</param>			
		/// <remarks></remarks>
		/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.StateProvince objects.</returns>
		public override Nettiers.AdventureWorks.Entities.TList<StateProvince> GetAll(TransactionManager transactionManager, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
				
			WsProxy.StateProvince[] items = proxy.StateProvinceProvider_GetAll(start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

			/// <summary>
			/// 	Deletes a row from the DataSource.
			/// </summary>
			/// <param name="_salesPersonId">Primary key for SalesTerritoryHistory records.. Primary Key.</param>	
			/// <param name="_startDate">Date the sales representive started work in the territory.. Primary Key.</param>	
			/// <param name="_territoryId">Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.. Primary Key.</param>	
            
			/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
			/// <remarks>Deletes based on primary key(s).</remarks>
			/// <returns>Returns true if operation suceeded.</returns>
			public override bool Delete(TransactionManager transactionManager, System.Int32 _salesPersonId, System.DateTime _startDate, System.Int32 _territoryId)
			{
				try
				{
				// call the proxy
				WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
				proxy.Url = Url;
				
				bool result = proxy.SalesTerritoryHistoryProvider_Delete(_salesPersonId, _startDate, _territoryId);				
				return result;
				}
				catch(SoapException soex)
				{
					System.Diagnostics.Debug.WriteLine(soex);
					throw soex;
				}
				catch(Exception ex)
				{
					System.Diagnostics.Debug.WriteLine(ex);
					throw ex;
				}
			}

		/// <summary>
		/// 	Gets rows from the datasource based on the PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID index.
		/// </summary>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="_salesPersonId">Primary key for SalesTerritoryHistory records.</param>
		/// <param name="_startDate">Date the sales representive started work in the territory.</param>
		/// <param name="_territoryId">Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.</param>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="count">out parameter to get total records for query</param>	
		/// <remarks></remarks>
		/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.SalesTerritoryHistory"/> class.</returns>
		public override Nettiers.AdventureWorks.Entities.SalesTerritoryHistory GetBySalesPersonIdStartDateTerritoryId(TransactionManager transactionManager, System.Int32 _salesPersonId, System.DateTime _startDate, System.Int32 _territoryId, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			WsProxy.SalesTerritoryHistory items = proxy.SalesTerritoryHistoryProvider_GetBySalesPersonIdStartDateTerritoryId(_salesPersonId, _startDate, _territoryId, start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		///		Gets Store objects from the datasource by ContactID in the
		///		StoreContact table. Table Store is related to table Contact
		///		through the (M:N) relationship defined in the StoreContact table.
		/// </summary>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pagelen">Number of rows to return.</param>
		/// <param name="_contactId">Contact (store employee) identification number. Foreign key to Contact.ContactID.</param>
		/// <param name="count">Number of rows in the DataSource.</param>
		/// <remarks></remarks>
		/// <returns>Returns a typed collection of Store objects.</returns>
		public override TList<Store> GetByContactIdFromStoreContact(TransactionManager transactionManager, System.Int32 _contactId, int start, int pagelen, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
				
			WsProxy.Store[] items = proxy.StoreProvider_GetByContactIdFromStoreContact(_contactId, start, pagelen, out count);
	
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		/// 	Gets rows from the datasource based on the PK_TestIssue117TableC index.
		/// </summary>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="_testIssue117TableAid"></param>
		/// <param name="_testIssue117TableBid"></param>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="count">out parameter to get total records for query</param>	
		/// <remarks></remarks>
		/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TestIssue117Tablec"/> class.</returns>
		public override Nettiers.AdventureWorks.Entities.TestIssue117Tablec GetByTestIssue117TableAidTestIssue117TableBid(TransactionManager transactionManager, System.Int32 _testIssue117TableAid, System.Int32 _testIssue117TableBid, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			WsProxy.TestIssue117Tablec items = proxy.TestIssue117TablecProvider_GetByTestIssue117TableAidTestIssue117TableBid(_testIssue117TableAid, _testIssue117TableBid, start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		///		Gets TestIssue117TableA objects from the datasource by TestIssue117TableBId in the
		///		TestIssue117TableC table. Table TestIssue117TableA is related to table TestIssue117TableB
		///		through the (M:N) relationship defined in the TestIssue117TableC table.
		/// </summary>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pagelen">Number of rows to return.</param>
		/// <param name="_testIssue117TableBid"></param>
		/// <param name="count">Number of rows in the DataSource.</param>
		/// <remarks></remarks>
		/// <returns>Returns a typed collection of TestIssue117TableA objects.</returns>
		public override TList<TestIssue117Tablea> GetByTestIssue117TableBidFromTestIssue117Tablec(TransactionManager transactionManager, System.Int32 _testIssue117TableBid, int start, int pagelen, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
				
			WsProxy.TestIssue117Tablea[] items = proxy.TestIssue117TableaProvider_GetByTestIssue117TableBidFromTestIssue117Tablec(_testIssue117TableBid, start, pagelen, out count);
	
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		///		Gets CountryRegion objects from the datasource by CurrencyCode in the
		///		CountryRegionCurrency table. Table CountryRegion is related to table Currency
		///		through the (M:N) relationship defined in the CountryRegionCurrency table.
		/// </summary>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pagelen">Number of rows to return.</param>
		/// <param name="_currencyCode">ISO standard currency code. Foreign key to Currency.CurrencyCode.</param>
		/// <param name="count">Number of rows in the DataSource.</param>
		/// <remarks></remarks>
		/// <returns>Returns a typed collection of CountryRegion objects.</returns>
		public override TList<CountryRegion> GetByCurrencyCodeFromCountryRegionCurrency(TransactionManager transactionManager, System.String _currencyCode, int start, int pagelen, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
				
			WsProxy.CountryRegion[] items = proxy.CountryRegionProvider_GetByCurrencyCodeFromCountryRegionCurrency(_currencyCode, start, pagelen, out count);
	
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		/// 	Gets rows from the datasource based on the FK_NullFKeyChild_NullFKeyParent key.
		///		FK_NullFKeyChild_NullFKeyParent Description: 
		/// </summary>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pageLength">Number of rows to return.</param>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="_nullFkeyParentId"></param>
		/// <param name="count">out parameter to get total records for query</param>	
		/// <remarks></remarks>		
		/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.NullFkeyChild objects.</returns>
		public override Nettiers.AdventureWorks.Entities.TList<NullFkeyChild> GetByNullFkeyParentId(TransactionManager transactionManager, System.Int32? _nullFkeyParentId, int start, int pageLength, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
			WsProxy.NullFkeyChild[] items = proxy.NullFkeyChildProvider_GetByNullFkeyParentId(_nullFkeyParentId, start, pageLength, out count);
			
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}

		/// <summary>
		///		Gets ProductModel objects from the datasource by ProductDescriptionID in the
		///		ProductModelProductDescriptionCulture table. Table ProductModel is related to table ProductDescription
		///		through the (M:N) relationship defined in the ProductModelProductDescriptionCulture table.
		/// </summary>
		/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
		/// <param name="start">Row number at which to start reading.</param>
		/// <param name="pagelen">Number of rows to return.</param>
		/// <param name="_productDescriptionId">Primary key. Foreign key to ProductDescription.ProductDescriptionID.</param>
		/// <param name="count">Number of rows in the DataSource.</param>
		/// <remarks></remarks>
		/// <returns>Returns a typed collection of ProductModel objects.</returns>
		public override TList<ProductModel> GetByProductDescriptionIdFromProductModelProductDescriptionCulture(TransactionManager transactionManager, System.Int32 _productDescriptionId, int start, int pagelen, out int count)
		{
			try
			{
			WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
			proxy.Url = Url;
				
			WsProxy.ProductModel[] items = proxy.ProductModelProvider_GetByProductDescriptionIdFromProductModelProductDescriptionCulture(_productDescriptionId, start, pagelen, out count);
	
			return Convert(items); 
			}
			catch(SoapException soex)
			{
				System.Diagnostics.Debug.WriteLine(soex);
				throw soex;
			}
			catch(Exception ex)
			{
				System.Diagnostics.Debug.WriteLine(ex);
				throw ex;
			}
		}