Chrzaszcz v 22. 9. 2017, 08:39

2017-09-22T08:39:50Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update stock dispositions in system. ==== Exact name ==== `API_UpdateStockDispositions` ==== Type =…“

2017-08-02T07:57:17Z

Založena nová stránka s textem „==== Description ==== Method allows You to update stock dispositions in system. ==== Exact name ==== <code>API_UpdateStockDispositions</code> ==== Type =…“

Nová stránka

==== Description ====
Method allows You to update stock dispositions in system.

==== Exact name ====
<code>API_UpdateStockDispositions</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@StockID
|int
|
|ID of stock from stock list (see relation)
|API_GetStocks.ID
|-
|@ProductID
|int
|
|ID of product from products list (see relation)
|API_GetProducts.ID
|-
|@MinimumQuantity
|numeric(18,4)
|
|Minimum quantity
|
|-
|@MaximumQuantity
|numeric(18,4)
|
|Maximum quantity
|
|-
|@IsArchived
|int
|
|Is archived
|
|-
|@OnStockQuantity
|decimal(10,3)
|
|On stock quantity
|
|-
|@FullStockPrice
|decimal(18,4)
|
|Full stock price
|
|-
|@PricePerPiece
|decimal(18,4)
|
|Price per piece
|
|-
|@WarehousePosition
|nvarchar(50)
|
|Warehouse position
|
|-
|@ReservedQuantity
|decimal(18,2)
|
|Reserved quantity
|
|-
|@LastInDate
|datetime
|
|LastIn date
|
|-
|@LastOutDate
|datetime
|
|Last out date
|
|-
|@LastChangeDate
|datetime
|
|Last change date
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @StockID int
DECLARE @ProductID int
DECLARE @MinimumQuantity numeric(18,4)
DECLARE @MaximumQuantity numeric(18,4)
DECLARE @IsArchived int
DECLARE @OnStockQuantity decimal(10,3)
DECLARE @FullStockPrice decimal(18,4)
DECLARE @PricePerPiece decimal(18,4)
DECLARE @WarehousePosition nvarchar(50)
DECLARE @ReservedQuantity decimal(18,2)
DECLARE @LastInDate datetime
DECLARE @LastOutDate datetime
DECLARE @LastChangeDate datetime

SELECT @ID = [ID],
@StockID = [StockID],
@ProductID = [ProductID],
@MinimumQuantity = [MinimumQuantity],
@MaximumQuantity = 5,
@IsArchived = [IsArchived],
@OnStockQuantity = [OnStockQuantity],
@FullStockPrice = [FullStockPrice],
@PricePerPiece = [PricePerPiece],
@WarehousePosition = [WarehousePosition],
@ReservedQuantity = [ReservedQuantity],
@LastInDate = [LastInDate],
@LastOutDate = [LastOutDate],
@LastChangeDate = [LastChangeDate]
FROM [API_GetStockDispositions]
WHERE id = 3

EXECUTE [API_UpdateStockDispositions]
@ID,
@StockID,
@ProductID,
@MinimumQuantity,
@MaximumQuantity,
@IsArchived,
@OnStockQuantity,
@FullStockPrice,
@PricePerPiece,
@WarehousePosition,
@ReservedQuantity,
@LastInDate,
@LastOutDate,
@LastChangeDate

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 101: / Řádka 101: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @StockID int
@@ Řádka 136: / Řádka 140: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateStockDispositions]
+  EXECUTE @return_value = [API_UpdateStockDispositions]
    @ID,
    @StockID,

API UpdateStockDispositions - Historie editací

Chrzaszcz v 22. 9. 2017, 08:39

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update stock dispositions in system. ==== Exact name ==== API_UpdateStockDispositions ==== Type =…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update stock dispositions in system. ==== Exact name ==== `API_UpdateStockDispositions` ==== Type =…“