C# Class WestWind.NorthwindDB

Exibir arquivo Open project: subsonic/SubSonic-3.0-Templates Class Usage Examples

Public Methods

Method	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 method

public CustOrderHist ( string CustomerID ) : StoredProcedure
CustomerID	string
return	StoredProcedure

CustOrdersDetail() public method

public CustOrdersDetail ( int OrderID ) : StoredProcedure
OrderID	int
return	StoredProcedure

CustOrdersOrders() public method

public CustOrdersOrders ( string CustomerID ) : StoredProcedure
CustomerID	string
return	StoredProcedure

EmployeeSalesbyCountry() public method

public EmployeeSalesbyCountry ( System.DateTime Beginning_Date, System.DateTime Ending_Date ) : StoredProcedure
Beginning_Date	System.DateTime
Ending_Date	System.DateTime
return	StoredProcedure

SalesByCategory() public method

public SalesByCategory ( string CategoryName, string OrdYear ) : StoredProcedure
CategoryName	string
OrdYear	string
return	StoredProcedure

SalesbyYear() public method

public SalesbyYear ( System.DateTime Beginning_Date, System.DateTime Ending_Date ) : StoredProcedure
Beginning_Date	System.DateTime
Ending_Date	System.DateTime
return	StoredProcedure

TenMostExpensiveProducts() public method

public TenMostExpensiveProducts ( ) : StoredProcedure
return	StoredProcedure