API CreateCrossNumbers: Porovnání verzí

Verze z 16. 4. 2019, 10:17

Method allows You to create new cross number in system.

API_CreateCrossNumbers

Standard executable stored procedure.

Parameter	Data type	Description	Relation
@GroupID	int	Group ID	API_GetProductGroups.ID
@Code	nvarchar(35)	TecDoc code or Laximo code
@BrandID	int	Brand ID	API_GetTecDocBrands.ID or API_GetLaximoBrands.ID
@BrandName	nvarchar(80)	Brand name	API_GetTecDocBrands.Name or API_GetLaximoBrands.Name
@TypeID	int	TecDoc cross = 0; Laximo cross = 1;

0 : OK
100 : Item could not be created

 DECLARE @return_value int
 EXEC @return_value = [API_CreateCrossNumbers] @GroupID= 1 ,@Code= 'JSS110', @BrandID= 161, @BrandName= 'TRW', @TypeID= 1

None.

@@ Řádek 1: / Řádek 1: @@
-a
+==== Description ====
+Method allows You to create new cross number in system.
+==== Exact name ====
+<code>API_CreateCrossNumbers</code>
+==== Type ====
+Standard executable stored procedure.
+==== Specification ====
+{| class="wikitable"
+!Parameter
+!Data type
+!Value range
+!Description
+!Relation
+|-
+|@GroupID
+|int
+|
+|Group ID
+|API_GetProductGroups.ID
+|-
+|@Code
+|nvarchar(35)
+|
+|TecDoc code
+or Laximo code
+|
+|-
+|@BrandID
+|int
+|
+|Brand ID
+|API_GetTecDocBrands.ID
+or API_GetLaximoBrands.ID
+|-
+|@BrandName
+|nvarchar(80)
+|
+|Brand name
+|API_GetTecDocBrands.Name
+or API_GetLaximoBrands.Name
+|-
+|@TypeID
+|int
+|
+|TecDoc cross = 0;
+Laximo cross = 1;
+|
+|}
+==== Return ====
+: OK
+: Item could not be created
+==== Example ====
+<syntaxhighlight lang="sql">
+ DECLARE @return_value int
+ EXEC @return_value = [API_CreateCrossNumbers] @GroupID= 1 ,@Code= 'JSS110', @BrandID= 161, @BrandName= 'TRW', @TypeID= 1
+</syntaxhighlight>
+==== Notices ====
+None.