C# Class WestWind.NorthwindDB

Afficher le fichier Open project: subsonic/SubSonic-3.0-Templates Class Usage Examples

Méthodes publiques

Méthode Description
CustOrderHist ( string CustomerID ) : StoredProcedure
CustOrdersDetail ( int OrderID ) : StoredProcedure
CustOrdersOrders ( string CustomerID ) : StoredProcedure
EmployeeSalesbyCountry ( System.DateTime Beginning_Date, System.DateTime Ending_Date ) : StoredProcedure
SalesByCategory ( string CategoryName, string OrdYear ) : StoredProcedure
SalesbyYear ( System.DateTime Beginning_Date, System.DateTime Ending_Date ) : StoredProcedure
TenMostExpensiveProducts ( ) : StoredProcedure

Method Details

CustOrderHist() public méthode

public CustOrderHist ( string CustomerID ) : StoredProcedure
CustomerID string
Résultat StoredProcedure

CustOrdersDetail() public méthode

public CustOrdersDetail ( int OrderID ) : StoredProcedure
OrderID int
Résultat StoredProcedure

CustOrdersOrders() public méthode

public CustOrdersOrders ( string CustomerID ) : StoredProcedure
CustomerID string
Résultat StoredProcedure

EmployeeSalesbyCountry() public méthode

public EmployeeSalesbyCountry ( System.DateTime Beginning_Date, System.DateTime Ending_Date ) : StoredProcedure
Beginning_Date System.DateTime
Ending_Date System.DateTime
Résultat StoredProcedure

SalesByCategory() public méthode

public SalesByCategory ( string CategoryName, string OrdYear ) : StoredProcedure
CategoryName string
OrdYear string
Résultat StoredProcedure

SalesbyYear() public méthode

public SalesbyYear ( System.DateTime Beginning_Date, System.DateTime Ending_Date ) : StoredProcedure
Beginning_Date System.DateTime
Ending_Date System.DateTime
Résultat StoredProcedure

TenMostExpensiveProducts() public méthode

public TenMostExpensiveProducts ( ) : StoredProcedure
Résultat StoredProcedure