API GetPrices: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „API_GetPrices ( @CustomerID int @ProductIDs table ) Example Declare @ID dbo.IDsList INSERT INTO @ID SELECT top 1000 ID FROM API_GetProductGroups WIT…“) |
|||
| (Není zobrazeno 6 mezilehlých verzí od 2 dalších uživatelů.) | |||
| Řádka 1: | Řádka 1: | ||
| − | API_GetPrices | + | '''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 (<code>dbo.IDsList</code>) | |
| − | |||
Aktuální verze z 15. 11. 2018, 11: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)
