Chrzaszcz v 22. 9. 2017, 08:22

2017-09-22T08:22:31Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update uasket item in system. ==== Exact name ==== `API_UpdateBasketItem` ==== Type ==== Standard e…“

2017-08-02T08:21:53Z

Založena nová stránka s textem „==== Description ==== Method allows You to update uasket item in system. ==== Exact name ==== <code>API_UpdateBasketItem</code> ==== Type ==== Standard e…“

Nová stránka

==== Description ====
Method allows You to update uasket item in system.

==== Exact name ====
<code>API_UpdateBasketItem</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@CustomerID
|int
|
|ID of customer from customers list (see relation)
|API_GetCustomers.ID
|-
|@CustomerWorkshopID
|int
|
|ID of workshops from workshops list (see relation)
|API_GetWorkshops.ID = API_GetCustomers.WorkshopID
|-
|@GroupID
|int
|
|ID of product groups from product groups list (see relation)
|API_GetProductGroups.ID
|-
|@ProductID
|int
|
|ID of product from product list (see relation)
|API_GetProducts.ID
|-
|@StorageCardID
|int
|
|ID of stock dispositions from stock dispositions list (see relation)
|API_GetStockDispositions.ID
|-
|@OrderID
|int
|
|ID of orders from orders list (see relation)
|API_GetOrders.ID
|-
|@GroupCode
|nvarchar(40)
|
|Group code
|
|-
|@ProductCode
|nvarchar(40)
|
|Product code
|
|-
|@ManufacturerCode
|nvarchar(40)
|
|Manufacturer code
|
|-
|@SupplierCode
|nvarchar(40)
|
|Supplier code
|
|-
|@Brand
|nvarchar(50)
|
|Brand
|
|-
|@Desription
|nvarchar(250)
|
|Desription
|
|-
|@OrderedQuantity
|decimal(18,2)
|
|Ordered quantity
|
|-
|@PricePerPiece
|decimal(18,3)
|
|Price per piece
|
|-
|@PricePerPieceWithVAT
|decimal(18,3)
|
|Price per piece with VAT
|
|-
|@PurchasePricePerPiece
|decimal(18,3)
|
|Purchase price per piece
|
|-
|@PurchasePricePerPieceWithVAT
|decimal(18,3)
|
|Purchase price per piece with VAT
|
|-
|@TotalPrice
|decimal(18,3)
|
|Total price
|
|-
|@TotalPriceWithVAT
|decimal(18,3)
|
|Total price with VAT
|
|-
|@TotalPurchasePrice
|decimal(18,3)
|
|Total purchase Price
|
|-
|@TotalPurchasePriceWithVAT
|decimal(18,3)
|
|Total purchase price with VAT
|
|-
|@DiscountInPercent
|decimal(18,3)
|
|DiscountIn percent
|
|-
|@DiscountPrice
|decimal(18,3)
|
|Discount price
|
|-
|@SurchargesPrice
|decimal(18,2)
|
|Surcharges price
|
|-
|@SurchargePriceWithVAT
|decimal(18,2)
|
|Surcharge price with VAT
|
|-
|@PricePerPieceInCurrency
|decimal(18,3)
|
|Price per piece in currency
|
|-
|@PricePerPieceWithVATInCurrency
|decimal(18,3)
|
|Price per piece with VAT in currency
|
|-
|@PurchasePricePerPieceInCurrency
|decimal(18,3)
|
|Purchase price per piece in currency
|
|-
|@PurchasePricePerPieceWithVATInCurrency
|decimal(18,3)
|
|Purchase price per piece with VAT in currency
|
|-
|@TotalPriceInCurrency
|decimal(18,3)
|
|Total price in currency
|
|-
|@TotalPriceWithVATInCurrency
|decimal(18,3)
|
|Total price with VAT in currency
|
|-
|@TotalPurchasePriceInCurrency
|decimal(18,3)
|
|Total purchase price in currency
|
|-
|@TotalPurchasePriceWithVATInCurrency
|decimal(18,3)
|
|Total purchase price with VAT in currency
|
|-
|@DiscountPriceInCurrency
|decimal(18,3)
|
|Discount price in currency
|
|-
|@SurchargesPriceInCurrency
|decimal(18,3)
|
|Surcharges price in currency
|
|-
|@SurchargesPriceWithVATInCurrency
|decimal(18,3)
|
|Surcharges price with VAT in currency
|
|-
|@CurrencyID
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@ForeignCurrencyID
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@Note
|nvarchar(50)
|
|Note
|
|-
|@VATRate
|decimal(18,2)
|
|VAT rate
|
|-
|@HistoryInfo
|nvarchar(300)
|
|History info
|
|-
|@ActionPrice
|int
|
|Action price
|
|-
|@ChildPricePerPieceInCurrency
|decimal(18,3)
|
|Child price per piece in currency
|
|-
|@ChildPricePerPieceWithVATInCurrency
|decimal(18,3)
|
|Child price per piece with VAT in currency
|
|-
|@ChildPurchasePricePerPieceInCurrency
|decimal(18,3)
|
|Child purchase price per piece in currency
|
|-
|@ChildPurchasePricePerPieceWithVATInCurrency
|decimal(18,3)
|
|Child purchase price per piece with VAT in currency
|
|-
|@ChildDiscountInCurrency
|decimal(18,3)
|
|Child discount in currency
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @CustomerID int
DECLARE @CustomerWorkshopID int
DECLARE @GroupID int
DECLARE @ProductID int
DECLARE @StorageCardID int
DECLARE @OrderID int
DECLARE @GroupCode nvarchar(40)
DECLARE @ProductCode nvarchar(40)
DECLARE @ManufacturerCode nvarchar(40)
DECLARE @SupplierCode nvarchar(40)
DECLARE @Brand nvarchar(50)
DECLARE @Desription nvarchar(250)
DECLARE @OrderedQuantity decimal(18,2)
DECLARE @PricePerPiece decimal(18,3)
DECLARE @PricePerPieceWithVAT decimal(18,3)
DECLARE @PurchasePricePerPiece decimal(18,3)
DECLARE @PurchasePricePerPieceWithVAT decimal(18,3)
DECLARE @TotalPrice decimal(18,3)
DECLARE @TotalPriceWithVAT decimal(18,3)
DECLARE @TotalPurchasePrice decimal(18,3)
DECLARE @TotalPurchasePriceWithVAT decimal(18,3)
DECLARE @DiscountInPercent decimal(18,3)
DECLARE @DiscountPrice decimal(18,3)
DECLARE @SurchargesPrice decimal(18,2)
DECLARE @SurchargePriceWithVAT decimal(18,2)
DECLARE @PricePerPieceInCurrency decimal(18,3)
DECLARE @PricePerPieceWithVATInCurrency decimal(18,3)
DECLARE @PurchasePricePerPieceInCurrency decimal(18,3)
DECLARE @PurchasePricePerPieceWithVATInCurrency decimal(18,3)
DECLARE @TotalPriceInCurrency decimal(18,3)
DECLARE @TotalPriceWithVATInCurrency decimal(18,3)
DECLARE @TotalPurchasePriceInCurrency decimal(18,3)
DECLARE @TotalPurchasePriceWithVATInCurrency decimal(18,3)
DECLARE @DiscountPriceInCurrency decimal(18,3)
DECLARE @SurchargesPriceInCurrency decimal(18,3)
DECLARE @SurchargesPriceWithVATInCurrency decimal(18,3)
DECLARE @CurrencyID int
DECLARE @ForeignCurrencyID int
DECLARE @Note nvarchar(50)
DECLARE @VATRate decimal(18,2)
DECLARE @HistoryInfo nvarchar(300)
DECLARE @ActionPrice int
DECLARE @ChildPricePerPieceInCurrency decimal(18,3)
DECLARE @ChildPricePerPieceWithVATInCurrency decimal(18,3)
DECLARE @ChildPurchasePricePerPieceInCurrency decimal(18,3)
DECLARE @ChildPurchasePricePerPieceWithVATInCurrency decimal(18,3)
DECLARE @ChildDiscountInCurrency decimal(18,3)

