API CreateTransport: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to create new transport in system. ==== Exact name ==== <code>API_CreateTransport</code> ==== Type ==== Standard…“)
 
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-
 
|-
|@Title
+
|@TransportName
|nvarchar(50)
+
|varchar(250)
 
|
 
|
|Title
+
|Transport name
 
|
 
|
 
|-
 
|-
|@HtmlText
+
|@Description
|ntext
+
|varchar(200)
 
|
 
|
|Html text
+
|Description
 
|
 
|
 
|-
 
|-
|@Language
+
|@Prohibit
 
|int
 
|int
 
|
 
|
|Language.
+
|Prohibit
cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17
 
 
|
 
|
 +
|-
 +
|@CashPaymentAllowed
 +
|int
 +
|
 +
|Cash payment allowed
 +
|
 +
|-
 +
|@WireTransferPaymentAllowed
 +
|int
 +
|
 +
|Wire transfer payment allowed
 +
|
 +
|-
 +
|@HideOnEshop
 +
|bit
 +
|
 +
|Hide on eshop
 +
|
 +
|-
 +
|@BranchID
 +
|int
 +
|
 +
|ID of branch from branch list (see relation)
 +
|API_GetBranches.ID
 
|}
 
|}
  
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
EXEC [API_CreateTransport] @Title= 'Title' ,@HtmlText= '<span style="color: red;"> Text </span>' ,@Language= 0
+
EXEC [API_CreateTransport] @TransportName= 'Transport' ,@Description= 'Description' ,@Prohibit= 0 ,@CashPaymentAllowed= 1 ,@WireTransferPaymentAllowed= 1 ,@HideOnEshop= 0 ,@BranchID= -1
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
==== Notices ====
 
==== Notices ====
 
None.
 
None.

Verze z 1. 8. 2017, 08:18

Description

Method allows You to create new transport in system.

Exact name

API_CreateTransport

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@TransportName varchar(250) Transport name
@Description varchar(200) Description
@Prohibit int Prohibit
@CashPaymentAllowed int Cash payment allowed
@WireTransferPaymentAllowed int Wire transfer payment allowed
@HideOnEshop bit Hide on eshop
@BranchID int ID of branch from branch list (see relation) API_GetBranches.ID

Example

EXEC [API_CreateTransport] @TransportName= 'Transport' ,@Description= 'Description' ,@Prohibit= 0 ,@CashPaymentAllowed= 1 ,@WireTransferPaymentAllowed= 1 ,@HideOnEshop= 0 ,@BranchID= -1

Notices

None.