API CreateUniversalPartsCategory - Historie editací

Chrzaszcz v 22. 9. 2017, 08:16

2017-09-22T08:16:11Z

← Starší verze		Verze z 22. 9. 2017, 08:16
Řádek 52:		Řádek 52:
	\|		\|
	\|}		\|}

			==== Return ====
			0 : OK
			100 : Item could not be created

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [API_CreateUniversalPartsCategory] @ParentID= 1 ,@Name = 'Name' ,@Description= 'Description' ,@SortIndex= 0 ,@IsRoot= 0 ,@IsTop= 0		DECLARE @return_value int
			EXEC @return_value = [API_CreateUniversalPartsCategory] @ParentID= 1 ,@Name = 'Name' ,@Description= 'Description' ,@SortIndex= 0 ,@IsRoot= 0 ,@IsTop= 0
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

2017-07-31T12:59:18Z

← Starší verze		Verze z 31. 7. 2017, 12:59
Řádek 16:		Řádek 16:
	!Relation		!Relation
	\|-		\|-
	\|@~~WorkshopID~~		\|@ParentID
	\|int		\|int
	\|		\|
	\|ID ~~of workshop from workshop list~~ (~~see relation~~)		\|Parent category ID
	\|~~API_GetWorkshops.ID~~		\|
			\|-
			\|@Name
			\|nvarchar(250)
			\|
			\|Name
			\|
			\|-
			\|@Description
			\|nvarchar(800)
			\|
			\|Description
			\|
			\|-
			\|@SortIndex
			\|int
			\|
			\|Sort index
			\|
			\|-
			\|@IsRoot
			\|bit
			\|
			\|Is root
			\|
			\|-
			\|@IsTop
			\|bit
			\|
			\|Is top
			\|
	\|}		\|}

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [API_CreateUniversalPartsCategory] @~~WorkshopID~~ = 1 ,@Name = 'Name' ,@~~Street~~ = '~~Street~~' ,@~~City~~ = ~~'City' ,@ZIPCode = 'ZIPCode'~~ ,@~~Country~~ = ~~'Country'~~ ,@~~Region~~ = ~~'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'~~		EXEC [API_CreateUniversalPartsCategory] @ParentID= 1 ,@Name = 'Name' ,@Description= 'Description' ,@SortIndex= 0 ,@IsRoot= 0 ,@IsTop= 0
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.