SELECT @ID = [ID],
@CustomerID = 3,
@CustomerWorkshopID = [CustomerWorkshopID],
@GroupID = [GroupID],
@ProductID = [ProductID],
@StorageCardID = [StorageCardID],
@OrderID = [OrderID],
@GroupCode = [GroupCode],
@ProductCode = [ProductCode],
@ManufacturerCode = [ManufacturerCode],
@SupplierCode = [SupplierCode],
@Brand = [Brand],
@Desription = [Desription],
@OrderedQuantity = [OrderedQuantity],
@PricePerPiece = [PricePerPiece],
@PricePerPieceWithVAT = [PricePerPieceWithVAT],
@PurchasePricePerPiece = [PurchasePricePerPiece],
@PurchasePricePerPieceWithVAT = [PurchasePricePerPieceWithVAT],
@TotalPrice = [TotalPrice],
@TotalPriceWithVAT = [TotalPriceWithVAT],
@TotalPurchasePrice = [TotalPurchasePrice],
@TotalPurchasePriceWithVAT = [TotalPurchasePriceWithVAT],
@DiscountInPercent = [DiscountInPercent],
@DiscountPrice = [DiscountPrice],
@SurchargesPrice = [SurchargesPrice],
@SurchargePriceWithVAT = [SurchargePriceWithVAT],
@PricePerPieceInCurrency = [PricePerPieceInCurrency],
@PricePerPieceWithVATInCurrency = [PricePerPieceWithVATInCurrency],
@PurchasePricePerPieceInCurrency = [PurchasePricePerPieceInCurrency],
@PurchasePricePerPieceWithVATInCurrency = [PurchasePricePerPieceWithVATInCurrency],
@TotalPriceInCurrency = [TotalPriceInCurrency],
@TotalPriceWithVATInCurrency = [TotalPriceWithVATInCurrency],
@TotalPurchasePriceInCurrency = [TotalPurchasePriceInCurrency],
@TotalPurchasePriceWithVATInCurrency = [TotalPurchasePriceWithVATInCurrency],
@DiscountPriceInCurrency = [DiscountPriceInCurrency],
@SurchargesPriceInCurrency = [SurchargesPriceInCurrency],
@SurchargesPriceWithVATInCurrency = [SurchargesPriceWithVATInCurrency],
@CurrencyID = [CurrencyID],
@ForeignCurrencyID = [ForeignCurrencyID],
@Note = [Note],
@VATRate = [VATRate],
@HistoryInfo = [HistoryInfo],
@ActionPrice = [ActionPrice],
@ChildPricePerPieceInCurrency = [ChildPricePerPieceInCurrency],
@ChildPricePerPieceWithVATInCurrency = [ChildPricePerPieceWithVATInCurrency],
@ChildPurchasePricePerPieceInCurrency = [ChildPurchasePricePerPieceInCurrency],
@ChildPurchasePricePerPieceWithVATInCurrency = [ChildPurchasePricePerPieceWithVATInCurrency],
@ChildDiscountInCurrency = [ChildDiscountInCurrency]
FROM [API_GetBasketItems]
WHERE id = 3

