#eqprofile #begin #description Ïðîôèëü DataMobile Ìîáèëüíàÿ òîðãîâëÿ #name Ïðîôèëü DataMobile Ìîáèëüíàÿ òîðãîâëÿ #code 0000000417 #command INSERT INTO speceqprofiles (CODE,ACTION_ID,ACTION_SCRIPT,F_CHECK,FARC,UPDATED,RECEIVED,EDIT_DAT) VALUES ('----------',15.00000000,'IF ( TYPE("ÈÍÄÅÊÑÓÑÒÐÎÉÑÒÂÀ") == "U" )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ ÑÎÎÁÙÅÍÈÅ("Äëÿ ðàáîòû äàííîãî ïðîôèëÿ òðåáóåòñÿ Àéòèäà âåðñèè 4.3.2 è âûøå", "Òðåáóåòñÿ îáíîâëåíèå");/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/// ÏÅÐÅÌÅÍÍÛÅ, ÇÍÀ×ÅÍÈß ÊÎÒÎÐÛÕ ÂËÈßÞÒ ÍÀ ÀËÃÎÐÈÒÌ ÂÛÃÐÓÇÊÈ/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÎÑÒÀÒÊÈ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÄÎÊÓÌÅÍÒ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÖÅÍÛ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÑÊËÀÄÛ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÊÎÍÒÐÀÃÅÍÒΠ= true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÏÎËÜÇÎÂÀÒÅËÅÉ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÊÀÒÅÃÎÐÈÈ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÒÎÂÀÐÛ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜØÒÐÈÕÊÎÄÛ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÑÒÀÒÓÑÛÄÎÊÓÌÅÍÒΠ= true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÑÒÀÒÓÑÛÏËÀÒÅÆÅÉ = true;/##CHR(13)##//##CHR(10)##/_ÂÛÃÐÓÆÀÒÜÏÐÈ×ÈÍÛÎÒÌÅÍÛ = true;/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( ÒÈÏ( "ÑÏÈÑÎÊÄÎÊÓÌÅÍÒÎÂ" ) == "U" ) ÑÏÈÑÎÊÄÎÊÓÌÅÍÒÎÂ= "";/##CHR(13)##//##CHR(10)##/IF ( ÒÈÏ( "ÏÐÈÇÍÀÊÎ×ÈÑÒÊÈÒÑÄ" ) == "U" ) ÏÐÈÇÍÀÊÎ×ÈÑÒÊÈÒÑÄ = false;/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/_ÏÀÏÊÀÂÛÃÐÓÇÊÈ = ÇÀÏÐÎÑ( "SELECT CASE WHEN connectstring = '''' THEN serialnumber ELSE connectstring END FROM sprequipment WHERE code = ''" + ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß + "''" );/##CHR(13)##//##CHR(10)##/IF (!ÏÓÑÒÎ(_ÏÀÏÊÀÂÛÃÐÓÇÊÈ))/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( ÏÐÀÂÑÈÌÂ( _ÏÀÏÊÀÂÛÃÐÓÇÊÈ, 1 ) != "\" )/##CHR(13)##//##CHR(10)##/ _ÏÀÏÊÀÂÛÃÐÓÇÊÈ += "\";/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ IF ( ÔÀÉË(_ÏÀÏÊÀÂÛÃÐÓÇÊÈ + "IN", 1) )/##CHR(13)##//##CHR(10)##/ _ÏÀÏÊÀÂÛÃÐÓÇÊÈ += "IN\"; /##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ _ÏÀÏÊÀÂÛÃÐÓÇÊÈ = "D:\";/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÏÎËÜÇÎÂÀÒÅËÅÉ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÏîëüçîâàòåëåé() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÑÊËÀÄÛ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÌàãàçèíû() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÊÎÍÒÐÀÃÅÍÒΠ)/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÊîíòðàãåíòîâ() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##///âûãðóçêà êàòåãîðèé/##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÊÀÒÅÃÎÐÈÈ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÊàòåãîðèè() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÒÎÂÀÐÛ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÒîâàðû() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜØÒÐÈÕÊÎÄÛ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüØòðèõêîäû() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÖÅÍÛ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÖåíû() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÎÑÒÀÒÊÈ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÎñòàòêè() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÑÒÀÒÓÑÛÄÎÊÓÌÅÍÒΠ)/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÑòàòóñûÄîêóìåíòîâ() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÑÒÀÒÓÑÛÏËÀÒÅÆÅÉ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÑòàòóñûÏëàòåæåé() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( _ÂÛÃÐÓÆÀÒÜÏÐÈ×ÈÍÛÎÒÌÅÍÛ )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( !RESTAPI.DMTRADE_ÂûãðóçèòüÏðè÷èíûÎòìåíûÄîñòàâêè() )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/RETURN true;',0,0,0,0,'10.11.2023 11:37:38') #command INSERT INTO speceqprofiles (CODE,ACTION_ID,ACTION_SCRIPT,F_CHECK,FARC,UPDATED,RECEIVED,EDIT_DAT) VALUES ('----------',16.00000000,'// Èñïîëüçóéåòñÿ ñëåäóþùèé øàáëîí/##CHR(13)##//##CHR(10)##/// ØÊ;Àðòèêóë;Íàèìåíîâàíèå;Õàðàêòåðèñòèêà;ÀëêîÍàèì;ÀëêîÎáúåì;ÀëêîÊðåïîñòü;Ïðîèçâîäèòåëü;ÏðîèçâÈÍÍ;ÏðîèçâÊÏÏ;ÀëêîÊîä;ÀëêîÏÄÔ;ÀëêîÑÍ;ÄàòàÐîçëèâà;ÀëêîÅñòüÂÔîðìàõ;ÊîäÔîðìûÀ;Ôàêò/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/_ÏÀÏÊÀÇÀÃÐÓÇÊÈ = ÇÀÏÐÎÑ( "SELECT CASE WHEN connectstring = '''' THEN serialnumber ELSE connectstring END FROM sprequipment WHERE code = ''" + ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß + "''" );/##CHR(13)##//##CHR(10)##/IF (!ÏÓÑÒÎ(_ÏÀÏÊÀÇÀÃÐÓÇÊÈ))/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ IF ( ÏÐÀÂÑÈÌÂ( _ÏÀÏÊÀÇÀÃÐÓÇÊÈ, 1 ) != "\" )/##CHR(13)##//##CHR(10)##/ _ÏÀÏÊÀÇÀÃÐÓÇÊÈ += "\";/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ IF ( ÔÀÉË(_ÏÀÏÊÀÇÀÃÐÓÇÊÈ + "OUT", 1) )/##CHR(13)##//##CHR(10)##/ _ÏÀÏÊÀÇÀÃÐÓÇÊÈ += "OUT\";/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ _ÏÀÏÊÀÇÀÃÐÓÇÊÈ = "D:\";/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/_ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ = ÔÀÉËÍÀÉÒÈ( _ÏÀÏÊÀÇÀÃÐÓÇÊÈ + "*.dmU" );/##CHR(13)##//##CHR(10)##/_ÈÌßANSIÔÀÉËÀ = _ÏÀÏÊÀÇÀÃÐÓÇÊÈ + ÓÍÈÊÀËÜÍÎÅÈÌß( ) + ".txt";/##CHR(13)##//##CHR(10)##/ÈÄÄÎÊÓÌÅÍÒÀ = 1;/##CHR(13)##//##CHR(10)##/Ôèðìà = @ÔèðìàÏîÓìîë÷àíèþ;/##CHR(13)##//##CHR(10)##/Ñêëàä = ÇÀÏÐÎÑ( "SELECT sklad FROM sprequipment WHERE code= ''" + ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß + "''" );/##CHR(13)##//##CHR(10)##/ÑïèñîêÍåÍàéäåííûõ = "";/##CHR(13)##//##CHR(10)##/WHILE ( !ÏÓÑÒÎ( _ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ ) )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ // Íåîáõîäèìî ïåðåíåñòè äàííûå èç ôàéëà â òàáëèöó ñ äàííûìè/##CHR(13)##//##CHR(10)##/ ÊÎÄÄÎÊÓÌÅÍÒÀ = @ÊîäÄîêóìåíòà;/##CHR(13)##//##CHR(10)##/ _ÔÀÉËÇÀÃÐÓÇÊÈ = ÔÀÉËÎÒÊÐÛÒÜ( _ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ, 0 );/##CHR(13)##//##CHR(10)##/ ÔÀÉËÓÑÒÀÍÎÂÈÒÜÓÊÀÇÀÒÅËÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, 0 );/##CHR(13)##//##CHR(10)##/ //ÑÒÐÎÊÀ = ÏÅÐÅÊÎÄÈÐÎÂÀÒÜ( ÔÀÉËÏÐÎ×ÈÒÀÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, "S", ÔÀÉËÐÀÇÌÅÐ( _ÔÀÉËÇÀÃÐÓÇÊÈ ) ), "UTF-16", "ANSI" );/##CHR(13)##//##CHR(10)##/ ÄÀÍÍÛÅÈÇÔÀÉËÀ = ÔÀÉËÏÐÎ×ÈÒÀÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, "B", ÔÀÉËÐÀÇÌÅÐ( _ÔÀÉËÇÀÃÐÓÇÊÈ ) );/##CHR(13)##//##CHR(10)##/ /*/##CHR(13)##//##CHR(10)##/ IF (!ÏÓÑÒÎ(ÄÀÍÍÛÅÈÇÔÀÉËÀ))/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ ÑÒÐÎÊÀ = ÏÅÐÅÊÎÄÈÐÎÂÀÒÜ( ÄÀÍÍÛÅÈÇÔÀÉËÀ , "UTF-16", "ANSI" );/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ ELSE/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ ÑÒÐÎÊÀ = "";/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ *//##CHR(13)##//##CHR(10)##/ ÑÒÐÎÊÀ = ÄÀÍÍÛÅÈÇÔÀÉËÀ;/##CHR(13)##//##CHR(10)##/ ÔÀÉËÇÀÊÐÛÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ );/##CHR(13)##//##CHR(10)##/ // Çàïèñûâàåì ïåðåêîäèðîâàííóþ ñòðîêó â íîâûé ôàéë/##CHR(13)##//##CHR(10)##/ _ÔÀÉËÇÀÃÐÓÇÊÈ = ÔÀÉËÑÎÇÄÀÒÜ( _ÈÌßANSIÔÀÉËÀ );/##CHR(13)##//##CHR(10)##/ ÔÀÉËÇÀÏÈÑÀÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, ÑÒÐÎÊÀ );/##CHR(13)##//##CHR(10)##/ ÔÀÉËÓÑÒÀÍÎÂÈÒÜÓÊÀÇÀÒÅËÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, 0 );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ // Ïðîïóñêàåì ïåðâóþ ñòðîêó - ýòî ïóñòûå çàãîëîâêè/##CHR(13)##//##CHR(10)##/ ÔÀÉËÏÐÎ×ÈÒÀÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, "S" );/##CHR(13)##//##CHR(10)##/ ÊÎËÈ×ÅÑÒÂÎÑÒÐÎÊÂÔÀÉËÅ = ÔÀÉËÊÎËÈ×ÅÑÒÂÎÑÒÐÎÊ( _ÔÀÉËÇÀÃÐÓÇÊÈ );/##CHR(13)##//##CHR(10)##/ ÍÎÌÅÐÑÒÐÎÊÈÔÀÉËÀ = 0;/##CHR(13)##//##CHR(10)##/ ÈÍÄÈÊÀÒÎÐ( "Çàãðóçêà ôàéëà " + _ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ, ÊÎËÈ×ÅÑÒÂÎÑÒÐÎÊÂÔÀÉËÅ );/##CHR(13)##//##CHR(10)##/ WHILE ( !ÔÀÉËÊÎÍÅÖÔÀÉËÀ( _ÔÀÉËÇÀÃÐÓÇÊÈ ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ ÍÎÌÅÐÑÒÐÎÊÈÔÀÉËÀ++;/##CHR(13)##//##CHR(10)##/ IF ( ÍÎÌÅÐÑÒÐÎÊÈÔÀÉËÀ % 10 == 0 )/##CHR(13)##//##CHR(10)##/ ÈÍÄÈÊÀÒÎÐ( ÍÎÌÅÐÑÒÐÎÊÈÔÀÉËÀ, "Çàãðóæåíî " + ÍÎÌÅÐÑÒÐÎÊÈÔÀÉËÀ + " èç " + ÊÎËÈ×ÅÑÒÂÎÑÒÐÎÊÂÔÀÉËÅ );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ ÑÒÐÎÊÀ = ";" + ÔÀÉËÏÐÎ×ÈÒÀÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ, "S" );/##CHR(13)##//##CHR(10)##/ ÊîäÒîâàðà = ÇÀÌÅÍÈÒÜ( ÏÎËÓ×ÈÒÜÑËÎÂÎ( ÑÒÐÎÊÀ, ";",";", 2 ), """", "" );/##CHR(13)##//##CHR(10)##/ ØòðèõÊîä = ÇÀÌÅÍÈÒÜ( ÏÎËÓ×ÈÒÜÑËÎÂÎ( ÑÒÐÎÊÀ, ";",";", 3 ), """", "" );/##CHR(13)##//##CHR(10)##/ Êîëè÷åñòâî = VAL( ÇÀÌÅÍÈÒÜ( ÏÎËÓ×ÈÒÜÑËÎÂÎ( ÑÒÐÎÊÀ, ";",";", 6 ), """", "" ) );/##CHR(13)##//##CHR(10)##/ Íàèìåíîâàíèå = ÇÀÌÅÍÈÒÜ( ÏÎËÓ×ÈÒÜÑËÎÂÎ( ÑÒÐÎÊÀ, ";",";", 9 ), """", "" );/##CHR(13)##//##CHR(10)##/ ÀëêîÏÄÔ = ÇÀÌÅÍÈÒÜ( ÏÎËÓ×ÈÒÜÑËÎÂÎ( ÑÒÐÎÊÀ, ";",";", 11 ), """", "" );/##CHR(13)##//##CHR(10)##/ ÀëêîÊîä = "";/##CHR(13)##//##CHR(10)##/ IF ( !ÏÓÑÒÎ( ÀëêîÏÄÔ ) )/##CHR(13)##//##CHR(10)##/ ÀëêîÊîä = ÅÃÀÈÑ.ÀëêîÊîäÈçÌàðêè( ÀëêîÏÄÔ );/##CHR(13)##//##CHR(10)##/ Òîâàð = "";/##CHR(13)##//##CHR(10)##/ Öåíà = 0.00;/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ // Îïðåäåëÿåì òîâàð, ïî ØÊ èëè àëêîêîäó/##CHR(13)##//##CHR(10)##/ IF ( !ÏÓÑÒÎ( ÀëêîÊîä ) )/##CHR(13)##//##CHR(10)##/ Òîâàð = ÇÀÏÐÎÑ( "SELECT TOP 1 code FROM sprres_egais WHERE alcocode = ''" + STDF( ÀëêîÊîä ) + "''" );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ /* /##CHR(13)##//##CHR(10)##/ //îïðåäåëèì âåñîâîé òîâàð ïî êîäó/##CHR(13)##//##CHR(10)##/ IF ( LEN( ØòðèõÊîä ) < 13 AND ATC( ØòðèõÊîä, ÊîäÒîâàðà ) > 0 )/##CHR(13)##//##CHR(10)##/ Òîâàð = ÇÀÏÐÎÑ("SELECT code FROM sprres WHERE maincode= ''" + STDF( ÊîäÒîâàðà ) + "''");/##CHR(13)##//##CHR(10)##/ *//##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ //îïðåäåëèì òîâàð ñïåðâà ïî êîäó/##CHR(13)##//##CHR(10)##/ Òîâàð = ÇÀÏÐÎÑ("SELECT code FROM sprres WHERE maincode= ''" + STDF( ÊîäÒîâàðà ) + "''");/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ IF ( ÏÓÑÒÎ( Òîâàð ) AND !ÏÓÑÒÎ( ØòðèõÊîä ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ // Ñíà÷àëà íàäî ïîïðîáîâàòü ðàñïîçíàòü øòðèõîâîé êîä ïî øàáëîíó èç ñïðàâî÷íèêà åäèíèö èçìåðåíèÿ/##CHR(13)##//##CHR(10)##/ ÄÎÁÀÂÈÒÜÊÎÍÒÅÊÑÒ( "SELECT code, bctemplate /##CHR(13)##//##CHR(10)##/ FROM spredn /##CHR(13)##//##CHR(10)##/ WHERE bctemplate <> '''' AND LEN( bctemplate ) = " + ÄËÈÍÀ( ØòðèõÊîä ) + " AND/##CHR(13)##//##CHR(10)##/ ( CHARINDEX( SUBSTRING( bctemplate, 1, 1 ), ''0123456789'' ) = 0 OR/##CHR(13)##//##CHR(10)##/ ( CHARINDEX( SUBSTRING( bctemplate, 2, 1 ), ''0123456789'' ) = 0 AND /##CHR(13)##//##CHR(10)##/ SUBSTRING( bctemplate, 1, 1 ) = ''" + STDF( LEFT( ØòðèõÊîä, 1 ) ) + "'' ) OR/##CHR(13)##//##CHR(10)##/ SUBSTRING( bctemplate, 1, 2 ) = ''" + STDF( LEFT( ØòðèõÊîä, 2 ) ) + "'' )", "ØàáëîíûØÊ", 1 );/##CHR(13)##//##CHR(10)##/ WHILE ( !ÊÎÍÅÖÊÎÍÒÅÊÑÒÀ( "ØàáëîíûØÊ" ) AND ÏÓÑÒÎ( Òîâàð ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ ÊîäÒîâàðàÈçØÊ = "";/##CHR(13)##//##CHR(10)##/ ÀðòèêóëÈçØÊ = "";/##CHR(13)##//##CHR(10)##/ Êîëè÷åñòâîÈçØÊ = "";/##CHR(13)##//##CHR(10)##/ // Ïðîâåðÿåì íà çíà÷àùèå öèôðû, óäîâëåòâîðÿåò ëè íàø øòðèõ-êîä øàáëîíó/##CHR(13)##//##CHR(10)##/ Øàáëîí = ØàáëîíûØÊ.bctemplate;/##CHR(13)##//##CHR(10)##/ ÍåØòðèõÊîä = false;/##CHR(13)##//##CHR(10)##/ ÍîìåðÑèìâîëà = 1;/##CHR(13)##//##CHR(10)##/ ÄëèíàØàáëîíà = ÄËÈÍÀ( Øàáëîí );/##CHR(13)##//##CHR(10)##/ WHILE( ÍîìåðÑèìâîëà < ÄëèíàØàáëîíà )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ IF ( AT( "ÀÊÌÑ", ÏÎÄÑÒÐÎÊÀ( Øàáëîí, ÍîìåðÑèìâîëà, 1 ) ) == 0 AND ÏÎÄÑÒÐÎÊÀ( Øàáëîí, ÍîìåðÑèìâîëà, 1 ) <> ÏÎÄÑÒÐÎÊÀ( ØòðèõÊîä, ÍîìåðÑèìâîëà, 1 ) )/##CHR(13)##//##CHR(10)##/ ÍåØòðèõÊîä = true;/##CHR(13)##//##CHR(10)##/ ÍîìåðÑèìâîëà++;/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ IF ( ÍåØòðèõÊîä )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ ÏÐÎÏÓÑÒÈÒÜ( 1, "ØàáëîíûØÊ" );/##CHR(13)##//##CHR(10)##/ CONTINUE;/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ ÍîìåðÑèìâîëà = 1;/##CHR(13)##//##CHR(10)##/ WHILE( ÍîìåðÑèìâîëà < ÄëèíàØàáëîíà )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ Ñèìâîë = ÏÎÄÑÒÐÎÊÀ( Øàáëîí, ÍîìåðÑèìâîëà, 1 );/##CHR(13)##//##CHR(10)##/ ÑèìâîëØÊ = ÏÎÄÑÒÐÎÊÀ( ØòðèõÊîä, ÍîìåðÑèìâîëà, 1 );/##CHR(13)##//##CHR(10)##/ IF ( Ñèìâîë == "Ê" )/##CHR(13)##//##CHR(10)##/ ÊîäÒîâàðàÈçØÊ += ÑèìâîëØÊ;/##CHR(13)##//##CHR(10)##/ ELSE IF ( Ñèìâîë == "À" )/##CHR(13)##//##CHR(10)##/ ÀðòèêóëÈçØÊ += ÑèìâîëØÊ;/##CHR(13)##//##CHR(10)##/ ELSE IF ( Ñèìâîë == "Ì" )/##CHR(13)##//##CHR(10)##/ Êîëè÷åñòâîÈçØÊ += ÑèìâîëØÊ;/##CHR(13)##//##CHR(10)##/ ÍîìåðÑèìâîëà++;/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ IF ( !ÏÓÑÒÎ( ÊîäÒîâàðàÈçØÊ ) OR !ÏÓÑÒÎ( ÀðòèêóëÈçØÊ ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ Òîâàð = ÇÀÏÐÎÑ("SELECT code FROM sprres/##CHR(13)##//##CHR(10)##/ WHERE " + ÅÑËÈ( !ÏÓÑÒÎ( ÊîäÒîâàðàÈçØÊ )," maincode= ''" + STDF( VAL( ÊîäÒîâàðàÈçØÊ ) ) + "''", /##CHR(13)##//##CHR(10)##/ " a_code= = ''" + STDF( ÀðòèêóëÈçØÊ ) + "''" ) );/##CHR(13)##//##CHR(10)##/ IF ( ÏÓÑÒÎ( Êîëè÷åñòâî ) )/##CHR(13)##//##CHR(10)##/ Êîëè÷åñòâî = VAL( Êîëè÷åñòâîÈçØÊ ) / 1000.00;/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ ÏÐÎÏÓÑÒÈÒÜ( 1, "ØàáëîíûØÊ" );/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/ IF ( ÏÓÑÒÎ( Òîâàð ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ // Åñëè íå íàøëè ïîäõîäÿùèé øàáëîí èëè òîâàð, òî èùåì â òàáëèöàõ øòðèõîâûõ êîäîâ/##CHR(13)##//##CHR(10)##/ ØòðèõÊîä = STDF( ØòðèõÊîä );/##CHR(13)##//##CHR(10)##/ Òîâàð = ÇÀÏÐÎÑ("SELECT nn FROM sprnnbc WHERE bc= ''" + ØòðèõÊîä + "'' /##CHR(13)##//##CHR(10)##/ UNION SELECT code FROM sprres_ed WHERE barcode= ''" + ØòðèõÊîä + "''/##CHR(13)##//##CHR(10)##/ UNION SELECT nn FROM reg006 WHERE bc= ''" + ØòðèõÊîä + "''/##CHR(13)##//##CHR(10)##/ UNION SELECT nn FROM reg009 WHERE bc= ''" + ØòðèõÊîä + "''" );/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ IF ( !ÏÓÑÒÎ( Òîâàð ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ IF ( ÊÎÄÄÎÊÓÌÅÍÒÀ == "001" )/##CHR(13)##//##CHR(10)##/ Öåíà = ÇÀÏÐÎÑ( " SELECT TOP 1 cena/##CHR(13)##//##CHR(10)##/ FROM reg001/##CHR(13)##//##CHR(10)##/ WHERE nn= ''" + Òîâàð + "'' AND account_= ''001'' AND priz= ''+'' AND/##CHR(13)##//##CHR(10)##/ ( DATEDIFF( day, date, GETDATE( ) ) > 0 OR /##CHR(13)##//##CHR(10)##/ ( DATEDIFF( day, date, GETDATE( ) ) = 0 AND DATEDIFF( second, date, GETDATE( ) ) >= 0 ) ) AND sklad= ''" + Ñêëàä + "'' /##CHR(13)##//##CHR(10)##/ ORDER BY date DESC, identity_column DESC " );/##CHR(13)##//##CHR(10)##/ ELSE/##CHR(13)##//##CHR(10)##/ Öåíà = ÇÀÏÐÎÑ( " SELECT dbo.fn_calcsklad_cena( ''" + Òîâàð + "'', '''', ''" + Ñêëàä + "'', ''001'' )" );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ IF ( ÏÓÑÒÎ( Íàèìåíîâàíèå ) )/##CHR(13)##//##CHR(10)##/ Íàèìåíîâàíèå = ÇÀÏÐÎÑ( "SELECT name FROM sprres WHERE code = ''" + Òîâàð + "''" );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ // Åñëè íå îïðåäåëèëè òîâàð è ïóñòàÿ ìàðêà, òî âûâîäèì ñîîáùåíèå/##CHR(13)##//##CHR(10)##/ IF ( ÏÓÑÒÎ( ÀëêîÏÄÔ ) AND ÏÓÑÒÎ( Òîâàð ) AND ÏÓÑÒÎ( ÀëêîÊîä ) )/##CHR(13)##//##CHR(10)##/ ÑïèñîêÍåÍàéäåííûõ += ØòðèõÊîä + " " + Íàèìåíîâàíèå + CHR( 13 );/##CHR(13)##//##CHR(10)##/ ELSE/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ // Åñëè åñòü ìàðêà, òî âìåñòî ØÊ çàïèñûâàåì åå/##CHR(13)##//##CHR(10)##/ IF ( !ÏÓÑÒÎ( ÀëêîÏÄÔ ) ) ØòðèõÊîä = STDF( ÀëêîÏÄÔ );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ ÇÀÏÐÎÑ( "INSERT INTO " + _ÈÌßÒÀÁËÈÖÛ + " ( doccode, docid, date, nn, nnname, kolp, cena, summa, barcode, firm, sklad, alcocode )/##CHR(13)##//##CHR(10)##/ VALUES( ''" + ÊÎÄÄÎÊÓÌÅÍÒÀ + "'', " + ÈÄÄÎÊÓÌÅÍÒÀ + ", GETDATE( ), ''" + Òîâàð + "'', ''" + STDF( Íàèìåíîâàíèå )+ "'', " + STR( Êîëè÷åñòâî, 16, 3 ) + ", /##CHR(13)##//##CHR(10)##/ " + STR( Öåíà, 16, 2 ) + ", " + STR( Öåíà * Êîëè÷åñòâî, 16, 2 ) + ", ''" + ØòðèõÊîä + "'', ''" + Ôèðìà + "'', ''" + Ñêëàä + "'', ''" + STDF( ÀëêîÊîä ) + "'' )" );/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ ÈÍÄÈÊÀÒÎÐ( );/##CHR(13)##//##CHR(10)##/ ÔÀÉËÇÀÊÐÛÒÜ( _ÔÀÉËÇÀÃÐÓÇÊÈ );/##CHR(13)##//##CHR(10)##/ ÎÆÈÄÀÍÈÅ( 500 );/##CHR(13)##//##CHR(10)##/ ÔÀÉËÓÄÀËÈÒÜ( _ÈÌßANSIÔÀÉËÀ );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ ÔÀÉËÏÅÐÅÈÌÅÍÎÂÀÒÜ( _ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ, _ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ + STRTRAN( STRTRAN( STRTRAN( TTOC( ÄÀÒÀÂÐÅÌß( ), 7 ), ".","" ), ":", "" ), " ", "" ) + ".bak" );/##CHR(13)##//##CHR(10)##/ _ÈÌßÔÀÉËÀÇÀÃÐÓÇÊÈ = ÔÀÉËÍÀÉÒÈÑËÅÄÓÞÙÈÉ( );/##CHR(13)##//##CHR(10)##/ ÈÄÄÎÊÓÌÅÍÒÀ++;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##/ÔÀÉËÇÀÊÎÍ×ÈÒÜÏÎÈÑÊ( );/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( !ÏÓÑÒÎ( ÑïèñîêÍåÍàéäåííûõ ) )/##CHR(13)##//##CHR(10)##/ ÑÎÎÁÙÅÍÈÅ( "Ñëåäóþùèå òîâàðû íå áûëè íàéäåíû â áàçå äàííûõ:" + CHR( 13 ) + ÑïèñîêÍåÍàéäåííûõ );/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/RETURN true;',0,0,0,0,'10.11.2023 11:37:38') #command INSERT INTO speceqprofiles (CODE,ACTION_ID,ACTION_SCRIPT,F_CHECK,FARC,UPDATED,RECEIVED,EDIT_DAT) VALUES ('----------',18.00000000,'//Ñâîéñòâà äðàéâåðà ÒÑÄ/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( ÏÓÑÒÎ( ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß ) )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ ÑÎÎÁÙÅÍÈÅ( "Ïåðåä íàñòðîéêîé äðàéâåðà îáîðóäîâàíèÿ íåîáõîäèìî çàïèñàòü êàðòî÷êó òîðãîâîãî îáîðóäîâàíèÿ." );/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ= "";/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÄÐÀÉÂÅÐÑÓÁÄ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ+= ÅÑËÈ( !ÏÓÑÒÎ( ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ), ",", "" ) + "''DMTRADE_ÄÐÀÉÂÅÐÑÓÁÄ''";/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÑÅÐÂÅÐÁÀÇÛÄÀÍÍÛÕ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ+= ÅÑËÈ( !ÏÓÑÒÎ( ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ), ",", "" ) + "''DMTRADE_ÑÅÐÂÅÐÁÀÇÛÄÀÍÍÛÕ''";/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÏÎÐÒÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ+= ÅÑËÈ( !ÏÓÑÒÎ( ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ), ",", "" ) + "''DMTRADE_ÏÎÐÒÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ''"; /##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÏÎËÜÇÎÂÀÒÅËÜÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ+= ÅÑËÈ( !ÏÓÑÒÎ( ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ), ",", "" ) + "''DMTRADE_ÏÎËÜÇÎÂÀÒÅËÜÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ''"; /##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÏÀÐÎËÜÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ+= ÅÑËÈ( !ÏÓÑÒÎ( ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ), ",", "" ) + "''DMTRADE_ÏÀÐÎËÜÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ''"; /##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÈÌßÁÀÇÛÄÀÍÍÛÕ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ+= ÅÑËÈ( !ÏÓÑÒÎ( ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ), ",", "" ) + "''DMTRADE_ÈÌßÁÀÇÛÄÀÍÍÛÕ''"; /##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##///çàãðóçèì íàñòðîéêè èç ÁÄ/##CHR(13)##//##CHR(10)##/DMTRADE_DBDRIVER = RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DBDRIVER", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##///åñëè äðàéâåð íå óêàçàí, òî èñïîëüçóåì native client 11/##CHR(13)##//##CHR(10)##/IF ( ÏÓÑÒÎ( DMTRADE_DBDRIVER ) )/##CHR(13)##//##CHR(10)##/ DMTRADE_DBDRIVER = "SQL SERVER Native Client 11.0";/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/DMTRADE_DBSERVER = RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DBSERVER", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß ); /##CHR(13)##//##CHR(10)##/DMTRADE_DBPORT = VAL( RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DBPORT", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß ) );/##CHR(13)##//##CHR(10)##/DMTRADE_DBUSER = RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DBUSER", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/DMTRADE_DBPASSWORD = RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DBPASSWORD", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/DMTRADE_DBNAME = RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DBNAME", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/ÎÒÏÐÀÂÈÒÜÑÎÎÁÙÅÍÈÅ( _ÃËÀÂÍÎÅÎÊÍÎÏÐÈËÎÆÅÍÈß, _ÑÎÎÁÙÅÍÈÅÂÛÏÎËÍÈÒÜÊÎÌÀÍÄÓ, "ÇÀÏÐÎÑÏÀÐÀÌÅÒÐÎÂ", ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ);/##CHR(13)##//##CHR(10)##/IF ( !_ÐÅÇÓËÜÒÀÒÂÂÎÄÀÏÀÐÀÌÅÒÐΠ)/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##///åñëè ïîëå äðàéâåðà îñòàâèëè ïóñòûì, òî èñïîëüçóåì native client 11/##CHR(13)##//##CHR(10)##/DMTRADE_DBDRIVER = ÅÑËÈ( ÏÓÑÒÎ( DMTRADE_ÄÐÀÉÂÅÐÑÓÁÄ ), "SQL SERVER Native Client 11.0", DMTRADE_ÄÐÀÉÂÅÐÑÓÁÄ ); /##CHR(13)##//##CHR(10)##/DMTRADE_DBSERVER = DMTRADE_ÑÅÐÂÅÐÁÀÇÛÄÀÍÍÛÕ; /##CHR(13)##//##CHR(10)##/DMTRADE_DBPORT = DMTRADE_ÏÎÐÒÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ;/##CHR(13)##//##CHR(10)##/DMTRADE_DBUSER = DMTRADE_ÏÎËÜÇÎÂÀÒÅËÜÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ;/##CHR(13)##//##CHR(10)##/DMTRADE_DBPASSWORD = DMTRADE_ÏÀÐÎËÜÑÅÐÂÅÐÀÁÀÇÛÄÀÍÍÛÕ;/##CHR(13)##//##CHR(10)##/DMTRADE_DBNAME = DMTRADE_ÈÌßÁÀÇÛÄÀÍÍÛÕ;/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##///ïåðåçàïèøåì â ÁÄ çíà÷åíèÿ ïàðàìåòðîâ/##CHR(13)##//##CHR(10)##/RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DBDRIVER", DMTRADE_DBDRIVER, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DBSERVER", DMTRADE_DBSERVER, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DBPORT", DMTRADE_DBPORT, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DBUSER", DMTRADE_DBUSER, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DBPASSWORD", DMTRADE_DBPASSWORD, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DBNAME", DMTRADE_DBNAME, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/_ÐÅÇÓËÜÒÀÒÂÂÎÄÀÏÀÐÀÌÅÒÐΠ= false;/##CHR(13)##//##CHR(10)##///åñëè ïàðàìåòðû ñâÿçè ñ ÁÄ íå îïðåäåëåíû, òî íå âûïîëíÿåì çàïðîñîâ ê ÁÄ DM/##CHR(13)##//##CHR(10)##/IF ( ÏÓÑÒÎ( DMTRADE_DBSERVER ) OR ÏÓÑÒÎ( DMTRADE_DBUSER ) OR ÏÓÑÒÎ( DMTRADE_DBPASSWORD ) OR ÏÓÑÒÎ( DMTRADE_DBNAME ) )/##CHR(13)##//##CHR(10)##/ RETURN true;/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##///ïðîâåðèì ñîåäèíåíèå ñ ÁÄ/##CHR(13)##//##CHR(10)##/ÐåçóëüòàòÏðîâåðêè = RESTAPI.DMTRADE_ÏðîâåðèòüÑîåäèíåíèåÑÁÄ( ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß, true );/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##///ïîëó÷èì ñïèñîê óñòðîéñòâ ñ ñåðâåðà/##CHR(13)##//##CHR(10)##/IF ( ! RESTAPI.DMTRADE_ÏðîâåðèòüÏàðàìåòðÑèñòåìû( "DMTRADE_ÈÄÓÑÒÐÎÉÑÒÂÀ" ) )/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ELSE/##CHR(13)##//##CHR(10)##/ ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ= "''DMTRADE_ÈÄÓÑÒÐÎÉÑÒÂÀ''";/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/IF ( RESTAPI.DMTRADE_Ïîëó÷èòüÄàííûåÈçÁÄ( ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß, "SELECT ID, CONVERT( binary, Name ) AS NAME, CONVERT( binary, SN ) AS SN, TimeLastSync FROM Devices", "Òàáëèöà óñòðîéñòâ", true ) )/##CHR(13)##//##CHR(10)##/{/##CHR(13)##//##CHR(10)##/ //ñîçäàäèì âðåìåííóþ òàáëèöó ñ ìîáèëüíûìè óñòðîéñòâàìè, â êîòîðóþ çàïèøåì âñå ïîëó÷åííûå èç ÁÄ DM óñòðîéñòâà äëÿ èõ ïîñëåäóþùåãî âûáîðà/##CHR(13)##//##CHR(10)##/ DMTRADE_ÈìÿÒàáëèöûÓñòðîéñòâ = "##DMTRADE_Devices";/##CHR(13)##//##CHR(10)##/ ÇÀÏÐÎÑ ( "IF object_id( ''tempdb.." + DMTRADE_ÈìÿÒàáëèöûÓñòðîéñòâ + "'' ) is not null DROP TABLE " + DMTRADE_ÈìÿÒàáëèöûÓñòðîéñòâ );/##CHR(13)##//##CHR(10)##/ ÇÀÏÐÎÑ ( "CREATE TABLE " + DMTRADE_ÈìÿÒàáëèöûÓñòðîéñòâ + " ( ID int, Name nvarchar(100), SN nvarchar(100), TimeLastSync datetime )" );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ ÂÛÁÐÀÒÜÊÎÍÒÅÊÑÒ( "DMTRADE_DATATABLE" ); /##CHR(13)##//##CHR(10)##/ WHILE ( !ÊÎÍÅÖÊÎÍÒÅÊÑÒÀ( "DMTRADE_DATATABLE" ) )/##CHR(13)##//##CHR(10)##/ {/##CHR(13)##//##CHR(10)##/ ÇÀÏÐÎÑ("INSERT INTO " + DMTRADE_ÈìÿÒàáëèöûÓñòðîéñòâ + " ( ID, Name, SN, TimeLastSync )/##CHR(13)##//##CHR(10)##/ VALUES ( " + STR( DMTRADE_DATATABLE.ID, 10, 0 ) + ",''" + /##CHR(13)##//##CHR(10)##/ STDF( ÏÅÐÅÊÎÄÈÐÎÂÀÒÜ( DMTRADE_DATATABLE.Name, ''Unicode'', ''ANSI'' ), 100 ) + "'',''" + /##CHR(13)##//##CHR(10)##/ STDF( ÏÅÐÅÊÎÄÈÐÎÂÀÒÜ( DMTRADE_DATATABLE.SN, ''Unicode'', ''ANSI'' ), 100 ) + "'',''" + /##CHR(13)##//##CHR(10)##/ DMTRADE_DATATABLE.TimeLastSync + "'' )");/##CHR(13)##//##CHR(10)##/ ÏÐÎÏÓÑÒÈÒÜ( 1, "DMTRADE_DATATABLE" );/##CHR(13)##//##CHR(10)##/ }/##CHR(13)##//##CHR(10)##/ ÓÄÀËÈÒÜÊÎÍÒÅÊÑÒ( "DMTRADE_DATATABLE" );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ //çàãðóçèì íàñòðîéêó ñ âûáðàííûì ÈÄ óñòðîéñòâà èç ÁÄ/##CHR(13)##//##CHR(10)##/ DMTRADE_DEVICEID = RESTAPI.DMTRADE_ÇàãðóçèòüÏàðàìåòðÑîåäèíåíèÿ( "DEVICEID", ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß );/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ //âûâåäåì çàïðîñ ïàðàìåòðîâ ñ âûáîðîì óñòðîéñòâà äëÿ ïðèâÿçêè ê îáîðóäîâàíèþ/##CHR(13)##//##CHR(10)##/ ÎÒÏÐÀÂÈÒÜÑÎÎÁÙÅÍÈÅ( _ÃËÀÂÍÎÅÎÊÍÎÏÐÈËÎÆÅÍÈß, _ÑÎÎÁÙÅÍÈÅÂÛÏÎËÍÈÒÜÊÎÌÀÍÄÓ, "ÇÀÏÐÎÑÏÀÐÀÌÅÒÐÎÂ", ÑÏÈÑÎÊÇÀÏÐÀØÈÂÀÅÌÛÕÏÀÐÀÌÅÒÐΠ);/##CHR(13)##//##CHR(10)##/ IF ( !_ÐÅÇÓËÜÒÀÒÂÂÎÄÀÏÀÐÀÌÅÒÐΠ)/##CHR(13)##//##CHR(10)##/ RETURN false;/##CHR(13)##//##CHR(10)##/ /##CHR(13)##//##CHR(10)##/ //ñîõðàíèì ïàðàìåòð â áàçå/##CHR(13)##//##CHR(10)##/ DMTRADE_DEVICEID = DMTRADE_ÈÄÓÑÒÐÎÉÑÒÂÀ; /##CHR(13)##//##CHR(10)##/ RESTAPI.DMTRADE_ÑîõðàíèòüÏàðàìåòðÑîåäèíåíèÿ( "DEVICEID", DMTRADE_DEVICEID, ÊÎÄÎÁÎÐÓÄÎÂÀÍÈß ); /##CHR(13)##//##CHR(10)##/}/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/RETURN true;',0,0,0,0,'10.11.2023 11:37:38') #command INSERT INTO speceqprofiles (CODE,ACTION_ID,ACTION_SCRIPT,F_CHECK,FARC,UPDATED,RECEIVED,EDIT_DAT) VALUES ('----------',19.00000000,'//Èìÿ óñòðîéñòâà ÒÑÄ/##CHR(13)##//##CHR(10)##/ÈÌßÓÑÒÐÎÉÑÒÂÀ = "DataMobile: Ìîáèëüíàÿ òîðãîâëÿ";/##CHR(13)##//##CHR(10)##//##CHR(13)##//##CHR(10)##/RETURN ÈÌßÓÑÒÐÎÉÑÒÂÀ;',0,0,0,0,'10.11.2023 11:37:38') #command INSERT INTO speceqprofiles (CODE,ACTION_ID,ACTION_SCRIPT,F_CHECK,FARC,UPDATED,RECEIVED,EDIT_DAT) VALUES ('----------',20.00000000,'//Êîëè÷åñòâî óñòðîéñòâ ÒÑÄ/##CHR(13)##//##CHR(10)##/RETURN 1;',0,0,0,0,'10.11.2023 11:37:38') #command INSERT INTO spreqprofiles (CODE,EX_CODE,NAME,TYPE,PORT,NOTE,PARENT,POSORDER,NOTAVAIL,MAINDB,MAINIC,CACCESS,TACCESS,FOLDER,RID,FARC,UPDATED,RECEIVED,EDIT_DAT) VALUES ('','','Ïðîôèëü DataMobile Ìîáèëüíàÿ òîðãîâëÿ','ÒÑÄ',0.00000000,'',0.00000000,7580.00000000,0,'',0.00000000,'','',0,'BB8A38B8-CBF9-421C-A625-0B792FEA2852',0,1,0,'10.11.2023 11:37:38')