Chrzaszcz v 16. 4. 2019, 10:35

2019-04-16T10:35:41Z

Chrzaszcz: Založena nová stránka s textem „a“

2019-04-16T10:21:03Z

Založena nová stránka s textem „a“

Nová stránka

← Starší verze		Verze z 16. 4. 2019, 10:35
Řádka 1:		Řádka 1:
−	a	+	==== 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.