Add(ChildGroupBox,16594303,847,74) { link(onEvent1,5968126:doEvent2,[(943,80)(943,258)]) } BEGIN_SDK Add(EditMulti,9384139,21,21) { EventCount=1 WorkCount=3 Width=881 Height=585 link(doWork1,10546403:doBringToFront,[(28,27)(28,111)]) link(doWork2,12584059:doEvent1,[(161,34)(161,62)]) link(doWork3,6924426:doText,[(61,41)(61,136)]) } Add(GroupBox,10546403,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="Персонал" Point(doBringToFront) Point(doSendToBack) } Add(MultiStrPart,16530701,555,319) { Char="\9" Count=1 link(onSplit,13977232:doString,[]) } Add(StringTableMT,6451170,471,151) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|20:Військове звання=150|7:ПІБ=200|27:Серія,номер посвідчення=150|20:Дата та № наказу=150|10:Статус=150|0:| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,9248840:doRead,[]) } Add(Button,16355538,303,151) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,11826088:doOperation,[]) } Add(Math,11826088,352,151) { Op2=1 ResultType=0 link(onResult,11892657:doEvent1,[]) link(Op1,6451170:Count,[(358,132)(418,132)(418,215)(477,215)]) } Add(Edit,6924426,100,130) { Left=60 Top=13 Width=465 Text="" link(onEnter,9384139:onEvent1,[(513,143)(513,27)]) } Add(Label,5399162,142,102) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,6261690,100,186) { Name="db" link(onOpen,5124064:doEvent1,[]) link(FileName,6924426:Text,[]) } Add(DSC_Exec,11620320,163,235) { SQL="CREATE TABLE IF NOT EXISTS personal ( \r\n id INTEGER PRIMARY KEY,\r\n rank text,\r\n name text,\r\n serial text,\r\n date integer,\r\n status integer -- 0-служит, 1-уволен \r\n);" DSManager="db" } Add(DSC_Exec,8618512,520,95) { DSManager="db" } Add(ArrayRW,9248840,603,158) { link(onRead,4885776:doSplit,[]) link(Array,12011409:Var3,[(609,142)(553,142)(553,216)]) } Add(Hub,11892657,408,151) { link(onEvent1,6451170:doAdd,[]) link(onEvent2,2342500:doString,[(446,164)(446,101)]) } Add(FormatStr,2342500,471,95) { DataCount=1 Mask="INSERT INTO personal (id) VALUES (%1)" link(onFString,8618512:doExec,[]) } Add(DSC_Query,12224532,268,200) { SQL="SELECT * FROM personal" DSManager="db" link(onQuery,6451170:doMT_Add,[(386,206)(386,192)]) } Add(DSC_Exec,3428744,709,228) { DSManager="db" } Add(FormatStr,4361700,646,228) { DataCount=6 Mask="UPDATE personal SET \r\n rank= '%2',\r\n name ='%3',\r\n serial = '%4',\r\n date ='%5',\r\n status= '%6' WHERE id=%1" link(onFString,3428744:doExec,[]) link(Str1,4885776:Part1,[]) link(Str2,4885776:Part2,[]) link(Str3,4885776:Part3,[]) link(Str4,4885776:Part4,[]) link(Str5,4885776:Part5,[]) link(Str6,4885776:Part6,[]) } Add(MultiStrPart,4885776,646,158) { Char="\9" Count=6 link(onSplit,4361700:doString,[(690,164)(690,199)(634,199)(634,234)]) } Add(Hub,5124064,149,186) { link(onEvent1,12224532:doQuery,[(215,192)(215,206)]) link(onEvent2,11620320:doExec,[]) } Add(Button,6320311,289,319) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,8987325:doEvent1,[]) } Add(Hub,8987325,345,319) { link(onEvent1,12390890:doRead,[]) link(onEvent2,10031616:doData,[]) } Add(DoData,10031616,387,326) { link(onEventData,6451170:doDelete,[(445,332)(445,171)]) link(Data,6296645:Var1,[(393,265)]) } Add(DSC_Exec,12949506,653,319) { DSManager="db" } Add(FormatStr,13977232,604,319) { DataCount=1 Mask="DELETE FROM personal WHERE id=%1" link(onFString,12949506:doExec,[]) link(Str1,16530701:Part1,[(610,307)(586,307)(586,363)(561,363)]) } Add(ArrayRW,12390890,506,319) { link(onRead,16530701:doSplit,[]) link(Array,12011409:Var2,[]) link(Index,6296645:Var2,[(519,294)(463,294)]) } Add(GetDataEx,12011409,506,211) { Angle=3 link(Data,6451170:Strings,[(491,216)]) } Add(GetDataEx,6296645,457,260) { Angle=1 link(Data,6451170:Index,[(498,265)]) } Add(Hub,12584059,301,56) { link(onEvent1,6451170:doClear,[(393,62)(393,164)]) link(onEvent2,6261690:doOpen,[(327,69)(327,131)(88,131)(88,192)]) } END_SDK Add(TabControl,8774474,175,203) { Left=215 Top=6 Width=735 Height=440 Tabs=#10:Інформація|8:Персонал|2:ТО|4:Шини|3:АКБ|5:Масло|18:Охолоджуюча рідина|15:Тормозна рідина|3:ЗІП|10:Моторесурс| Bitmaps=[] Buttons=0 HotTrack=0 Point(PageTab) link(onChange,4412880:doEvent,[(231,220)(340,220)(556,220)(556,258)]) } Add(ChildGroupBox,13958430,845,158) { link(onEvent1,5968126:doEvent4,[(943,164)(943,272)]) } BEGIN_SDK Add(EditMulti,11052900,21,21) { EventCount=1 WorkCount=3 Width=769 Height=571 link(doWork1,7766036:doBringToFront,[(28,27)(28,111)]) link(doWork2,15083432:doEvent1,[(133,34)(133,76)]) link(doWork3,2042301:doText,[(64,41)(64,136)]) } Add(GroupBox,7766036,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="Шини" Point(doBringToFront) } Add(MultiStrPart,164653,562,319) { Char="\9" Count=1 link(onSplit,16206179:doString,[]) } Add(StringTableMT,12222526,485,151) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|20:Заводсткий номер=150|10:Розмір=100|18:Завод-виробник=150|21:Дата виготовлення=150|31:Дата встановлення та пробіг=250|25:Дата зняття та пробіг=250|18:Причина зняття=200|0:|0:| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,2912116:doRead,[]) } Add(Button,1627946,317,151) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,11123210:doOperation,[]) } Add(Math,11123210,366,151) { Op2=1 ResultType=0 link(onResult,1709848:doEvent1,[]) link(Op1,12222526:Count,[(372,132)(432,132)(432,215)(491,215)]) } Add(Edit,2042301,107,130) { Left=60 Top=13 Width=465 Text="" link(onEnter,11052900:onEvent1,[(465,143)(465,27)]) } Add(Label,14593757,156,130) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,11438517,114,186) { Name="db" link(onOpen,69171:doEvent1,[]) link(FileName,2042301:Text,[(120,174)(113,174)]) } Add(DSC_Exec,5760494,177,235) { SQL="CREATE TABLE IF NOT EXISTS tires ( \r\nid INTEGER PRIMARY KEY,\r\n factorynumber integer,\r\n size integer,\r\n factory text,\r\n date integer,\r\n instillation integer,\r\n deletet integer,\r\n cause text\r\n);" DSManager="db" } Add(DSC_Exec,2306334,534,95) { DSManager="db" } Add(ArrayRW,2912116,617,158) { link(onRead,4873003:doSplit,[]) link(Array,8100482:Var3,[(623,142)(567,142)(567,216)]) } Add(Hub,1709848,422,151) { link(onEvent1,12222526:doAdd,[]) link(onEvent2,13982991:doString,[(460,164)(460,101)]) } Add(FormatStr,13982991,485,95) { DataCount=1 Mask="INSERT INTO tires (id) VALUES (%1)" link(onFString,2306334:doExec,[]) } Add(DSC_Query,15845815,282,200) { SQL="SELECT * FROM tires" DSManager="db" link(onQuery,12222526:doMT_Add,[(400,206)(400,192)]) } Add(DSC_Exec,623392,744,228) { DSManager="db" } Add(FormatStr,13284577,660,228) { DataCount=8 Mask="UPDATE tires SET\r\n factorynumber= '%2',\r\n size= '%3' ,\r\n factory= '%4',\r\n date= '%5',\r\n instillation= '%6',\r\n deletet= '%7',\r\n cause = '%8' \r\nWHERE id=%1" link(onFString,623392:doExec,[]) link(Str1,4873003:Part1,[]) link(Str2,4873003:Part2,[]) link(Str3,4873003:Part3,[]) link(Str4,4873003:Part4,[]) link(Str5,4873003:Part5,[]) link(Str6,4873003:Part6,[]) link(Str7,4873003:Part7,[]) link(Str8,4873003:Part8,[]) } Add(MultiStrPart,4873003,660,158) { Char="\9" Count=8 link(onSplit,13284577:doString,[(731,164)(731,199)(648,199)(648,234)]) } Add(Hub,69171,163,186) { link(onEvent1,15845815:doQuery,[(229,192)(229,206)]) link(onEvent2,5760494:doExec,[]) } Add(Button,15015739,303,319) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,5234139:doEvent1,[]) } Add(Hub,5234139,359,319) { link(onEvent1,8789522:doRead,[]) link(onEvent2,3503678:doData,[]) } Add(DoData,3503678,401,326) { link(onEventData,12222526:doDelete,[(459,332)(459,171)]) link(Data,1425860:Var1,[(407,265)]) } Add(DSC_Exec,16768126,667,319) { DSManager="db" } Add(FormatStr,16206179,618,319) { DataCount=1 Mask="DELETE FROM tires WHERE id=%1" link(onFString,16768126:doExec,[]) link(Str1,164653:Part1,[(624,307)(600,307)(600,363)(568,363)]) } Add(ArrayRW,8789522,520,319) { link(onRead,164653:doSplit,[]) link(Array,8100482:Var2,[]) link(Index,1425860:Var2,[(533,294)(477,294)]) } Add(GetDataEx,8100482,520,211) { Angle=3 link(Data,12222526:Strings,[(505,216)]) } Add(GetDataEx,1425860,471,260) { Angle=1 link(Data,12222526:Index,[(512,265)]) } Add(Hub,15083432,245,70) { link(onEvent1,12222526:doClear,[(372,76)(372,164)]) link(onEvent2,11438517:doOpen,[(271,83)(271,144)(85,144)(85,192)]) } END_SDK Add(ChildGroupBox,12437118,846,207) { link(onEvent1,5968126:doEvent5,[(943,213)(943,279)]) } BEGIN_SDK Add(EditMulti,2678438,21,21) { EventCount=1 WorkCount=3 Width=797 Height=599 link(doWork1,11109616:doBringToFront,[(28,27)(28,111)]) link(doWork2,2186146:doEvent1,[(126,34)(126,83)]) link(doWork3,12530325:doText,[(57,41)(57,136)]) } Add(GroupBox,11109616,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="АКБ" Point(doBringToFront) } Add(MultiStrPart,16078728,555,319) { Char="\9" Count=1 link(onSplit,7767836:doString,[]) } Add(StringTableMT,1489459,471,151) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|13:№ батареї=100|17:Марка батареї=150|18:Завод-виробник=150|21:Дата виготовлення=150|29:Приведення у робочий стан=200|16:Встановлення=150|12:Дата КТЦ=150|26:Дата та причина зняття=250| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,5757406:doRead,[]) } Add(Math,2138464,352,151) { Op2=1 ResultType=0 link(onResult,3796150:doEvent1,[]) link(Op1,1489459:Count,[(358,132)(418,132)(418,215)(477,215)]) } Add(Edit,12530325,93,130) { Left=60 Top=13 Width=465 Text="" link(onEnter,2678438:onEvent1,[(471,143)(471,27)]) } Add(Label,598003,142,130) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,1541997,100,186) { Name="db" link(onOpen,4580828:doEvent1,[]) link(FileName,12530325:Text,[(106,174)(99,174)]) } Add(DSC_Exec,15987716,177,235) { SQL="CREATE TABLE IF NOT EXISTS acb ( \r\nid INTEGER PRIMARY KEY,\r\nnumber integer,\r\nmarka integer, -- марка\r\nfactory integer, --завод \r\ndate integer,\r\nwork integer,\r\ninstillation integer,\r\ndatektc integer,\r\ncause text\r\n);\r\n" DSManager="db" } Add(DSC_Exec,16705274,520,95) { DSManager="db" } Add(ArrayRW,5757406,603,158) { link(onRead,11663236:doSplit,[]) link(Array,12674698:Var3,[(609,142)(553,142)(553,216)]) } Add(Hub,3796150,408,151) { link(onEvent1,1489459:doAdd,[]) link(onEvent2,164066:doString,[(446,164)(446,101)]) } Add(FormatStr,164066,471,95) { DataCount=1 Mask="INSERT INTO acb (id) VALUES (%1)" link(onFString,16705274:doExec,[]) } Add(DSC_Query,3556222,268,200) { SQL="SELECT * FROM acb" DSManager="db" link(onQuery,1489459:doMT_Add,[(386,206)(386,192)]) } Add(DSC_Exec,1996129,772,228) { DSManager="db" } Add(FormatStr,12564212,646,228) { DataCount=9 Mask="UPDATE acb SET\r\n number='%2',\r\n marka='%3',\r\n factory='%4', \r\n date='%5',\r\n work='%6',\r\n instillation='%7',\r\n datektc='%8',\r\n cause='%9'\r\nWHERE id=%1" link(onFString,1996129:doExec,[]) link(Str1,11663236:Part1,[]) link(Str2,11663236:Part2,[]) link(Str3,11663236:Part3,[]) link(Str4,11663236:Part4,[]) link(Str5,11663236:Part5,[]) link(Str6,11663236:Part6,[]) link(Str7,11663236:Part7,[]) link(Str8,11663236:Part8,[]) link(Str9,11663236:Part9,[]) } Add(MultiStrPart,11663236,646,158) { Char="\9" Count=9 link(onSplit,12564212:doString,[(690,164)(690,199)(634,199)(634,234)]) } Add(Hub,4580828,149,186) { link(onEvent1,3556222:doQuery,[(215,192)(215,206)]) link(onEvent2,15987716:doExec,[(170,199)(170,241)]) } Add(Button,16054055,289,319) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,6925697:doEvent1,[]) } Add(Hub,6925697,345,319) { link(onEvent1,3491835:doRead,[]) link(onEvent2,7449784:doData,[]) } Add(DoData,7449784,387,326) { link(onEventData,1489459:doDelete,[(445,332)(445,171)]) link(Data,12358231:Var1,[(393,265)]) } Add(DSC_Exec,7579152,653,319) { DSManager="db" } Add(FormatStr,7767836,604,319) { DataCount=1 Mask="DELETE FROM acb WHERE id=%1" link(onFString,7579152:doExec,[]) link(Str1,16078728:Part1,[(610,307)(586,307)(586,363)(561,363)]) } Add(ArrayRW,3491835,506,319) { link(onRead,16078728:doSplit,[]) link(Array,12674698:Var2,[]) link(Index,12358231:Var2,[(519,294)(463,294)]) } Add(GetDataEx,12674698,506,211) { Angle=3 link(Data,1489459:Strings,[(491,216)]) } Add(GetDataEx,12358231,457,260) { Angle=1 link(Data,1489459:Index,[(498,265)]) } Add(Button,8590332,303,151) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,2138464:doOperation,[]) } Add(Hub,2186146,231,77) { link(onEvent1,1489459:doClear,[(358,83)(358,164)]) link(onEvent2,1541997:doOpen,[(257,90)(257,141)(88,141)(88,192)]) } END_SDK Add(ChildGroupBox,12602276,846,256) { link(onEvent1,5968126:doEvent6,[(943,262)(943,286)]) } BEGIN_SDK Add(EditMulti,3944223,0,14) { EventCount=1 WorkCount=3 Width=839 Height=585 link(doWork1,3695041:doBringToFront,[(7,20)]) link(doWork2,15457894:doEvent1,[(164,27)(164,62)]) link(doWork3,13614708:doText,[(43,34)(43,164)]) } Add(GroupBox,3695041,7,112) { Left=220 Top=35 Width=775 Height=450 Caption="Масло" Point(doBringToFront) } Add(MultiStrPart,13327469,548,347) { Char="\9" Count=1 link(onSplit,11016733:doString,[]) } Add(StringTableMT,12397356,464,179) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|21:Дата заміни масла=200|13:Тип масла=150|24:Причина заміни масла=250|23:Дата заміни фільтру=200|26:Причина заміни фільтру=250|0:|0:| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,2213808:doRead,[]) } Add(Button,2222468,296,179) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,5021796:doOperation,[]) } Add(Math,5021796,345,179) { Op2=1 ResultType=0 link(onResult,11461881:doEvent1,[]) link(Op1,12397356:Count,[(351,160)(411,160)(411,243)(470,243)]) } Add(Edit,13614708,86,158) { Left=60 Top=13 Width=465 Text="" link(onEnter,3944223:onEvent1,[(478,171)(478,20)]) } Add(Label,7069515,135,158) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,4409359,93,214) { Name="db" link(onOpen,9846779:doEvent1,[]) link(FileName,13614708:Text,[(99,202)(92,202)]) } Add(DSC_Exec,6978250,156,263) { SQL="CREATE TABLE IF NOT EXISTS butter ( \r\nid INTEGER PRIMARY KEY,\r\ndatebutter integer,\r\ntype integer,\r\ncausebatter text,\r\ndatefilter integer,\r\ncausefilter text\r\n);\r\n" DSManager="db" } Add(DSC_Exec,1493733,513,123) { DSManager="db" } Add(ArrayRW,2213808,596,186) { link(onRead,2571016:doSplit,[]) link(Array,4410071:Var3,[(602,170)(546,170)(546,244)]) } Add(Hub,11461881,401,179) { link(onEvent1,12397356:doAdd,[]) link(onEvent2,2009613:doString,[(439,192)(439,129)]) } Add(FormatStr,2009613,464,123) { DataCount=1 Mask="INSERT INTO butter (id) VALUES (%1)" link(onFString,1493733:doExec,[]) } Add(DSC_Query,15798435,261,228) { SQL="SELECT * FROM butter" DSManager="db" link(onQuery,12397356:doMT_Add,[(379,234)(379,220)]) } Add(DSC_Exec,11379607,772,256) { DSManager="db" } Add(FormatStr,15297647,639,256) { DataCount=6 Mask="UPDATE butter SET\r\n datebutter='%2',\r\n type='%3',\r\n causebatter='%4',\r\n datefilter='%5',\r\n causefilter='%6' \r\nWHERE id=%1" link(onFString,11379607:doExec,[]) link(Str1,2571016:Part1,[]) link(Str2,2571016:Part2,[]) link(Str3,2571016:Part3,[]) link(Str4,2571016:Part4,[]) link(Str5,2571016:Part5,[]) link(Str6,2571016:Part6,[]) } Add(MultiStrPart,2571016,639,186) { Char="\9" Count=6 link(onSplit,15297647:doString,[(683,192)(683,227)(627,227)(627,262)]) } Add(Hub,9846779,142,214) { link(onEvent1,15798435:doQuery,[(208,220)(208,234)]) link(onEvent2,6978250:doExec,[(168,227)(168,248)(144,248)(144,269)]) } Add(Button,7148669,282,347) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,15398364:doEvent1,[]) } Add(Hub,15398364,338,347) { link(onEvent1,14184427:doRead,[]) link(onEvent2,13652696:doData,[]) } Add(DoData,13652696,380,354) { link(onEventData,12397356:doDelete,[(438,360)(438,199)]) link(Data,8455910:Var1,[(386,293)]) } Add(DSC_Exec,8749688,646,347) { DSManager="db" } Add(FormatStr,11016733,597,347) { DataCount=1 Mask="DELETE FROM butter WHERE id=%1" link(onFString,8749688:doExec,[]) link(Str1,13327469:Part1,[(603,335)(579,335)(579,391)(554,391)]) } Add(ArrayRW,14184427,499,347) { link(onRead,13327469:doSplit,[]) link(Array,4410071:Var2,[]) link(Index,8455910:Var2,[(512,322)(456,322)]) } Add(GetDataEx,4410071,499,239) { Angle=3 link(Data,12397356:Strings,[(484,244)]) } Add(GetDataEx,8455910,450,288) { Angle=1 link(Data,12397356:Index,[(491,293)]) } Add(Hub,15457894,329,56) { link(onEvent1,12397356:doClear,[(403,62)(403,192)]) link(onEvent2,4409359:doOpen,[(355,69)(355,145)(81,145)(81,220)]) } END_SDK Add(ChildGroupBox,7725053,846,305) { link(onEvent1,5968126:doEvent7,[(943,311)(943,293)]) } BEGIN_SDK Add(EditMulti,3276299,21,21) { EventCount=1 WorkCount=3 Width=797 Height=585 link(doWork1,2250338:doBringToFront,[(28,27)(28,111)]) link(doWork2,6014386:doEvent1,[(151,34)(151,76)]) link(doWork3,12758551:doText,[(81,41)(81,178)]) } Add(GroupBox,2250338,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="Охолоджуюча рідина" Point(doBringToFront) } Add(MultiStrPart,11193971,604,361) { Char="\9" Count=1 link(onSplit,7187556:doString,[]) } Add(StringTableMT,7261521,520,193) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|22:Дата заміни рідини=150|14:Тип рідини=200|18:Причина заміни=200| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,9813648:doRead,[]) } Add(Button,5857724,352,193) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,15887589:doOperation,[]) } Add(Math,15887589,401,193) { Op2=1 ResultType=0 link(onResult,3341652:doEvent1,[]) link(Op1,7261521:Count,[(407,174)(467,174)(467,257)(526,257)]) } Add(Edit,12758551,142,172) { Left=60 Top=13 Width=465 Text="" link(onEnter,3276299:onEvent1,[(496,185)(496,27)]) } Add(Label,15381254,191,172) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,3823219,149,228) { Name="db" link(onOpen,6688445:doEvent1,[]) link(FileName,12758551:Text,[(155,216)(148,216)]) } Add(DSC_Exec,1789287,212,277) { SQL="CREATE TABLE IF NOT EXISTS cool ( \r\n id INTEGER PRIMARY KEY,\r\n date integer,\r\n type integer, --тип охлаждающей жидкости\r\n cause text\r\n);" DSManager="db" } Add(DSC_Exec,12537168,569,137) { DSManager="db" } Add(ArrayRW,9813648,652,200) { link(onRead,1315024:doSplit,[]) link(Array,16245542:Var3,[(658,184)(602,184)(602,258)]) } Add(Hub,3341652,457,193) { link(onEvent1,7261521:doAdd,[]) link(onEvent2,15364540:doString,[(495,206)(495,143)]) } Add(FormatStr,15364540,520,137) { DataCount=1 Mask="INSERT INTO cool (id) VALUES (%1)" link(onFString,12537168:doExec,[]) } Add(DSC_Query,9317544,317,242) { SQL="SELECT * FROM cool" DSManager="db" link(onQuery,7261521:doMT_Add,[(435,248)(435,234)]) } Add(DSC_Exec,7252923,744,270) { DSManager="db" } Add(FormatStr,7483739,695,270) { DataCount=4 Mask="UPDATE cool SET\r\n date ='%2',\r\n type ='%3',\r\n cause='%4'\r\nWHERE id=%1" link(onFString,7252923:doExec,[]) link(Str1,1315024:Part1,[]) link(Str2,1315024:Part2,[]) link(Str3,1315024:Part3,[]) link(Str4,1315024:Part4,[]) } Add(MultiStrPart,1315024,695,200) { Char="\9" Count=4 link(onSplit,7483739:doString,[(739,206)(739,241)(683,241)(683,276)]) } Add(Hub,6688445,198,228) { link(onEvent1,9317544:doQuery,[(264,234)(264,248)]) link(onEvent2,1789287:doExec,[]) } Add(Button,12564371,338,361) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,4543428:doEvent1,[]) } Add(Hub,4543428,394,361) { link(onEvent1,13862924:doRead,[]) link(onEvent2,1966287:doData,[]) } Add(DoData,1966287,436,368) { link(onEventData,7261521:doDelete,[(494,374)(494,213)]) link(Data,12472011:Var1,[(442,307)]) } Add(DSC_Exec,11719274,702,361) { DSManager="db" } Add(FormatStr,7187556,653,361) { DataCount=1 Mask="DELETE FROM cool WHERE id=%1" link(onFString,11719274:doExec,[]) link(Str1,11193971:Part1,[(659,349)(635,349)(635,405)(610,405)]) } Add(ArrayRW,13862924,555,361) { link(onRead,11193971:doSplit,[]) link(Array,16245542:Var2,[]) link(Index,12472011:Var2,[(568,336)(512,336)]) } Add(GetDataEx,16245542,555,253) { Angle=3 link(Data,7261521:Strings,[(540,258)]) } Add(GetDataEx,12472011,506,302) { Angle=1 link(Data,7261521:Index,[(547,307)]) } Add(Hub,6014386,280,70) { link(onEvent1,7261521:doClear,[(407,76)(407,206)]) link(onEvent2,3823219:doOpen,[(306,83)(306,159)(137,159)(137,234)]) } END_SDK Add(ChildGroupBox,6441274,846,347) { link(onEvent1,5968126:doEvent8,[(944,353)(944,300)]) } BEGIN_SDK Add(EditMulti,14658651,21,21) { EventCount=1 WorkCount=3 Width=797 Height=585 link(doWork1,9482439:doBringToFront,[(28,27)(28,111)]) link(doWork2,11786609:doEvent1,[(126,34)(126,132)]) link(doWork3,9880777:doText,[(57,41)(57,192)]) } Add(GroupBox,9482439,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="Тормозна рідина" Point(doBringToFront) } Add(MultiStrPart,11808187,555,375) { Char="\9" Count=1 link(onSplit,14921085:doString,[]) } Add(StringTableMT,11628349,471,207) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|22:Дата заміни рідини=150|14:Тип рідини=150|25:Причини заміни рідини=200| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,14554881:doRead,[]) } Add(Button,10175587,303,207) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,13477734:doOperation,[]) } Add(Math,13477734,352,207) { Op2=1 ResultType=0 link(onResult,14374679:doEvent1,[]) link(Op1,11628349:Count,[(358,188)(418,188)(418,271)(477,271)]) } Add(Edit,9880777,93,186) { Left=60 Top=13 Width=465 Text="" link(onEnter,14658651:onEvent1,[(471,199)(471,27)]) } Add(Label,626523,142,186) { Left=10 Top=14 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,11676265,100,242) { Name="db" link(onOpen,5852984:doEvent1,[]) link(FileName,9880777:Text,[(106,230)(99,230)]) } Add(DSC_Exec,6635697,163,291) { SQL="CREATE TABLE IF NOT EXISTS brake ( \r\nid INTEGER PRIMARY KEY,\r\ndate integer,\r\ntype integer, --тип тормозной жидкости\r\ncause text\r\n);" DSManager="db" } Add(DSC_Exec,13306669,520,151) { DSManager="db" } Add(ArrayRW,14554881,603,214) { link(onRead,1415404:doSplit,[]) link(Array,9121665:Var3,[(609,198)(553,198)(553,272)]) } Add(Hub,14374679,408,207) { link(onEvent1,11628349:doAdd,[]) link(onEvent2,1146953:doString,[(446,220)(446,157)]) } Add(FormatStr,1146953,471,151) { DataCount=1 Mask="INSERT INTO brake (id) VALUES (%1)" link(onFString,13306669:doExec,[]) } Add(DSC_Query,10021401,268,256) { SQL="SELECT * FROM brake" DSManager="db" link(onQuery,11628349:doMT_Add,[(386,262)(386,248)]) } Add(DSC_Exec,9590347,695,284) { DSManager="db" } Add(FormatStr,3525371,646,284) { DataCount=4 Mask="UPDATE brake SET\r\n date ='%2',\r\n type ='%3',\r\n cause='%4'\r\nWHERE id=%1" link(onFString,9590347:doExec,[]) link(Str1,1415404:Part1,[]) link(Str2,1415404:Part2,[]) link(Str3,1415404:Part3,[]) link(Str4,1415404:Part4,[]) } Add(MultiStrPart,1415404,646,214) { Char="\9" Count=4 link(onSplit,3525371:doString,[(690,220)(690,255)(634,255)(634,290)]) } Add(Hub,5852984,149,242) { link(onEvent1,10021401:doQuery,[(215,248)(215,262)]) link(onEvent2,6635697:doExec,[]) } Add(Button,13607318,289,375) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,7314400:doEvent1,[]) } Add(Hub,7314400,345,375) { link(onEvent1,901330:doRead,[]) link(onEvent2,7677846:doData,[]) } Add(DoData,7677846,387,382) { link(onEventData,11628349:doDelete,[(445,388)(445,227)]) link(Data,11513600:Var1,[(393,321)]) } Add(DSC_Exec,15743862,653,375) { DSManager="db" } Add(FormatStr,14921085,604,375) { DataCount=1 Mask="DELETE FROM brake WHERE id=%1" link(onFString,15743862:doExec,[]) link(Str1,11808187:Part1,[(610,363)(586,363)(586,419)(561,419)]) } Add(ArrayRW,901330,506,375) { link(onRead,11808187:doSplit,[]) link(Array,9121665:Var2,[]) link(Index,11513600:Var2,[(519,350)(463,350)]) } Add(GetDataEx,9121665,506,267) { Angle=3 link(Data,11628349:Strings,[(491,272)]) } Add(GetDataEx,11513600,457,316) { Angle=1 link(Data,11628349:Index,[(498,321)]) } Add(Hub,11786609,231,126) { link(onEvent1,11628349:doClear,[(358,132)(358,220)]) link(onEvent2,11676265:doOpen,[(257,139)(257,193)(88,193)(88,248)]) } END_SDK Add(ChanelToIndex,983114,126,210) { link(onIndex,8774474:PageTab,[]) } Add(Hub,16008142,91,203) { link(onEvent1,983114:doWork2,[(112,209)(112,223)]) link(onEvent2,983114:doWork1,[]) } Add(ChildGroupBox,2049293,846,398) { link(onEvent1,5968126:doEvent9,[(944,404)(944,307)]) } BEGIN_SDK Add(EditMulti,10278234,21,21) { EventCount=1 WorkCount=3 Width=832 Height=536 link(doWork1,5492797:doBringToFront,[(28,27)(30,34)(28,111)]) link(doWork2,15593822:doEvent1,[(105,34)(105,83)]) link(doWork3,8211285:doText,[(77,41)(77,115)]) } Add(GroupBox,5492797,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="ЗІП" Point(doBringToFront) } Add(StringTableMT,15469714,504,130) { Left=10 Top=55 Width=760 Height=320 Columns=#4:№=25|16:Найменування=150|12:Кількість=75|13:Наявність=150| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,4396345:doRead,[]) } Add(Button,12082724,336,130) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,10464164:doOperation,[]) } Add(Math,10464164,385,130) { Op2=1 ResultType=0 link(onResult,14385736:doEvent1,[]) link(Op1,15469714:Count,[(391,111)(451,111)(451,194)(510,194)]) } Add(Edit,8211285,133,109) { Left=60 Top=13 Width=465 Text="" link(onEnter,10278234:onEvent1,[(506,122)(506,27)]) } Add(Label,12175055,175,109) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,8917315,133,165) { Name="db" link(onOpen,8537194:doEvent1,[]) link(FileName,8211285:Text,[]) } Add(DSC_Exec,6109932,196,214) { SQL="CREATE TABLE IF NOT EXISTS zip ( \r\nid INTEGER PRIMARY KEY,\r\nname text,\r\nquantity integer,\r\navailability text\r\n);\r\n" DSManager="db" } Add(DSC_Exec,3352109,553,74) { DSManager="db" } Add(ArrayRW,4396345,636,137) { link(onRead,7276389:doSplit,[]) link(Array,13512207:Var3,[(642,121)(586,121)(586,195)]) } Add(Hub,14385736,441,130) { link(onEvent1,15469714:doAdd,[]) link(onEvent2,13810872:doString,[(479,143)(479,80)]) } Add(FormatStr,13810872,504,74) { DataCount=1 Mask="INSERT INTO zip (id) VALUES (%1)" link(onFString,3352109:doExec,[]) } Add(DSC_Query,11464347,301,179) { SQL="SELECT * FROM zip" DSManager="db" link(onQuery,15469714:doMT_Add,[(419,185)(419,171)]) } Add(DSC_Exec,13958286,728,207) { DSManager="db" } Add(FormatStr,8698081,679,207) { DataCount=4 Mask="UPDATE zip SET\r\n name='%2',\r\n quantity='%3',\r\n availability='%4'\r\nWHERE id=%1" link(onFString,13958286:doExec,[]) link(Str1,7276389:Part1,[]) link(Str2,7276389:Part2,[]) link(Str3,7276389:Part3,[]) link(Str4,7276389:Part4,[]) } Add(MultiStrPart,7276389,679,137) { Char="\9" Count=4 link(onSplit,8698081:doString,[(723,143)(723,178)(667,178)(667,213)]) } Add(Hub,8537194,182,165) { link(onEvent1,11464347:doQuery,[(248,171)(248,185)]) link(onEvent2,6109932:doExec,[]) } Add(Button,838602,322,298) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,3158010:doEvent1,[]) } Add(Hub,3158010,378,298) { link(onEvent1,12698045:doRead,[]) link(onEvent2,5386638:doData,[]) } Add(DoData,5386638,420,305) { link(onEventData,15469714:doDelete,[(478,311)(478,150)]) link(Data,6121884:Var1,[(426,244)]) } Add(DSC_Exec,14026919,686,298) { DSManager="db" } Add(FormatStr,2168871,637,298) { DataCount=1 Mask="DELETE FROM zip WHERE id=%1" link(onFString,14026919:doExec,[]) link(Str1,13695267:Part1,[(643,286)(619,286)(619,342)(594,342)]) } Add(ArrayRW,12698045,539,298) { link(onRead,13695267:doSplit,[]) link(Array,13512207:Var2,[]) link(Index,6121884:Var2,[(552,273)(496,273)]) } Add(GetDataEx,13512207,539,190) { Angle=3 link(Data,15469714:Strings,[(524,195)]) } Add(GetDataEx,6121884,490,239) { Angle=1 link(Data,15469714:Index,[(531,244)]) } Add(MultiStrPart,13695267,588,298) { Char="\9" Count=1 link(onSplit,2168871:doString,[]) } Add(Hub,15593822,189,77) { link(onEvent1,15469714:doClear,[(353,83)(353,143)]) link(onEvent2,8917315:doOpen,[(215,90)(215,130)(121,130)(121,171)]) } END_SDK Add(DoData,1090255,763,32) { link(onEventData,13869979:doWork1,[]) } Add(DoData,12636495,763,74) { link(onEventData,16594303:doWork1,[]) } Add(DoData,2973519,763,116) { link(onEventData,3392:doWork1,[]) } Add(DoData,11432164,761,158) { link(onEventData,13958430:doWork1,[]) } Add(DoData,12030643,762,207) { link(onEventData,12437118:doWork1,[]) } Add(DoData,11648305,762,256) { link(onEventData,12602276:doWork1,[]) } Add(DoData,15919337,762,305) { link(onEventData,7725053:doWork1,[]) } Add(DoData,3114967,762,347) { link(onEventData,6441274:doWork1,[]) } Add(DoData,772131,762,398) { link(onEventData,2049293:doWork1,[]) } Add(IndexToChanel,4412880,672,252) { Count=11 link(onEvent1,1090255:doData,[(744,258)(744,38)]) link(onEvent2,12636495:doData,[(744,265)(744,80)]) link(onEvent3,2973519:doData,[(744,272)(744,122)]) link(onEvent4,11432164:doData,[(744,279)(744,164)]) link(onEvent5,12030643:doData,[(744,286)(744,213)]) link(onEvent6,11648305:doData,[(744,293)(744,262)]) link(onEvent7,15919337:doData,[(744,300)(744,311)]) link(onEvent8,3114967:doData,[(744,307)(744,353)]) link(onEvent9,772131:doData,[(744,314)(744,404)]) link(onEvent10,14087333:doData,[(744,321)(744,451)]) } Add(MainForm,5210529,328,105) { Width=1141 Height=990 Point(onClose) Point(SizeHeader) Point(Handle) link(onCreate,11302920:doEvent1,[]) } Add(Hub,5968126,1008,245) { InCount=10 link(onEvent1,2811278:In,[]) } Add(Hub,5246273,518,252) { OutCount=10 link(onEvent1,13869979:doWork2,[(556,258)(556,45)]) link(onEvent2,16594303:doWork2,[(689,265)(689,87)]) link(onEvent3,3392:doWork2,[(556,272)(556,129)]) link(onEvent4,13958430:doWork2,[(556,279)(556,171)]) link(onEvent5,12437118:doWork2,[(556,286)(556,220)]) link(onEvent6,12602276:doWork2,[(556,293)(556,269)]) link(onEvent7,7725053:doWork2,[(556,300)(556,318)]) link(onEvent8,6441274:doWork2,[(556,307)(556,360)]) link(onEvent9,2049293:doWork2,[(689,314)(689,411)]) link(onEvent10,11784741:doWork2,[(556,321)(556,458)]) } Add(ListBox,5671226,406,238) { Left=5 Top=30 Width=200 Height=920 DataType=1 Point(Index) Point(onDblClick) link(onClick,14170629:doEvent1,[(474,251)(474,146)]) link(onDblClick,5246273:doEvent1,[]) } Add(DoData,736780,427,350) { link(onEventData,5671226:doDelete,[(467,356)(467,317)(366,317)(366,258)]) link(Data,5671226:Index,[]) } Add(Button,16015661,343,350) { Left=150 Top=5 Width=60 Caption="Удалить" link(onClick,736780:doData,[]) } Add(ODialog,4673223,126,56) { Filter="Текст|*.txt" link(onExecute,14485583:doEvent1,[]) } Add(SDialog,6419896,126,105) { Filter="Текст|*.txt" link(onExecute,12522412:doEvent1,[]) } Add(Menu,7920668,0,77) { Menu=#4:Файл|1:(|5:Новий|8:Відкрити|8:Зберегти|11:Зберегти як|1:-|5:Вихід|1:)|8:Допомога|12:Про програму| Point(onSelectNum) link(onSelectNum,3934991:doEvent,[]) } Add(IndexToChanel,3934991,49,84) { Count=11 link(onEvent3,4673223:doExecute,[(117,104)(117,62)]) link(onEvent4,5625880:doWork2,[]) link(onEvent5,5625880:doWork3,[(117,118)]) link(onEvent10,5210529:doClose,[(201,153)(201,132)]) link(onEvent11,10924091:doMessage,[]) } Add(Hub,14485583,182,56) { link(onEvent1,13865704:doWork2,[]) link(onEvent2,12700761:In,[]) } Add(Memory,12805926,329,56) { } Add(Message,10924091,126,154) { Message="Привет " } Add(HubEx,5625880,113,105) { link(onEvent,6419896:doExecute,[]) } Add(Hub,12522412,182,105) { link(onEvent1,13865704:doWork3,[(300,111)]) link(onEvent2,13036038:In,[]) } Add(HubEx,13865704,296,56) { link(onEvent,12805926:doValue,[]) } Add(ChildGroupBox,11784741,849,445) { link(onEvent1,5968126:doEvent10,[(944,451)(944,314)]) } BEGIN_SDK Add(EditMulti,13082838,21,21) { EventCount=1 WorkCount=3 Width=832 Height=536 link(doWork1,12209291:doBringToFront,[(28,27)(30,34)(28,111)]) link(doWork2,13423097:doEvent1,[(119,34)(119,83)]) link(doWork3,7743094:doText,[(73,41)(73,115)]) } Add(GroupBox,12209291,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="Моторесурс" Point(doBringToFront) } Add(StringTableMT,7735608,504,130) { Left=10 Top=55 Width=760 Height=320 Columns=#6:Рік=50|10:Січень=100|9:Лютий=100|12:Березень=100|11:Квітень=100|11:Травень=100|11:Червень=100|10:Липень=100|11:Серпень=100|12:Вересень=100|11:Жовтень=100|12:Листопад=100|11:Грудень=100|21:Поточні показники=200|10:Річний=150|26:З початку експлуатації=250|23:Після останнього КР=250| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,1283587:doRead,[(566,143)(566,181)(623,181)(623,143)]) } Add(Button,2317060,336,130) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,5922852:doOperation,[]) } Add(Math,5922852,385,130) { Op2=1 ResultType=0 link(onResult,14753751:doEvent1,[]) link(Op1,7735608:Count,[(391,111)(451,111)(451,194)(510,194)]) } Add(Edit,7743094,126,109) { Left=60 Top=13 Width=465 Text="" link(onEnter,13082838:onEvent1,[(506,122)(506,27)]) } Add(Label,14235026,182,109) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,10583734,133,165) { Name="db" link(onOpen,1870618:doEvent1,[]) link(FileName,7743094:Text,[(139,153)(132,153)]) } Add(DSC_Exec,2633806,196,214) { SQL="CREATE TABLE IF NOT EXISTS resource ( \r\nid INTEGER PRIMARY KEY,\r\nyear integer,\r\njan integer,\r\nfeb integer,\r\nmarch integer,\r\napril integer,\r\nmay integer,\r\njune integer,\r\njule integer,\r\naugust integer,\r\nsept integer,\r\noctober integer,\r\nnovember integer,\r\ndecember integer,\r\ncurrent integer,\r\nyearnew integer,\r\nstart integer,\r\nlastkr integer\r\n);\r\n" DSManager="db" } Add(DSC_Exec,16616374,553,74) { DSManager="db" } Add(ArrayRW,1283587,636,137) { link(onRead,8118530:doSplit,[]) link(Array,16774790:Var3,[(642,121)(585,121)(585,190)(589,190)(592,198)(592,209)(578,209)(565,206)(565,194)(565,194)]) } Add(Hub,14753751,441,130) { link(onEvent1,7735608:doAdd,[]) link(onEvent2,14995619:doString,[(479,143)(479,80)]) } Add(FormatStr,14995619,504,74) { DataCount=1 Mask="INSERT INTO resource (id) VALUES (%1)" link(onFString,16616374:doExec,[]) } Add(DSC_Query,15192787,301,179) { SQL="SELECT * FROM resource" DSManager="db" link(onQuery,7735608:doMT_Add,[(419,185)(419,171)]) } Add(DSC_Exec,10253509,749,270) { DSManager="db" } Add(FormatStr,6136212,679,207) { DataCount=18 Mask="UPDATE resource SET \r\n year='%2',\r\n jan='%3',\r\n feb='%4',\r\n march='%5',\r\n april='%6',\r\n may='%7',\r\n june='%8',\r\n jule='%9',\r\n august='%10',\r\n sept='%11',\r\n october='%12',\r\n november='%13',\r\n december='%14',\r\n current='%15',\r\n yearnew='%16',\r\n start='%17',\r\n lastkr='%18'\r\nWHERE id=%1\r\n\r\n" link(onFString,10253509:doExec,[(764,213)(764,245)(737,245)(737,276)]) link(Str1,8118530:Part1,[]) link(Str2,8118530:Part2,[]) link(Str3,8118530:Part3,[]) link(Str4,8118530:Part4,[]) link(Str5,8118530:Part5,[]) link(Str6,8118530:Part6,[]) link(Str7,8118530:Part7,[]) link(Str8,8118530:Part8,[]) link(Str9,8118530:Part9,[]) link(Str10,8118530:Part10,[]) link(Str11,8118530:Part11,[]) link(Str12,8118530:Part12,[]) link(Str13,8118530:Part13,[]) link(Str14,8118530:Part14,[]) link(Str15,8118530:Part15,[]) link(Str16,8118530:Part16,[]) link(Str17,8118530:Part17,[]) link(Str18,8118530:Part18,[]) } Add(MultiStrPart,8118530,679,137) { Char="\9" Count=18 link(onSplit,6136212:doString,[(723,143)(723,178)(667,178)(667,213)]) } Add(Hub,1870618,182,165) { link(onEvent1,15192787:doQuery,[(248,171)(248,185)]) link(onEvent2,2633806:doExec,[]) } Add(Button,3984982,322,298) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,1303128:doEvent1,[]) } Add(Hub,1303128,378,298) { link(onEvent1,8562638:doRead,[]) link(onEvent2,15559044:doData,[]) } Add(DoData,15559044,420,305) { link(onEventData,7735608:doDelete,[(478,311)(478,150)]) link(Data,11617938:Var1,[(426,244)]) } Add(DSC_Exec,11160853,686,298) { DSManager="db" } Add(FormatStr,4574577,637,298) { DataCount=1 Mask="DELETE FROM resource WHERE id=%1" link(onFString,11160853:doExec,[]) link(Str1,5605138:Part1,[(643,286)(619,286)(619,342)(594,342)]) } Add(ArrayRW,8562638,539,298) { link(onRead,5605138:doSplit,[]) link(Array,16774790:Var2,[]) link(Index,11617938:Var2,[(552,273)(496,273)]) } Add(GetDataEx,16774790,539,190) { Angle=3 link(Data,7735608:Strings,[(524,195)]) } Add(GetDataEx,11617938,490,239) { Angle=1 link(Data,7735608:Index,[(531,244)]) } Add(MultiStrPart,5605138,588,298) { Char="\9" Count=1 link(onSplit,4574577:doString,[]) } Add(Hub,13423097,217,77) { link(onEvent1,7735608:doClear,[(367,83)(367,143)]) link(onEvent2,10583734:doOpen,[(243,90)(243,130)(121,130)(121,171)]) } END_SDK Add(DoData,14087333,763,445) { link(onEventData,11784741:doWork1,[]) } Add(InfoTip,10612721,828,345) { Info=#0:|26: Тормозна рідина| Width=169 Height=39 } Add(InfoTip,13875501,828,303) { Info=#1: |34: Охолоджуюча рідина| Width=169 Height=39 } Add(InfoTip,1920936,828,205) { Info=#0:|12: АКБ| Width=169 Height=39 } Add(InfoTip,13177498,828,156) { Info=#0:|13: Шини| Width=169 Height=39 } Add(InfoTip,12905837,828,114) { Info=#0:|11: ТО| Width=169 Height=39 } Add(InfoTip,16183452,499,16) { Info=#18:Сторінки програми | Width=547 Height=487 } Add(InfoTip,14087171,828,254) { Info=#0:|14: Масло| Width=169 Height=39 } Add(InfoTip,9347721,828,394) { Info=#0:|12: ЗІП| Width=169 Height=39 } Add(InfoTip,6981593,828,72) { Info=#0:|17: Персонал| Width=169 Height=39 } Add(InfoTip,1691909,828,23) { Info=#0:|20: Информація| Width=169 Height=46 } Add(InfoTip,10770090,826,441) { Info=#0:|19: Моторесурс| Width=169 Height=39 } Add(LineBreak,897259,259,238) { Caption="Занос данных" link(Out,5671226:doAdd,[]) Primary=[2811278,812,7] } Add(LineBreak,11875401,259,266) { Caption="Открытие" link(Out,5671226:doLoad,[]) Primary=[12700761,-42,-203] } Add(LineBreak,2923617,259,287) { Caption="Сохранение " link(Out,5671226:doSave,[(371,293)(371,279)]) Primary=[13036038,-35,-175] } Add(ChildGroupBox,13869979,844,32) { link(onEvent1,5968126:doEvent1,[(942,38)(942,251)]) } BEGIN_SDK Add(EditMulti,1093219,-21,14) { EventCount=3 WorkCount=4 Width=895 Height=599 link(doWork1,1821971:doBringToFront,[]) link(doWork2,3450379:doEvent1,[(154,27)(154,90)]) link(doWork3,16763885:doText,[(53,34)(53,164)]) } Add(GroupBox,1821971,42,14) { Left=220 Top=35 Width=775 Height=450 Caption="Інформація" Point(doBringToFront) } Add(MultiStrPart,4801076,583,347) { Char="\9" Count=1 link(onSplit,16452228:doString,[]) } Add(StringTableMT,4461392,499,179) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|9:Серія=100|19:Марка та модель=100|7:Тип=150|16:Постачальник=150|19:Код ВК 001-2000=250|18:Завод-виробник=200|20:Рік виготовлення=200|8:Шасі=250|10:Кузов№=200|23:Модель та № двигуна-250|14:В/Н машини=200|14:Моторесурс=200|9:Водій=200|10:Статус=200| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,305548:doRead,[]) } Add(Button,1999484,331,179) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,8453774:doOperation,[]) } Add(Math,8453774,380,179) { Op2=1 ResultType=0 link(onResult,16330249:doEvent1,[]) link(Op1,4461392:Count,[(386,160)(446,160)(446,243)(505,243)]) } Add(Edit,16763885,128,158) { Left=60 Top=13 Width=465 Text="" link(onEnter,1093219:onEvent1,[(517,171)(517,20)]) } Add(Label,8111066,170,130) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,15709408,128,214) { Name="db" link(onOpen,8742108:doEvent1,[]) link(FileName,16763885:Text,[]) } Add(DSC_Exec,9664755,191,263) { SQL="CREATE TABLE IF NOT EXISTS transport ( \r\n id INTEGER PRIMARY KEY,\r\n series TEXT,\r\n marka INTEGER,\r\n model INTEGER,\r\n type INTEGER,\r\n provider INTEGER,\r\n codvk TEXT,\r\n factory INTEGER,\r\n dyear INTEGER,\r\n chassis TEXT,\r\n body TEXT,\r\n engine TEXT,\r\n regnom TEXT,\r\n prob INTEGER,\r\n driver INTEGER,\r\n status INTEGER\r\n);" DSManager="db" } Add(DSC_Exec,16541716,548,123) { DSManager="db" } Add(ArrayRW,305548,631,186) { link(onRead,6984200:doSplit,[]) link(Array,15787793:Var3,[(637,170)(581,170)(581,244)]) } Add(Hub,16330249,436,179) { link(onEvent1,4461392:doAdd,[]) link(onEvent2,6194733:doString,[(474,192)(474,129)]) } Add(FormatStr,6194733,499,123) { DataCount=1 Mask="INSERT INTO transport (id) VALUES (%1)" link(onFString,16541716:doExec,[]) } Add(DSC_Query,15980389,296,228) { SQL="SELECT * FROM transport" DSManager="db" link(onQuery,4461392:doMT_Add,[(414,234)(414,220)]) } Add(DSC_Exec,10975249,828,256) { DSManager="db" } Add(FormatStr,2826321,674,256) { DataCount=16 Mask="UPDATE transport SET \r\n series = '%2',\r\n marka ='%3',\r\n model = '%4',\r\n type ='%5',\r\n provider = '%6', \r\n codvk = '%7',\r\n factory = '%8',\r\n dyear = '%9',\r\n chassis = '%10',\r\n body = '%11',\r\n engine = '%12',\r\n regnom = '%13',\r\n prob = '%14',\r\n driver = '%15',\r\n status = '%16'\r\n \r\n WHERE id=%1" link(onFString,10975249:doExec,[]) link(Str1,6984200:Part1,[]) link(Str2,6984200:Part2,[]) link(Str3,6984200:Part3,[]) link(Str4,6984200:Part4,[]) link(Str5,6984200:Part5,[]) link(Str6,6984200:Part6,[]) link(Str7,6984200:Part7,[]) link(Str8,6984200:Part8,[]) link(Str9,6984200:Part9,[]) link(Str10,6984200:Part10,[]) link(Str11,6984200:Part11,[]) link(Str12,6984200:Part12,[]) link(Str13,6984200:Part13,[]) link(Str14,6984200:Part14,[]) link(Str15,6984200:Part15,[]) link(Str16,6984200:Part16,[]) } Add(MultiStrPart,6984200,674,186) { Char="\9" Count=16 link(onSplit,2826321:doString,[(718,192)(718,227)(662,227)(662,262)]) } Add(Hub,8742108,177,214) { link(onEvent1,15980389:doQuery,[(243,220)(243,234)]) link(onEvent2,9664755:doExec,[]) } Add(Button,693845,317,347) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,3620438:doEvent1,[]) } Add(Hub,3620438,373,347) { link(onEvent1,11359987:doRead,[]) link(onEvent2,2656656:doData,[]) } Add(DoData,2656656,415,354) { link(onEventData,4461392:doDelete,[(473,360)(473,199)]) link(Data,844141:Var1,[(421,293)]) } Add(DSC_Exec,8380853,681,347) { DSManager="db" } Add(FormatStr,16452228,632,347) { DataCount=1 Mask="DELETE FROM transport WHERE id=%1" link(onFString,8380853:doExec,[]) link(Str1,4801076:Part1,[(638,335)(614,335)(614,391)(589,391)]) } Add(ArrayRW,11359987,534,347) { link(onRead,4801076:doSplit,[]) link(Array,15787793:Var2,[]) link(Index,844141:Var2,[(547,322)(491,322)]) } Add(GetDataEx,15787793,534,239) { Angle=3 link(Data,4461392:Strings,[(519,244)]) } Add(GetDataEx,844141,485,288) { Angle=1 link(Data,4461392:Index,[(526,293)]) } Add(Hub,3450379,329,84) { link(onEvent1,4461392:doClear,[(421,90)(421,192)]) link(onEvent2,15709408:doOpen,[(355,97)(355,159)(116,159)(116,220)]) } END_SDK Add(MultiElementEx,15470616,325,168) { link(Handle,5210529:SizeHeader,[(331,152)(334,152)]) link(HeaderSize,5210529:Handle,[(345,152)(341,152)]) } BEGIN_SDK Add(EditMultiEx,192608,21,21) { WorkCount=#9:doMaxSize| EventCount=#7:XxYsize| VarCount=#16:WidthVisibleArea|17:HeightVisibleArea| DataCount=#6:Handle|10:BorderSize|10:HeaderSize| Width=958 Height=557 link(doMaxSize,7045888:doEvent1,[(137,27)(137,265)]) link(WidthVisibleArea,377241:Var2,[(27,420)(629,420)]) link(HeightVisibleArea,15386201:Var2,[(34,459)(594,459)]) } Add(Screen,7845531,350,189) { Point(BottomWorkarea) } Add(SizeWindow,8420958,350,259) { link(Handle,192608:Handle,[(356,140)(27,140)]) link(Width,7845531:Width,[(363,245)(356,245)]) link(Height,7845531:BottomWorkarea,[(370,247)(377,247)]) } Add(Hub,7045888,252,259) { OutCount=3 link(onEvent1,8420958:doWidth,[]) link(onEvent2,8420958:doHeight,[]) link(onEvent3,10623626:In,[]) } Add(MathParse,15142984,525,231) { MathStr="%1 - (%2*2)" link(onResult,9890621:doValue,[]) link(X1,8420958:CurrentWidth,[(531,219)(415,219)(415,303)(356,303)]) link(X2,7021917:Var3,[(538,126)]) } Add(MathParse,9862497,525,308) { DataCount=3 MathStr="%1 - %2 - %3" link(onResult,12337854:doValue,[]) link(X1,8420958:CurrentHeight,[(531,297)(363,297)]) link(X2,7021917:Var2,[(538,219)(440,219)]) link(X3,192608:HeaderSize,[(545,164)(41,164)]) } Add(Hub,4056530,483,231) { link(onEvent1,15142984:doCalc,[]) link(onEvent2,9862497:doCalc,[(515,244)(515,314)]) } Add(LineBreak,3886,427,231) { link(Out,4056530:doEvent1,[]) Primary=[10623626,-112,42] } Add(GetDataEx,7021917,434,121) { Angle=3 link(Data,192608:BorderSize,[(34,126)]) } Add(Memory,9890621,623,231) { } Add(Memory,12337854,588,308) { link(onData,387831:doStrCatDlm,[(670,314)(670,454)]) } Add(StrCatDelim,387831,721,448) { Delimiter="x" link(onStrCatDlm,192608:XxYsize,[(866,454)(866,27)]) link(Str1,377241:Var3,[(727,278)]) link(Str2,15386201:Var3,[(734,369)]) } Add(GetDataEx,377241,623,273) { link(Data,9890621:Value,[]) } Add(GetDataEx,15386201,588,364) { link(Data,12337854:Value,[]) } END_SDK Add(Hub,11302920,392,119) { link(onEvent1,16008142:doEvent1,[(418,125)(418,174)(79,174)(79,209)]) link(onEvent2,15470616:doMaxSize,[(418,132)(418,160)(313,160)(313,174)]) } Add(DatePicker,6955404,0,21) { Left=1010 Top=5 Width=115 Height=21 } Add(ChildGroupBox,3392,846,116) { link(onEvent1,5968126:doEvent3,[(943,122)(943,265)]) } BEGIN_SDK Add(EditMulti,594006,-14,14) { EventCount=1 WorkCount=3 Width=783 Height=585 link(doWork1,14145463:doBringToFront,[(77,20)(77,111)]) link(doWork2,7427265:doEvent1,[(91,27)(91,90)]) link(doWork3,8670019:doText,[(29,34)(29,178)]) } Add(GroupBox,14145463,35,105) { Left=220 Top=35 Width=775 Height=450 Caption="ТО" Point(doBringToFront) } Add(MultiStrPart,6596111,534,361) { Char="\9" Count=1 link(onSplit,12549810:doString,[]) } Add(StringTableMT,10156469,450,193) { Left=10 Top=55 Width=775 Height=320 Columns=#4:№=25|19:Дата проведення=150|10:Вид ТО=150|23:Показник спідометру=150|19:Висновок про ТО=200|0:| StrDelimiter="\9" Redaction=0 IconsCheck=[] MiscIcons=[] Icons=[] Point(doMT_Add) Point(Strings) Point(onLineChange) Point(Index) link(onLineChange,7660174:doRead,[]) } Add(Button,12281969,233,193) { Left=10 Top=34 Width=120 Caption="Добавить строку" link(onClick,7952942:doOperation,[]) } Add(Math,7952942,331,193) { Op2=1 ResultType=0 link(onResult,9388554:doEvent1,[]) link(Op1,10156469:Count,[(337,174)(397,174)(397,257)(456,257)]) } Add(Label,10005151,121,172) { Left=10 Top=13 Width=48 Height=17 Caption="Имя БД:" } Add(DS_SQLite,9742640,79,228) { Name="db" link(onOpen,12589275:doEvent1,[]) link(FileName,14551549:Var2,[]) } Add(DSC_Exec,16276188,142,277) { SQL="CREATE TABLE IF NOT EXISTS tov ( \r\n id INTEGER PRIMARY KEY,\r\n date integer,\r\n nameTO text,\r\n odometr integer,\r\n conclusion text\r\n);" DSManager="db" } Add(DSC_Exec,3063644,499,137) { DSManager="db" } Add(ArrayRW,7660174,582,200) { link(onRead,2536623:doSplit,[]) link(Array,355376:Var3,[(588,184)(532,184)(532,258)]) } Add(Hub,9388554,387,193) { link(onEvent1,10156469:doAdd,[]) link(onEvent2,6135054:doString,[(425,206)(425,143)]) } Add(FormatStr,6135054,450,137) { DataCount=1 Mask="INSERT INTO tov (id) VALUES (%1)" link(onFString,3063644:doExec,[]) } Add(DSC_Query,3811334,247,242) { SQL="SELECT * FROM tov" DSManager="db" link(onQuery,10156469:doMT_Add,[(365,248)(365,234)]) } Add(DSC_Exec,13779534,674,270) { DSManager="db" } Add(FormatStr,2197243,625,270) { DataCount=5 Mask="UPDATE tov \r\nSET date ='%2',\r\n nameTO = '%3',\r\n odometr ='%4',\r\n conclusion ='%5' \r\nWHERE id=%1" link(onFString,13779534:doExec,[]) link(Str1,2536623:Part1,[]) link(Str2,2536623:Part2,[]) link(Str3,2536623:Part3,[]) link(Str4,2536623:Part4,[]) link(Str5,2536623:Part5,[]) } Add(MultiStrPart,2536623,625,200) { Char="\9" Count=5 link(onSplit,2197243:doString,[(669,206)(669,241)(613,241)(613,276)]) } Add(Hub,12589275,128,228) { link(onEvent1,3811334:doQuery,[(194,234)(194,248)]) link(onEvent2,16276188:doExec,[]) } Add(Button,2956267,268,361) { Left=135 Top=34 Width=120 Caption="Удалить строку" link(onClick,6767165:doEvent1,[]) } Add(Hub,6767165,324,361) { link(onEvent1,12972110:doRead,[]) link(onEvent2,361708:doData,[]) } Add(DoData,361708,366,368) { link(onEventData,10156469:doDelete,[(415,374)(415,211)(450,211)]) link(Data,7895740:Var1,[(372,307)]) } Add(DSC_Exec,12366266,632,361) { DSManager="db" } Add(FormatStr,12549810,583,361) { DataCount=1 Mask="DELETE FROM tov WHERE id=%1" link(onFString,12366266:doExec,[]) link(Str1,6596111:Part1,[(589,349)(565,349)(565,405)(540,405)]) } Add(ArrayRW,12972110,485,361) { link(onRead,6596111:doSplit,[]) link(Array,355376:Var2,[]) link(Index,7895740:Var2,[(498,336)(442,336)]) } Add(GetDataEx,355376,485,253) { Angle=3 link(Data,10156469:Strings,[(470,258)]) } Add(GetDataEx,7895740,436,302) { Angle=1 link(Data,10156469:Index,[(477,307)]) } Add(Hub,7427265,196,84) { OutCount=3 link(onEvent1,10156469:doClear,[(330,90)(330,206)]) link(onEvent2,9742640:doOpen,[(222,97)(222,165)(67,165)(67,234)]) } Add(GetDataEx,14551549,79,217) { link(Data,8670019:Text,[(85,216)(78,216)]) } Add(Edit,8670019,72,172) { Left=60 Top=13 Width=465 Text="" link(onEnter,594006:onEvent1,[(436,185)(436,20)]) } END_SDK Add(Hub,14170629,518,140) { OutCount=10 link(onEvent1,13869979:doWork3,[(688,146)(688,52)]) link(onEvent2,16594303:doWork3,[(688,153)(688,94)]) link(onEvent3,3392:doWork3,[(688,160)(688,136)]) link(onEvent4,13958430:doWork3,[(688,167)(688,178)]) link(onEvent5,12437118:doWork3,[(689,174)(689,227)]) link(onEvent6,12602276:doWork3,[(689,181)(689,276)]) link(onEvent7,7725053:doWork3,[(689,188)(689,325)]) link(onEvent8,6441274:doWork3,[(689,195)(689,367)]) link(onEvent9,2049293:doWork3,[(689,202)(689,418)]) link(onEvent10,11784741:doWork3,[(690,209)(690,465)]) }
В моторесурсе посчитать сумму всех месяцев и вывести в "поточні показники" SELECT 1 From to1 WHERE текущие показания одометра - показания одометра последнего to1 >= периодичность to1 в км
По твоим словам нам нужны показания текущего одометра - показания одометра последнего ТО и поэтому нам нужно сделать чтобы оно постоянно сохраняло показания одометра во время последнего ТО. Редактировалось 2 раз(а), последний 2018-08-27 12:19:30
|