Курсовые работы / ПРИС КП_И_11
.pdf
|
, |
|
|
. |
|
– |
, |
|
. |
2.2. |
|
2.2 – |
|
|
|
|
|
|
|
|
id |
Number |
|
. . . |
String |
|
|
Datetime |
|
|
Datetime |
|
|
Datetime |
|
|
String |
|
|
Number |
|
|
String |
|
|
String |
|
|
Number |
|
|
Number |
|
|
String |
|
|
String |
|
|
Number |
|
|
Number |
|
|
String |
|
|
String |
|
|
String |
|
|
String |
|
|
Number |
|
|
String |
|
|
String |
|
, |
2.9, |
|
,
.
.
. |
« |
».
22
« |
» |
, |
.
« ».
.
« |
» « |
» |
, |
. |
2.9 – |
, |
.
.
; |
, |
, |
.
.
,
, |
. |
, |
,
( 2.10).
.
.
23
,
( 2.3).
2.10 – ER-
2.3 –
|
|
|
|
id |
Integer |
|
|
. . . |
String |
100 |
|
|
Datetime |
10 |
|
|
Datetime |
10 |
|
|
Datetime |
10 |
|
|
String |
2 |
|
|
Integer |
|
>0 <50 |
|
String |
11 |
|
|
String |
|
|
|
Float |
|
>0 |
|
Float |
|
>0 |
|
String |
25 |
|
|
String |
8 |
|
|
Float |
|
>0 |
|
Integer |
|
>0 |
|
String |
25 |
|
|
String |
25 |
|
|
String |
25 |
|
|
String |
25 |
|
|
Float |
|
>0 |
|
String |
20 |
|
|
String |
20 |
|
24
, |
, |
, |
( 2.11).
|
2.11 – |
|
, |
|
|
|
, |
|
, |
. |
, |
. |
|
|
|
|
, |
|
. |
|
, |
0. |
|
, |
1–7. |
|
, |
|
|
. |
|
. |
- |
MS Access Delphi 7. |
|
|
25 |
|
3
3.1
Access |
3.1 – 3.6. |
[12-13].
3.1 – |
« |
» |
Id_avto
Marka
Nomer
Gruzopodiemnost
Moshnost
EDIT
3.2 – |
« |
» |
Id_gruza
Tip_gruza
Ves_gruza
Trebovania_k_transportirovke
EDIT
3.3 – |
« |
» |
Id_marshruti
Mesto_naznachenia
Rasstoyanie
Klass_dorogi
Klass_slognosti
Stoimost
EDIT
26
3.4 – |
« |
» |
|
|
|
|
|
|
|
|
|
Id_voditeli |
|
|
|
FIO |
|
|
|
Foto |
|
|
OLE |
Data_rogdenia |
|
|
/ |
Klassnost |
|
|
|
Stag |
|
|
|
Kontaktniy_telephon |
|
|
|
EDIT |
|
|
|
|
|
|
|
3.5 – |
« |
» |
|
|
|
|
|
|
|
|
|
Id_reys |
|
|
|
id_marshruti |
|
|
|
id_avto |
|
|
|
id_gruzi |
|
|
|
data_nachala |
|
|
/ |
data_oconchania |
|
|
/ |
id_voditeli |
|
|
|
EDIT |
|
|
|
|
|
|
|
3.6 – |
« |
» |
|
|
|
|
|
|
|
|
|
USER_ID |
|
|
|
URER |
|
|
|
PASS |
|
|
|
. EDIT
.
.
3.2
27
3.1.
(
)
Ф
3.1 –
, |
|
|
|
|
. |
|
|
|
. |
|
|
: |
, |
, |
, |
|
. |
« |
» |
|
|
. |
« |
|
|
» |
|
: |
, |
, |
|
|
, |
. |
« |
» |
|
|
|
|
: |
, |
|
, |
, |
, |
. |
« |
» |
, |
|
|
. |
28
3.3 |
|
|
|
|
|
|
ADO. |
Data |
Access |
( |
), Data |
Controls ( |
) |
ADO ( |
ADO). |
|
3.2 [14-16]. |
|
|
|
|
3.2 – |
|
|
|
|
|
3.3. |
|
|
|
|
RepoQuery |
RepoDataSourse |
|
AvtoQuery |
AvtoDataSourse |
|
|
|
VoditeliQuery |
VoditeliDataSourse |
|
|
|
|
|
Repo2Query |
Repo2DataSourse |
ADOConnection1 |
GruziQuery |
GruziiDataSourse |
|
|
|
|
|
PwdQuery |
PwdDataSourse |
|
MarchrutiQuery |
MarshrutiDataSourse |
|
|
|
ReysQuery |
ReysDataSourse |
DataSourse2 |
CheckEditQuery |
|
|
|
Reys2Query |
Reys2DataSourse |
|
|
3.3 – |
|
|
29
ChechEditQuery DataSourse2 |
|
|
. PwdQuery |
PwdDataSourse |
. |
ADOConnecton |
|
. Query |
|
. |
|
3.4 |
, |
|
« |
, |
|
|
|
|
|
» |
3.4 [17-18]. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
К
<
К
3.4 –
30
|
|
|
. |
|
|
. |
|
|
|
, |
|
, |
. |
« |
» |
|
|
, |
|
|
. |
, |
|
|
|
. |
|
|
, |
|
. |
3.5
Delphi 7 |
Access. |
|
|
Gruzoperevozki.mdb |
|
Project.exe. |
Gruzoperevozki.mdb |
– |
. Project.exe |
– |
|
|
. |
|
: |
Intel Pentium 233 |
|
, |
|
Microsoft Windows |
XP, Windows 2000, Windows 98, |
||
|
32 |
, |
|
75-160 |
. |
|
|
|
|
Project.exe. |
|
|
|
|
|
. |
|
Gruzoperevozki.mdb. |
|
|
, |
|
|
|
. |
|
: |
, |
. |
. |
|
|
111, |
222. |
|
|
|
|
. |
|
|
|
|
|
|
, |
|
: |
, |
, |
, |
|
. |
|
|
|
31 |
|
|