Add(SQLite_DB,8019830,483,72)
{
 link(onOpen,10194826:doEvent1,[])
 link(FileName,737798:getVar,[])
}
Add(LineBreakEx,737798,483,44)
{
 Caption="dbname"
 Type=2
}
Add(LineBreakEx,16022277,483,114)
{
 Caption="iddb"
 Type=3
 link(_Data,8019830:dbHandle,[])
}
Add(Hub,10194826,553,72)
{
 link(onEvent1,811205:doExec,[(590,78)(590,43)])
 link(onEvent2,13268407:doEvent1,[(585,85)(585,120)])
}
Add(Message,5629167,679,37)
{
}
Add(GetDataEx,14316002,1127,177)
{
 link(Data,4848583:Select,[(1133,169)(902,169)])
}
Add(HubEx,2548887,434,72)
{
 link(onEvent,8019830:doOpen,[])
}
Add(InfoTip,8881405,1022,212)
{
 Info=#14:удаение заказа|
 Width=232
 Height=186
}
Add(Message,3588801,987,541)
{
}
Add(StringTable,4848583,889,121)
{
 Left=5
 Top=10
 Width=895
 Height=250
 Columns=#5:номер|6:клиент|6:принят|4:срок|8:выполнен|7:фамилия|7:техника|10:исплнитель|9:состояние|6:статус|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|0:|
 Redaction=1
 Flat=1
 link(onClick,5588304:doSplit,[(931,127)(931,196)(443,196)(443,260)])
}
Add(SQLite_Query,2597026,700,121)
{
 SQL="Select * From Zakaz;"
 link(onQuery,10852970:doStr,[])
 link(dbHandle,8567406:getVar,[])
}
Add(MT_String,10852970,742,121)
{
 link(onResult,1603982:doCharset,[])
}
Add(SQLite_Exec,811205,630,37)
{
 SQL="Create Table IF NOT EXISTS Zakaz(\r\nid INTEGER PRIMARY KEY,\r\nIdcl char(20), \r\nDatain char(10), \r\nDatafin char(10),\r\nDataout char(10), \r\nFam char(20), \r\nTeh char(50),\r\nMeh char(30),\r\nProgress char(20),\r\nStatus char(10));\r\n"
 link(onError,5629167:doMessage,[])
 link(dbHandle,15379790:getVar,[])
}
Add(LineBreakEx,8567406,700,93)
{
 Caption="iddb"
 Type=2
}
Add(LineBreakEx,15379790,630,9)
{
 Caption="iddb"
 Type=2
}
Add(LineBreakEx,9428442,637,114)
{
 Caption="cleartb"
}
Add(LineBreakEx,10700098,546,121)
{
 Caption="print"
 Type=1
 link(OnEvent,13268407:doEvent2,[])
}
Add(LineBreakEx,949575,826,128)
{
 Caption="cleartb"
 Type=1
 link(OnEvent,4848583:doClear,[])
}
Add(Charset,1603982,784,121)
{
 Type=7
 link(onCharset,4848583:doAdd,[])
}
Add(Hub,13268407,602,114)
{
 InCount=2
 link(onEvent1,9428442:doWork,[])
 link(onEvent2,2597026:doQuery,[])
}
Add(InfoTip,8691889,602,-5)
{
 Info=#15:таблица заказов|
 Width=99
 Height=81
}
Add(LineBreakEx,7817427,938,513)
{
 Caption="iddb"
 Type=2
}
Add(Charset,6887757,896,541)
{
 Type=6
 link(onCharset,6739193:doExec,[])
}
Add(SQLite_Exec,6739193,938,541)
{
 link(onError,3588801:doMessage,[])
 link(dbHandle,7817427:getVar,[])
}
Add(Button,11701198,623,541)
{
 Left=180
 Top=445
 Width=85
 Caption="сохранить"
 link(onClick,5226684:doEvent1,[])
}
Add(FormatStr,7576807,784,541)
{
 DataCount=10
 Mask="Insert or REPLACE into Zakaz Values( %1, '%2', '%3', '%4', '%5','%6', '%7', '%8', '%9', '%10' );"
 link(onFString,6887757:doCharset,[])
 link(Str1,13123266:Value,[])
 link(Str2,12342606:Var,[])
 link(Str3,1945137:Var,[])
 link(Str4,6203560:Var,[])
 link(Str5,1805279:Var,[])
 link(Str6,4562820:Var,[])
 link(Str7,13707108:Var,[])
 link(Str8,15990674:String,[(839,332)(881,332)])
 link(Str9,13059894:Text,[(846,449)(916,449)])
 link(Str10,13142070:String,[(853,455)(965,455)])
}
Add(Hub,5226684,679,541)
{
 OutCount=3
 link(onEvent1,7576807:doString,[])
 link(onEvent2,6409687:doWork,[])
 link(onEvent3,16069663:doEvent1,[(713,561)(713,589)(457,589)(457,400)])
}
Add(LineBreakEx,6409687,721,548)
{
 Caption="print"
}
Add(Hub,16069663,469,394)
{
 OutCount=10
 link(onEvent1,13123266:doClear,[(651,400)(651,218)])
 link(onEvent2,10170633:doWork3,[(662,407)])
 link(onEvent3,10431632:doWork3,[(669,414)])
 link(onEvent4,14408251:doWork3,[(683,421)])
 link(onEvent5,13067768:doWork3,[(690,428)])
 link(onEvent6,5539106:doWork3,[(697,435)])
 link(onEvent7,11668556:doWork3,[(704,442)])
 link(onEvent8,2751523:doData,[])
 link(onEvent9,1152306:doWork3,[(725,456)])
 link(onEvent10,9091242:doWork3,[(739,463)])
}
Add(MultiStrData,5588304,455,254)
{
 Count=10
 link(Str,14316002:Var1,[(461,182)])
 link(onPart1,13123266:doValue,[(635,260)(635,211)])
 link(onPart2,10170633:doWork2,[(639,267)(639,246)])
 link(onPart3,10431632:doWork2,[])
 link(onPart4,14408251:doWork2,[])
 link(onPart5,13067768:doWork2,[])
 link(onPart6,5539106:doWork2,[])
 link(onPart7,11668556:doWork2,[])
 link(onPart8,4529310:doWork2,[(635,309)(635,316)])
 link(onPart9,1152306:doWork2,[(627,316)(627,337)])
 link(onPart10,9091242:doWork2,[(619,323)(619,365)])
}
Add(Memory,13123266,784,205)
{
 Default=String(NULL)
}
Add(GlobalVar,12342606,791,240)
{
 Name="idcl"
}
Add(HubEx,10170633,658,240)
{
 link(onEvent,12342606:doValue,[])
}
Add(GlobalVar,1945137,798,268)
{
 Name="dat"
}
Add(HubEx,10431632,665,268)
{
 link(onEvent,1945137:doValue,[])
}
Add(DatePicker,4042862,315,338)
{
 Left=130
 Top=395
 Height=21
 link(onChange,3189426:doValue,[])
}
Add(GlobalVar,3189426,371,338)
{
 Name="datafin"
}
Add(GlobalVar,6203560,805,275)
{
 Name="datafin"
}
Add(DatePicker,5026728,315,387)
{
 Left=205
 Top=395
 Height=21
 link(onChange,11150510:doValue,[])
}
Add(GlobalVar,11150510,371,387)
{
 Name="dataout"
 Data=String()
}
Add(GlobalVar,1805279,812,282)
{
 Name="dataout"
 Data=String()
}
Add(HubEx,14408251,679,275)
{
 link(onEvent,6203560:doValue,[])
}
Add(HubEx,13067768,686,282)
{
 link(onEvent,1805279:doValue,[])
}
Add(GlobalVar,4562820,819,289)
{
 Name="famil"
 Data=String()
}
Add(HubEx,5539106,693,289)
{
 link(onEvent,4562820:doValue,[])
}
Add(GlobalVar,13707108,826,296)
{
 Name="teh"
 Data=String()
}
Add(HubEx,11668556,700,296)
{
 link(onEvent,13707108:doValue,[])
}
Add(ComboBox,15990674,868,268)
{
 Left=375
 Top=390
 Height=21
 Point(doSelectString)
}
Add(DoData,2751523,511,443)
{
 link(onEventData,4529310:doWork3,[(711,449)])
}
Add(HubEx,4529310,707,310)
{
 link(onEvent,15990674:doSelectString,[])
}
Add(Edit,13059894,910,324)
{
 Left=290
 Top=395
}
Add(HubEx,1152306,721,331)
{
 link(onEvent,13059894:doText2,[])
}
Add(ComboBox,13142070,952,317)
{
 Left=470
 Top=390
 Height=21
 Point(doSelectString)
}
Add(HubEx,9091242,735,359)
{
 link(onEvent,13142070:doSelectString,[])
}
Add(Button,2491679,1029,289)
{
 Left=85
 Top=445
 Width=85
 Caption="удалить"
 link(onClick,4019247:doEvent1,[])
}
Add(FormatStr,410803,1127,296)
{
 DataCount=1
 Mask="DELETE FROM Zakaz WHERE id=%1;"
 link(onFString,9768976:doExec,[])
 link(Str1,15214582:Left,[])
}
Add(LineBreakEx,10004347,1176,268)
{
 Caption="iddb"
 Type=2
}
Add(StrPart,15214582,1127,233)
{
 Char=";"
 Point(Left)
 Point(Right)
 link(Str,14316002:Var2,[])
}
Add(LineBreakEx,10116064,1127,331)
{
 Caption="print"
}
Add(Hub,4019247,1085,289)
{
 InCount=2
 OutCount=3
 link(onEvent1,15214582:doSplit,[(1113,295)(1113,239)])
 link(onEvent2,410803:doString,[])
 link(onEvent3,10116064:doWork,[(1113,309)(1113,337)])
}
Add(SQLite_Exec,9768976,1176,296)
{
 link(dbHandle,10004347:getVar,[])
}