API UpdateTransport - Historie editací

Chrzaszcz v 9. 11. 2018, 14:47

2018-11-09T14:47:52Z

Chrzaszcz v 22. 9. 2017, 08:43

2017-09-22T08:43:08Z

Chrzaszcz v 2. 8. 2017, 07:36

2017-08-02T07:36:11Z

Chrzaszcz v 2. 8. 2017, 07:34

2017-08-02T07:34:48Z

Chrzaszcz v 2. 8. 2017, 07:24

2017-08-02T07:24:03Z

Chrzaszcz v 2. 8. 2017, 07:22

2017-08-02T07:22:15Z

Chrzaszcz v 2. 8. 2017, 07:21

2017-08-02T07:21:57Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update transport in system. ==== Exact name ==== `API_UpdateTransport` ==== Type ==== Standard exec…“

2017-08-02T07:21:13Z

Založena nová stránka s textem „==== Description ==== Method allows You to update transport in system. ==== Exact name ==== <code>API_UpdateTransport</code> ==== Type ==== Standard exec…“

Nová stránka

==== Description ====
Method allows You to update transport in system.

==== Exact name ====
<code>API_UpdateTransport</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|ID
|int
|Internal system id
|
|-
|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 ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @TransportName
DECLARE @Description
DECLARE @Prohibit
DECLARE @CashPaymentAllowed
DECLARE @WireTransferPaymentAllowed
DECLARE @HideOnEshop
DECLARE @BranchID

SELECT @ID = ID,
@TransportName = 'Transport 2',
@Description = Description,
@Prohibit = Prohibit,
@CashPaymentAllowed = CashPaymentAllowed,
@WireTransferPaymentAllowed = WireTransferPaymentAllowed,
@HideOnEshop = HideOnEshop,
@BranchID = BranchID
FROM [API_GetTransports]
WHERE ID = 3

EXECUTE [API_UpdateTransport]
@ID,
@TransportName,
@Description,
@Prohibit,
@CashPaymentAllowed,
@WireTransferPaymentAllowed,
@HideOnEshop,
@BranchID

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 23: / Řádka 23: @@
 |-
 |@TransportName
-|varchar(250)
+|nvarchar(250)
+|
 |Transport name
@@ Řádka 29: / Řádka 29: @@
 |-
 |@Description
-|varchar(200)
+|nvarchar(200)
+|
 |Description
@@ Řádka 73: / Řádka 73: @@
   DECLARE @return_value int
   DECLARE @ID int
-  DECLARE @TransportName varchar(250)
+  DECLARE @TransportName nvarchar(250)
-  DECLARE @Description varchar(200)
+  DECLARE @Description nvarchar(200)
   DECLARE @Prohibit int
   DECLARE @CashPaymentAllowed int

@@ Řádka 65: / Řádka 65: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @TransportName varchar(250)
@@ Řádka 88: / Řádka 92: @@
   WHERE  ID = 3
-  EXECUTE [API_UpdateTransport]
+  EXECUTE @return_value = [API_UpdateTransport]
   @ID,
   @TransportName,

@@ Řádka 77: / Řádka 77: @@
   DECLARE @BranchID
-  SELECT @ID = ID,
+  SELECT @ID = [ID],
          @TransportName = 'Transport 2',
-         @Description = Description,
+         @Description = [Description],
-         @Prohibit = Prohibit,
+         @Prohibit = [Prohibit],
-         @CashPaymentAllowed = CashPaymentAllowed,
+         @CashPaymentAllowed = [CashPaymentAllowed],
-         @WireTransferPaymentAllowed = WireTransferPaymentAllowed,
+         @WireTransferPaymentAllowed = [WireTransferPaymentAllowed],
-         @HideOnEshop = HideOnEshop,
+         @HideOnEshop = [HideOnEshop],
-         @BranchID = BranchID
+         @BranchID = [BranchID]
   FROM   [API_GetTransports]
   WHERE  ID = 3

@@ Řádka 18: / Řádka 18: @@
 |@ID
 |int
 |Internal system id
+|
@@ Řádka 23: / Řádka 24: @@
 |@TransportName
 |varchar(250)
 |Transport name
+|
@@ Řádka 28: / Řádka 30: @@
 |@Description
 |varchar(200)
 |Description
+|
@@ Řádka 33: / Řádka 36: @@
 |@Prohibit
 |int
 |Prohibit
+|
@@ Řádka 38: / Řádka 42: @@
 |@CashPaymentAllowed
 |int
 |Cash payment allowed
+|
@@ Řádka 43: / Řádka 48: @@
 |@WireTransferPaymentAllowed
 |int
 |Wire transfer payment allowed
+|
@@ Řádka 48: / Řádka 54: @@
 |@HideOnEshop
 |bit
 |Hide on eshop
+|
@@ Řádka 53: / Řádka 60: @@
 |@BranchID
 |int
 |ID of branch from branch list (see relation)
 |API_GetBranches.ID

@@ Řádka 16: / Řádka 16: @@
 !Relation
 |-
-|I@D
+|@ID
 |int
 |Internal system id