Add(ChildForm,9467718,546,98)
{
 FirstUsage=0
}
BEGIN_SDK
  Add(EditMulti,2379941,-35,-7)
  {
   EventCount=6
   WorkCount=1
   DataCount=1
   VarCount=2
   Width=1329
   Height=823
   link(doWork1,14021805:doShowModal,[(21,-1)(21,237)])
   link(Var2,13311944:Var1,[(-22,82)])
  }
  Add(MainForm,14021805,154,203)
  {
   Left=35
   Top=100
   Width=376
   Height=320
   Visible=1
   Point(onClose)
   Point(doShowModal)
   link(onActivate,11585841:doEvent1,[(250,209)(250,139)])
   link(onCreate,15049992:doOpen,[])
   link(onClose,15049992:doClose,[])
  }
  Add(Edit,8193515,609,238)
  {
   Left=65
   Top=160
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
  }
  Add(Edit,4896915,567,294)
  {
   Left=65
   Top=190
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
  }
  Add(Edit,7707199,581,336)
  {
   Left=65
   Top=220
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
  }
  Add(Label,3448287,1184,371)
  {
   Left=5
   Top=10
   Width=55
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Фамилия"
  }
  Add(Label,12074310,1182,420)
  {
   Left=5
   Top=40
   Width=28
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Имя"
  }
  Add(Label,16429677,1182,462)
  {
   Left=5
   Top=100
   Width=40
   Height=19
   Font=[Times New Roman,10,1,0,204]
   Caption="Логин"
  }
  Add(Label,4932833,1183,511)
  {
   Left=5
   Top=70
   Width=55
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Отчество"
  }
  Add(Label,1072301,1176,553)
  {
   Left=15
   Top=135
   Width=4
   Height=4
   Font=[Times New Roman,10,0,0,204]
   Caption=""
  }
  Add(Label,11865404,1183,595)
  {
   Left=5
   Top=130
   Width=53
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Телефон"
  }
  Add(Label,3469290,1183,679)
  {
   Left=5
   Top=160
   Width=45
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Диллер"
  }
  Add(Label,1739345,1187,641)
  {
   Left=5
   Top=190
   Width=32
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Email"
  }
  Add(Button,13679188,63,245)
  {
   Left=240
   Top=45
   Width=85
   Height=35
   Caption="ОТМЕНА"
   link(onClick,13117481:doEvent1,[(111,251)(111,293)])
  }
  Add(Edit,8947271,511,35)
  {
   Left=65
   Top=10
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
   Point(doSetFocus)
   link(onChange,15997396:doWork1,[(569,41)(569,139)(408,139)(408,237)])
  }
  Add(DS_SQLite,15049992,203,217)
  {
   Name="mdb"
   FileName="C:\SOFT\mydbase.db"
   WaitClose=0
   link(onOpen,7388849:doWork3,[(508,223)])
  }
  Add(Hub,13117481,126,287)
  {
   InCount=3
   link(onEvent1,14021805:doClose,[(147,293)(147,230)])
  }
  Add(Edit,9848688,526,151)
  {
   Left=65
   Top=100
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Enabled=1
   Text=""
   Point(doSetFocus)
  }
  Add(Edit,11868430,519,95)
  {
   Left=65
   Top=40
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
  }
  Add(Edit,6824894,543,186)
  {
   Left=65
   Top=70
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
  }
  Add(Edit,8358532,550,228)
  {
   Left=65
   Top=130
   Width=160
   Font=[Times New Roman,10,0,0,204]
   Text=""
  }
  Add(DSC_Exec,1263187,785,693)
  {
   DSManager="parent.mdb"
  }
  Add(GetDataEx,13311944,511,77)
  {
   link(Data,8947271:Text,[])
  }
  Add(Hub,11585841,315,133)
  {
   OutCount=3
   link(onEvent1,5259777:doEvent1,[(395,139)(395,48)])
   link(onEvent3,7388849:doWork2,[(343,153)(343,90)])
  }
  Add(Hub,5259777,413,42)
  {
   link(onEvent1,8947271:doText,[(445,48)(445,41)])
   link(onEvent2,8947271:doSetFocus,[])
  }
  Add(MultiElement,15997396,420,231)
  {
   link(onEvent1,9848688:doText,[(459,237)(459,157)])
  }
  BEGIN_SDK
    Add(EditMulti,12137061,42,49)
    {
     EventCount=1
     WorkCount=1
     DataCount=1
     Width=1549
     Height=60
     VOffset=21
     HOffset=21
     link(doWork1,7056492:doModify,[])
    }
    Add(Replace,11439842,112,70)
    {
     SubStr="а"
     DestStr="a"
     link(onReplace,530333:doReplace,[])
    }
    Add(Replace,530333,154,70)
    {
     SubStr="б"
     DestStr="b"
     link(onReplace,11128969:doReplace,[])
    }
    Add(Replace,11128969,196,70)
    {
     SubStr="в"
     DestStr="v"
     link(onReplace,3391353:doReplace,[])
    }
    Add(Replace,3391353,238,70)
    {
     SubStr="г"
     DestStr="g"
     link(onReplace,14636492:doReplace,[])
    }
    Add(Replace,14636492,280,70)
    {
     SubStr="д"
     DestStr="d"
     link(onReplace,12283807:doReplace,[])
    }
    Add(Replace,12283807,322,70)
    {
     SubStr="е"
     DestStr="e"
     link(onReplace,16094144:doReplace,[])
    }
    Add(Replace,16094144,364,70)
    {
     SubStr="ё"
     DestStr="yo"
     link(onReplace,15370106:doReplace,[])
    }
    Add(Replace,15370106,406,70)
    {
     SubStr="ж"
     DestStr="zh"
     link(onReplace,16045438:doReplace,[])
    }
    Add(Replace,16045438,448,70)
    {
     SubStr="з"
     DestStr="z"
     link(onReplace,7316617:doReplace,[])
    }
    Add(Replace,7316617,490,70)
    {
     SubStr="и"
     DestStr="i"
     link(onReplace,7859333:doReplace,[])
    }
    Add(Replace,7859333,532,70)
    {
     SubStr="й"
     DestStr="i"
     link(onReplace,4297793:doReplace,[])
    }
    Add(Replace,4297793,574,70)
    {
     SubStr="к"
     DestStr="k"
     link(onReplace,14445077:doReplace,[])
    }
    Add(Replace,14445077,616,70)
    {
     SubStr="л"
     DestStr="l"
     link(onReplace,2487017:doReplace,[])
    }
    Add(Replace,2487017,658,70)
    {
     SubStr="м"
     DestStr="m"
     link(onReplace,13580692:doReplace,[])
    }
    Add(Replace,13580692,700,70)
    {
     SubStr="н"
     DestStr="n"
     link(onReplace,634748:doReplace,[])
    }
    Add(Replace,634748,742,70)
    {
     SubStr="о"
     DestStr="o"
     link(onReplace,439275:doReplace,[])
    }
    Add(Replace,439275,784,70)
    {
     SubStr="п"
     DestStr="p"
     link(onReplace,10546314:doReplace,[])
    }
    Add(Replace,10546314,826,70)
    {
     SubStr="р"
     DestStr="r"
     link(onReplace,5604329:doReplace,[])
    }
    Add(Replace,5604329,868,70)
    {
     SubStr="с"
     DestStr="s"
     link(onReplace,8844822:doReplace,[])
    }
    Add(Replace,8844822,910,70)
    {
     SubStr="т"
     DestStr="t"
     link(onReplace,1176478:doReplace,[])
    }
    Add(Replace,1176478,952,70)
    {
     SubStr="у"
     DestStr="u"
     link(onReplace,2638968:doReplace,[])
    }
    Add(Replace,2638968,994,70)
    {
     SubStr="ф"
     DestStr="f"
     link(onReplace,2325184:doReplace,[])
    }
    Add(Replace,2325184,1036,70)
    {
     SubStr="х"
     DestStr="h"
     link(onReplace,7324732:doReplace,[])
    }
    Add(Replace,7324732,1078,70)
    {
     SubStr="ц"
     DestStr="tс"
     link(onReplace,7644681:doReplace,[])
    }
    Add(Replace,7644681,1118,70)
    {
     SubStr="ч"
     DestStr="ch"
     link(onReplace,5102336:doReplace,[])
    }
    Add(Replace,5102336,1160,70)
    {
     SubStr="ш"
     DestStr="sh"
     link(onReplace,1683350:doReplace,[])
    }
    Add(Replace,1683350,1202,70)
    {
     SubStr="щ"
     DestStr="sh"
     link(onReplace,713049:doReplace,[])
    }
    Add(Replace,713049,1244,70)
    {
     SubStr="ь"
     DestStr="'"
     link(onReplace,2888230:doReplace,[])
    }
    Add(Replace,12869705,1370,70)
    {
     SubStr="э"
     DestStr="a"
     link(onReplace,10021912:doReplace,[])
    }
    Add(Replace,12585389,1328,70)
    {
     SubStr="ъ"
     link(onReplace,12869705:doReplace,[])
    }
    Add(Replace,2888230,1286,70)
    {
     SubStr="ы"
     DestStr="y"
     link(onReplace,12585389:doReplace,[])
    }
    Add(Replace,10021912,1412,70)
    {
     SubStr="ю"
     DestStr="yu"
     link(onReplace,7662520:doReplace,[])
    }
    Add(Replace,7662520,1454,70)
    {
     SubStr="я"
     DestStr="ya"
     link(onReplace,1073863:doReplace,[])
    }
    Add(StrCase,7056492,63,70)
    {
     link(onModify,11439842:doReplace,[])
     link(Str,12137061:Data1,[])
    }
    Add(Replace,1073863,1510,70)
    {
     SubStr=" "
     DestStr="_"
     link(onReplace,12137061:onEvent1,[])
    }
  END_SDK
  Add(FormatStr,8675650,525,700)
  {
   DataCount=10
   Mask="UPDATE table1 SET lastname='%1', \r\n  name='%2', \r\n  login='%3', \r\n  middle_name='%4', \r\n  phone='%5', \r\n  diller='%6', \r\n  email='%7', \r\n  password_flexta='%8', \r\n  password_mmf='%9'\r\n  WHERE id=%10;"
   link(onFString,1263187:doExec,[(720,706)(720,699)])
   link(Str1,13311944:Var2,[(531,389)(517,389)])
   link(Str2,11868430:Text,[(538,410)(525,410)])
   link(Str3,5483149:Var2,[(545,541)(542,541)])
   link(Str4,6824894:Text,[(552,540)(549,540)])
   link(Str5,8358532:Text,[(559,483)(556,483)])
   link(Str6,8193515:Text,[(566,492)(615,492)])
   link(Str7,4896915:Text,[])
   link(Str8,7707199:Text,[(580,534)(587,534)])
   link(Str9,5824197:Text,[(587,580)(671,580)])
   link(Str10,8347477:Result,[(594,408)(650,408)])
  }
  Add(GetDataEx,5483149,536,381)
  {
   link(Data,9848688:Text,[(542,289)(532,289)])
  }
  Add(DSC_QueryScalar,8347477,644,84)
  {
   SQL="SELECT COUNT(*) FROM table1"
   DSManager="parent.mdb"
  }
  Add(Label,5124501,1146,677)
  {
   Left=5
   Top=220
   Width=45
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="Flextera"
  }
  Add(Edit,5824197,665,420)
  {
   Left=65
   Top=250
   Width=160
   Text=""
  }
  Add(Label,10334331,1141,672)
  {
   Left=5
   Top=250
   Width=35
   Height=19
   Font=[Times New Roman,10,0,0,204]
   Caption="MMF"
  }
  Add(Button,16538821,21,357)
  {
   Left=240
   Top=10
   Width=85
   Height=35
   link(onClick,13441164:doEvent1,[(60,363)(60,360)])
  }
  Add(Hub,13441164,67,354)
  {
   link(onEvent1,13117481:doEvent2,[(103,360)(103,300)])
   link(onEvent2,8675650:doString,[(303,367)(303,706)])
  }
  Add(HubEx,7388849,504,84)
  {
   link(onEvent,8347477:doQuery,[])
  }
