Retrieves a collection of Products from the database using the supplied SQL FROM and WHERE criteria and parameters. The starting SQL is: SELECT Product.* FROM Product {0} WHERE 1 = 1 {1}. So any additional FROM criteria should look something like: ", Product_Function" or "INNER JOIN Product_Function ON Product.Product_Code = Product_Function.Product_Code" etc. Any additional WHERE criteria should start with AND, like: "AND Product.Product_Code = Product_Function.Product_Code" etc.

Namespace:  Asi.iBO.Commerce
Assembly:  Asi.iBO (in Asi.iBO.dll) Version: 15.1.2.0

Syntax

C#
public static Hashtable GetProducts(
	IiMISUser user,
	string additionalFrom,
	string where,
	SqlParameter[] parameters
)
Visual Basic (Declaration)
Public Shared Function GetProducts ( _
	user As IiMISUser, _
	additionalFrom As String, _
	where As String, _
	parameters As SqlParameter() _
) As Hashtable
Visual C++
public:
static Hashtable^ GetProducts(
	IiMISUser^ user, 
	String^ additionalFrom, 
	String^ where, 
	array<SqlParameter^>^ parameters
)

Parameters

user
Type: Asi.iBO..::.IiMISUser
The IiMISUser object providing the security credentials of the logged in user.
additionalFrom
Type: System..::.String
Any additional FROM criteria tacked onto "FROM Product ", or string.Empty if no additional tables are required.
where
Type: System..::.String
Any additional WHERE criteria tacked onto "WHERE 1 = 1 ", or string.Empty if no additional WHERE criteria is required.
parameters
Type: array< System.Data.SqlClient..::.SqlParameter >[]()[]
Bind variables for the WHERE criteria. Using bind variables is preferred over strings imbedded in the WHERE criteria. Send NULL if no bind variables are needed.

Return Value

A Hashtable consisting of

See Also