C# 클래스 Nettiers.AdventureWorks.Data.WebServiceClient.WsProductProviderBase

This class is the webservice client implementation that exposes CRUD methods for Nettiers.AdventureWorks.Entities.Product objects.

상속: ProductProviderBase

파일 보기 프로젝트 열기: netTiers/netTiers

공개 메소드들

메소드	설명
BulkInsert ( TransactionManager transactionManager, Nettiers entityList ) : void	Lets you efficiently bulk many entity to the database. After inserting into the datasource, the Nettiers.AdventureWorks.Entities.Product object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns)
Convert ( Nettiers outItem, WsProxy item ) : Product	Convert a nettiers collection to the ws proxy collection.
Convert ( WsProxy item ) : Product	Convert a nettiers collection to the ws proxy collection.
Convert ( WsProxy items ) : Nettiers.AdventureWorks.Entities.TList	Convert a collection from the ws proxy to a nettiers collection.
Convert ( Nettiers item ) : WsProxy.Product	Convert a nettiers entity to the ws proxy entity.
Convert ( Nettiers items ) : WsProxy.Product[]	Convert a collection from to a nettiers collection to a the ws proxy collection.
Delete ( TransactionManager transactionManager, System _productId ) : bool	Deletes based on primary key(s).
Find ( TransactionManager transactionManager, string whereClause, int start, int pagelen, int &count ) : Nettiers.AdventureWorks.Entities.TList	Returns rows meeting the whereclause condition from the DataSource. Operators must be capitalized (OR, AND)
GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList	Gets All rows from the DataSource.
GetByDocumentIdFromProductDocument ( TransactionManager transactionManager, System _documentId, int start, int pagelen, int &count ) : TList	Gets Product objects from the datasource by DocumentID in the ProductDocument table. Table Product is related to table Document through the (M:N) relationship defined in the ProductDocument table.
GetByLocationIdFromProductInventory ( TransactionManager transactionManager, System _locationId, int start, int pagelen, int &count ) : TList	Gets Product objects from the datasource by LocationID in the ProductInventory table. Table Product is related to table Location through the (M:N) relationship defined in the ProductInventory table.
GetByName ( TransactionManager transactionManager, System _name, int start, int pageLength, int &count ) : Product	Gets rows from the datasource based on the AK_Product_Name index.
GetByProductId ( TransactionManager transactionManager, System _productId, int start, int pageLength, int &count ) : Product	Gets rows from the datasource based on the PK_Product_ProductID index.
GetByProductModelId ( TransactionManager transactionManager, System _productModelId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList	Gets rows from the datasource based on the FK_Product_ProductModel_ProductModelID key. FK_Product_ProductModel_ProductModelID Description: Foreign key constraint referencing ProductModel.ProductModelID.
GetByProductNumber ( TransactionManager transactionManager, System _productNumber, int start, int pageLength, int &count ) : Product	Gets rows from the datasource based on the AK_Product_ProductNumber index.
GetByProductPhotoIdFromProductProductPhoto ( TransactionManager transactionManager, System _productPhotoId, int start, int pagelen, int &count ) : TList	Gets Product objects from the datasource by ProductPhotoID in the ProductProductPhoto table. Table Product is related to table ProductPhoto through the (M:N) relationship defined in the ProductProductPhoto table.
GetByProductSubcategoryId ( TransactionManager transactionManager, System _productSubcategoryId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList	Gets rows from the datasource based on the FK_Product_ProductSubcategory_ProductSubcategoryID key. FK_Product_ProductSubcategory_ProductSubcategoryID Description: Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.
GetByRowguid ( TransactionManager transactionManager, System _rowguid, int start, int pageLength, int &count ) : Product	Gets rows from the datasource based on the AK_Product_rowguid index.
GetBySizeUnitMeasureCode ( TransactionManager transactionManager, System _sizeUnitMeasureCode, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList	Gets rows from the datasource based on the FK_Product_UnitMeasure_SizeUnitMeasureCode key. FK_Product_UnitMeasure_SizeUnitMeasureCode Description: Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
GetBySpecialOfferIdFromSpecialOfferProduct ( TransactionManager transactionManager, System _specialOfferId, int start, int pagelen, int &count ) : TList	Gets Product objects from the datasource by SpecialOfferID in the SpecialOfferProduct table. Table Product is related to table SpecialOffer through the (M:N) relationship defined in the SpecialOfferProduct table.
GetByVendorIdFromProductVendor ( TransactionManager transactionManager, System _vendorId, int start, int pagelen, int &count ) : TList	Gets Product objects from the datasource by VendorID in the ProductVendor table. Table Product is related to table Vendor through the (M:N) relationship defined in the ProductVendor table.
GetByWeightUnitMeasureCode ( TransactionManager transactionManager, System _weightUnitMeasureCode, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList	Gets rows from the datasource based on the FK_Product_UnitMeasure_WeightUnitMeasureCode key. FK_Product_UnitMeasure_WeightUnitMeasureCode Description: Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
GetPaged ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList	Gets a page of rows from the DataSource.
Insert ( TransactionManager transactionManager, Nettiers entity ) : bool	Inserts a Nettiers.AdventureWorks.Entities.Product object into the datasource using a transaction.
Update ( TransactionManager transactionManager, Nettiers entity ) : bool	Update an existing row in the datasource.
WsProductProviderBase ( ) : System	Creates a new WsProductProviderBase instance. Uses connection string to connect to datasource.
WsProductProviderBase ( string url ) : System	Creates a new WsProductProviderBase instance. Uses connection string to connect to datasource.

메소드 상세

BulkInsert() 공개 메소드

Lets you efficiently bulk many entity to the database.

After inserting into the datasource, the Nettiers.AdventureWorks.Entities.Product object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns)

public BulkInsert ( TransactionManager transactionManager, Nettiers entityList ) : void
transactionManager	TransactionManager	NOTE: The transaction manager should be null for the web service client implementation.
entityList	Nettiers	The entities.
리턴	void

Convert() 공개 정적인 메소드

Convert a nettiers collection to the ws proxy collection.

public static Convert ( Nettiers outItem, WsProxy item ) : Product
outItem	Nettiers
item	WsProxy
리턴	Nettiers.AdventureWorks.Entities.Product

Convert() 공개 정적인 메소드

Convert a nettiers collection to the ws proxy collection.

public static Convert ( WsProxy item ) : Product
item	WsProxy
리턴	Nettiers.AdventureWorks.Entities.Product

Convert() 공개 정적인 메소드

Convert a collection from the ws proxy to a nettiers collection.

public static Convert ( WsProxy items ) : Nettiers.AdventureWorks.Entities.TList
items	WsProxy
리턴	Nettiers.AdventureWorks.Entities.TList

Convert() 공개 정적인 메소드

Convert a nettiers entity to the ws proxy entity.

public static Convert ( Nettiers item ) : WsProxy.Product
item	Nettiers
리턴	WsProxy.Product

Convert() 공개 정적인 메소드

Convert a collection from to a nettiers collection to a the ws proxy collection.

public static Convert ( Nettiers items ) : WsProxy.Product[]
items	Nettiers
리턴	WsProxy.Product[]

Delete() 공개 메소드

Deletes based on primary key(s).

public Delete ( TransactionManager transactionManager, System _productId ) : bool
transactionManager	TransactionManager	object
_productId	System
리턴	bool

Find() 공개 메소드

Returns rows meeting the whereclause condition from the DataSource.

Operators must be capitalized (OR, AND)

public Find ( TransactionManager transactionManager, string whereClause, int start, int pagelen, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
whereClause	string	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').
start	int	Row number at which to start reading.
pagelen	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	Nettiers.AdventureWorks.Entities.TList

GetAll() 공개 메소드

Gets All rows from the DataSource.

public GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.TList

GetByDocumentIdFromProductDocument() 공개 메소드

Gets Product objects from the datasource by DocumentID in the ProductDocument table. Table Product is related to table Document through the (M:N) relationship defined in the ProductDocument table.

public GetByDocumentIdFromProductDocument ( TransactionManager transactionManager, System _documentId, int start, int pagelen, int &count ) : TList
transactionManager	TransactionManager	object
_documentId	System	Document identification number. Foreign key to Document.DocumentID.
start	int	Row number at which to start reading.
pagelen	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	TList

GetByLocationIdFromProductInventory() 공개 메소드

Gets Product objects from the datasource by LocationID in the ProductInventory table. Table Product is related to table Location through the (M:N) relationship defined in the ProductInventory table.

public GetByLocationIdFromProductInventory ( TransactionManager transactionManager, System _locationId, int start, int pagelen, int &count ) : TList
transactionManager	TransactionManager	object
_locationId	System	Inventory location identification number. Foreign key to Location.LocationID.
start	int	Row number at which to start reading.
pagelen	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	TList

GetByName() 공개 메소드

Gets rows from the datasource based on the AK_Product_Name index.

public GetByName ( TransactionManager transactionManager, System _name, int start, int pageLength, int &count ) : Product
transactionManager	TransactionManager	object
_name	System	Name of the product.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.Product

GetByProductId() 공개 메소드

Gets rows from the datasource based on the PK_Product_ProductID index.

public GetByProductId ( TransactionManager transactionManager, System _productId, int start, int pageLength, int &count ) : Product
transactionManager	TransactionManager	object
_productId	System	Primary key for Product records.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.Product

GetByProductModelId() 공개 메소드

Gets rows from the datasource based on the FK_Product_ProductModel_ProductModelID key. FK_Product_ProductModel_ProductModelID Description: Foreign key constraint referencing ProductModel.ProductModelID.

public GetByProductModelId ( TransactionManager transactionManager, System _productModelId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
_productModelId	System	Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.TList

GetByProductNumber() 공개 메소드

Gets rows from the datasource based on the AK_Product_ProductNumber index.

public GetByProductNumber ( TransactionManager transactionManager, System _productNumber, int start, int pageLength, int &count ) : Product
transactionManager	TransactionManager	object
_productNumber	System	Unique product identification number.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.Product

GetByProductPhotoIdFromProductProductPhoto() 공개 메소드

Gets Product objects from the datasource by ProductPhotoID in the ProductProductPhoto table. Table Product is related to table ProductPhoto through the (M:N) relationship defined in the ProductProductPhoto table.

public GetByProductPhotoIdFromProductProductPhoto ( TransactionManager transactionManager, System _productPhotoId, int start, int pagelen, int &count ) : TList
transactionManager	TransactionManager	object
_productPhotoId	System	Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
start	int	Row number at which to start reading.
pagelen	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	TList

GetByProductSubcategoryId() 공개 메소드

Gets rows from the datasource based on the FK_Product_ProductSubcategory_ProductSubcategoryID key. FK_Product_ProductSubcategory_ProductSubcategoryID Description: Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.

public GetByProductSubcategoryId ( TransactionManager transactionManager, System _productSubcategoryId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
_productSubcategoryId	System	Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.TList

GetByRowguid() 공개 메소드

Gets rows from the datasource based on the AK_Product_rowguid index.

public GetByRowguid ( TransactionManager transactionManager, System _rowguid, int start, int pageLength, int &count ) : Product
transactionManager	TransactionManager	object
_rowguid	System	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.Product

GetBySizeUnitMeasureCode() 공개 메소드

Gets rows from the datasource based on the FK_Product_UnitMeasure_SizeUnitMeasureCode key. FK_Product_UnitMeasure_SizeUnitMeasureCode Description: Foreign key constraint referencing UnitMeasure.UnitMeasureCode.

public GetBySizeUnitMeasureCode ( TransactionManager transactionManager, System _sizeUnitMeasureCode, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
_sizeUnitMeasureCode	System	Unit of measure for Size column.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.TList

GetBySpecialOfferIdFromSpecialOfferProduct() 공개 메소드

Gets Product objects from the datasource by SpecialOfferID in the SpecialOfferProduct table. Table Product is related to table SpecialOffer through the (M:N) relationship defined in the SpecialOfferProduct table.

public GetBySpecialOfferIdFromSpecialOfferProduct ( TransactionManager transactionManager, System _specialOfferId, int start, int pagelen, int &count ) : TList
transactionManager	TransactionManager	object
_specialOfferId	System	Primary key for SpecialOfferProduct records.
start	int	Row number at which to start reading.
pagelen	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	TList

GetByVendorIdFromProductVendor() 공개 메소드

Gets Product objects from the datasource by VendorID in the ProductVendor table. Table Product is related to table Vendor through the (M:N) relationship defined in the ProductVendor table.

public GetByVendorIdFromProductVendor ( TransactionManager transactionManager, System _vendorId, int start, int pagelen, int &count ) : TList
transactionManager	TransactionManager	object
_vendorId	System	Primary key. Foreign key to Vendor.VendorID.
start	int	Row number at which to start reading.
pagelen	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	TList

GetByWeightUnitMeasureCode() 공개 메소드

Gets rows from the datasource based on the FK_Product_UnitMeasure_WeightUnitMeasureCode key. FK_Product_UnitMeasure_WeightUnitMeasureCode Description: Foreign key constraint referencing UnitMeasure.UnitMeasureCode.

public GetByWeightUnitMeasureCode ( TransactionManager transactionManager, System _weightUnitMeasureCode, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
_weightUnitMeasureCode	System	Unit of measure for Weight column.
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	out parameter to get total records for query
리턴	Nettiers.AdventureWorks.Entities.TList

GetPaged() 공개 메소드

Gets a page of rows from the DataSource.

public GetPaged ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager	TransactionManager	object
whereClause	string	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').
orderBy	string	Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);
start	int	Row number at which to start reading.
pageLength	int	Number of rows to return.
count	int	Number of rows in the DataSource.
리턴	Nettiers.AdventureWorks.Entities.TList

Insert() 공개 메소드

Inserts a Nettiers.AdventureWorks.Entities.Product object into the datasource using a transaction.

public Insert ( TransactionManager transactionManager, Nettiers entity ) : bool
transactionManager	TransactionManager	object
entity	Nettiers	Nettiers.AdventureWorks.Entities.Product object to insert.
리턴	bool

Update() 공개 메소드

Update an existing row in the datasource.

public Update ( TransactionManager transactionManager, Nettiers entity ) : bool
transactionManager	TransactionManager	object
entity	Nettiers	Nettiers.AdventureWorks.Entities.Product object to update.
리턴	bool

WsProductProviderBase() 공개 메소드

Creates a new WsProductProviderBase instance. Uses connection string to connect to datasource.

public WsProductProviderBase ( ) : System
리턴	System

WsProductProviderBase() 공개 메소드

Creates a new WsProductProviderBase instance. Uses connection string to connect to datasource.

public WsProductProviderBase ( string url ) : System
url	string	The url to the nettiers webservice.
리턴	System