END_SDK
Add(MainForm,7057179,147,322)
{
 Width=971
 Height=501
 Caption="Добавление сотрудников на портал MMF и Flextera"
 Position=1
 Point(onClose)
 link(onCreate,16168490:doOpen,[])
 link(onClose,16168490:doClose,[])
}
Add(StringTableMT,16628981,371,315)
{
 Left=10
 Top=55
 Width=940
 Height=405
 Columns=#2:id|5:Логин|14:Пароль FLEXTER|10:Пароль MMF|7:Фамилия|3:Имя|8:Отчество|7:Телефон|9:Эл. адрес|6:Диллер|
 StrDelimiter="\9"
 ColumnWidth=100
 Redaction=0
 TabGrid=0
 TabGridFrame=0
 Grid=0
 Gradient=0
 IconsCheck=[]
 MiscIcons=[]
 Icons=[]
 Point(doMT_Add)
 Point(Strings)
 Point(onLineChange)
 Point(onDblClick)
 link(onClick,1702344:doPutText,[(415,321)(415,405)(352,405)(352,426)])
 link(onLineChange,3699975:doWork2,[(421,327)])
}
Add(Button,10786776,266,98)
{
 Left=10
 Top=25
 Width=120
 Font=[MS Sans Serif,8,1,0,1]
 Caption="Добавить строку"
 link(onClick,15092223:doEvent1,[])
}
Add(DS_SQLite,16168490,210,336)
{
 Name="mdb"
 FileName="C:\SOFT\mydbase.db"
 link(onOpen,10454492:doExec,[])
}
Add(DSC_Exec,10454492,259,336)
{
 SQL="CREATE TABLE IF NOT EXISTS table1 (\r\n id int, \r\n login TEXT, \r\n password_flexta TEXT, \r\n password_mmf TEXT,\r\n name TEXT,\r\n lastname TEXT,\r\n middle_name TEXT,\r\n phone TEXT,\r\n email TEXT,\r\n diller TEXT);"
 DSManager="mdb"
 link(onExec,11160510:doWork2,[])
}
Add(ArrayRW,3995575,434,322)
{
 link(onRead,2831270:doWork2,[])
 link(Array,16628981:Strings,[(440,315)(418,315)(418,384)(391,384)])
}
Add(DSC_Query,8749579,322,336)
{
 SQL="SELECT * FROM table1"
 DSManager="mdb"
 link(onQuery,16628981:doMT_Add,[(362,342)(362,356)])
 link(onColumns,16628981:doClear,[(362,349)(362,328)])
}
Add(DSC_Exec,2307078,742,371)
{
 DSManager="mdb"
 link(onExec,2225601:doWork2,[(782,377)(782,218)])
}
Add(FormatStr,6841402,560,392)
{
 DataCount=10
 Mask="UPDATE table1 SET login='%2',password_flexta='%3',password_mmf='%4',name='%5',\r\nlastname='%6', middle_name='%7',phone='%8',email='%9',diller='%10' WHERE id=%1"
 link(onFString,14192086:doWork2,[(646,398)(646,377)])
 link(Str1,2776629:Part1,[])
 link(Str2,2776629:Part2,[])
 link(Str3,2776629:Part3,[])
 link(Str4,2776629:Part4,[])
 link(Str5,2776629:Part5,[])
 link(Str6,2776629:Part6,[])
 link(Str7,2776629:Part7,[])
 link(Str8,2776629:Part8,[])
 link(Str9,2776629:Part9,[])
 link(Str10,2776629:Part10,[])
}
Add(MultiStrPart,2776629,560,322)
{
 Char="\9"
 Count=10
 link(onSplit,3059522:doWork2,[])
}
Add(Button,14428720,322,476)
{
 Left=135
 Top=25
 Width=120
 Font=[MS Sans Serif,8,1,0,1]
 Caption="Удалить строку"
 link(onClick,2932136:doSplit,[])
}
Add(FormatStr,214626,427,476)
{
 DataCount=1
 Mask="DELETE FROM table1 WHERE id=%1 "
 link(onFString,14192086:doWork3,[(669,482)])
 link(Str1,2932136:Part1,[(433,468)(418,468)(418,523)(384,523)])
}
Add(MultiStrPart,2932136,378,476)
{
 Char="\9"
 Count=1
 link(onSplit,214626:doString,[])
 link(Str,15748700:Var2,[])
}
Add(Hub,15092223,448,98)
{
 link(onEvent1,9467718:doWork1,[])
}
Add(HubEx,14192086,665,371)
{
 link(onEvent,587237:doWork2,[])
}
Add(HubEx,11160510,301,336)
{
 link(onEvent,8749579:doQuery,[])
}
Add(Clipboard,1702344,357,420)
{
 Point(PutText)
 link(PutText,15748700:Var1,[(363,376)])
}
Add(GetDataEx,15748700,378,371)
{
 link(Data,16628981:Select,[])
}
Add(HubEx,3699975,420,322)
{
 link(onEvent,3995575:doRead,[])
}
Add(HubEx,2831270,532,322)
{
 link(onEvent,2776629:doSplit,[])
}
Add(HubEx,3059522,641,322)
{
 Angle=1
 link(onEvent,6841402:doString,[(645,364)(548,364)(548,398)])
}
Add(HubEx,587237,672,371)
{
 link(onEvent,2307078:doExec,[])
}
Add(FormatStr,9469642,1082,361)
{
 Mask="INSERT INTO table1( id,login,password_flexta,password_mmf) VALUES(NULL,'','%1','%2');"
 link(Str2,13350104:Result,[])
}
Add(StringGen,13350104,1089,319)
{
 Count=8
 Charset="ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$%&*abcdefghijklmnopqrstuvwxyz!@#$%&*ABCDEFGHIJKLMNOPQRSTUVWXYZ"
}
Add(Hub,7231284,970,326)
{
 link(onEvent1,13350104:doGenerateRnd,[])
 link(onEvent2,16430948:doGenerateRnd,[(1009,339)(1009,374)])
}
Add(StringGen,16430948,1033,361)
{
 Count=8
 Charset="ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#$%&*abcdefghijklmnopqrstuvwxyz!@#$%&*ABCDEFGHIJKLMNOPQRSTUVWXYZ"
 link(onResult,9469642:doString,[])
}
Add(HubEx,2225601,602,212)
{
 Angle=2
}
Add(HubEx,12464817,553,212)
{
 Angle=2
 link(onEvent,11160510:doWork1,[(305,218)])
}
Add(HubEx,2278295,588,212)
{
 Angle=2
 link(onEvent,12464817:doWork2,[])
}