API UpdateProduct - Historie editací

Chrzaszcz v 13. 8. 2020, 08:32

2020-08-13T08:32:14Z

Chrzaszcz v 28. 9. 2017, 13:25

2017-09-28T13:25:44Z

Chrzaszcz v 22. 9. 2017, 08:37

2017-09-22T08:37:07Z

Chrzaszcz v 8. 8. 2017, 07:51

2017-08-08T07:51:52Z

Chrzaszcz v 8. 8. 2017, 07:47

2017-08-08T07:47:04Z

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

2017-08-08T07:45:39Z

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

Nová stránka

==== Description ====
Method allows You to update product in system.

==== Exact name ====
<code>API_UpdateProduct</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID3
|int
|
|Internal system id
|API_GetBranches.ID
|-
|@SupplierID
|int
|
|Supplier ID
|API_GetCustomers.ID
|-
|@GroupID
|int
|
|Group ID
|API_GetProductGroups.ID
|-
|@SupplierProductCode
|nvarchar(40)
|
|Supplier product code
|
|-
|@ManufacturerSupplier
|nvarchar(50)
|
|Manufacturer supplier
|
|-
|@Prefix
|nvarchar(3)
|
|Prefix
|
|-
|@SupplierItemName
|nvarchar(150)
|
|Supplier item name
|
|-
|@MinimumOrderableQuantity
|decimal(18,2)
|
|Minimum orderable quantity
|
|-
|@ForeignPrice
|decimal(19,6)
|
|Foreign price
|
|-
|@BasicPrice
|decimal(18,6)
|
|Basic price
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID3 int
DECLARE @SupplierID int
DECLARE @GroupID int
DECLARE @SupplierProductCode nvarchar(40)
DECLARE @ManufacturerSupplier nvarchar(50)
DECLARE @Prefix nvarchar(3)
DECLARE @SupplierItemName nvarchar(150)
DECLARE @MinimumOrderableQuantity decimal(18,2)
DECLARE @ForeignPrice decimal(19,6)
DECLARE @BasicPrice decimal(19,6)

SELECT @ID3 = [ID],
@SupplierID = [SupplierID],
@GroupID = [GroupID],
@SupplierProductCode = [SupplierProductCode],
@ManufacturerSupplier = [ManufacturerSupplier],
@Prefix = [Prefix],
@SupplierItemName = [SupplierItemName],
@MinimumOrderableQuantity = [MinimumOrderableQuantity],
@ForeignPrice = [ForeignPrice],
@BasicPrice = [BasicPrice]
FROM [API_GetProducts]
WHERE id = 3

EXECUTE [API_UpdateProduct]
@ID3,
@SupplierID,
@GroupID,
@SupplierProductCode,
@ManufacturerSupplier,
@Prefix,
@SupplierItemName,
@MinimumOrderableQuantity,
@ForeignPrice,
@BasicPrice

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 80: / Řádka 80: @@
+|
 |Basic price
+|
 |}
@@ Řádka 101: / Řádka 107: @@
   DECLARE @ForeignPrice decimal(19,6)
   DECLARE @BasicPrice decimal(19,6)
@@ Řádka 113: / Řádka 120: @@
         @SupplierIsArchiving = [IsArchiving]
         @ForeignPrice = [ForeignPrice],
-        @BasicPrice = 200
+        @BasicPrice = 200,
   FROM   [API_GetProducts]
   WHERE  id = 3
@@ Řádka 129: / Řádka 137: @@
    @ForeignPrice,
    @BasicPrice
 </syntaxhighlight>

@@ Řádka 62: / Řádka 62: @@
+|
 |Minimum orderable quantity
+|
 |-
@@ Řádka 92: / Řádka 98: @@
   DECLARE @SupplierItemName nvarchar(150)
   DECLARE @MinimumOrderableQuantity decimal(18,2)
   DECLARE @ForeignPrice decimal(19,6)
   DECLARE @BasicPrice decimal(19,6)
@@ Řádka 104: / Řádka 111: @@
         @SupplierItemName = [SupplierItemName],
         @MinimumOrderableQuantity = [MinimumOrderableQuantity],
         @ForeignPrice = [ForeignPrice],
         @BasicPrice = 200
@@ Řádka 118: / Řádka 126: @@
    @SupplierItemName,
    @MinimumOrderableQuantity,
    @ForeignPrice,
    @BasicPrice

@@ Řádka 77: / Řádka 77: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID3 int
   DECLARE @SupplierID int
@@ Řádka 105: / Řádka 109: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateProduct]
+  EXECUTE @return_value = [API_UpdateProduct]
    @ID3,
    @SupplierID,

@@ Řádka 20: / Řádka 20: @@
+|
 |Internal system id
-|API_GetBranches.ID
+|API_GetProducts.ID
 |-
 |@SupplierID