API GetPrices: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 1: | Řádek 1: | ||
'''API_GetPrices''' | '''API_GetPrices''' | ||
@CustomerID int - API_GetCustomers.ID, | @CustomerID int - API_GetCustomers.ID, | ||
@UseEshopDiscount - Use Eshop Discount (0-OFF, 1-ON) | |||
@ProductIDs table - API_GetProductGroups.ID | @ProductIDs table - API_GetProductGroups.ID | ||
| Řádek 13: | Řádek 14: | ||
EXEC '''Api_getprices''' | EXEC '''Api_getprices''' | ||
@CustomerID = 2, | @CustomerID = 2, | ||
@UseEshopDiscount = 1, | |||
@ProductIDs = @ID | @ProductIDs = @ID | ||
==== Notice ==== | ==== Notice ==== | ||
Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>) | Price calculation function uses own data type called IDsList (<code>dbo.IDsList</code>) | ||
Aktuální verze z 15. 11. 2018, 10:20
API_GetPrices
@CustomerID int - API_GetCustomers.ID, @UseEshopDiscount - Use Eshop Discount (0-OFF, 1-ON) @ProductIDs table - API_GetProductGroups.ID
Example:
DECLARE @ID dbo.IDSLIST INSERT INTO @ID SELECT TOP 1000 id FROM api_getproductgroups WHERE tecdocbrandname = 'WALKER' EXEC Api_getprices @CustomerID = 2, @UseEshopDiscount = 1, @ProductIDs = @ID
Notice
Price calculation function uses own data type called IDsList (dbo.IDsList)