API UpdateCrossNumbers: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „a“) |
|||
| Řádka 1: | Řádka 1: | ||
| − | + | ==== Description ==== | |
| + | Method allows You to update cross number in system. | ||
| + | |||
| + | ==== Exact name ==== | ||
| + | <code>API_UpdateCrossNumbers</code> | ||
| + | |||
| + | ==== Type ==== | ||
| + | Standard executable stored procedure. | ||
| + | |||
| + | ==== Specification ==== | ||
| + | {| class="wikitable" | ||
| + | !Parameter | ||
| + | !Data type | ||
| + | !Value range | ||
| + | !Description | ||
| + | !Relation | ||
| + | |- | ||
| + | |@ID | ||
| + | |int | ||
| + | | | ||
| + | |Internal system id | ||
| + | |API_GetCrossNumbers.ID | ||
| + | |- | ||
| + | |@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 | ||
| + | | | ||
| + | |Type ID | ||
| + | |TecDoc cross = 0; | ||
| + | Laximo cross = 1; | ||
| + | |} | ||
| + | |||
| + | ==== Return ==== | ||
| + | 0 : OK | ||
| + | 100 : Item could not be updated | ||
| + | |||
| + | ==== Example ==== | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | DECLARE @return_value int | ||
| + | DECLARE @ID int | ||
| + | DECLARE @GroupID int | ||
| + | DECLARE @Code nvarchar(35) | ||
| + | DECLARE @BrandID int | ||
| + | DECLARE @BrandName nvarchar(80) | ||
| + | DECLARE @TypeID int | ||
| + | |||
| + | |||
| + | SELECT @ID = [ID], | ||
| + | @GroupID = [GroupID], | ||
| + | @Code = 'GCH585', | ||
| + | @BrandID = [BrandID], | ||
| + | @BrandName = [BrandName], | ||
| + | @TypeID = [TypeID] | ||
| + | FROM [API_GetCrossNumbers] | ||
| + | WHERE id = 3 | ||
| + | |||
| + | EXECUTE @return_value = [API_UpdateCrossNumbers] | ||
| + | @ID, | ||
| + | @GroupID, | ||
| + | @Code, | ||
| + | @BrandID, | ||
| + | @BrandName, | ||
| + | @TypeID | ||
| + | |||
| + | </syntaxhighlight> | ||
| + | |||
| + | ==== Notices ==== | ||
| + | None. | ||
Aktuální verze z 16. 4. 2019, 11:35
Description
Method allows You to update cross number in system.
Exact name
API_UpdateCrossNumbers
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Internal system id | API_GetCrossNumbers.ID | |
| @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 | Type ID | TecDoc cross = 0;
Laximo cross = 1; |
Return
0 : OK 100 : Item could not be updated
Example
DECLARE @return_value int
DECLARE @ID int
DECLARE @GroupID int
DECLARE @Code nvarchar(35)
DECLARE @BrandID int
DECLARE @BrandName nvarchar(80)
DECLARE @TypeID int
SELECT @ID = [ID],
@GroupID = [GroupID],
@Code = 'GCH585',
@BrandID = [BrandID],
@BrandName = [BrandName],
@TypeID = [TypeID]
FROM [API_GetCrossNumbers]
WHERE id = 3
EXECUTE @return_value = [API_UpdateCrossNumbers]
@ID,
@GroupID,
@Code,
@BrandID,
@BrandName,
@TypeID
Notices
None.
