CREATE TABLE IF NOT EXISTS transport(
id INTEGER PRIMARY KEY,
series TEXT,
marka INTEGER, --id из списка марок
model INTEGER, --id из списка моделей
type INTEGER, --id из списка типов
provider INTEGER, --id из списка поставщиков
codvk text, --там и цифры и буквы
factory INTEGER, --id из списка производителей
dyear INTEGER,
chassis text,
body text,
engine text,
regNom text,
prob INTEGER,
driver INTEGER, --id из таблицы personal
status INTEGER -- 0-рабочая, 1-в ремонте, 2-списана
);
CREATE TABLE IF NOT EXISTS personal (
id INTEGER PRIMARY KEY,
rank text,
name text,
serial text,
date integer,
status integer -- 0-служит, 1-уволен
);
CREATE TABLE IF NOT EXISTS tov (
id INTEGER PRIMARY KEY,
date integer,
nameTO text,
odometr integer,
conclusion text
);
CREATE TABLE IF NOT EXISTS tires (
id INTEGER PRIMARY KEY,
factorynumber integer,
size integer,
factory text, --производителей очень много и я не всех смогу прописать так как не всех знаю
date integer,
instillation integer,
deletet integer,
cause text
);
CREATE TABLE IF NOT EXISTS acb (
id INTEGER PRIMARY KEY,
number integer,
marka integer, -- марка
factory integer, --завод
date integer,
work integer,
instillation integer,
datektc integer,
cause text
);
CREATE TABLE IF NOT EXISTS butter (
id INTEGER PRIMARY KEY,
datebutter integer,
type integer, -- тип масла
causebatter text,
datefilter integer,
causefilter text
);
CREATE TABLE IF NOT EXISTS cool (
id INTEGER PRIMARY KEY,
date integer,
type ineteger, --тип охлаждающей жидкости
cause text
);
CREATE TABLE IF NOT EXISTS brake (
id INTEGER PRIMARY KEY,
date integer,
type ineteger, --тип тормозной жидкости
cause text
);
CREATE TABLE IF NOT EXISTS zip (
id INTEGER PRIMARY KEY,
name text,
quantity integer,
availability text
);
CREATE TABLE IF NOT EXISTS resource (
id INTEGER PRIMARY KEY,
year integer,
jan integer,
feb integer,
march integer,
april integer,
may integer,
june integer,
jule integer,
august integer,
sept integer,
october integer,
november integer,
december integer,
yearnew integer,
start integer,
lastkr integer
);
Как теперь правильно обратиться к базе данных к таблице resourse к переменным с явнваря по февраль, чтобы от туда брало данные и загорались лампочки в зависимости от заданного условия.
И да мне не надо 720 лампочек мне надо только 10 лампочек( ТО-1, ТО-2 , КР, СР, СО, АКБ, ШИНЫ, Охл. жид. , Тормозная жид. , Общий моторесурс) на каждую машину будет разная бд которую мы будем загружать из списка строк нажимаю даблклил на название. Надо сделать чтобы эти лампочки связовались с бд считывали определенные данные и исходя из них уже горели или не горели
--- Добавлено в 2018-08-21 10:23:36
я правильно сделал все? только еще не прописал для выбора статуса или производителей
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|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,[])
}
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\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)(586,121)(586,195)])
}
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=17
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 yearnew='%15',\r\n start='%16',\r\n lastkr='%17'\r\nWHERE id=%1"
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,[])
}
Add(MultiStrPart,8118530,679,137)
{
Char="\9"
Count=17
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(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,695,228)
{
DSManager="db"
}
Add(FormatStr,4361700,646,228)
{
DataCount=5
Mask="UPDATE personal SET rank= '%2', name ='%3', serial = '%4', date ='%5', 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,[])
}
Add(MultiStrPart,4885776,646,158)
{
Char="\9"
Count=5
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 integer='%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,[])
}
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 TABLECREATE TABLE IF NOT EXISTS cool ( \r\n id INTEGER PRIMARY KEY,\r\n date integer,\r\n type ineteger, --тип охлаждающей жидкости\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 ineteger, --тип тормозной жидкости\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(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,485,16)
{
Info=#18:Сторінки програми |
Width=561
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,10422579,259,238)
{
Caption="Занос данных"
link(Out,5671226:doAdd,[(375,244)(375,244)])
Primary=[2811278,812,7]
}
Add(LineBreak,9732947,259,266)
{
Caption="Открытие"
link(Out,5671226:doLoad,[])
Primary=[12700761,-42,-203]
}
Add(LineBreak,14324659,259,287)
{
Caption="Сохранение "
link(Out,5671226:doSave,[(371,293)(371,279)])
Primary=[13036038,-35,-175]
}
Add(ChildGroupBox,13869979,844,32)
{
link(onEvent3,5968126:doEvent1,[(943,52)(943,251)])
}
BEGIN_SDK
Add(EditMulti,1093219,-21,14)
{
EventCount=3
WorkCount=3
Width=895
Height=599
link(doWork1,1821971:doBringToFront,[])
link(doWork2,1054614:doEvent1,[(119,27)(119,69)])
link(doWork3,12731683:doText2,[])
}
Add(GroupBox,1821971,42,14)
{
Left=220
Top=35
Width=775
Height=450
Caption="Інформація"
Point(doBringToFront)
}
Add(StringTableMT,3507321,457,165)
{
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,8097891:doRead,[])
}
Add(Button,5227062,289,165)
{
Left=10
Top=34
Width=120
Caption="Добавить строку"
link(onClick,5709514:doOperation,[])
}
Add(Math,5709514,338,165)
{
Op2=1
ResultType=0
link(onResult,15254699:doEvent1,[])
link(Op1,3507321:Count,[(344,146)(404,146)(404,229)(463,229)])
}
Add(Edit,12731683,86,21)
{
Left=60
Top=13
Width=465
Text=""
link(onChange,1093219:onEvent2,[])
link(onEnter,1093219:onEvent3,[])
}
Add(Label,15829541,128,39)
{
Left=10
Top=13
Width=48
Height=17
Caption="Имя БД:"
}
Add(DS_SQLite,2788739,86,200)
{
Name="db"
link(onOpen,16210215:doEvent1,[])
link(FileName,12731683:Text,[])
}
Add(DSC_Exec,3817980,198,207)
{
SQL="CREATE TABLE IF NOT EXISTS transport(\r\n id INTEGER PRIMARY KEY,\r\n series TEXT,\r\n marka INTEGER, --id из списка марок \r\n model INTEGER, --id из списка моделей\r\n type INTEGER, --id из списка типов \r\n provider INTEGER, --id из списка поставщиков\r\n codvk text, --тут и текст и буквы\r\n factory INTEGER, --id из списка производителей\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, --id из таблицы personal \r\n status INTEGER -- 0-рабочая, 1-в ремонте, 2-списана \r\n );\r\n"
DSManager="db"
}
Add(DSC_Exec,13011596,506,109)
{
DSManager="db"
}
Add(ArrayRW,8097891,589,172)
{
link(onRead,1975636:doSplit,[])
link(Array,10746862:Var3,[(595,158)(539,158)(539,157)(539,230)])
}
Add(Hub,15254699,394,165)
{
link(onEvent1,3507321:doAdd,[])
link(onEvent2,363894:doString,[(432,178)(432,115)])
}
Add(FormatStr,363894,457,109)
{
DataCount=1
Mask="INSERT INTO transport (id) VALUES (%1)"
link(onFString,13011596:doExec,[])
}
Add(DSC_Query,5954143,254,200)
{
SQL="SELECT * FROM transport"
DSManager="db"
link(onQuery,3507321:doMT_Add,[])
}
Add(DSC_Exec,8261552,821,305)
{
DSManager="db"
}
Add(FormatStr,14594587,632,235)
{
DataCount=16
Mask="UPDATE transport SET series = '%2',marka= '%3' model = '%4', type = '%5', provider = '%6', codvk = '%7' , factory = '%8' , dyear = '%9' , chassis = '%10', body ='%11' , engine= '%12', regNom= '%13' , prob= '%14' , diver='%15' , status= '%16' WHERE id=%1"
link(onFString,8261552:doExec,[(784,241)(784,311)])
link(Str1,1975636:Part1,[])
link(Str2,1975636:Part2,[])
link(Str3,1975636:Part3,[])
link(Str4,1975636:Part4,[])
link(Str5,1975636:Part5,[])
link(Str6,1975636:Part6,[])
link(Str7,1975636:Part7,[])
link(Str8,1975636:Part8,[])
link(Str9,1975636:Part9,[])
link(Str10,1975636:Part10,[])
link(Str11,1975636:Part11,[])
link(Str12,1975636:Part12,[])
link(Str13,1975636:Part13,[])
link(Str14,1975636:Part14,[])
link(Str15,1975636:Part15,[])
link(Str16,1975636:Part16,[])
}
Add(MultiStrPart,1975636,632,172)
{
Char="\9"
Count=16
link(onSplit,14594587:doString,[(759,178)(759,210)(620,210)(620,241)])
}
Add(Hub,16210215,135,200)
{
link(onEvent1,5954143:doQuery,[])
link(onEvent2,3817980:doExec,[])
}
Add(Button,9039559,275,333)
{
Left=135
Top=34
Width=120
Caption="Удалить строку"
link(onClick,12175230:doEvent1,[])
}
Add(Hub,12175230,331,333)
{
link(onEvent1,16009664:doRead,[])
link(onEvent2,14938611:doData,[])
}
Add(DoData,14938611,373,340)
{
link(onEventData,3507321:doDelete,[(431,346)(431,185)])
link(Data,13069318:Var1,[(379,279)])
}
Add(DSC_Exec,2818224,639,333)
{
DSManager="db"
}
Add(FormatStr,9911972,590,333)
{
DataCount=1
Mask="DELETE FROM transport WHERE id=%1"
link(onFString,2818224:doExec,[])
link(Str1,1062532:Part1,[(596,321)(572,321)(572,377)(541,377)])
}
Add(ArrayRW,16009664,492,333)
{
link(onRead,1062532:doSplit,[])
link(Array,10746862:Var2,[])
link(Index,13069318:Var2,[(505,308)(449,308)])
}
Add(GetDataEx,10746862,492,225)
{
Angle=3
link(Data,3507321:Strings,[(477,230)])
}
Add(GetDataEx,13069318,443,274)
{
Angle=1
link(Data,3507321:Index,[(484,279)])
}
Add(MultiStrPart,1062532,535,333)
{
Char="\9"
Count=1
link(onSplit,9911972:doString,[])
}
Add(Hub,1054614,259,63)
{
link(onEvent1,3507321:doClear,[(365,69)(365,178)])
link(onEvent2,2788739:doOpen,[(285,76)(285,141)(74,141)(74,206)])
}
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,13485889,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,847,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 integer,\r\n nameTO = '%2'\r\n odometr ='%3',\r\n conclusion ='%4' \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)])
}
Поиск
Друзья
Администрация