Chrzaszcz v 9. 11. 2018, 13:27

2018-11-09T13:27:25Z

← Starší verze		Verze z 9. 11. 2018, 13:27
Řádek 59:		Řádek 59:
	\|-		\|-
	\|@Note		\|@Note
	\|~~varchar~~(150)		\|nvarchar(150)
	\|		\|
	\|Note		\|Note
Řádek 65:		Řádek 65:
	\|-		\|-
	\|@Purpose		\|@Purpose
	\|~~varchar~~(150)		\|nvarchar(150)
	\|		\|
	\|Purpose		\|Purpose
Řádek 85:		Řádek 85:
	DECLARE @Price decimal(19, 4)		DECLARE @Price decimal(19, 4)
	DECLARE @PriceInCurrency decimal(18, 4)		DECLARE @PriceInCurrency decimal(18, 4)
	DECLARE @Note ~~varchar~~(150)		DECLARE @Note nvarchar(150)
	DECLARE @Purpose ~~varchar~~(150)		DECLARE @Purpose nvarchar(150)

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

2018-04-30T13:39:12Z

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

Nová stránka

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

==== Exact name ====
<code>API_UpdatePayment</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetPayments.ID
|-
|@DocumentID
|int
|
|ID of invoices from invoices list (see relation)
|API_GetInvoices.ID
|-
|@CurrencyID
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@CurrencyIDInCurrency
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@ExchangeRate
|decimal(18,6)
|
|Exchange rate
|
|-
|@Price
|decimal(19,4)
|
|Price
|
|-
|@PriceInCurrency
|decimal(18,4)
|
|Price in currency
|
|-
|@Note
|varchar(150)
|
|Note
|
|-
|@Purpose
|varchar(150)
|
|Purpose
|
|}

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

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
DECLARE @ID int
DECLARE @CurrencyID int
DECLARE @CurrencyIDInCurrency int
DECLARE @ExchangeRate decimal(18, 6)
DECLARE @Price decimal(19, 4)
DECLARE @PriceInCurrency decimal(18, 4)
DECLARE @Note varchar(150)
DECLARE @Purpose varchar(150)

SELECT @ID = [ID],
@CurrencyID = [CurrencyID]
@CurrencyIDInCurrency = [CurrencyIDInCurrency]
@ExchangeRate = [ExchangeRate]
@Price = 0
@PriceInCurrency = 0
@Note = ''
@Purpose = ''
FROM [API_GetPayments]
WHERE DocumentID = 1

EXECUTE @return_value = [API_UpdatePayment]
@ID,
@CurrencyID
@CurrencyIDInCurrency
@ExchangeRate
@Price
@PriceInCurrency
@Note
@Purpose

</syntaxhighlight>

==== Notices ====
None.

API UpdatePayment - Historie editací

Chrzaszcz v 9. 11. 2018, 13:27

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

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