API UpdateStock - Historie editací

Chrzaszcz v 9. 11. 2018, 14:45

2018-11-09T14:45:50Z

Chrzaszcz v 20. 9. 2017, 14:10

2017-09-20T14:10:31Z

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

2017-08-02T14:36:12Z

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

Nová stránka

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

==== Exact name ====
<code>API_UpdateStock</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@WorkshopID
|int
|
|ID of workshop from workshop list (see relation)
|API_GetWorkshops.ID
|-
|@Name
|nvarchar(50)
|
|Name
|
|-
|@Description
|nvarchar(500)
|
|Description
|
|-
|@EshopName
|nchar(30)
|
|Eshop name
|
|-
|@BranchID
|int
|
|ID of branch from branch list (see relation)
|API_GetBranches.ID
|-
|@IsVisibleOnEshop
|int
|
|Is visible on eshop
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @WorkshopID int
DECLARE @Name nvarchar(100)
DECLARE @Description varchar(500)
DECLARE @EshopName nchar(30)
DECLARE @BranchID int
DECLARE @IsVisibleOnEshop int

SELECT @ID = [ID],
@WorkshopID = [WorkshopID],
@Name = 'Name 2',
@Description = [Description],
@EshopName = [EshopName],
@BranchID = [BranchID],
@IsVisibleOnEshop = [IsVisibleOnEshop]
FROM [API_GetStocks]
WHERE id = 3

EXECUTE [API_UpdateStock]
@ID,
@WorkshopID,
@Name,
@Description,
@EshopName,
@BranchID,
@IsVisibleOnEshop

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 41: / Řádka 41: @@
 |-
 |@EshopName
-|nchar(30)
+|nvarchar(30)
+|
 |Eshop name
@@ Řádka 69: / Řádka 69: @@
   DECLARE @WorkshopID int
   DECLARE @Name nvarchar(100)
-  DECLARE @Description varchar(500)
+  DECLARE @Description nvarchar(500)
-  DECLARE @EshopName nchar(30)
+  DECLARE @EshopName nvarchar(30)
   DECLARE @BranchID int
   DECLARE @IsVisibleOnEshop int

@@ Řádka 59: / Řádka 59: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @WorkshopID int
@@ Řádka 80: / Řádka 84: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateStock]
+  EXECUTE @return_value = [API_UpdateStock]
    @ID,
    @WorkshopID,

API UpdateStock - Historie editací

Chrzaszcz v 9. 11. 2018, 14:45

Chrzaszcz v 20. 9. 2017, 14:10

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

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