C# Класс Nettiers.AdventureWorks.Data.WebServiceClient.WsProductProviderBase

This class is the webservice client implementation that exposes CRUD methods for Nettiers.AdventureWorks.Entities.Product objects.
Наследование: ProductProviderBase
Показать файл Открыть проект

Открытые методы

Метод Описание
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