Please enable JavaScript.
Coggle requires JavaScript to display documents.
OrderService VandenBan (StartThreadWorkerVdbanDownload (SELECT ID FROM…
OrderService
VandenBan
StartThreadWorkerVdbanDownload
SELECT ID FROM OnioIO.dbo.VDBAN_orders WHERE Predat = 0 AND Predano IS NOT NULL AND Odeslano IS NULL AND Stornovano IS NULL AND Neresit = 0 AND Predano > DATEADD(mm,-1, GETDATE()) ORDER BY Vlozeni DESC
Je tam neco ??
Ne skonci
Jo
Sestav XML a zepetj se na
https://webservice.vandenban.nl/webservices
zavolej ITr1002501_vdban_sluzba_bezi
INSERT INTO OnioIO.dbo.VDBAN_order_ReturnFiles([FileName], [Content], Downloaded)
VALUES(@fname
,
fdata,
GETDATE())
Vracena data jako
soubry zapis do SQL
OnioIO.dbo.VDBAN_order_ReturnFiles SET [Content] =
fdata,
Downloaded = GETDATE() where [FileName] =
fname
Pripadne do Update
Parse....
Zalzoeni objednavky :VDban_vytvor_objednavku
StartThreadWorkerVdbanUpload
SELECT ID FROM OnioIO.dbo.VDBAN_orders WHERE Predat = 1 AND Predano IS NULL AND Neresit = 0 ORDER BY Vlozeni DESC
je tam neco noveho ?
Ne skonci
Jo - vytvor XML ktere posles na ASMX
Vezmi data z VDBAN_orders a VDBAN_order_senders
sestav z nich XML
Ktere posli na
https://webservice.vandenban.nl/webservices
pak zavolej v SQL Reporty.dbo.ITr1002501_vdban_sluzba_bezi
pokud vznikne chyba zavolej OnioIO.dbo.VDBAN_order_ErrorStore
ID ktrere je v odpovedi web serice vem a potvrd v DB ze robhla obejdnavka idObjednavkyVDBAN
Pak jeste zavolej
2 more items...