API CreateBranch: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
Porovnání s novější verzí →

Zavadil (diskuse | příspěvky)

2 uživatelské skupiny
138 editací
VizuálníWikitext
Založena nová stránka s textem „API_CreateBranch @WorkshopID int - API_GetWorkshops.ID @Name nvarchar(100) @Street nvarchar(200) @City nvarchar(120) @ZIPCode nvarchar(15) @Country…“
 
Bez shrnutí editace
Řádek 1: Řádek 1:
API_CreateBranch
==== <code>API_CreateBranch</code> ====


@WorkshopID int - API_GetWorkshops.ID
==== Specification ====
@Name nvarchar(100)
{| class="wikitable"
@Street nvarchar(200)
!Parameter
@City nvarchar(120)
!Data type
@ZIPCode nvarchar(15)
!Value range
@Country nvarchar(70)
!Description
@Region nvarchar(70)
!Relation
@State nvarchar(80)
|-
@StateID int - API_GetCountry.ID
|@WorkshopID
@Phone nvarchar(50)
|int
@Fax nvarchar(50)
|
@MobilePhone nvarchar(50)
|Workshop ID
@Email nvarchar(70)
(could be equal to ID in Your internal system)
@Web nvarchar(120)
|API_GetWorkshops.ID
|-
|@Name  
|nvarchar(100)
|
|Workshop name
|
|-
|@Street  
|nvarchar(200)
|
|
|
|-
|@City  
|nvarchar(120)
|
|
|
|-
|@ZIPCode  
|nvarchar(15)
|
|
|
|-
|@Country  
|nvarchar(70)
|
|
|
|-
|@Region  
|nvarchar(70)
|
|
|
|-
|@State  
|nvarchar(80)
|
|
|
|-
|@StateID
|int
|
|ID of country
|API_GetCountry.ID
|-
|@Phone  
|nvarchar(50)
|
|Phone
|
|-
|@Fax
|nvarchar(50)
|
|Fax
|
|-
|@MobilePhone
|nvarchar(50)
|
|Mobile phone
|
|-
|@Email
|nvarchar(70)
|
|Email
|
|-
|@Web
|nvarchar(120)
|
|Web address
|
|}


 
==== Example ====
Example:
<syntaxhighlight lang="sql">
EXEC [API_CreateBranch]  
EXEC [API_CreateBranch] @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'
  @WorkshopID = 1
</syntaxhighlight>
  ,@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'

Verze z 24. 7. 2017, 16:15

API_CreateBranch

Specification

Parameter Data type Value range Description Relation
@WorkshopID int Workshop ID

(could be equal to ID in Your internal system)

API_GetWorkshops.ID
@Name nvarchar(100) Workshop name
@Street nvarchar(200)
@City nvarchar(120)
@ZIPCode nvarchar(15)
@Country nvarchar(70)
@Region nvarchar(70)
@State nvarchar(80)
@StateID int ID of country API_GetCountry.ID
@Phone nvarchar(50) Phone
@Fax nvarchar(50) Fax
@MobilePhone nvarchar(50) Mobile phone
@Email nvarchar(70) Email
@Web nvarchar(120) Web address

Example

EXEC [API_CreateBranch] @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'
Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateBranch&oldid=216“