EXECUTE [API_UpdateBasketItem]
@ID,
@CustomerID,
@CustomerWorkshopID,
@GroupID,
@ProductID,
@StorageCardID,
@OrderID,
@GroupCode,
@ProductCode,
@ManufacturerCode,
@SupplierCode,
@Brand,
@Desription,
@OrderedQuantity,
@PricePerPiece,
@PricePerPieceWithVAT,
@PurchasePricePerPiece,
@PurchasePricePerPieceWithVAT,
@TotalPrice,
@TotalPriceWithVAT,
@TotalPurchasePrice,
@TotalPurchasePriceWithVAT,
@DiscountInPercent,
@DiscountPrice,
@SurchargesPrice,
@SurchargePriceWithVAT,
@PricePerPieceInCurrency,
@PricePerPieceWithVATInCurrency,
@PurchasePricePerPieceInCurrency,
@PurchasePricePerPieceWithVATInCurrency,
@TotalPriceInCurrency,
@TotalPriceWithVATInCurrency,
@TotalPurchasePriceInCurrency,
@TotalPurchasePriceWithVATInCurrency,
@DiscountPriceInCurrency,
@SurchargesPriceInCurrency,
@SurchargesPriceWithVATInCurrency,
@CurrencyID,
@ForeignCurrencyID,
@Note,
@VATRate,
@HistoryInfo,
@ActionPrice,
@ChildPricePerPieceInCurrency,
@ChildPricePerPieceWithVATInCurrency,
@ChildPurchasePricePerPieceInCurrency,
@ChildPurchasePricePerPieceWithVATInCurrency,
@ChildDiscountInCurrency

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 305: / Řádka 305: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @CustomerID int
@@ Řádka 408: / Řádka 412: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateBasketItem]
+  EXECUTE @return_value = [API_UpdateBasketItem]
    @ID,
    @CustomerID,

API UpdateBasketItem - Historie editací

Chrzaszcz v 22. 9. 2017, 08:22

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update uasket item in system. ==== Exact name ==== API_UpdateBasketItem ==== Type ==== Standard e…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update uasket item in system. ==== Exact name ==== `API_UpdateBasketItem` ==== Type ==== Standard e…“