Chrzaszcz v 13. 8. 2020, 07:56

2020-08-13T07:56:42Z

← Starší verze		Verze z 13. 8. 2020, 07:56
Řádek 1:		Řádek 1:
	==== Description ====		==== Description ====
	Method allows You to update and create new product ~~group~~ in system.		Method allows You to update and create new product groups in system.

	==== Exact name ====		==== Exact name ====
	<code>~~API_ProductGroup_BULK~~</code>		<code>API_ProductGroups_BULK</code>

	==== Type ====		==== Type ====
Řádek 214:		Řádek 214:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	DECLARE @return_value int		DECLARE @return_value int
	Declare @~~ProductGrup~~ dbo.~~APIsProductGroup~~		Declare @ProductGroups dbo.APIsProductGroups
	INSERT INTO @~~ProductGrup~~		INSERT INTO @ProductGroups
	SELECT G.[ProductCode],		SELECT G.[ProductCode],
	G.[TecDocCode],		G.[TecDocCode],
Řádek 252:		Řádek 252:
	SELECT '1457429619', '1 457 429 619', 'BOSCH', 30, 'BOSCH', null, null, 'Name', '', 1, 100, 190, 7, '', '1457429619BOS', 'BOSCH', '', 100, 220, '', '', 16028, 1, 148, 0, 0, '', null, 0, 0		SELECT '1457429619', '1 457 429 619', 'BOSCH', 30, 'BOSCH', null, null, 'Name', '', 1, 100, 190, 7, '', '1457429619BOS', 'BOSCH', '', 100, 220, '', '', 16028, 1, 148, 0, 0, '', null, 0, 0

	exec @return_value = dbo.[~~API_ProductGroup_BULK~~] @~~ProductGrup~~		exec @return_value = dbo.[API_ProductGroups_BULK] @ProductGroups
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	~~API_ProductGroup_BULK~~ procedure uses own data type called ~~ProductGrup~~ (dbo.~~APIsProductGroup~~).		API_ProductGroups_BULK procedure uses own data type called ProductGroups (dbo.APIsProductGroups).

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update and create new product group in system. ==== Exact name ==== `API_ProductGroup_BULK` ==== Ty…“

2020-08-12T14:52:09Z

Založena nová stránka s textem „==== Description ==== Method allows You to update and create new product group in system. ==== Exact name ==== <code>API_ProductGroup_BULK</code> ==== Ty…“

Nová stránka

==== Description ====
Method allows You to update and create new product group in system.

==== Exact name ====
<code>API_ProductGroup_BULK</code>

==== Type ====
Standard executable stored procedure with table-Valued Parameters.

==== Table-Valued Parameters Specification ====
{| class="wikitable"
!Columns name
!Data type
!Value range
!Description
!Relation
|-
|ProductCode
|nvarchar(40)
|
|Product code
|
|-
|TecDocCode
|nvarchar(35)
|
|TecDoc code
|
|-
|TecDocBrandName
|nvarchar(80)
|
|TecDoc brand name
|
|-
|TecDocBrandID
|int
|
|TecDoc brand ID
|
|-
|GroupName
|nvarchar(100)
|
|Group name
|
|-
|SubGoupName
|nvarchar(100)
|
|Sub goup name
|
|-
|AssortmentName
|nvarchar(100)
|
|AssortmentName
|
|-
|Name
|nvarchar(100)
|
|Name
|
|-
|Name2
|nvarchar(150)
|
|Name 2
|
|-
|IsNew
|bit
|
|Is new:
0 = Off,

1 = On
|
|-
|PurchasePrice
|decimal(18,6)
|
|Purchase price
|
|-
|RetailPrice
|decimal(18,6)
|
|Retail price
|
|-
|SupplierID
|int
|
|Supplier ID
|API_GetCustomers.ID
|-
|Prefix
|nvarchar(3)
|
|Prefix
|
|-
|SupplierProductCode
|nvarchar(40)
|
|Supplier product code
|
|-
|ManufacturerSupplier
|nvarchar(50)
|
|Manufacturer supplier
|
|-
|SupplierItemName
|nvarchar(300)
|
|Supplier item name
|
|-
|BasicPrice
|decimal(19,6)
|
|Basic price
|
|-
|SupplierRetailPrice
|decimal(19,6)
|
|Supplier retail price
|
|-
|Description
|nvarchar(250)
|
|Description
|
|-
|EshopDescription
|nvarchar(500)
|
|Eshop description
|
|-
|VATRate
|int
|
|ID of VAT rates from VAT rates list (see relation)
|API_GetVATRates.ID
|-
|MinimumOrderablePieces
|decimal(18,2)
|
|Minimum orderable pieces
|
|-
|UnitID
|int
|
|ID of unit from units list (see relation)
|API_GetUnits.ID
|-
|IsSale
|bit
|
|Is sale:
0 = Off,

1 = On
|
|-
|IsHiddenOnEshop
|bit
|
|Is hidden on eshop:
0 = Off,

1 = On
|

|-
|InfoReturnOfGoods
|nvarchar(50)
|
|Info return of goods
|
|-
|ID
|int
|
|Internal system id. If you create it, set it to null
|API_GetProductGroups.ID
|-
|IsArchiving
|int
|
|Is archiving. If you create it, set it to null
|
|-
|SupplierIsArchiving
|int
|
|Supplier is archiving. If you create it, set it to null
|
|}

==== Return ====
0 : OK
100 : Error

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @return_value int
Declare @ProductGrup dbo.APIsProductGroup
INSERT INTO @ProductGrup
SELECT G.[ProductCode],
G.[TecDocCode],
G.[TecDocBrandName],
G.[TecDocBrandID],
G.[GroupName],
G.[SubGoupName],
G.[AssortmentName],
G.[Name],
G.[Name2],
1, --G.[IsNew],
G.[PurchasePrice],
G.[RetailPrice],
P.[SupplierID],
P.[Prefix],
P.[SupplierProductCode],
P.[ManufacturerSupplier],
P.[SupplierItemName],
P.[BasicPrice],
P.[RetailPrice],
G.[Description],
G.[EshopDescription],
G.[VATRate],
G.[MinimumOrderablePieces],
G.[UnitID],
G.[IsSale],
G.[IsHiddenOnEshop],
P.[InfoReturnOfGoods],
G.[ID],
G.[IsArchiving],
P.[IsArchiving]
FROM [API_GetProductGroups] G
LEFT JOIN [API_GetProducts] P ON G.ID = P.GroupID
WHERE G.ID in (7,9)
union
SELECT '1457429619', '1 457 429 619', 'BOSCH', 30, 'BOSCH', null, null, 'Name', '', 1, 100, 190, 7, '', '1457429619BOS', 'BOSCH', '', 100, 220, '', '', 16028, 1, 148, 0, 0, '', null, 0, 0

exec @return_value = dbo.[API_ProductGroup_BULK] @ProductGrup
</syntaxhighlight>

==== Notices ====
API_ProductGroup_BULK procedure uses own data type called ProductGrup (dbo.APIsProductGroup).

API ProductGroup BULK - Historie editací

Chrzaszcz v 13. 8. 2020, 07:56

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update and create new product group in system. ==== Exact name ==== API_ProductGroup_BULK ==== Ty…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update and create new product group in system. ==== Exact name ==== `API_ProductGroup_BULK` ==== Ty…“