,

Add(MainForm,2953706,98,140)
{
Width=1252
Height=791
link(onCreate,12987101:doEvent1,[])
}
Add(ChildPanelRush,16763009,217,210)
{
@Hint=#18:Список спортсменов|
link(onError,7275040:doWork,[])
link(Data1,10742668:Var2,[])
}
BEGIN_SDK
Add(EditMultiEx,3445826,21,21)
{
WorkCount=#9:doVisible|8:doString|7:doWork2|
EventCount=#7:onError|
DataCount=#5:Data1|
Width=937
Height=956
link(doVisible,396614:doEvent1,[(158,27)(158,202)])
link(doString,5183992:doWork1,[(49,34)(49,188)])
link(doWork2,5183992:doWork2,[(36,41)(36,195)])
}
Add(PanelRush,2319833,224,35)
{
Left=5
Top=40
Width=1220
Height=624
Layout="parent.sidebar"
WidthScale=100
Glyphs=[]
Point(doVisible)
}
Add(ChildPanel,5183992,70,182)
{
link(onEvent1,1722227:doWork2,[(121,188)(121,153)])
link(onEvent2,6949883:doQuery,[(121,195)(121,233)(58,233)(58,272)])
link(onEvent3,16258063:doEvent1,[(464,202)(464,461)])
link(onEvent4,396614:doEvent2,[])
link(Data1,3445826:Data1,[(76,102)(27,102)])
}
BEGIN_SDK
Add(EditMulti,12371822,21,21)
{
EventCount=4
WorkCount=3
DataCount=1
VarCount=2
Width=1084
Height=382
link(doWork1,1154872:doEvent2,[(582,27)(582,139)])
link(doWork2,6701094:doExecute,[(67,34)(67,139)])
link(Var1,15072164:dbSession,[(27,354)(699,354)])
link(Var2,6111724:FString,[(34,357)(1000,357)])
}
Add(Panel,6465823,112,49)
{
Left=2
Top=2
Width=1216
Height=53
Align=2
Layout="parent.vert"
}
Add(ComboBox,15474256,756,140)
{
Left=12
Top=16
Width=285
Height=21
Font=[Verdana,10,0,0,204]
Text=""
ReadOnly=0
Point(doSelectString)
link(onClick,162677:doEvent2,[(800,153)(800,195)(583,195)(583,237)])
}
Add(ODialog,6701094,112,133)
{
Filter="Microsoft Excel (.xls,.xlsx)|*.xls;*.xlsx"
Title="Выбрать файл"
FileName=""
Select=1
link(onExecute,5822952:doString,[])
}
Add(FileTools,9696297,357,133)
{
link(onEnd,1966518:doEvent,[])
}
Add(FilePartElm,10813017,231,133)
{
Point(Part)
link(onPart,2318333:doString,[])
}
Add(FormatStr,2318333,294,133)
{
Mask="%2%1"
Point(FString)
link(onFString,9696297:doFileExists,[(342,139)(342,160)])
link(Str2,3713749:Var1,[(307,103)])
}
Add(IndexToChanel,1966518,406,133)
{
link(onEvent1,5492936:doCopy,[])
}
Add(FormatStr,5822952,175,133)
{
Mask="%1"
Point(FString)
link(onFString,10813017:doPart,[])
}
Add(FileTools,5492936,462,126)
{
link(onEnd,6884805:doEvent1,[])
link(FileName,5822952:FString,[(468,114)(162,114)(162,179)(181,179)])
link(NewFileName,2318333:FString,[(475,114)(514,114)(514,177)(300,177)])
}
Add(FileSearch,7071899,630,140)
{
Ext="*.xl*"
link(onSearch,16246838:doPart,[])
link(onEndSearch,6106797:doData,[(668,153)(668,121)(219,121)(219,188)])
link(Dir,3713749:Var2,[])
}
Add(Hub,1154872,595,126)
{
InCount=2
OutCount=3
link(onEvent1,15474256:doClear,[(733,132)(733,153)])
link(onEvent2,8773124:doString,[(623,139)(623,69)])
link(onEvent3,7071899:doSearch,[])
}
Add(FormatStr,8773124,637,63)
{
Mask="%1Files\"
Point(FString)
link(Str1,12371822:Data1,[(643,42)(27,42)])
}
Add(FilePartElm,16246838,693,140)
{
link(onPart,15474256:doAdd,[])
}
Add(GetDataEx,3713749,637,98)
{
link(Data,8773124:FString,[])
}
Add(DoData,6106797,231,182)
{
link(onEventData,15474256:doSelectString,[])
link(Data,10813017:Part,[])
}
Add(FormatStr,8382041,840,140)
{
Mask="Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};\r\nDriverID=22;\r\nDBQ=%1;\r\nDefaultDir=%2;\r\nFirstRowWhasNames=1;\r\nReadOnly=true;\r\nScanRows=0;"
Point(FString)
link(Str2,15693269:Var3,[(853,103)])
AddHint(53,-106,187,104,Mask)
}
Add(OLEdb,7245872,630,287)
{
Point(onError)
link(onConnect,15072164:doCreate,[])
link(Driver,8382041:FString,[(636,207)(846,207)])
link(onError,3993591:doWork2,[(676,300)(676,328)])
}
Add(OLEdb_Session,15072164,693,287)
{
Point(onError)
link(onError,3993591:doWork1,[(737,300)])
}
Add(ArrayRW,10125309,938,294)
{
link(onRead,6111724:doString,[])
link(Array,14512374:Array,[])
link(Index,14512374:Index,[(951,268)(958,268)])
}
Add(FormatStr,6111724,994,294)
{
DataCount=3
Mask="SELECT * FROM "%2"."%1$A1:P" "%1$";"
Point(FString)
link(onFString,12371822:onEvent2,[(1066,300)(1066,34)])
link(Str2,4260558:FString,[(1007,275)(762,275)])
AddHint(-100,-146,183,26,Mask)
}
Add(ComboBox,14512374,938,203)
{
Left=327
Top=16
Width=200
Height=21
Font=[Verdana,10,1,0,204]
Text=""
ReadOnly=0
DropDownCount=20
Point(Index)
Point(doSelectString)
}
Add(VBJScript,10100796,840,238)
{
@Hint=#16:Query SQL Server|
WorkPoints=#6:doOpen|7:doSheet|7:doClose|
EventPoints=#8:onSheets|6:onOpen|
Script=#9:Dim strIn|5:Dim i|5:Dim j|12:Dim objExcel|11:Dim onExcel|0:|22:Sub doWork(Data,Index)|18: Select Case Index|15: Case "doOpen"|52: Set objExcel = CreateObject("Excel.Application")|52: Set objWorkbook = objExcel.Workbooks.Open (Data)|71: j = objWorkbook.Sheets.Count 'Узнаём количество листов|88: For i=1 To j 'Листы начинаются не с "0", а с "1" |86: strIn = objWorkbook.Sheets(i).Name 'Узнаём имя очередного листа |65: sys.onSheets strIn 'Выводим имя наружу|9: Next|17: sys.onOpen 1 |94: 'Case "doSheet" 'На вход подаётся строка, содержащая имя Листа|33: 'objExcel.Sheets(Data).Select|38: 'objExcel.ActiveSheet.Cells.Select|43: 'objExcel.Selection.NumberFormat = "@" |39: 'objExcel.ActiveWorkbook.Save() |17: Case "doClose"|17: objExcel.Quit|26: Set objExcel = Nothing|17: sys.onOpen 0 |0:|11: End Select|0:|7:End Sub|
UseName=0
link(onSheets,11519168:doEvent1,[])
}
Add(FormatStr,4260558,756,224)
{
DataCount=3
Mask="%3%2"
Point(FString)
link(onFString,2059942:doEvent1,[])
link(Str2,15474256:String,[])
link(Str3,15693269:Var2,[])
}
Add(Hub,2059942,805,224)
{
OutCount=4
link(onEvent1,8382041:doString,[(829,230)(829,146)])
link(onEvent2,14512374:doClear,[(914,237)(914,216)])
link(onEvent3,10100796:doOpen,[])
link(onEvent4,10100796:doClose,[(829,251)(829,258)])
}
Add(Hub,11519168,889,238)
{
link(onEvent1,14512374:doAdd,[(921,244)(921,209)])
link(onEvent2,14512374:doSelectString,[])
}
Add(Hub,6884805,525,126)
{
link(onEvent1,1154872:doEvent1,[])
link(onEvent2,162677:doEvent1,[(567,139)(567,230)])
}
Add(Hub,162677,595,224)
{
InCount=3
link(onEvent1,4260558:doString,[])
link(onEvent2,7245872:doOpen,[(619,237)(619,293)])
}
Add(Button,13955783,511,238)
{
Left=300
Top=15
Width=25
Height=25
Font=[MS Sans Serif,10,0,0,1]
Caption=">"
link(onClick,162677:doEvent3,[])
}
Add(GetDataEx,15693269,770,98)
{
Angle=3
link(Data,3713749:Var3,[])
}
Add(Button,16694623,840,294)
{
Left=530
Top=16
Width=75
Caption="Прочитать"
link(onClick,10125309:doRead,[])
}
Add(LineBreakEx,505374,756,322)
{
Caption="error"
}
Add(HubEx,3993591,733,322)
{
link(onEvent,505374:doWork,[])
}
Add(LineBreakEx,15609658,819,21)
{
Caption="error"
Type=1
link(OnEvent,12371822:onEvent1,[])
}
Add(Button,15176750,1050,350)
{
Left=630
Top=17
Width=135
Caption="Вывод в таблицу"
link(onClick,12371822:onEvent3,[(1094,356)(1094,41)])
}
END_SDK
Add(MTStrTbl,11420048,469,203)
{
Left=10
Top=60
Width=1188
Height=540
Font=[Trebuchet MS,10,0,0,204]
Name="tab_1"
Layout="vert"
HeightScale=100
ColumnWidth=125
Grid=0
ChangeWidth=1
SmallIconsManager="icons"
DrawManager="parent.color"
Point(onResize)
link(onClientRect,7369290:doValue,[])
}
Add(MST_Clear,4248970,231,203)
{
ClearAll=0
MSTControl="tab_1"
link(onChange,7468935:doEnum,[])
}
Add(MST_RowAction,11858166,406,245)
{
MSTControl="tab_1"
}
Add(VisualStrings,8002343,357,245)
{
Point(doText)
Point(onText)
link(onText,11858166:doRowAction,[])
}
Add(IconsManager,6182759,406,154)
{
Name="icons"
ImgSize=23
Icons=[]
}
Add(For,15293353,483,259)
{
Start=2
IncludeEnd=1
link(onEvent,15398697:doEvent1,[])
link(End,11420048:CountCol,[])
}
Add(Hub,396614,182,196)
{
InCount=3
OutCount=3
link(onEvent1,8037998:doClear,[(221,202)(221,328)])
link(onEvent2,4248970:doClear,[])
}
Add(MT_Add,12744814,567,259)
{
Data=Integer(0)
InputMT=1
link(onAdd,11420048:doClientRect,[(606,265)(606,195)(459,195)(459,209)])
}
Add(Hub,15398697,532,259)
{
OutCount=5
link(onEvent2,12744814:doAdd,[(556,272)(556,265)])
link(onEvent3,13943142:doAdd,[(581,279)(581,272)])
}
Add(MT_Memory,7369290,623,224)
{
}
Add(MT_Add,13943142,623,266)
{
link(onAdd,14592175:##add,[])
link(Data,7369290:Value,[])
}
Add(MT_Add,10032579,812,266)
{
InputMT=1
link(onAdd,2164106:doEvent1,[])
link(Data,3581317:GetData,[])
}
Add(EventFromData,3581317,812,196)
{
link(onEvent,2375588:doOperation,[])
}
Add(Math,2375588,868,196)
{
Op2=2
ResultType=0
link(onResult,3581317:doData,[(914,202)(914,177)(804,177)(804,202)])
link(Op1,14592175:##eventIndex,[(874,191)(905,191)(905,348)(734,348)])
}
Add(MST_ColAction,8424163,406,203)
{
MSTControl="tab_1"
}
Add(StrList,8126035,273,133)
{
Strings=#3: =0|8:№=45==2;|19:Фамилия Имя=170==0;|13:Дата рождения|3:Пол|13:Тренер/Регион|6:Разряд|12:Группа (А-Б)|13:Вид программы|19:Партнер для Дуйлянь|
}
Add(ArrayEnum,7468935,287,203)
{
link(onItem,8424163:doColAction,[])
link(onEndEnum,8002343:doText,[(334,216)(334,251)])
link(Array,8126035:Array,[])
}
Add(VBoxLayout,8984564,224,77)
{
Name="vert"
}
Add(LineBreakEx,4329885,168,147)
{
Caption="error"
}
Add(LineBreakEx,8129517,833,63)
{
Caption="error"
Type=1
link(OnEvent,3445826:onError,[(916,69)(916,27)])
}
Add(OLEdb_Query,6949883,70,266)
{
link(onQuery,16341124:doStr,[(132,272)(132,391)])
link(onColumns,3706937:doEnum,[(122,279)(122,335)])
link(onError,1722227:doWork3,[(144,286)])
link(dbSession,5183992:Var1,[])
link(Text,5183992:Var2,[])
}
Add(MT_Enum,3706937,161,329)
{
link(onItem,8037998:doAdd,[(598,335)(598,321)])
link(onEndEnum,16347290:doEvent1,[])
}
Add(HubEx,1722227,140,147)
{
link(onEvent,4329885:doWork,[])
}
Add(MST_RowAction,3745421,497,385)
{
MSTControl="tab_1"
}
Add(FormatStr,16026086,273,448)
{
Mask=";%2;%1"
link(onFString,7529942:doMultiReplace,[])
link(Str2,7748722:Count,[])
}
Add(CounterEx,7748722,280,385)
{
Max=50000
Point(doReset)
}
Add(Hub,1756548,231,385)
{
link(onEvent1,7748722:doNext,[])
link(onEvent2,16026086:doString,[(263,398)(263,454)])
}
Add(MT_String,16341124,161,385)
{
link(onResult,15716330:doAdd,[(206,391)(206,783)])
}
Add(MT_String,6368181,448,385)
{
link(onResult,3745421:doRowAction,[])
}
Add(ChildPanelEx,14592175,728,266)
{
Mode=1
link(onClick,10032579:doAdd,[])
link(onEvent3,14930183:doEnum,[(774,279)(774,416)(632,416)(632,377)])
}
BEGIN_SDK
Add(EditMultiEx,3666061,21,21)
{
WorkCount=#5:##add|7:##clear|5:doAdd|7:doClear|0:|
EventCount=#7:onClick|8:onEvent3|8:onEvent2|
VarCount=#12:##eventIndex|0:|
Height=347
Point(##add)
Point(##clear)
Point(##eventIndex)
link(##add,3080955:doEvent1,[])
link(doAdd,700701:doEvent1,[(32,41)(32,104)])
}
Add(ComboBox,11831577,161,133)
{
Width=56
Height=21
Text="Метро"
ReadOnly=0
DropDownCount=15
BoxDrawManager="col"
Point(doSelect)
Point(doWidth)
Point(doHeight)
link(onClick,3666061:onClick,[(257,146)(257,27)])
}
Add(Panel,13780392,161,42)
{
Left=30
Top=92
Width=150
Point(doLeft)
Point(doTop)
Point(doWidth)
Point(doHeight)
Point(doBringToFront)
}
Add(MT_MultiData,6426008,91,49)
{
From=1
Count=4
link(onData1,13780392:doLeft,[])
link(onData2,13780392:doTop,[])
link(onData3,13780392:doWidth,[])
link(onData4,13780392:doHeight,[])
}
Add(Hub,3080955,42,21)
{
OutCount=5
link(onEvent2,3666061:onEvent3,[])
link(onEvent3,6426008:doSeparateMT,[(74,41)(74,55)])
link(onEvent4,14082670:doSeparateMT,[(74,48)(74,167)])
link(onEvent5,13780392:doBringToFront,[(64,55)(64,83)])
}
Add(MT_MultiData,14082670,91,161)
{
Count=5
link(onData1,2228938:doOperation,[(135,167)(135,213)(79,213)(79,230)])
link(onData4,11831577:doWidth,[])
link(onData5,11831577:doHeight,[])
}
Add(StrList,1422913,252,161)
{
Strings=#1:1|1:2|1:3|1:4|1:5|1:6|1:7|1:8|1:9|2:10|2:11|2:12|2:13|2:14|2:15|2:16|2:17|2:18|2:19|2:20|
Point(doGetString)
Point(onGetString)
Point(Index)
}
Add(BoxDrawManager,15301189,28,161)
{
Name="col"
Gutter=1
StyleBack=1
ImageShift=1
GutterShift=1
GutterWidth=1
InversGrad=0
InversGutt=0
DarkColor=-16777214
ColorFrame=-16777201
LightClrGutt=-16777201
DarkClrGutt=-16777201
DarkClrBack=-16777201
}
Add(Math,2228938,91,224)
{
Op2=-2
link(onResult,11831577:doSelect,[(142,230)(142,181)])
}
Add(Hub,700701,112,98)
{
link(onEvent1,11831577:doAdd,[(144,104)(144,139)])
}
END_SDK
Add(StrList,8037998,630,315)
{
}
Add(ArrayEnum,14930183,644,371)
{
link(onItem,14592175:doAdd,[(705,377)(705,286)])
link(Array,8037998:Array,[])
}
Add(StrList,10284801,329,371)
{
Strings=#10: 0:00:00=;|
}
Add(MultiReplace,7529942,322,448)
{
link(onResult,6368181:doMTString,[(401,454)(401,405)])
link(ReplaceList,10284801:Text,[])
}
Add(FormatStr,9502191,448,896)
{
DataCount=9
Mask="%2;%3;%4;%5;%6;%7;%8;%9"
Point(FString)
link(onFString,1756548:doEvent1,[(525,902)(525,934)(214,934)(214,391)])
link(Str2,9496124:Part1,[])
link(Str3,7650402:Part1,[(468,879)(475,879)])
link(Str4,3129939:Part1,[(475,879)(489,879)])
link(Str5,13630037:Part1,[(482,879)(503,879)])
link(Str6,3860584:Part1,[(489,879)(517,879)])
link(Str7,1191090:Part1,[(496,879)(531,879)])
link(Str8,15714012:Part1,[(503,879)(545,879)])
link(Str9,11512437:Part1,[(510,879)(559,879)])
AddHint(-51,51,148,13,Mask)
}
Add(MultiStrPart,9496124,455,518)
{
Count=1
Point(doFrom)
}
Add(StrList,15716330,245,777)
{
}
Add(ArrayEnum,6808174,259,840)
{
link(onItem,3343078:doEvent1,[])
link(Array,15716330:Array,[])
}
Add(Hub,3343078,308,840)
{
OutCount=9
link(onEvent1,9496124:doSplit,[(396,846)(396,524)])
link(onEvent2,7650402:doSplit,[(396,853)(396,566)])
link(onEvent3,3129939:doSplit,[(396,860)(396,608)])
link(onEvent4,13630037:doSplit,[(396,867)(396,650)])
link(onEvent5,3860584:doSplit,[(396,874)(396,699)])
link(onEvent6,1191090:doSplit,[(396,881)(396,741)])
link(onEvent7,15714012:doSplit,[(396,888)(396,783)])
link(onEvent8,11512437:doSplit,[(396,895)(396,825)])
link(onEvent9,9502191:doString,[])
}
Add(MST_Clear,124635,868,455)
{
MSTControl="tab_1"
}
Add(Hub,16258063,826,455)
{
InCount=3
OutCount=4
link(onEvent1,124635:doClear,[])
link(onEvent2,7748722:doReset,[(852,468)(852,437)(268,437)(268,398)])
link(onEvent3,239713:doData,[(852,475)(852,661)(177,661)(177,846)])
}
Add(Hub,16347290,399,336)
{
InCount=2
link(onEvent1,15293353:doFor,[(465,342)(465,265)])
link(onEvent2,16258063:doEvent2,[(619,349)(619,468)])
}
Add(MT_MultiData,4576189,273,644)
{
link(onData1,14206171:doEvent,[])
}
Add(MultiStrPart,7650402,469,560)
{
From=1
Count=1
Point(doFrom)
}
Add(MultiStrPart,3129939,483,602)
{
From=2
Count=1
Point(doFrom)
}
Add(MultiStrPart,13630037,497,644)
{
From=3
Count=1
Point(doFrom)
}
Add(MultiStrPart,3860584,511,693)
{
From=4
Count=1
Point(doFrom)
}
Add(MultiStrPart,1191090,525,735)
{
From=5
Count=1
Point(doFrom)
}
Add(MultiStrPart,15714012,539,777)
{
From=6
Count=1
Point(doFrom)
}
Add(MultiStrPart,11512437,553,819)
{
From=7
Count=1
Point(doFrom)
}
Add(Hub,2164106,854,266)
{
OutCount=5
link(onEvent2,3353702:doColAction,[])
link(onEvent3,16258063:doEvent3,[(886,286)(886,382)(814,382)(814,475)])
link(onEvent5,9880631:doEvent1,[(900,300)(900,506)(231,506)(231,531)])
}
Add(MST_ColAction,3353702,917,273)
{
Action=5
MSTControl="tab_1"
}
Add(DoData,239713,189,840)
{
link(onEventData,6808174:doEnum,[])
}
Add(IndexToChanel,14206171,343,644)
{
Count=10
Point(Data)
link(onEvent3,9496124:doFrom,[(401,664)(401,538)])
link(onEvent4,7650402:doFrom,[(408,671)(408,580)])
link(onEvent5,3129939:doFrom,[(415,678)(415,622)])
link(onEvent6,13630037:doFrom,[(422,685)(422,664)])
link(onEvent7,3860584:doFrom,[(429,692)(429,713)])
link(onEvent8,1191090:doFrom,[(436,699)(436,755)])
link(onEvent9,15714012:doFrom,[(443,706)(443,797)])
link(onEvent10,11512437:doFrom,[(450,713)(450,839)])
link(Data,5658346:Value2,[(349,632)(317,632)(317,744)(286,744)])
}
Add(MT_MultiMem,5658346,273,700)
{
}
Add(Hub,9880631,238,525)
{
OutCount=4
link(onEvent2,4576189:doSeparateMT,[(262,538)(262,650)])
link(onEvent3,5658346:doValue,[(262,545)(262,706)])
}
END_SDK
Add(LineBreakEx,7275040,266,210)
{
Caption="error"
}
Add(Button,12630303,98,224)
{
Left=15
Top=10
Width=165
Caption="OpenExcel"
link(onClick,16763009:doWork2,[])
}
Add(Dir,5699205,217,77)
{
Point(MyDocumentDir)
}
Add(FormatStr,10996460,259,154)
{
Mask="%1Files\"
link(onFString,5699205:doDir,[(303,160)(303,118)(205,118)(205,83)])
link(Str1,10742668:Var3,[(265,131)])
}
Add(GetDataEx,10742668,217,126)
{
link(Data,5699205:CurrentDir,[])
}
Add(Hub,12987101,140,154)
{
OutCount=3
link(onEvent1,10996460:doString,[])
link(onEvent2,16763009:doVisible,[(186,167)(186,216)])
link(onEvent3,16763009:doString,[(186,174)(186,223)])
}