Π Π°Π·ΡΠ°Π±ΠΎΡΠΊΠ° Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ Π΄Π»Ρ ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ
ΠΡΡ ΠΎΠ΄Ρ ΠΈΠ· Π·Π°Π΄Π°Π½ΠΈΡ Π½Π° ΠΊΡΡΡΠΎΠ²ΠΎΠΉ ΠΏΡΠΎΠ΅ΠΊΡ ΡΡΠ°Π²ΠΈΡΡΡ Π·Π°Π΄Π°ΡΠ° ΡΠ°Π·ΡΠ°Π±ΠΎΡΠ°ΡΡ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ΠΈ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π΄Π»Ρ ΠΎΠ±ΡΠ°Π±ΠΎΡΠΊΠΈ Π΄Π°Π½Π½ΡΡ Π΄Π»Ρ ΠΊΠΎΠ½ΠΊΡΠ΅ΡΠ½ΠΎΠΉ ΠΏΡΠ΅Π΄ΠΌΠ΅ΡΠ½ΠΎΠΉ ΠΎΠ±Π»Π°ΡΡΠΈ. ΠΡΠΏΠΎΠ»Π½ΡΡ ΠΊΡΡΡΠΎΠ²ΠΎΠΉ ΠΏΡΠΎΠ΅ΠΊΡ, ΡΡΡΠ΄Π΅Π½Ρ ΡΡΠΈΡΡΡ ΠΏΡΠΈΠΌΠ΅Π½ΡΡΡ Π·Π½Π°Π½ΠΈΡ ΠΏΠΎ Π±Π°Π·Π°ΠΌ Π΄Π°Π½Π½ΡΡ Π½Π° ΠΏΡΠ°ΠΊΡΠΈΠΊΠ΅, ΡΠ°Π±ΠΎΡΠ°ΡΡ ΡΠΎ ΡΠΏΠ΅ΡΠΈΠ°Π»ΡΠ½ΠΎΠΉ ΡΠ΅Ρ Π½ΠΈΡΠ΅ΡΠΊΠΎΠΉ ΠΈ ΡΠΏΡΠ°Π²ΠΎΡΠ½ΠΎΠΉ Π»ΠΈΡΠ΅ΡΠ°ΡΡΡΠΎΠΉ, ΡΠ°ΠΌΠΎΡΡΠΎΡΡΠ΅Π»ΡΠ½ΠΎ ΠΏΡΠΈΠ½ΠΈΠΌΠ°ΡΡ ΠΈ ΠΎΡΠ΅Π½ΠΈΠ²Π°ΡΡ ΠΊΠ°ΡΠ΅ΡΡΠ²ΠΎ ΠΏΡΠΈΠ½ΡΡΡΡ ΡΠ΅ΡΠ΅Π½ΠΈΠΉ. Case 9: InsertForm→ADOQuery1→SQL→Text… Π§ΠΈΡΠ°ΡΡ Π΅ΡΡ >
Π Π°Π·ΡΠ°Π±ΠΎΡΠΊΠ° Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ Π΄Π»Ρ ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ (ΡΠ΅ΡΠ΅ΡΠ°Ρ, ΠΊΡΡΡΠΎΠ²Π°Ρ, Π΄ΠΈΠΏΠ»ΠΎΠΌ, ΠΊΠΎΠ½ΡΡΠΎΠ»ΡΠ½Π°Ρ)
ΠΡΡ ΠΎΠ΄Ρ ΠΈΠ· Π·Π°Π΄Π°Π½ΠΈΡ Π½Π° ΠΊΡΡΡΠΎΠ²ΠΎΠΉ ΠΏΡΠΎΠ΅ΠΊΡ ΡΡΠ°Π²ΠΈΡΡΡ Π·Π°Π΄Π°ΡΠ° ΡΠ°Π·ΡΠ°Π±ΠΎΡΠ°ΡΡ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ΠΈ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π΄Π»Ρ ΠΎΠ±ΡΠ°Π±ΠΎΡΠΊΠΈ Π΄Π°Π½Π½ΡΡ Π΄Π»Ρ ΠΊΠΎΠ½ΠΊΡΠ΅ΡΠ½ΠΎΠΉ ΠΏΡΠ΅Π΄ΠΌΠ΅ΡΠ½ΠΎΠΉ ΠΎΠ±Π»Π°ΡΡΠΈ. ΠΡΠΏΠΎΠ»Π½ΡΡ ΠΊΡΡΡΠΎΠ²ΠΎΠΉ ΠΏΡΠΎΠ΅ΠΊΡ, ΡΡΡΠ΄Π΅Π½Ρ ΡΡΠΈΡΡΡ ΠΏΡΠΈΠΌΠ΅Π½ΡΡΡ Π·Π½Π°Π½ΠΈΡ ΠΏΠΎ Π±Π°Π·Π°ΠΌ Π΄Π°Π½Π½ΡΡ Π½Π° ΠΏΡΠ°ΠΊΡΠΈΠΊΠ΅, ΡΠ°Π±ΠΎΡΠ°ΡΡ ΡΠΎ ΡΠΏΠ΅ΡΠΈΠ°Π»ΡΠ½ΠΎΠΉ ΡΠ΅Ρ Π½ΠΈΡΠ΅ΡΠΊΠΎΠΉ ΠΈ ΡΠΏΡΠ°Π²ΠΎΡΠ½ΠΎΠΉ Π»ΠΈΡΠ΅ΡΠ°ΡΡΡΠΎΠΉ, ΡΠ°ΠΌΠΎΡΡΠΎΡΡΠ΅Π»ΡΠ½ΠΎ ΠΏΡΠΈΠ½ΠΈΠΌΠ°ΡΡ ΠΈ ΠΎΡΠ΅Π½ΠΈΠ²Π°ΡΡ ΠΊΠ°ΡΠ΅ΡΡΠ²ΠΎ ΠΏΡΠΈΠ½ΡΡΡΡ ΡΠ΅ΡΠ΅Π½ΠΈΠΉ.
ΠΡΠ°ΡΠΊΠΈΠΉ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π·Π°Π΄Π°Ρ ΠΊΡΡΡΠΎΠ²ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ°:
Π°) Π‘ΠΏΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°ΡΡ Π»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΡΡ ΠΈ ΡΠΈΠ·ΠΈΡΠ΅ΡΠΊΡΡ ΠΌΠΎΠ΄Π΅Π»Ρ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ;
Π±) Π Π΅Π°Π»ΠΈΠ·ΠΎΠ²Π°ΡΡ Π² Π‘Π£ΠΠ ΡΠΏΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°Π½Π½ΡΡ ΠΌΠΎΠ΄Π΅Π»Ρ;
Π²) Π‘ΠΎΠ·Π΄Π°ΡΡ ΠΊΠ»ΠΈΠ΅Π½ΡΡΠΊΠΎΠ΅ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΡ Π΄Π»Ρ ΡΠ°Π±ΠΎΡΡ Ρ ΡΠΎΠ·Π΄Π°Π½Π½ΠΎΠΉ Π±Π°Π·ΠΎΠΉ Π΄Π°Π½Π½ΡΡ .
1. ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅ ΠΏΡΠ΅Π΄ΠΌΠ΅ΡΠ½ΠΎΠΉ ΠΎΠ±Π»Π°ΡΡΠΈ.
ΠΠΎ Π·Π°Π΄Π°Π½ΠΈΡ Π½Π° ΠΊΡΡΡΠΎΠ²ΠΎΠΉ ΠΏΡΠΎΠ΅ΠΊΡ Π½Π΅ΠΎΠ±Ρ ΠΎΠ΄ΠΈΠΌΠΎ ΡΠΎΠ·Π΄Π°ΡΡ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ , Π° ΡΠ°ΠΊΠΆΠ΅ ΠΊΠ»ΠΈΠ΅Π½ΡΡΠΊΠΎΠ΅ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π΄Π»Ρ ΠΏΡΠ΅Π΄ΠΌΠ΅ΡΠ½ΠΎΠΉ ΠΎΠ±Π»Π°ΡΡΠΈ «ΠΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½Π°Ρ ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠ°Ρ ΡΡΠ°Π½ΡΠΈΡ»:
Π Π°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ ΠΌΠΎΠΆΠ½ΠΎ ΠΏΠΎΠ΄ΡΠ°Π·Π΄Π΅Π»ΠΈΡΡ Π½Π° Π²ΠΎΠ΄ΠΈΡΠ΅Π»Π΅ΠΉ ΠΏΠΎΠ΄Π²ΠΈΠΆΠ½ΠΎΠ³ΠΎ ΡΠΎΡΡΠ°Π²Π°, Π΄ΠΈΡΠΏΠ΅ΡΡΠ΅ΡΠΎΠ², ΡΠ΅ΠΌΠΎΠ½ΡΠ½ΠΈΠΊΠΎΠ² ΠΏΠΎΠ΄Π²ΠΈΠΆΠ½ΠΎΠ³ΠΎ ΡΠΎΡΡΠ°Π²Π°, ΠΏΡΡΠ΅ΠΉ, ΠΊΠ°ΡΡΠΈpΠΎΠ², ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΡΠ»ΡΠΆΠ±Ρ ΠΏΠΎΠ΄Π³ΠΎΡΠΎΠ²ΠΊΠΈ ΡΠΎΡΡΠ°Π²ΠΎΠ², ΡΠΏΡΠ°Π²ΠΎΡΠ½ΠΎΠΉ ΡΠ»ΡΠΆΠ±Ρ ΠΈ Π΄pΡΠ³ΠΈΡ , ΠΊΠΎΡΠΎpΡΠ΅ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡpΠ°ΡΠΈΠ²Π½ΠΎ ΠΎΡΠ½ΠΎΡΡΡΡΡ ΠΊΠ°ΠΆΠ΄ΡΠΉ ΠΊ ΡΠ²ΠΎΠ΅ΠΌΡ ΠΎΡΠ΄Π΅Π»Ρ. ΠΠ°ΠΆΠ΄Π°Ρ ΠΈΠ· ΠΏΠ΅ΡΠ΅ΡΠΈΡΠ»Π΅Π½Π½ΡΡ ΠΊΠ°ΡΠ΅Π³ΠΎΡΠΈΠΉ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΠΈΠΌΠ΅Π΅Ρ ΡΠ½ΠΈΠΊΠ°Π»ΡΠ½ΡΠ΅ Π°ΡΡΠΈΠ±ΡΡΡ-Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ, ΠΎΠΏΡΠ΅Π΄Π΅Π»ΡΠ΅ΠΌΡΠ΅ ΠΏΡΠΎΡΠ΅ΡΡΠΈΠΎΠ½Π°Π»ΡΠ½ΠΎΠΉ Π½Π°ΠΏΡΠ°Π²Π»Π΅Π½Π½ΠΎΡΡΡΡ. Π ΠΎΡΠ΄Π΅Π»Π°Ρ ΡΡΡΠ΅ΡΡΠ²ΡΠ΅Ρ pΠ°Π·Π±ΠΈΠ΅Π½ΠΈΠ΅ pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² Π½Π° Π±pΠΈΠ³Π°Π΄Ρ. ΠΡΠ΄Π΅Π»Ρ Π²ΠΎΠ·Π³Π»Π°Π²Π»ΡΡΡΡΡ Π½Π°ΡΠ°Π»ΡΠ½ΠΈΠΊΠ°ΠΌΠΈ, ΠΊΠΎΡΠΎpΡΠ΅ ΠΏpΠ΅Π΄ΡΡΠ°Π²Π»ΡΡΡ ΡΠΎΠ±ΠΎΠΉ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡpΠ°ΡΠΈΡ ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ. Π ΡΡΠ½ΠΊΡΠΈΠΈ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡpΠ°ΡΠΈΠΈ Π²Ρ ΠΎΠ΄ΠΈΡ ΠΏΠ»Π°Π½ΠΈpΠΎΠ²Π°Π½ΠΈΠ΅ ΠΌΠ°ΡΡΡΡΡΠΎΠ², ΡΠΎΡΡΠ°Π²Π»Π΅Π½ΠΈΠ΅ pΠ°ΡΠΏΠΈΡΠ°Π½ΠΈΠΉ, ΡΠΎpΠΌΠΈpΠΎΠ²Π°Π½ΠΈΠ΅ ΠΊΠ°Π΄pΠΎΠ²ΠΎΠ³ΠΎ ΡΠΎΡΡΠ°Π²Π° ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ. ΠΠ° ΠΊΠ°ΠΆΠ΄ΡΠΌ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠΌ Π·Π°ΠΊpΠ΅ΠΏΠ»ΡΠ΅ΡΡΡ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Π½Π°Ρ Π±pΠΈΠ³Π°Π΄Π°. ΠΠ° Π½Π΅ΡΠΊΠΎΠ»ΡΠΊΠΈΠΌΠΈ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Π°ΠΌΠΈ Π·Π°ΠΊΡΠ΅ΠΏΠ»ΡΠ΅ΡΡΡ Π±pΠΈΠ³Π°Π΄Π° ΡΠ΅Ρ Π½ΠΈΠΊΠΎΠ²-ΡΠ΅ΠΌΠΎΠ½ΡΠ½ΠΈΠΊΠΎΠ², Π²ΡΠΏΠΎΠ»Π½ΡΡΡΠ°Ρ ΡΠ΅ΠΉΡΠΎΠ²ΡΠΉ ΠΈ ΠΏΠ»Π°Π½ΠΎΠ²ΡΠΉ ΡΠ΅Ρ ΠΎΡΠΌΠΎΡΡ (ΠΏΠΎ ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΠΎΠΌΡ Π³ΡΠ°ΡΠΈΠΊΡ), ΡΠ΅ΠΌΠΎΠ½Ρ, ΡΠ΅Ρ Π½ΠΈΡΠ΅ΡΠΊΠΎΠ΅ ΠΎΠ±ΡΠ»ΡΠΆΠΈΠ²Π°Π½ΠΈΠ΅. ΠΠΎΠ΄ΠΈΡΠ΅Π»ΠΈ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ² ΠΎΠ±ΡΠ·ΡΠ½Ρ ΠΏpΠΎΡ ΠΎΠ΄ΠΈΡΡ ΠΊΠ°ΠΆΠ΄ΡΠΉ Π³ΠΎΠ΄ ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡp, Π½Π΅ ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡp Π½Π΅ΠΎΠ±Ρ ΠΎΠ΄ΠΈΠΌΠΎ ΠΏΠ΅pΠ΅Π²Π΅ΡΡΠΈ Π½Π° Π΄pΡΠ³ΡΡ pΠ°Π±ΠΎΡΡ. ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ² Π΄ΠΎΠ»ΠΆΠ΅Π½ ΡΠ²ΠΎΠ΅Π²pΠ΅ΠΌΠ΅Π½Π½ΠΎ ΠΎΡΠΌΠ°ΡpΠΈΠ²Π°ΡΡΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠ°ΠΌΠΈ-ΡΠ΅ΠΌΠΎΠ½ΡΠΈΠΊΠ°ΠΌΠΈ ΠΈ ΠΏpΠΈ Π½Π΅ΠΎΠ±Ρ ΠΎΠ΄ΠΈΠΌΠΎΡΡΠΈ pΠ΅ΠΌΠΎΠ½ΡΠΈpΠΎΠ²Π°ΡΡΡΡ. ΠΠΎΠ΄Π³ΠΎΡΠΎΠ²ΠΊΠ° ΠΊ pΠ΅ΠΉΡΡ Π²ΠΊΠ»ΡΡΠ°Π΅Ρ Π² ΡΠ΅Π±Ρ ΡΠ΅Ρ Π½ΠΈΡΠ΅ΡΠΊΡΡ ΡΠ°ΡΡΡ (ΡΠ΅ΠΉΡΠΎΠ²ΡΠΉ ΡΠ΅Ρ ΠΎΡΠΌΠΎΡΡ, ΠΌΠ΅Π»ΠΊΠΈΠΉ ΡΠ΅ΠΌΠΎΠ½Ρ) ΠΈ ΠΎΠ±ΡΠ»ΡΠΆΠΈΠ²Π°ΡΡΡΡ ΡΠ°ΡΡΡ (ΡΠ±ΠΎpΠΊΠ° Π²Π°Π³ΠΎΠ½ΠΎΠ², Π·Π°ΠΏΠ°Ρ ΠΏΡΠΎΠ΄ΡΠΊΡΠΎΠ² ΠΏΠΈΡΠ°Π½ΠΈΡ ΠΈ Ρ. ΠΏ.).
Π pΠ°ΡΠΏΠΈΡΠ°Π½ΠΈΠΈ ΡΠΊΠ°Π·ΡΠ²Π°Π΅ΡΡΡ ΡΠΈΠΏ ΠΏΠΎΠ΅Π·Π΄Π° (ΡΠΊΠΎΡΡΠΉ, ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠΈΠΉ…), Π½ΠΎΠΌΠ΅Ρ ΠΏΠΎΠ΅Π·Π΄Π°, Π΄Π½ΠΈ ΠΈ Π²ΡΠ΅ΠΌΡ ΠΎΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΡ ΠΈ ΠΏΡΠΈΠ±ΡΡΠΈΡ, ΠΌΠ°ΡΡΡΡΡ (Π½Π°ΡΠ°Π»ΡΠ½ΡΠΉ ΠΈ ΠΊΠΎΠ½Π΅ΡΠ½ΡΠΉ ΠΏΡΠ½ΠΊΡΡ Π½Π°Π·Π½Π°ΡΠ΅Π½ΠΈΡ, ΠΎΡΠ½ΠΎΠ²Π½ΡΠ΅ ΡΠ·Π»ΠΎΠ²ΡΠ΅ ΡΡΠ°Π½ΡΠΈΠΈ), ΡΡΠΎΠΈΠΌΠΎΡΡΡ Π±ΠΈΠ»Π΅ΡΠ°. ΠΠΈΠ»Π΅ΡΡ Π½Π° ΠΏΠΎΠ΅Π·Π΄ ΠΌΠΎΠΆΠ½ΠΎ ΠΏpΠΈΠΎΠ±pΠ΅ΡΡΠΈ Π·Π°pΠ°Π½Π΅Π΅ ΠΈΠ»ΠΈ Π·Π°Π±pΠΎΠ½ΠΈpΠΎΠ²Π°ΡΡ Π² ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΡΡ ΠΊΠ°ΡΡΠ°Ρ . ΠΠΎ ΠΎΡΠΏpΠ°Π²Π»Π΅Π½ΠΈΡ ΠΏΠΎΠ΅Π·Π΄Π°, Π΅ΡΠ»ΠΈ Π΅ΡΡΡ Π½Π΅ΠΎΠ±Ρ ΠΎΠ΄ΠΈΠΌΠΎΡΡΡ, Π±ΠΈΠ»Π΅Ρ ΠΌΠΎΠΆΠ½ΠΎ Π²Π΅pΠ½ΡΡΡ. ΠΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΠΈΠ΅ ΠΏΠΎΠ΅Π·Π΄ΠΎΠ² ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ Π·Π°Π΄Π΅pΠΆΠ°Π½ΠΎ ΠΈΠ·-Π·Π° ΠΎΠΏΠΎΠ·Π΄Π°Π½ΠΈΠΉ ΠΏΠΎΠ΅Π·Π΄ΠΎΠ², ΠΏΠΎΠ³ΠΎΠ΄Π½ΡΡ ΡΡΠ»ΠΎΠ²ΠΈΠΉ, ΡΠ΅Ρ Π½ΠΈΡΠ΅ΡΠΊΠΈΡ Π½Π΅ΠΏΠΎΠ»Π°Π΄ΠΎΠΊ.
ΠΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΡΠ΅ ΠΌΠ°ΡΡΡΡΡΡ ΠΌΠΎΠΆΠ½ΠΎ pΠ°Π·Π΄Π΅Π»ΠΈΡΡ Π½Π° ΡΠ»Π΅Π΄ΡΡΡΠΈΠ΅ ΠΊΠ°ΡΠ΅Π³ΠΎpΠΈΠΈ: Π²Π½ΡΡpΠ΅Π½Π½ΠΈΠ΅, ΠΌΠ΅ΠΆΠ΄ΡΠ½Π°pΠΎΠ΄Π½ΡΠ΅, ΡΡΡΠΈΡΡΠΈΡΠ΅ΡΠΊΠΈΠ΅, ΡΠΏΠ΅ΡΠΈΠ°Π»ΡΠ½ΡΠ΅ ΠΌΠ°ΡΡΡΡΡΡ. ΠΠ°ΡΡΠ°ΠΆΠΈpΡ ΠΌΠΎΠ³ΡΡ ΡΠ΄Π°Π²Π°ΡΡ ΡΠ²ΠΎΠΈ Π²Π΅ΡΠΈ Π² Π±Π°Π³Π°ΠΆΠ½ΠΎΠ΅ ΠΎΡΠ΄Π΅Π»Π΅Π½ΠΈΠ΅.
ΠΠΈΠ΄Ρ Π·Π°ΠΏΡΠΎΡΠΎΠ²:
1. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π²ΡΠ΅Ρ pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ, Π½Π°ΡΠ°Π»ΡΠ½ΠΈΠΊΠΎΠ² ΠΎΡΠ΄Π΅Π»ΠΎΠ², pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠ³ΠΎ ΠΎΡΠ΄Π΅Π»Π°, ΠΏΠΎ ΡΡΠ°ΠΆΡ pΠ°Π±ΠΎΡΡ Π½Π° ΡΡΠ°Π½ΡΠΈΠΈ, ΠΏΠΎΠ»ΠΎΠ²ΠΎΠΌΡ ΠΏpΠΈΠ·Π½Π°ΠΊΡ, Π²ΠΎΠ·pΠ°ΡΡΡ, ΠΏpΠΈΠ·Π½Π°ΠΊΡ Π½Π°Π»ΠΈΡΠΈΡ ΠΈ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²Π° Π΄Π΅ΡΠ΅ΠΉ, pΠ°Π·ΠΌΠ΅pΡ Π·Π°pΠ°Π±ΠΎΡΠ½ΠΎΠΉ ΠΏΠ»Π°ΡΡ.
2. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² Π² Π±pΠΈΠ³Π°Π΄Π΅, ΠΏΠΎ Π²ΡΠ΅ΠΌ ΠΎΡΠ΄Π΅Π»Π°ΠΌ, Π² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ ΠΎΡΠ΄Π΅Π»Π΅, ΠΎΠ±ΡΠ»ΡΠΆΠΈΠ²Π°ΡΡΠΈΡ Π½Π΅ΠΊΠΎΡΠΎΡΡΠΉ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ², ΠΏΠΎ Π²ΠΎΠ·pΠ°ΡΡΡ, ΡΡΠΌΠΌΠ°pΠ½ΠΎΠΉ (ΡpΠ΅Π΄Π½Π΅ΠΉ) Π·Π°pΠΏΠ»Π°ΡΠ΅ Π² Π±pΠΈΠ³Π°Π΄Π΅.
3. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π²ΠΎΠ΄ΠΈΡΠ΅Π»Π΅ΠΉ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡp Π»ΠΈΠ±ΠΎ Π½Π΅ ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡp Π² ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ Π³ΠΎΠ΄, ΠΏΠΎ ΠΏΠΎΠ»ΠΎΠ²ΠΎΠΌΡ ΠΏpΠΈΠ·Π½Π°ΠΊΡ, Π²ΠΎΠ·pΠ°ΡΡΡ, pΠ°Π·ΠΌΠ΅pΡ Π·Π°pΠ°Π±ΠΎΡΠ½ΠΎΠΉ ΠΏΠ»Π°ΡΡ.
4. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΏΡΠΈΠΏΠΈΡΠ°Π½Π½ΡΡ ΠΊ ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ, Π½Π°Ρ ΠΎΠ΄ΡΡΠΈΡ ΡΡ Π½Π° Π½Π΅ΠΉ Π² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠ΅ Π²pΠ΅ΠΌΡ, ΠΏΠΎ Π²pΠ΅ΠΌΠ΅Π½ΠΈ ΠΏΡΠΈΠ±ΡΡΠΈΡ Π½Π° ΡΡΠ°Π½ΡΠΈΠΈ, ΠΏΠΎ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²Ρ ΡΠΎΠ²Π΅pΡΠ΅Π½Π½ΡΡ ΠΌΠ°ΡΡΡΡΡΠΎΠ².
5. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΏΠ»Π°Π½ΠΎΠ²ΡΠΉ ΡΠ΅Ρ ΠΎΡΠΌΠΎΡp Π·Π° ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΡΠΉ ΠΏΠ΅pΠΈΠΎΠ΄ Π²pΠ΅ΠΌΠ΅Π½ΠΈ, ΠΎΡΠΏpΠ°Π²Π»Π΅Π½Π½ΡΡ Π² pΠ΅ΠΌΠΎΠ½Ρ Π² ΠΎΠ±ΠΎΠ·Π½Π°ΡΠ΅Π½Π½ΠΎΠ΅ Π²pΠ΅ΠΌΡ, pΠ΅ΠΌΠΎΠ½ΡΠΈpΠΎΠ²Π°Π½Π½ΡΡ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠ΅ ΡΠΈΡΠ»ΠΎ pΠ°Π·, ΠΏΠΎ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²Ρ ΡΠΎΠ²Π΅pΡΠ΅Π½Π½ΡΡ ΡΠ΅ΠΉΡΠΎΠ² Π΄ΠΎ pΠ΅ΠΌΠΎΠ½ΡΠ°, ΠΏΠΎ Π²ΠΎΠ·pΠ°ΡΡΡ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Π°.
6. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΏΠΎΠ΅Π·Π΄ΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ ΠΌΠ°pΡpΡΡΠ΅, ΠΏΠΎ Π΄Π»ΠΈΡΠ΅Π»ΡΠ½ΠΎΡΡΠΈ ΠΌΠ°ΡΡΡΡΡΠ°, ΠΏΠΎ ΡΠ΅Π½Π΅ Π±ΠΈΠ»Π΅ΡΠ° ΠΈ ΠΏΠΎ Π²ΡΠ΅ΠΌ ΡΡΠΈΠΌ ΠΊpΠΈΡΠ΅pΠΈΡΠΌ ΡpΠ°Π·Ρ.
7. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΎΡΠΌΠ΅Π½Π΅Π½Π½ΡΡ pΠ΅ΠΉΡΠΎΠ² ΠΏΠΎΠ»Π½ΠΎΡΡΡΡ, Π² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ Π½Π°ΠΏpΠ°Π²Π»Π΅Π½ΠΈΠΈ, ΠΏΠΎ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌΡ ΠΌΠ°pΡpΡΡΡ.
8. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π·Π°Π΄Π΅pΠΆΠ°Π½Π½ΡΡ pΠ΅ΠΉΡΠΎΠ² ΠΏΠΎΠ»Π½ΠΎΡΡΡΡ, ΠΏΠΎ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΉ ΠΏpΠΈΡΠΈΠ½Π΅, ΠΏΠΎ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌΡ ΠΌΠ°pΡpΡΡΡ, ΠΈ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π·Π° Π²pΠ΅ΠΌΡ Π·Π°Π΄Π΅pΠΆΠΊΠΈ.
9. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΡpΠ΅Π΄Π½Π΅Π΅ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΠΏpΠΎΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π·Π° ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ ΠΈΠ½ΡΠ΅ΡΠ²Π°Π» Π²ΡΠ΅ΠΌΠ΅Π½ΠΈ Π½Π° ΠΎΠΏpΠ΅Π΄Π΅Π»Π΅Π½Π½ΡΠ΅ ΠΌΠ°pΡpΡΡΡ, ΠΏΠΎ Π΄Π»ΠΈΡΠ΅Π»ΡΠ½ΠΎΡΡΠΈ ΠΌΠ°ΡΡΡΡΡΠ°, ΠΏΠΎ ΡΠ΅Π½Π΅ Π±ΠΈΠ»Π΅ΡΠ°.
10. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΌΠ°ΡΡΡΡΡΠΎΠ² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΉ ΠΊΠ°ΡΠ΅Π³ΠΎpΠΈΠΈ, ΡΠ»Π΅Π΄ΡΡΡΠΈΡ Π² ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΠΎΠΌ Π½Π°ΠΏpΠ°Π²Π»Π΅Π½ΠΈΠΈ.
11. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΏΠ°ΡΡΠ°ΠΆΠΈpΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ pΠ΅ΠΉΡΠ΅, ΡΠ΅Ρ Π°Π²ΡΠΈΡ Π² ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ Π΄Π΅Π½Ρ, ΡΠ΅Ρ Π°Π²ΡΠΈΡ Π·Π° Π³pΠ°Π½ΠΈΡΡ Π² ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ Π΄Π΅Π½Ρ, ΠΏΠΎ ΠΏpΠΈΠ·Π½Π°ΠΊΡ ΡΠ΄Π°ΡΠΈ Π²Π΅ΡΠ΅ΠΉ Π² Π±Π°Π³Π°ΠΆΠ½ΠΎΠ΅ ΠΎΡΠ΄Π΅Π»Π΅Π½ΠΈΠ΅, ΠΏΠΎ ΠΏΠΎΠ»ΠΎΠ²ΠΎΠΌΡ ΠΏpΠΈΠ·Π½Π°ΠΊΡ, ΠΏΠΎ Π²ΠΎΠ·pΠ°ΡΡΡ.
12. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π½Π΅Π²ΡΠΊΡΠΏΠ»Π΅Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ pΠ΅ΠΉΡ, Π΄Π΅Π½Ρ, Π½Π΅ΠΊΠΎΡΠΎΡΡΠΉ ΠΌΠ°pΡpΡΡ.
13. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ pΠ΅ΠΉΡ, Π΄Π΅Π½Ρ, ΠΌΠ°pΡpΡΡ.
2. Π‘ΠΎΠ·Π΄Π°Π½ΠΈΠ΅ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ΠΈ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΡ ΠΎΠ±ΡΠ°Π±ΠΎΡΠΊΠΈ Π΄Π°Π½Π½ΡΡ .
2.1 ΠΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΎΠ΅ ΠΏΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ .
Π»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΈΠΉ Π±Π°Π·Π° ΠΊΠ»ΠΈΠ΅Π½ΡΡΠΊΠΈΠΉ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ ΠΡΠ΄Π΅Π»ΠΈΠΌ ΡΡΡΠ½ΠΎΡΡΠΈ ΠΈ ΠΈΡ Π°ΡΡΠΈΠ±ΡΡΡ Π² Π·Π°Π΄Π°Π½Π½ΠΎΠΉ ΠΏΡΠ΅Π΄ΠΌΠ΅ΡΠ½ΠΎΠΉ ΠΎΠ±Π»Π°ΡΡΠΈ:
— Π Π°Π±ΠΎΡΠ½ΠΈΠΊ (Π€.Π.Π., ΡΠΈΠΏ, ΡΡΠ°ΠΆ, ΠΏΠΎΠ», Π²ΠΎΠ·ΡΠ°ΡΡ, Π΄Π΅ΡΠΈ, Π·/ΠΏ, Π΄Π°ΡΠ° ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡΡΠ°, Π½ΠΎΠΌΠ΅Ρ ΠΎΡΠ΄Π΅Π»Π°, Π½ΠΎΠΌΠ΅Ρ Π±ΡΠΈΠ³Π°Π΄Ρ);
— ΠΡΠ΄Π΅Π» (Π½Π°Π·Π²Π°Π½ΠΈΠ΅ ΠΎΡΠ΄Π΅Π»Π°, Π€.Π.Π. Π½Π°ΡΠ°Π»ΡΠ½ΠΈΠΊΠ° ΠΎΡΠ΄Π΅Π»Π°);
— ΠΡΠΈΠ³Π°Π΄Π° (ΡΠΈΠΏ Π±ΡΠΈΠ³Π°Π΄Ρ, Π½ΠΎΠΌΠ΅Ρ ΠΎΡΠ΄Π΅Π»Π°);
— ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ² (Π΄Π°ΡΠ° ΠΏΠΎΡΠ»Π΅Π΄Π½Π΅Π³ΠΎ ΡΠ΅Ρ ΠΎΡΠΌΠΎΡΡΠ°, Π΄Π°ΡΠ° ΠΏΠΎΡΠ»Π΅Π΄Π½Π΅Π³ΠΎ ΡΠ΅ΠΌΠΎΠ½ΡΠ°, ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ°Π· ΡΠ΅ΠΌΠΎΠ½ΡΠ°, ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΅ΠΉΡΠΎΠ², Π²ΠΎΠ·ΡΠ°ΡΡ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Π°);
— Π Π°ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅ (Π½ΠΎΠΌΠ΅Ρ ΡΠ΅ΠΉΡΠ°, Π½ΠΎΠΌΠ΅Ρ ΠΏΠΎΠ΅Π·Π΄Π°, ΡΠΈΠΏ ΠΏΠΎΠ΅Π·Π΄Π°, Π΄Π°ΡΠ° ΠΈ Π²ΡΠ΅ΠΌΡ ΠΎΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΡ, Π΄Π°ΡΠ° ΠΈ Π²ΡΠ΅ΠΌΡ ΠΏΡΠΈΠ±ΡΡΠΈΡ, Π½Π°ΡΠ°Π»ΡΠ½ΡΠΉ ΠΏΡΠ½ΠΊΡ, ΠΊΠΎΠ½Π΅ΡΠ½ΡΠΉ ΠΏΡΠ½ΠΊΡ, ΡΡΠΎΠΈΠΌΠΎΡΡΡ Π±ΠΈΠ»Π΅ΡΠ°, ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ Π±ΠΈΠ»Π΅ΡΠΎΠ², Π΄Π»ΠΈΡΠ΅Π»ΡΠ½ΠΎΡΡΡ ΠΌΠ°ΡΡΡΡΡΠ°);
— ΠΡΠΌΠ΅Π½Π΅Π½Π½ΡΠΉ ΡΠ΅ΠΉΡ (ΠΏΡΠΈΡΠΈΠ½Π° ΠΎΡΠΌΠ΅Π½Ρ);
— ΠΠ°Π΄Π΅ΡΠΆΠ°Π½Π½ΡΠΉ ΡΠ΅ΠΉΡ (ΠΏΡΠΈΡΠΈΠ½Π° Π·Π°Π΄Π΅ΡΠΆΠΊΠΈ, Π²ΡΠ΅ΠΌΡ Π·Π°Π΄Π΅ΡΠΆΠΊΠΈ, ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ²);
— ΠΠΈΠ»Π΅Ρ (Π½ΠΎΠΌΠ΅Ρ Π±ΠΈΠ»Π΅ΡΠ°, Π½ΠΎΠΌΠ΅Ρ ΡΠ΅ΠΉΡΠ°, ΡΡΠ°ΡΡΡ Π±ΠΈΠ»Π΅ΡΠ°, ΡΠΈΠΏ Π±ΠΈΠ»Π΅ΡΠ°, Π²ΡΠ΅ΠΌΡ ΠΏΠΎΠΊΡΠΏΠΊΠΈ, Π€.Π.Π. Π²Π»Π°Π΄Π΅Π»ΡΡΠ° ΠΊΡΠΏΠ»Π΅Π½Π½ΠΎΠ³ΠΎ Π±ΠΈΠ»Π΅ΡΠ°, ΠΏΠΎΠ» Π²Π»Π°Π΄Π΅Π»ΡΡΠ°, Π²ΠΎΠ·ΡΠ°ΡΡ Π²Π»Π°Π΄Π΅Π»ΡΡΠ°, Π½ΠΎΠΌΠ΅Ρ Π±Π°Π³Π°ΠΆΠ° Π²Π»Π°Π΄Π΅Π»ΡΡΠ°).
ΠΠ±ΡΠ°Π·ΡΠ΅ΠΌ ΡΠ²ΡΠ·ΠΈ ΠΈ ΠΎΡΠ½ΠΎΡΠ΅Π½ΠΈΡ ΠΌΠ΅ΠΆΠ΄Ρ ΡΡΡΠ½ΠΎΡΡΡΠΌΠΈ.
1) Π Π°Π±ΠΎΡΠ½ΠΈΠΊ-ΠΡΠ΄Π΅Π». Π‘Π²ΡΠ·Ρ ΠΌΠ½ΠΎΠ³ΠΈΠ΅-ΠΊ-ΠΎΠ΄Π½ΠΎΠΌΡ. ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² Π² ΠΎΡΠ΄Π΅Π»Π΅ ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ Π½Π΅ΠΎΠ³ΡΠ°Π½ΠΈΡΠ΅Π½Π½ΡΠΌ, Π° ΠΎΡΠ΄Π΅Π» Ρ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠ° ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ ΠΎΠ΄ΠΈΠ½.
2) ΠΡΠ΄Π΅Π»-ΠΡΠΈΠ³Π°Π΄Π°. Π‘Π²ΡΠ·Ρ ΠΎΠ΄ΠΈΠ½-ΠΊΠΎ-ΠΌΠ½ΠΎΠ³ΠΈΠΌ. ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ Π±ΡΠΈΠ³Π°Π΄ Π² ΠΎΡΠ΄Π΅Π»Π΅ ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ Π½Π΅ΠΎΠ³ΡΠ°Π½ΠΈΡΠ΅Π½Π½ΠΎ, Π° Π±ΡΠΈΠ³Π°Π΄Π° ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ ΡΠΎΠ»ΡΠΊΠΎ Π² ΠΎΠ΄Π½ΠΎΠΌ ΠΎΡΠ΄Π΅Π»Π΅.
3) ΠΡΠΈΠ³Π°Π΄Π°-ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ². Π‘Π²ΡΠ·Ρ ΠΌΠ½ΠΎΠ³ΠΈΠ΅-ΠΊΠΎ-ΠΌΠ½ΠΎΠ³ΠΈΠΌ. ΠΠ΄Π½Π° Π±ΡΠΈΠ³Π°Π΄Π° ΠΌΠΎΠΆΠ΅Ρ ΠΎΠ±ΡΠ»ΡΠΆΠΈΠ²Π°ΡΡ Π½Π΅ΡΠΊΠΎΠ»ΡΠΊΠΎ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΈ ΠΎΠ΄ΠΈΠ½ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ² ΠΌΠΎΠΆΠ΅Ρ ΠΎΠ±ΡΠ»ΡΠΆΠΈΠ²Π°ΡΡ Π½Π΅ΡΠΊΠΎΠ»ΡΠΊΠΎ Π±ΡΠΈΠ³Π°Π΄.
4) ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²-Π Π°ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅. Π‘Π²ΡΠ·Ρ ΠΌΠ½ΠΎΠ³ΠΈΠ΅-ΠΊΠΎ-ΠΌΠ½ΠΎΠ³ΠΈΠΌ. ΠΠ΄ΠΈΠ½ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ² ΠΌΠΎΠΆΠ΅Ρ Π½Π΅ΡΠΊΠΎΠ»ΡΠΊΠΎ ΡΠ°Π· Π²ΡΡΡΠ΅ΡΠ°ΡΡΡΡ Π² ΠΏΡΠ½ΠΊΡΠ°Ρ ΡΠ°ΡΠΏΠΈΡΠ°Π½ΠΈΡ. Π Π² ΠΎΠ΄Π½ΠΎΠΌ ΡΠ°ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅ ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ Π·Π°Π΄Π΅ΠΉΡΡΠ²ΠΎΠ²Π°Π½ΠΎ ΠΌΠ½ΠΎΠ³ΠΎ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ².
5) Π Π°ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅-ΠΠΈΠ»Π΅Ρ. Π‘Π²ΡΠ·Ρ ΠΎΠ΄ΠΈΠ½-ΠΊΠΎ-ΠΌΠ½ΠΎΠ³ΠΈΠΌ. Π£ ΠΎΠ΄Π½ΠΎΠ³ΠΎ ΠΏΡΠ½ΠΊΡΠ° ΡΠ°ΡΠΏΠΈΡΠ°Π½ΠΈΡ ΠΌΠΎΠΆΠ΅Ρ Π±ΡΡΡ Π½Π΅ΡΠΊΠΎΠ»ΡΠΊΠΎ Π±ΠΈΠ»Π΅ΡΠΎΠ².
ΠΠ° ΠΎΡΠ½ΠΎΠ²Π΅ ΠΎΠΏΠΈΡΠ°Π½ΠΈΠΈ ΡΠ²ΡΠ·Π΅ΠΉ ΠΈ ΠΎΡΠ½ΠΎΡΠ΅Π½ΠΈΠΉ ΠΌΠ΅ΠΆΠ΄Ρ ΡΡΡΠ½ΠΎΡΡΡΠΌΠΈ ΠΏΠΎΡΡΡΠΎΠΈΠΌ Π»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΡΡ ΠΌΠΎΠ΄Π΅Π»Ρ. (ΡΠΌ. Π ΠΈΡ2).
Π ΠΈΡ2. ΠΠΎΠ³ΠΈΡΠ΅ΡΠΊΠ°Ρ ΠΌΠΎΠ΄Π΅Π»Ρ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ .
ΠΡΠ΄Π΅Π»ΠΈΠΌ Π²Π½Π΅ΡΠ½ΠΈΠ΅ ΠΊΠ»ΡΡΠΈ ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΡΡ ΠΎΡΠ½ΠΎΡΠ΅Π½ΠΈΠΉ:
1) Id_otdela — ΠΠ½Π΅ΡΠ½ΠΈΠΉ ΠΊΠ»ΡΡ Π΄Π»Ρ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ ΡΠ²ΡΠ·ΠΈ — Π Π°Π±ΠΎΡΠ½ΠΈΠΊ-ΠΡΠ΄Π΅Π».
2) Id_otd — Π²Π½Π΅ΡΠ½ΠΈΠΉ ΠΊΠ»ΡΡ Π΄Π»Ρ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ ΡΠ²ΡΠ·ΠΈ ΠΡΠΈΠ³Π°Π΄Π°-ΠΡΠ΄Π΅Π».
3) Id_brig, id_lok — Π²Π½Π΅ΡΠ½ΠΈΠ΅ ΠΊΠ»ΡΡΠΈ Π΄Π»Ρ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ ΡΠ²ΡΠ·ΠΈ ΠΡΠΈΠ³Π°Π΄Π°-ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ².
4) Id_r, id_lok — Π²Π½Π΅ΡΠ½ΠΈΠ΅ ΠΊΠ»ΡΡΠΈ Π΄Π»Ρ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ ΡΠ²ΡΠ·ΠΈ ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²-Π Π°ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅.
5) Id_r — Π²Π½Π΅ΡΠ½ΠΈΠΉ ΠΊΠ»ΡΡ Π΄Π»Ρ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ ΡΠ²ΡΠ·ΠΈ Π Π°ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅-ΠΠΈΠ»Π΅Ρ ΠΠ° ΠΎΡΠ½ΠΎΠ²Π΅ ΠΎΠΏΠΈΡΠ°Π½Π½ΡΡ ΡΡΡΠ½ΠΎΡΡΠ΅ΠΉ ΠΈ ΠΎΡΠ½ΠΎΡΠ΅Π½ΠΈΠΉ ΠΌΠ΅ΠΆΠ΄Ρ Π½ΠΈΠΌΠΈ ΠΏΠΎΡΡΡΠΎΠΈΠΌ ΡΠ΅Π»ΡΡΠΈΠΎΠ½Π½ΡΡ ΠΌΠΎΠ΄Π΅Π»Ρ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ Π΄Π»Ρ Π‘Π£ΠΠ MySQL (ΡΠΌ. Π ΠΈΡ3). ΠΠΎΠ΄ ΡΠΎΠ·Π΄Π°Π½ΠΈΡ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ΠΌΠΎΠ΄Π½ΠΎ ΠΏΠΎΡΠΌΠΎΡΡΠ΅ΡΡ Π² «ΠΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠΈ Π».
Π ΠΈΡ3. Π Π΅Π»ΡΡΠΈΠΎΠ½Π½Π°Ρ ΠΌΠΎΠ΄Π΅Π»Ρ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ .
2.2 ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ.
ΠΠ»ΠΈΠ΅Π½ΡΡΠΊΠΎΠ΅ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠ°Π½ΠΎ Π΄Π»Ρ ΠΎΠ±ΡΠ°Π±ΠΎΡΠΊΠΈ ΠΊΠΎΠ½ΠΊΡΠ΅ΡΠ½ΠΎΠΉ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ΠΏΡΠ΅Π΄ΠΌΠ΅ΡΠ½ΠΎΠΉ ΠΎΠ±Π»Π°ΡΡΠΈ «ΠΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½Π°Ρ ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠ°Ρ ΡΡΠ°Π½ΡΠΈΡ».
ΠΠ°Π½Π½ΠΎΠ΅ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ ΠΈΠΌΠ΅Π΅Ρ ΡΠ»Π΅Π΄ΡΡΡΠΈΠ΅ ΡΡΠ½ΠΊΡΠΈΠΈ:
— ΠΡΠΎΡΠΌΠΎΡΡ Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ;
— ΠΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠ΅ Π΄Π°Π½Π½ΡΡ Π² Π±Π°Π·Ρ;
— Π Π΅Π΄Π°ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ ΡΠΆΠ΅ ΠΈΠΌΠ΅ΡΡΠΈΡ ΡΡ Π΄Π°Π½Π½ΡΡ Π² Π±Π°Π·Π΅;
— Π£Π΄Π°Π»Π΅Π½ΠΈΠ΅ Π΄Π°Π½Π½ΡΡ ΠΈΠ· Π±Π°Π·Ρ.
Π’Π°ΠΊΠΆΠ΅ ΡΠ΅Π°Π»ΠΈΠ·ΠΎΠ²Π°Π½Ρ ΡΠ»Π΅Π΄ΡΡΡΠΈΠ΅ Π·Π°ΠΏΡΠΎΡΡ, ΠΏΠΎΠ·Π²ΠΎΠ»ΡΡΡΠΈΠ΅ ΡΡΡΠ΅ΠΊΡΠΈΠ²Π½ΠΎ ΠΈΡΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΡ Π΄Π°Π½Π½ΡΠ΅:
1. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π²ΡΠ΅Ρ pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ, Π½Π°ΡΠ°Π»ΡΠ½ΠΈΠΊΠΎΠ² ΠΎΡΠ΄Π΅Π»ΠΎΠ², pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠ³ΠΎ ΠΎΡΠ΄Π΅Π»Π°, ΠΏΠΎ ΡΡΠ°ΠΆΡ pΠ°Π±ΠΎΡΡ Π½Π° ΡΡΠ°Π½ΡΠΈΠΈ, ΠΏΠΎΠ»ΠΎΠ²ΠΎΠΌΡ ΠΏpΠΈΠ·Π½Π°ΠΊΡ, Π²ΠΎΠ·pΠ°ΡΡΡ, ΠΏpΠΈΠ·Π½Π°ΠΊΡ Π½Π°Π»ΠΈΡΠΈΡ ΠΈ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²Π° Π΄Π΅ΡΠ΅ΠΉ, pΠ°Π·ΠΌΠ΅pΡ Π·Π°pΠ°Π±ΠΎΡΠ½ΠΎΠΉ ΠΏΠ»Π°ΡΡ.
2. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ pΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² Π² Π±pΠΈΠ³Π°Π΄Π΅, ΠΏΠΎ Π²ΡΠ΅ΠΌ ΠΎΡΠ΄Π΅Π»Π°ΠΌ, Π² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ ΠΎΡΠ΄Π΅Π»Π΅, ΠΎΠ±ΡΠ»ΡΠΆΠΈΠ²Π°ΡΡΠΈΡ Π½Π΅ΠΊΠΎΡΠΎΡΡΠΉ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ², ΠΏΠΎ Π²ΠΎΠ·pΠ°ΡΡΡ, ΡΡΠΌΠΌΠ°pΠ½ΠΎΠΉ (ΡpΠ΅Π΄Π½Π΅ΠΉ) Π·Π°pΠΏΠ»Π°ΡΠ΅ Π² Π±pΠΈΠ³Π°Π΄Π΅.
3. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π²ΠΎΠ΄ΠΈΡΠ΅Π»Π΅ΠΉ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡp Π»ΠΈΠ±ΠΎ Π½Π΅ ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΌΠ΅Π΄ΠΎΡΠΌΠΎΡp Π² ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ Π³ΠΎΠ΄, ΠΏΠΎ ΠΏΠΎΠ»ΠΎΠ²ΠΎΠΌΡ ΠΏpΠΈΠ·Π½Π°ΠΊΡ, Π²ΠΎΠ·pΠ°ΡΡΡ, pΠ°Π·ΠΌΠ΅pΡ Π·Π°pΠ°Π±ΠΎΡΠ½ΠΎΠΉ ΠΏΠ»Π°ΡΡ.
4. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΏΡΠΈΠΏΠΈΡΠ°Π½Π½ΡΡ ΠΊ ΠΆΠ΅Π»Π΅Π·Π½ΠΎΠ΄ΠΎΡΠΎΠΆΠ½ΠΎΠΉ ΡΡΠ°Π½ΡΠΈΠΈ, Π½Π°Ρ ΠΎΠ΄ΡΡΠΈΡ ΡΡ Π½Π° Π½Π΅ΠΉ Π² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠ΅ Π²pΠ΅ΠΌΡ, ΠΏΠΎ Π²pΠ΅ΠΌΠ΅Π½ΠΈ ΠΏΡΠΈΠ±ΡΡΠΈΡ Π½Π° ΡΡΠ°Π½ΡΠΈΠΈ, ΠΏΠΎ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²Ρ ΡΠΎΠ²Π΅pΡΠ΅Π½Π½ΡΡ ΠΌΠ°ΡΡΡΡΡΠΎΠ².
5. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ², ΠΏpΠΎΡΠ΅Π΄ΡΠΈΡ ΠΏΠ»Π°Π½ΠΎΠ²ΡΠΉ ΡΠ΅Ρ ΠΎΡΠΌΠΎΡp Π·Π° ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΡΠΉ ΠΏΠ΅pΠΈΠΎΠ΄ Π²pΠ΅ΠΌΠ΅Π½ΠΈ, ΠΎΡΠΏpΠ°Π²Π»Π΅Π½Π½ΡΡ Π² pΠ΅ΠΌΠΎΠ½Ρ Π² ΠΎΠ±ΠΎΠ·Π½Π°ΡΠ΅Π½Π½ΠΎΠ΅ Π²pΠ΅ΠΌΡ, pΠ΅ΠΌΠΎΠ½ΡΠΈpΠΎΠ²Π°Π½Π½ΡΡ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠ΅ ΡΠΈΡΠ»ΠΎ pΠ°Π·, ΠΏΠΎ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²Ρ ΡΠΎΠ²Π΅pΡΠ΅Π½Π½ΡΡ ΡΠ΅ΠΉΡΠΎΠ² Π΄ΠΎ pΠ΅ΠΌΠΎΠ½ΡΠ°, ΠΏΠΎ Π²ΠΎΠ·pΠ°ΡΡΡ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Π°.
6. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΏΠΎΠ΅Π·Π΄ΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ ΠΌΠ°pΡpΡΡΠ΅, ΠΏΠΎ Π΄Π»ΠΈΡΠ΅Π»ΡΠ½ΠΎΡΡΠΈ ΠΌΠ°ΡΡΡΡΡΠ°, ΠΏΠΎ ΡΠ΅Π½Π΅ Π±ΠΈΠ»Π΅ΡΠ° ΠΈ ΠΏΠΎ Π²ΡΠ΅ΠΌ ΡΡΠΈΠΌ ΠΊpΠΈΡΠ΅pΠΈΡΠΌ ΡpΠ°Π·Ρ.
7. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΎΡΠΌΠ΅Π½Π΅Π½Π½ΡΡ pΠ΅ΠΉΡΠΎΠ² ΠΏΠΎΠ»Π½ΠΎΡΡΡΡ, Π² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ Π½Π°ΠΏpΠ°Π²Π»Π΅Π½ΠΈΠΈ, ΠΏΠΎ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌΡ ΠΌΠ°pΡpΡΡΡ.
8. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π·Π°Π΄Π΅pΠΆΠ°Π½Π½ΡΡ pΠ΅ΠΉΡΠΎΠ² ΠΏΠΎΠ»Π½ΠΎΡΡΡΡ, ΠΏΠΎ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΉ ΠΏpΠΈΡΠΈΠ½Π΅, ΠΏΠΎ ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌΡ ΠΌΠ°pΡpΡΡΡ, ΠΈ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π·Π° Π²pΠ΅ΠΌΡ Π·Π°Π΄Π΅pΠΆΠΊΠΈ.
9. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΡpΠ΅Π΄Π½Π΅Π΅ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΠΏpΠΎΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π·Π° ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ ΠΈΠ½ΡΠ΅ΡΠ²Π°Π» Π²ΡΠ΅ΠΌΠ΅Π½ΠΈ Π½Π° ΠΎΠΏpΠ΅Π΄Π΅Π»Π΅Π½Π½ΡΠ΅ ΠΌΠ°pΡpΡΡΡ, ΠΏΠΎ Π΄Π»ΠΈΡΠ΅Π»ΡΠ½ΠΎΡΡΠΈ ΠΌΠ°ΡΡΡΡΡΠ°, ΠΏΠΎ ΡΠ΅Π½Π΅ Π±ΠΈΠ»Π΅ΡΠ°.
10. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΌΠ°ΡΡΡΡΡΠΎΠ² ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΉ ΠΊΠ°ΡΠ΅Π³ΠΎpΠΈΠΈ, ΡΠ»Π΅Π΄ΡΡΡΠΈΡ Π² ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΠΎΠΌ Π½Π°ΠΏpΠ°Π²Π»Π΅Π½ΠΈΠΈ.
11. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΠΏΠ°ΡΡΠ°ΠΆΠΈpΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ pΠ΅ΠΉΡΠ΅, ΡΠ΅Ρ Π°Π²ΡΠΈΡ Π² ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ Π΄Π΅Π½Ρ, ΡΠ΅Ρ Π°Π²ΡΠΈΡ Π·Π° Π³pΠ°Π½ΠΈΡΡ Π² ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ Π΄Π΅Π½Ρ, ΠΏΠΎ ΠΏpΠΈΠ·Π½Π°ΠΊΡ ΡΠ΄Π°ΡΠΈ Π²Π΅ΡΠ΅ΠΉ Π² Π±Π°Π³Π°ΠΆΠ½ΠΎΠ΅ ΠΎΡΠ΄Π΅Π»Π΅Π½ΠΈΠ΅, ΠΏΠΎ ΠΏΠΎΠ»ΠΎΠ²ΠΎΠΌΡ ΠΏpΠΈΠ·Π½Π°ΠΊΡ, ΠΏΠΎ Π²ΠΎΠ·pΠ°ΡΡΡ.
12. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ Π½Π΅Π²ΡΠΊΡΠΏΠ»Π΅Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΠΎΠΌ pΠ΅ΠΉΡ, Π΄Π΅Π½Ρ, Π½Π΅ΠΊΠΎΡΠΎΡΡΠΉ ΠΌΠ°pΡpΡΡ.
13. ΠΠΎΠ»ΡΡΠΈΡΡ ΠΎΠ±ΡΠ΅Π΅ ΡΠΈΡΠ»ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² Π½Π° ΡΠΊΠ°Π·Π°Π½Π½ΡΠΉ pΠ΅ΠΉΡ, Π΄Π΅Π½Ρ, ΠΌΠ°pΡpΡΡ.
Π ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ ΡΠ΅Π°Π»ΠΈΠ·ΠΎΠ²Π°Π½ ΠΏΡΠΎΡΠΌΠΎΡΡ ΠΊΠ°ΠΆΠ΄ΠΎΠΉ ΡΠ°Π±Π»ΠΈΡΡ Ρ ΠΏΠΎΠΌΠΎΡΡΡ ΠΊΠ½ΠΎΠΏΠΎΠΊ, ΡΠΎΠΎΡΠ²Π΅ΡΡΡΠ²ΡΡΡΠΈΡ Π½Π°Π·Π²Π°Π½ΠΈΡΠΌ ΡΠ°Π±Π»ΠΈΡΡ. (ΡΠΌ. Π ΠΈΡ4).
Π ΠΈΡ4. ΠΠ»Π°Π²Π½ΠΎΠ΅ ΠΎΠΊΠ½ΠΎ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΡ.
Π’Π°ΠΊΠΆΠ΅ ΠΎΡΠ³Π°Π½ΠΈΠ·ΠΎΠ²Π°Π½Π½ΠΎ ΠΌΠ΅Π½Ρ Π΄Π»Ρ ΡΠ΄ΠΎΠ±ΡΡΠ²Π° ΠΈΡΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°Π½ΠΈΡ Π·Π°ΠΏΡΠΎΡΠΎΠ² (ΡΠΌ. Π ΠΈΡ5, Π ΠΈΡ6).
Π ΠΈΡ5. ΠΡΠΏΠ°Π΄Π°ΡΡΠ΅Π΅ ΠΌΠ΅Π½Ρ Π΄Π»Ρ Π²ΡΠ±ΠΎΡΠ° Π½ΡΠΆΠ½ΠΎΠ³ΠΎ Π·Π°ΠΏΡΠΎΡΠ°.
Π ΠΈΡ. 6. ΠΠΊΠ½ΠΎ Π΄Π»Ρ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π·Π°ΠΏΡΠΎΡΠ°, Π²ΡΠ±ΡΠ°Π½Π½ΠΎΠ³ΠΎ Π² ΠΌΠ΅Π½Ρ Π³Π»Π°Π²Π½ΠΎΠ³ΠΎ ΠΎΠΊΠ½Π°.
2.3 Π’Π΅ΡΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ.
ΠΡΠΈ ΡΠ΅ΡΡΠΈΡΠΎΠ²Π°Π½ΠΈΠΈ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ ΠΌΡ ΠΏΡΠΎΠ²Π΅ΡΠΈΠ»ΠΈ Π΅Π΅ ΡΠ°Π±ΠΎΡΠΎΡΠΏΠΎΡΠΎΠ±Π½ΠΎΡΡΡ ΠΈ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΠ΅ ΡΠ»Π΅Π΄ΡΡΡΠΈΠΉ ΡΡΠ½ΠΊΡΠΈΠΉ:
a) ΠΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠ΅ Π΄Π°Π½Π½ΡΡ Π² Π±Π°Π·Ρ. (Π ΠΈΡ7).
Π ΠΈΡ7. ΠΠΎΠ±Π°Π²Π»Π΅Π½ΠΈΠ΅ Π½ΠΎΠ²ΠΎΠ³ΠΎ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠ°.
b) Π Π΅Π΄Π°ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ Π΄Π°Π½Π½ΡΡ Π² Π±Π°Π·Π΅. (Π ΠΈΡ. 8).
Π ΠΈΡ. 8. ΠΠ·ΠΌΠ΅Π½Π΅Π½ΠΈΠ΅ ΡΡΠ°ΡΡΡΠ° Π±ΠΈΠ»Π΅ΡΠ°.
c) Π£Π΄Π°Π»Π΅Π½ΠΈΠ΅ Π΄Π°Π½Π½ΡΡ ΠΈΠ· Π±Π°Π·Ρ. (Π ΠΈΡ. 9).
Π ΠΈΡ. 9. Π£Π΄Π°Π»Π΅Π½ΠΈΠ΅ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠ°.
d) ΠΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΠ΅ Π·Π°ΠΏΡΠΎΡΠΎΠ². (Π ΠΈΡ10, 11, 12).
Π ΠΈΡ10. ΠΠΎΠΊΠ°Π·Π°Π½Ρ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Ρ, ΠΎΡΠΏΡΠ°Π²Π»Π΅Π½Π½ΡΠ΅ Π½Π° ΡΠ΅ΠΌΠΎΠ½Ρ Π² Π·Π°Π΄Π°Π½Π½ΡΠΉ Π΄Π΅Π½Ρ.
Π ΠΈΡ11. ΠΠΎΠΊΠ°Π·Π°Π½Π½ΠΎ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ² ΠΏΠΎ Π·Π°Π΄Π°Π½Π½ΠΎΠΌΡ ΠΌΠ°ΡΡΡΡΡΡ.
Π ΠΈΡ12. ΠΠΎΠΊΠ°Π·Π°Π½Ρ Π²ΡΠ΅ Π·Π°Π΄Π΅ΡΠΆΠ°Π½Π½ΡΠ΅ ΡΠ΅ΠΉΡΡ ΠΏΠΎ Π·Π°Π΄Π°Π½Π½ΠΎΠΉ ΠΏΡΠΈΡΠΈΠ½Π΅.
ΠΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π.
ΠΠΈΡΡΠΈΠ½Π³ ΡΠΊΡΠΈΠΏΡΠ° Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ .
Π»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΈΠΉ Π±Π°Π·Π° ΠΊΠ»ΠΈΠ΅Π½ΡΡΠΊΠΈΠΉ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅.
# SQL Manager 2010 for MySQL 4.5.0.9.
# ;
# Host: localhost.
# Port: 3306.
# Database: zd_21var_db.
/*! 40 101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*! 40 101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*! 40 101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*! 40 101 SET NAMES utf8 */;
SET FOREIGN_KEY_CHECKS=0;
CREATE DATABASE `zd_21var_db`.
CHARACTER SET 'cp1251'.
COLLATE 'cp1251_general_ci';
USE `zd_21var_db`;
#.
# Structure for the `raspisanie` table:
#.
CREATE TABLE `raspisanie` (.
`id_r` int (11) NOT NULL AUTO_INCREMENT,.
`nomer_poezd` int (11) DEFAULT NULL,.
`type_poezd` varchar (30) DEFAULT NULL,.
`otprav` datetime DEFAULT NULL,.
`prib` datetime DEFAULT NULL,.
`marshrut_nach` varchar (30) DEFAULT NULL,.
`marshrut_kon` char (20) DEFAULT NULL,.
`stoim_bilet` int (11) DEFAULT NULL,.
`kol_bilet` int (11) DEFAULT NULL,.
`vremya_marsh` int (11) DEFAULT NULL,.
PRIMARY KEY (`id_r`),.
UNIQUE KEY `id_r` (`id_r`).
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
#.
# Structure for the `bileti` table:
#.
CREATE TABLE `bileti` (.
`id_bil` bigint (20) NOT NULL AUTO_INCREMENT,.
`status_bil` varchar (30) DEFAULT NULL,.
`type_bil` varchar (20) DEFAULT NULL,.
`vrem_buy` time DEFAULT NULL,.
`fio_owner` varchar (20) DEFAULT NULL,.
`sex` varchar (3) DEFAULT NULL,.
`age_ow` int (11) DEFAULT NULL,.
`nomer_bagazh` int (11) DEFAULT NULL,.
`id_r` int (11) NOT NULL,.
PRIMARY KEY (`id_bil`,`id_r`),.
UNIQUE KEY `id_bil` (`id_bil`),.
KEY `Relationship8` (`id_r`),.
CONSTRAINT `Relationship8` FOREIGN KEY (`id_r`) REFERENCES `raspisanie` (`id_r`) ON DELETE NO ACTION ON UPDATE NO ACTION.
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
#.
# Structure for the `log` table:
#.
CREATE TABLE `log` (.
`log` varchar (20) DEFAULT NULL.
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#.
# Structure for the `lokomotivi` table:
#.
CREATE TABLE `lokomotivi` (.
`id_lok` int (11) NOT NULL AUTO_INCREMENT,.
`date_teh_osm` date DEFAULT NULL,.
`date_remont_last` date DEFAULT NULL,.
`kol_remont` int (11) DEFAULT NULL,.
`kol_reis` int (11) DEFAULT NULL,.
`age_lok` int (11) DEFAULT NULL,.
PRIMARY KEY (`id_lok`),.
UNIQUE KEY `id_lok` (`id_lok`).
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
#.
# Structure for the `otdeli` table:
#.
CREATE TABLE `otdeli` (.
`id_otd` int (11) NOT NULL AUTO_INCREMENT,.
`fio_nach_otd` varchar (30) DEFAULT NULL,.
`name_otd` varchar (30) DEFAULT NULL,.
PRIMARY KEY (`id_otd`),.
UNIQUE KEY `id_otd` (`id_otd`).
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
#.
# Structure for the `teh_brigad` table:
#.
CREATE TABLE `teh_brigad` (.
`id_brig` int (11) NOT NULL AUTO_INCREMENT,.
`type_brigad` varchar (30) DEFAULT NULL,.
`id_otd` int (11) NOT NULL,.
`sred_zp` int (11) DEFAULT NULL,.
PRIMARY KEY (`id_brig`),.
UNIQUE KEY `id_brig` (`id_brig`),.
KEY `id_otd` (`id_otd`),.
CONSTRAINT `teh_brigad_fk` FOREIGN KEY (`id_otd`) REFERENCES `otdeli` (`id_otd`) ON DELETE CASCADE ON UPDATE CASCADE.
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
#.
# Structure for the `lokomotivi_teh_brigad` table:
#.
CREATE TABLE `lokomotivi_teh_brigad` (.
`id_lok` int (11) NOT NULL,.
`id_brig` int (11) NOT NULL,.
PRIMARY KEY (`id_lok`,`id_brig`),.
KEY `Relationship6_Teh_brigad` (`id_brig`),.
CONSTRAINT `Relationship6_Lokomotivi` FOREIGN KEY (`id_lok`) REFERENCES `lokomotivi` (`id_lok`) ON DELETE NO ACTION ON UPDATE NO ACTION,.
CONSTRAINT `Relationship6_Teh_brigad` FOREIGN KEY (`id_brig`) REFERENCES `teh_brigad` (`id_brig`) ON DELETE NO ACTION ON UPDATE NO ACTION.
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#.
# Structure for the `otmen_reis` table:
#.
CREATE TABLE `otmen_reis` (.
`prichina_otmen` varchar (20) DEFAULT NULL,.
`id_r` int (11) NOT NULL,.
PRIMARY KEY (`id_r`),.
CONSTRAINT `Raspisanie_Otmen_reis` FOREIGN KEY (`id_r`) REFERENCES `raspisanie` (`id_r`) ON DELETE NO ACTION ON UPDATE NO ACTION.
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#.
# Structure for the `rabotniki` table:
#.
CREATE TABLE `rabotniki` (.
`id_rab` int (11) NOT NULL AUTO_INCREMENT,.
`fio` varchar (30) DEFAULT NULL,.
`type` varchar (30) DEFAULT NULL,.
`stazh` int (11) DEFAULT NULL,.
`sex` varchar (2) DEFAULT NULL,.
`age` int (4) DEFAULT NULL,.
`deti` int (11) DEFAULT NULL,.
`zar_pl` int (11) DEFAULT NULL,.
`date_med` date DEFAULT NULL,.
`id_otd` int (11) NOT NULL,.
`id_br` int (11) DEFAULT NULL,.
PRIMARY KEY (`id_rab`),.
UNIQUE KEY `id_rab` (`id_rab`),.
KEY `id_otd` (`id_otd`),.
CONSTRAINT `rabotniki_fk` FOREIGN KEY (`id_otd`) REFERENCES `otdeli` (`id_otd`).
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
CREATE DEFINER = 'root'@'localhost' TRIGGER `sred_zp_update` AFTER INSERT ON `rabotniki`.
FOR EACH ROW.
BEGIN.
DECLARE idbr INT (255);
DECLARE zp INT (255);
DECLARE srzp INT (255);
select `rabotniki`.`id_br`, `rabotniki`.`zar_pl` into idbr, zp from `rabotniki` where id_rab = NEW. id_rab;
select AVG (`rabotniki`.`zar_pl`) into srzp from `rabotniki` where `rabotniki`.`id_br` = idbr;
UPDATE `teh_brigad` SET `teh_brigad`.`sred_zp` = srzp where `teh_brigad`.`id_brig` = idbr;
INSERT INTO `log` VALUES («nhbut»);
END;
CREATE DEFINER = 'root'@'localhost' TRIGGER `rabotniki_after_upd_tr` AFTER UPDATE ON `rabotniki`.
FOR EACH ROW.
BEGIN.
DECLARE idbr INT (255);
DECLARE zp INT (255);
DECLARE srzp INT (255);
select `rabotniki`.`id_br`, `rabotniki`.`zar_pl` into idbr, zp from `rabotniki` where id_rab = NEW. id_rab;
select AVG (`rabotniki`.`zar_pl`) into srzp from `rabotniki` where `rabotniki`.`id_br` = idbr;
UPDATE `teh_brigad` SET `teh_brigad`.`sred_zp` = srzp where `teh_brigad`.`id_brig` = idbr;
INSERT INTO `log` VALUES («nhbut»);
END;
#.
# Structure for the `raspisanie_lokomotivi` table:
#.
CREATE TABLE `raspisanie_lokomotivi` (.
`id_r` int (11) NOT NULL,.
`id_lok` int (11) NOT NULL,.
PRIMARY KEY (`id_r`,`id_lok`),.
KEY `Relationship7_Lokomotivi` (`id_lok`),.
CONSTRAINT `Relationship7_Lokomotivi` FOREIGN KEY (`id_lok`) REFERENCES `lokomotivi` (`id_lok`) ON DELETE NO ACTION ON UPDATE NO ACTION,.
CONSTRAINT `Relationship7_Raspisanie` FOREIGN KEY (`id_r`) REFERENCES `raspisanie` (`id_r`) ON DELETE NO ACTION ON UPDATE NO ACTION.
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#.
# Structure for the `zaredzh_reis` table:
#.
CREATE TABLE `zaredzh_reis` (.
`prichina_zad` varchar (30) DEFAULT NULL,.
`vremya_zad` varchar (30) DEFAULT NULL,.
`kol_sdan_bilet` int (11) DEFAULT NULL,.
`id_r` int (11) NOT NULL,.
PRIMARY KEY (`id_r`),.
CONSTRAINT `Raspisanie_Zaredzh_reis` FOREIGN KEY (`id_r`) REFERENCES `raspisanie` (`id_r`) ON DELETE NO ACTION ON UPDATE NO ACTION.
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#.
# Definition for the `new_proc` procedure:
#.
CREATE DEFINER = 'root'@'localhost' PROCEDURE `new_proc`(.
IN param1 DATETIME,.
IN param2 DATETIME.
).
NOT DETERMINISTIC.
CONTAINS SQL.
SQL SECURITY DEFINER.
COMMENT ''.
BEGIN.
select raspisanie. otprav, `raspisanie`.prib into param1, param2 from raspisanie;
update raspisanie set raspisanie.`vremya_marsh` = param2 — param1 where raspisanie. otprav = param1;
insert into log values (param2 — param1);
END;
#.
# Data for the `raspisanie` table (LIMIT 0,500).
#.
INSERT INTO `raspisanie` (`id_r`, `nomer_poezd`, `type_poezd`, `otprav`, `prib`, `marshrut_nach`, `marshrut_kon`, `stoim_bilet`, `kol_bilet`, `vremya_marsh`) VALUES.
(1,1,'ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠΈΠΉ ΡΠΊΠΎΡΡΠΉ', '2011;01−01 00:00:00', '2011;01−01 00:00:00', 'ΠΠ°ΡΠ½Π°ΡΠ»', 'ΠΠΎΠ²ΠΎΡΠΈΠ±ΠΈΡΡΠΊ', 400,120,12),.
(2,2,'ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΡΠΊΠΈΠΉ', '2012;02−02 12:30:00', '2012;02−05 15:30:00', 'ΠΠ°ΡΠ½Π°ΡΠ»', 'ΠΡΡΠ°Π½Π°', 4000,100,72),.
(5,3,'Π³ΡΡΠ·ΠΎΠ²ΠΎΠΉ', '2011;02−01 06:00:00', '2011;02−06 16:35:00', 'ΠΠ»Π°Π΄ΠΈΠ²ΠΎΡΡΠΎΠΊ', 'ΠΡΠ°ΡΠ½ΠΎΡΡΡΠΊ', NULL, NULL, 120),.
(6,4,'Π³ΡΡΠ·ΠΎΠ²ΠΎΠΉ', '2011;12−21 00:00:00', '2011;12−28 00:00:00', 'ΠΠΎΡΠΊΠ²Π°', 'Π ΠΈΠ³Π°', NULL, NULL, 168);
COMMIT;
#.
# Data for the `bileti` table (LIMIT 0,500).
#.
INSERT INTO `bileti` (`id_bil`, `status_bil`, `type_bil`, `vrem_buy`, `fio_owner`, `sex`, `age_ow`, `nomer_bagazh`, `id_r`) VALUES.
(1,'ΡΠ΄Π°Π½', 'ΠΌΠ΅ΠΆΠ³ΠΎΡΠΎΠ΄', '12:32:00', 'ΠΠ²Π°Π½ΠΎΠ²', 'ΠΌ', 19,25 486,1),.
(2,'ΡΠ΄Π°Π½', 'ΠΌΠ΅ΠΆΠ³ΠΎΡΠΎΠ΄', '12:32:00', 'ΠΠ΅ΡΡΠΎΠ²', 'ΠΌ', 56, NULL, 1),.
(3,'ΡΠ΄Π°Π½', 'ΡΠ°ΠΌΠΎΠΆΠ½Ρ', '15:56:00', 'Π Π°Π΄ΠΎΠ½Π΅ΠΆΡΠΊΠΈΠΉ', 'ΠΌ', 41, NULL, 2),.
(4,'Π½Π΅Π²ΡΠΊΡΠΏΠ»Π΅Π½', 'ΠΌΠ΅ΠΆΠ³ΠΎΡΠΎΠ΄', NULL, NULL, NULL, NULL, NULL, 1),.
(5,'Π½Π΅Π²ΡΠΊΡΠΏΠ»Π΅Π½', 'ΡΠ°ΠΌΠΎΠΆΠ½Ρ', NULL, NULL, NULL, NULL, NULL, 2);
COMMIT;
#.
# Data for the `log` table (LIMIT 0,500).
#.
INSERT INTO `log` (`log`) VALUES.
('nhbut'),.
('nhbut'),.
('nhbut'),.
('nhbut'),.
('nhbut'),.
('nhbut'),.
('nhbut'),.
('nhbut');
COMMIT;
#.
# Data for the `lokomotivi` table (LIMIT 0,500).
#.
INSERT INTO `lokomotivi` (`id_lok`, `date_teh_osm`, `date_remont_last`, `kol_remont`, `kol_reis`, `age_lok`) VALUES.
(1,'2010;02−25', NULL, NULL, 14,2),.
(2,'2011;12−04', '2011;12−01', 4,25,3);
COMMIT;
#.
# Data for the `otdeli` table (LIMIT 0,500).
#.
INSERT INTO `otdeli` (`id_otd`, `fio_nach_otd`, `name_otd`) VALUES.
(1,'ΠΠ²Π°Π½ΠΎΠ²', 'Π Π΅ΠΌΠΎΠ½ΡΠ½ΡΠΉ'),.
(2,'Π‘Π΅ΠΌΡΠΎΠ²', 'ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΡΠΉ');
COMMIT;
#.
# Data for the `teh_brigad` table (LIMIT 0,500).
#.
INSERT INTO `teh_brigad` (`id_brig`, `type_brigad`, `id_otd`, `sred_zp`) VALUES.
(1,'Π Π΅ΠΌΠΎΠ½ΡΠ½ΠΈΠΊΠΈ ΡΠΎΡΡΠ°Π²Π°', 1,17 000),.
(2,'ΠΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Π½Π°Ρ', 2,18 750);
COMMIT;
#.
# Data for the `lokomotivi_teh_brigad` table (LIMIT 0,500).
#.
INSERT INTO `lokomotivi_teh_brigad` (`id_lok`, `id_brig`) VALUES.
(1,2),.
(2,1);
COMMIT;
#.
# Data for the `otmen_reis` table (LIMIT 0,500).
#.
INSERT INTO `otmen_reis` (`prichina_otmen`, `id_r`) VALUES.
('ΠΠΎΠ³ΠΎΠ΄Π½ΡΠ΅ ΡΡΠ»ΠΎΠ²ΠΈΡ', 5),.
('Π’Π°ΠΌΠΎΠΆΠ½Ρ', 6);
COMMIT;
#.
# Data for the `rabotniki` table (LIMIT 0,500).
#.
INSERT INTO `rabotniki` (`id_rab`, `fio`, `type`, `stazh`, `sex`, `age`, `deti`, `zar_pl`, `date_med`, `id_otd`, `id_br`) VALUES.
(1,'ΠΠ²Π°Π½ΠΎΠ²', 'Π°Π΄ΠΌΠΈΠ½ΠΈΡΡΡΠ°ΡΠΈΡ', 20,'ΠΌ', 40,2,50 000, NULL, 1, NULL),.
(2,'ΠΠ΅ΡΡΠΎΠ²', 'Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 12,'ΠΌ', 42,1,18 000,'2011;02−25', 2,2),.
(3,'Π‘Π΅ΠΌΠ΅Π½ΠΎΠ²', 'ΡΠ΅ΠΌΠΎΠ½ΡΠ½ΠΈΠΊ ΡΠΎΡΡΠ°Π²Π°', 15,'ΠΌ', 45,1,17 000,'2010;03−22', 1,1),.
(4,'Π‘Π΅ΠΌΡΠΎΠ²', 'Π°Π΄ΠΌΠΈΠ½ΠΈΡΡΡΠ°ΡΠΈΡ', 25,'ΠΌ', 50,1,20 000, NULL, 2, NULL),.
(8,'Π’ΡΡΠΊΠΈΠ½Π°', 'Π΄ΠΈΡΠΏΠ΅ΡΡΠ΅Ρ', 22,'ΠΆ', 42,1,21 000, NULL, 2,2),.
(9,'ΠΠ΅Π΄ΠΈΠ½', 'Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 22,'ΠΌ', 42, NULL, 24 000,'2010;02−25', 2,2),.
(10,'Π‘ΠΈΠ΄ΠΎΡΠΎΠ²', 'Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 15,'ΠΌ', 35,1,12 000,'2011;02−25', 2,2);
COMMIT;
#.
# Data for the `raspisanie_lokomotivi` table (LIMIT 0,500).
#.
INSERT INTO `raspisanie_lokomotivi` (`id_r`, `id_lok`) VALUES.
(1,2);
COMMIT;
#.
# Data for the `zaredzh_reis` table (LIMIT 0,500).
#.
INSERT INTO `zaredzh_reis` (`prichina_zad`, `vremya_zad`, `kol_sdan_bilet`, `id_r`) VALUES.
('Π’Π°ΠΌΠΎΠΆΠ½Ρ', '3', 1,1),.
('ΠΠΎΠ³ΠΎΠ΄Π°', '1', 0,2);
COMMIT;
ΠΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π.
ΠΠΈΡΡΠΈΠ½Π³ ΠΊΠΎΠ΄Π° ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ.
Unit1.h.
// ;
#ifndef Unit1H.
#define Unit1H.
// ;
#include.
#include.
#include.
#include.
#include.
#include.
#include.
#include.
#include.
#include.
#include.
#include.
// ;
class TForm1: public TForm.
{.
__published: // IDE-managed Components.
TADOConnection *ADOConnection1;
TADOQuery *ADOQuery1;
TDataSource *DataSource1;
TDBGrid *DBGrid1;
TMainMenu *MainMenu1;
TMenuItem *N1;
TMenuItem *N2;
TMenuItem *N3;
TMenuItem *N4;
TMenuItem *N5;
TDBNavigator *DBNavigator1;
TMenuItem *N6;
TMenuItem *N7;
TMenuItem *N8;
TMenuItem *N9;
TMenuItem *N10;
TMenuItem *N11;
TMenuItem *N12;
TMenuItem *N13;
TMenuItem *N14;
TMenuItem *N15;
TButton *Button1;
TButton *Button2;
TButton *Button3;
TButton *Button4;
TButton *Button5;
TButton *Button6;
TButton *Button7;
TButton *Button8;
TButton *Button9;
TButton *Button10;
void __fastcall N5Click (TObject *Sender);
void __fastcall N2Click (TObject *Sender);
void __fastcall N3Click (TObject *Sender);
void __fastcall N4Click (TObject *Sender);
void __fastcall RadioButton1Click (TObject *Sender);
void __fastcall RadioButton2Click (TObject *Sender);
void __fastcall RadioButton3Click (TObject *Sender);
void __fastcall RadioButton4Click (TObject *Sender);
void __fastcall RadioButton5Click (TObject *Sender);
void __fastcall RadioButton6Click (TObject *Sender);
void __fastcall RadioButton7Click (TObject *Sender);
void __fastcall RadioButton8Click (TObject *Sender);
void __fastcall RadioButton9Click (TObject *Sender);
void __fastcall RadioButton10Click (TObject *Sender);
void __fastcall N6Click (TObject *Sender);
void __fastcall N7Click (TObject *Sender);
void __fastcall N8Click (TObject *Sender);
void __fastcall N9Click (TObject *Sender);
void __fastcall N10Click (TObject *Sender);
void __fastcall N11Click (TObject *Sender);
void __fastcall N12Click (TObject *Sender);
void __fastcall N13Click (TObject *Sender);
void __fastcall N14Click (TObject *Sender);
void __fastcall N15Click (TObject *Sender);
void __fastcall Button1Click (TObject *Sender);
void __fastcall Button3Click (TObject *Sender);
void __fastcall Button5Click (TObject *Sender);
void __fastcall Button7Click (TObject *Sender);
void __fastcall Button9Click (TObject *Sender);
void __fastcall Button2Click (TObject *Sender);
void __fastcall Button4Click (TObject *Sender);
void __fastcall Button6Click (TObject *Sender);
void __fastcall Button8Click (TObject *Sender);
void __fastcall Button10Click (TObject *Sender);
private: // User declarations.
public: // User declarations.
__fastcall TForm1 (TComponent* Owner);
};
// ;
extern PACKAGE TForm1 *Form1;
// ;
#endif.
Unit1.cpp.
// ;
#include.
#pragma hdrstop.
#include «Unit1.h».
#include «Unit2.cpp».
// ;
#pragma package (smart_init).
#pragma resource «*.dfm».
TForm1 *Form1;
AnsiString NameTable;
AnsiString DoneKey;
int keyMenu = 0;
String query = ««;
// ;
__fastcall TForm1: TForm1 (TComponent* Owner).
: TForm (Owner).
{.
}.
// ;
void __fastcall TForm1: N5Click (TObject *Sender).
{.
Application->Terminate ();
}.
// ;
void __fastcall TForm1: N2Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π²ΡΠ΅Ρ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ²»;
keyMenu = 1;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = true;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = true;
InsertForm->Button7->Visible = true;
InsertForm->Button1->Caption = «ΠΡΠ΅ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΈ ΠΆΠ΄»;
InsertForm->Button2->Caption = «ΠΠ°ΡΠ°Π»ΡΠ½ΠΈΠΊΠΈ ΠΎΡΠ΄Π΅Π»ΠΎΠ²»;
InsertForm->Button3->Caption = «Π Π°Π±ΠΎΡΠ½ΠΈΠΊΠΈ ΠΎΡΠ΄Π΅Π»Π°»;
InsertForm->Button4->Caption = «ΠΠΎ ΡΡΠ°ΠΆΡ»;
InsertForm->Button5->Caption = «ΠΠΎ ΠΏΠΎΠ». ΠΏΡΠΈΠ·Π½Π°ΠΊΡ»;
InsertForm->Button6->Caption = «ΠΠΎ Π½Π°Π»ΠΈΡΠΈΡ Π΄Π΅ΡΠ΅ΠΉ»;
InsertForm->Button7->Caption = «ΠΠΎ ΡΠ°Π·ΠΌΠ΅ΡΡ Π·/ΠΏ»;
InsertForm->Label1->Visible = false;
InsertForm->Label2->Visible = false;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = true;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = ««;
InsertForm->Label3->Caption = «ΠΠΎΠΌΠ΅Ρ =»;
InsertForm->Label4->Caption = «Π‘ΡΠ°ΠΆ =»;
InsertForm->Label5->Caption = «ΠΠΎΠ» =»;
InsertForm->Label6->Caption = «ΠΠΎΠ».Π΄Π΅Ρ=»;
InsertForm->Label7->Caption = «Π·/ΠΏ =»;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = false;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = true;
InsertForm->Edit7->Visible = true;
}.
// ;
void __fastcall TForm1: N3Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π²ΡΠ΅Ρ ΡΠ°Π±ΠΎΡΠ½ΠΈΠΊΠΎΠ² Π² Π±ΡΠΈΠ³Π°Π΄Π°Ρ »;
keyMenu = 2;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = true;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = true;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠ΅ ΡΠ°Π±ΠΎΡ. Π² Π±ΡΠΈΠ³Π°Π΄Π°Ρ »;
InsertForm->Button2->Caption = «Π Π°Π±ΠΎΡ. Π² Π±ΡΠΈΠ³ ΠΏΠΎ ΠΎΡΠ΄Π΅Π»»;
InsertForm->Button3->Caption = «Π Π°Π±ΠΎΡΠ½ΠΈΠΊΠΈ ΠΎΡΠ΄Π΅Π»Π°»;
InsertForm->Button4->Caption = «Π Π°Π±ΠΎΡ ΠΎΠ±ΡΠ»ΡΠΆ Π»ΠΎΠΊΠΎΠΌ.»;
InsertForm->Button5->Caption = «ΠΠΎ Π²ΠΎΠ·ΡΠ°ΡΡΡ»;
InsertForm->Button6->Caption = «ΠΠΎ ΡΡ. Π·/ΠΏ Π² Π±ΡΠΈΠ³»;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = false;
InsertForm->Label2->Visible = false;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = ««;
InsertForm->Label3->Caption = «ΠΠΎΠΌΠ΅Ρ =»;
InsertForm->Label4->Caption = «ΠΠΎΠΌΠ΅Ρ =»;
InsertForm->Label5->Caption = «=»;
InsertForm->Label6->Caption = «Π·/ΠΏ =»;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = false;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = true;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N4Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π²ΡΠ΅Ρ Π²ΠΎΠ΄ΠΈΡΠ΅Π»Π΅ΠΉ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ²»;
keyMenu = 3;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = true;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = true;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠ΅ Π²ΠΎΠ΄ΠΈΡΠ΅Π»ΠΈ Π»ΠΎΠΊΠΎΠΌ.»;
InsertForm->Button2->Caption = «ΠΡΠΎΡΠ»ΠΈ ΠΌΠ΅Π΄. ΠΎΡΠΌΠΎΡΡ»;
InsertForm->Button3->Caption = «ΠΠ΅ ΠΏΡΠΎΡΠ»ΠΈ ΠΌΠ΅. ΠΎΡΠΌΠΎΡΡ»;
InsertForm->Button4->Caption = «ΠΠΎ ΠΏΠΎΠ». ΠΏΡΠΈΠ·Π½Π°ΠΊ (ΠΌ-ΠΆ)»;
InsertForm->Button5->Caption = «ΠΠΎ Π²ΠΎΠ·ΡΠ°ΡΡΡ»;
InsertForm->Button6->Caption = «ΠΠΎ Π·/ΠΏ»;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = false;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = «Π³ΠΎΠ΄ =»;
InsertForm->Label3->Caption = «Π³ΠΎΠ΄ =»;
InsertForm->Label4->Caption = «ΠΏΠΎΠ» =»;
InsertForm->Label5->Caption = «Π²ΠΎΠ·Ρ =»;
InsertForm->Label6->Caption = «Π·/ΠΏ =»;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = true;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N6Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π²ΡΠ΅Ρ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ²»;
keyMenu = 4;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = false;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠ΅ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²Ρ»;
InsertForm->Button2->Caption = «ΠΠΎ Π²ΡΠ΅ΠΌΠ΅Π½ΠΈ ΠΏΡΠΈΠ±ΡΡΠΈΡ»;
InsertForm->Button3->Caption = «ΠΠΎ ΠΊΠΎΠ»-Π²Ρ ΡΠ΅ΠΉΡΠΎΠ²»;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = ««;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = false;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = false;
InsertForm->Label5->Visible = false;
InsertForm->Label6->Visible = false;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = «Π²ΡΠ΅ΠΌΡ»;
InsertForm->Label3->Caption = «=»;
InsertForm->Label4->Caption = ««;
InsertForm->Label5->Caption = ««;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = false;
InsertForm->Edit5->Visible = false;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N7Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π²ΡΠ΅Ρ Π»ΠΎΠΊΠΎΠΌΠΎΡΠΈΠ²ΠΎΠ² ΡΠ΅Ρ ΠΎΡΠΌΠΎΡΡΠ°»;
keyMenu = 5;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = false;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = true;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = true;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠΎΡΠ΅Π΄ΡΠΈΠ΅ Π’Π»;
InsertForm->Button2->Caption = ««;
InsertForm->Button3->Caption = «Π Π΅ΠΌΠΎΠ½Ρ ΠΊΠΎΠ». ΡΠ°Π·»;
InsertForm->Button4->Caption = «ΠΠΎΠ».ΡΠ΅ΠΉΡΠΎΠ² Π΄ΠΎ ΡΠ΅ΠΌ.»;
InsertForm->Button5->Caption = «ΠΡΠΏΡΠ°Π²Π». Π½Π° ΡΠ΅ΠΌΠΎΠ½Ρ»;
InsertForm->Button6->Caption = «ΠΠΎ Π²ΠΎΠ·ΡΠ°ΡΡΡ Π»ΠΎΠΊ.»;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = «Π‘»;
InsertForm->Label2->Caption = «ΠΠ»;
InsertForm->Label3->Caption = «=»;
InsertForm->Label4->Caption = «=»;
InsertForm->Label5->Caption = «Π΄Π°ΡΠ°:»;
InsertForm->Label6->Caption = «=»;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = true;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = true;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N8Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π²ΡΠ΅Ρ ΠΏΠΎΠ΅Π·Π΄ΠΎΠ²»;
keyMenu = 6;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = false;
InsertForm->Button4->Visible = true;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΠΎ Π²ΡΠ΅ΠΌ ΠΏΠ°ΡΠ°ΠΌ.»;
InsertForm->Button2->Caption = «ΠΠΎ ΠΌΠ°ΡΡΡΡΡΡ:»;
InsertForm->Button3->Caption = ««;
InsertForm->Button4->Caption = «ΠΠΎ Π²ΡΠ΅ΠΌΠ΅Π½ΠΈ ΠΌΠ°ΡΡ.»;
InsertForm->Button5->Caption = «ΠΠΎ ΡΠ΅Π½Π΅ Π±ΠΈΠ»Π΅ΡΠ°»;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = «Π½Π°Ρ:»;
InsertForm->Label3->Caption = «ΠΊΠΎΠ½:»;
InsertForm->Label4->Caption = «=»;
InsertForm->Label5->Caption = «=»;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N9Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΎΡΠΌΠ΅Π½Π΅Π½Π½ΡΡ ΡΠ΅ΠΉΡΠΎΠ²»;
keyMenu = 7;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = false;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠ΅ ΠΎΡΠΌ. ΡΠ΅ΠΉΡΡ»;
InsertForm->Button2->Caption = «ΠΡΠΌ. ΡΠ΅ΠΉΡ Π² Π½Π°ΠΏΡΠ°Π²:»;
InsertForm->Button3->Caption = «ΠΡΠΌ. ΡΠ΅ΠΉΡ ΠΏΠΎ ΠΌΠ°ΡΡ.:»;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = ««;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = false;
InsertForm->Label6->Visible = false;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = ««;
InsertForm->Label3->Caption = «Π½Π°Ρ:»;
InsertForm->Label4->Caption = «ΠΊΠΎΠ½:»;
InsertForm->Label5->Caption = ««;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = false;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N10Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π·Π°Π΄Π΅ΡΠΆΠ°Π½Π½ΡΡ ΡΠ΅ΠΉΡΠΎΠ²»;
keyMenu = 8;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = false;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠ΅ Π·Π°Π΄. ΡΠ΅ΠΉΡΡ»;
InsertForm->Button2->Caption = «ΠΠ°Π΄. ΡΠ΅ΠΉΡ ΠΏΠΎ ΠΏΡΠΈΡ.:»;
InsertForm->Button3->Caption = «ΠΠ°Π΄. ΡΠ΅ΠΉΡ ΠΏΠΎ ΠΌΠ°ΡΡ.:»;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = «ΠΠΎΠ». ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ²»;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = false;
InsertForm->Label6->Visible = false;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = ««;
InsertForm->Label2->Caption = ««;
InsertForm->Label3->Caption = «Π½Π°Ρ:»;
InsertForm->Label4->Caption = «ΠΊΠΎΠ½:»;
InsertForm->Label5->Caption = ««;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = false;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = false;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N11Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΏΡΠΎΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ²»;
keyMenu = 9;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = false;
InsertForm->Button3->Visible = false;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = true;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΡΠΎΠ΄Π°Π½. Π±ΠΈΠ»Π΅ΡΡ»;
InsertForm->Button2->Caption = ««;
InsertForm->Button3->Caption = ««;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = «ΠΠΎ Π΄Π»ΠΈΠ½ΡΠ΅Π». ΠΌΠ°ΡΡ.»;
InsertForm->Button6->Caption = «ΠΠΎ ΡΠ΅Π½Π΅ Π±ΠΈΠ»Π΅ΡΠ°»;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = «Ρ:»;
InsertForm->Label2->Caption = «ΠΏΠΎ:»;
InsertForm->Label3->Caption = «Π½Π°Ρ:»;
InsertForm->Label4->Caption = «ΠΊΠΎΠ½:»;
InsertForm->Label5->Caption = «=»;
InsertForm->Label6->Caption = «=»;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = true;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = true;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N12Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΌΠ°ΡΡΡΡΡΠΎΠ²»;
keyMenu = 10;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = false;
InsertForm->Button3->Visible = false;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = false;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΠ°ΡΡΡΡΡΡ»;
InsertForm->Button2->Caption = ««;
InsertForm->Button3->Caption = ««;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = ««;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = false;
InsertForm->Label4->Visible = false;
InsertForm->Label5->Visible = false;
InsertForm->Label6->Visible = false;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = «ΡΠΈΠΏ:»;
InsertForm->Label2->Caption = «Π½Π°ΠΏΡΠ°Π².:»;
InsertForm->Label3->Caption = ««;
InsertForm->Label4->Caption = ««;
InsertForm->Label5->Caption = ««;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = true;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = false;
InsertForm->Edit4->Visible = false;
InsertForm->Edit5->Visible = false;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N13Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΏΠ°ΡΡΠ°ΠΆΠΈΡΠΎΠ²»;
keyMenu = 11;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = true;
InsertForm->Button5->Visible = true;
InsertForm->Button6->Visible = true;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΠΎ ΡΠ΅ΠΉΡΡ»;
InsertForm->Button2->Caption = «ΠΠΎ Π΄Π½Ρ ΠΎΡΡΠ΅Π·Π΄Π°»;
InsertForm->Button3->Caption = «ΠΠ° Π³ΡΠ°Π½ΠΈΡΡ»;
InsertForm->Button4->Caption = «Π‘Π΄Π°Π»ΠΈ Π² Π±Π°Π³Π°ΠΆ»;
InsertForm->Button5->Caption = «ΠΠΎ ΠΏΠΎΠ»Ρ»;
InsertForm->Button6->Caption = «ΠΠΎ Π²ΠΎΠ·ΡΠ°ΡΡΡ»;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = true;
InsertForm->Label6->Visible = true;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = «=»;
InsertForm->Label2->Caption = «=»;
InsertForm->Label3->Caption = «Π΄Π΅Π½Ρ ΠΎΡ.»;
InsertForm->Label4->Caption = ««;
InsertForm->Label5->Caption = «(ΠΌ, ΠΆ)»;
InsertForm->Label6->Caption = «=»;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = true;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = false;
InsertForm->Edit5->Visible = true;
InsertForm->Edit6->Visible = true;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N14Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠ΅ΡΠ΅ΡΠ΅Π½Ρ Π½Π΅Π²ΡΠΊΡΠΏΠ»Π΅Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ²»;
keyMenu = 12;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = false;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΠΎ ΡΠ΅ΠΉΡΡ»;
InsertForm->Button2->Caption = «ΠΠΎ Π΄Π½Ρ ΠΎΡΡΠ΅Π·Π΄Π°»;
InsertForm->Button3->Caption = «ΠΠΎ ΠΌΠ°ΡΡΡΡΡΡ»;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = ««;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = false;
InsertForm->Label6->Visible = false;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = «β»;
InsertForm->Label2->Caption = «Π΄Π΅Π½Ρ ΠΎΡ:»;
InsertForm->Label3->Caption = «Π½Π°Ρ:»;
InsertForm->Label4->Caption = «ΠΊΠΎΠ½:»;
InsertForm->Label5->Caption = ««;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = true;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = false;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
void __fastcall TForm1: N15Click (TObject *Sender).
{.
InsertForm->Show ();
InsertForm->Caption = «ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΄Π°Π½Π½ΡΡ Π±ΠΈΠ»Π΅ΡΠΎΠ²»;
keyMenu = 13;
InsertForm->Button1->Visible = true;
InsertForm->Button2->Visible = true;
InsertForm->Button3->Visible = true;
InsertForm->Button4->Visible = false;
InsertForm->Button5->Visible = false;
InsertForm->Button6->Visible = false;
InsertForm->Button7->Visible = false;
InsertForm->Button1->Caption = «ΠΠΎ ΡΠ΅ΠΉΡΡ»;
InsertForm->Button2->Caption = «ΠΠΎ Π΄Π½Ρ ΠΎΡΡΠ΅Π·Π΄Π°»;
InsertForm->Button3->Caption = «ΠΠΎ ΠΌΠ°ΡΡΡΡΡΡ»;
InsertForm->Button4->Caption = ««;
InsertForm->Button5->Caption = ««;
InsertForm->Button6->Caption = ««;
InsertForm->Button7->Caption = ««;
InsertForm->Label1->Visible = true;
InsertForm->Label2->Visible = true;
InsertForm->Label3->Visible = true;
InsertForm->Label4->Visible = true;
InsertForm->Label5->Visible = false;
InsertForm->Label6->Visible = false;
InsertForm->Label7->Visible = false;
InsertForm->Label1->Caption = «β»;
InsertForm->Label2->Caption = «Π΄Π΅Π½Ρ ΠΎΡ:»;
InsertForm->Label3->Caption = «Π½Π°Ρ:»;
InsertForm->Label4->Caption = «ΠΊΠΎΠ½:»;
InsertForm->Label5->Caption = ««;
InsertForm->Label6->Caption = ««;
InsertForm->Label7->Caption = ««;
InsertForm->Edit1->Visible = true;
InsertForm->Edit2->Visible = true;
InsertForm->Edit3->Visible = true;
InsertForm->Edit4->Visible = true;
InsertForm->Edit5->Visible = false;
InsertForm->Edit6->Visible = false;
InsertForm->Edit7->Visible = false;
}.
// ;
// ;
void __fastcall TForm1: RadioButton1Click (TObject *Sender).
{.
NameTable = «raspisanie»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton2Click (TObject *Sender).
{.
NameTable = «bileti»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton3Click (TObject *Sender).
{.
NameTable = «zaredzh_reis»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton4Click (TObject *Sender).
{.
NameTable = «otmen_reis»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton5Click (TObject *Sender).
{.
NameTable = «raspisanie_lokomotivi»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton6Click (TObject *Sender).
{.
NameTable = «rabotniki»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton7Click (TObject *Sender).
{.
NameTable = «otdeli»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton8Click (TObject *Sender).
{.
NameTable = «teh_brigad»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton9Click (TObject *Sender).
{.
NameTable = «lokomotivi»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TForm1: RadioButton10Click (TObject *Sender).
{.
NameTable = «lokomotivi_teh_brigad»;
Form1->ADOQuery1->SQL->Text = «select * from „+NameTable+“»;
Form1->ADOQuery1->Active = 1;
Form1->ADOQuery1->ExecSQL ();
}.
// ;
void __fastcall TInsertForm: Button1Click (TObject *Sender).
{.
switch (keyMenu).
{.
case 1: InsertForm->ADOQuery1->SQL->Text = «select * from rabotniki»;
break;
case 2: InsertForm->ADOQuery1->SQL->Text = «SELECT * FROM rabotniki WHERE `rabotniki`.`id_br` IS NOT NULL»;
break;
case 3: InsertForm->ADOQuery1->SQL->Text = «select * from rabotniki where rabotniki. type = 'Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ'»;
break;
case 4: InsertForm->ADOQuery1->SQL->Text = «select * from lokomotivi»;
break;
case 5: InsertForm->ADOQuery1->SQL->Text = «select * from lokomotivi where lokomotivi. date_teh_osm >= '"+InsertForm->Edit1->Text+"'and lokomotivi. date_teh_osm <= ' „+InsertForm->Edit2->Text+“ '»;
break;
case 6: InsertForm->ADOQuery1->SQL->Text = «select * from raspisanie»;
break;
case 7: InsertForm->ADOQuery1->SQL->Text = «select * from raspisanie, otmen_reis where raspisanie. id_r = otmen_reis.id_r»;
break;
case 8: InsertForm->ADOQuery1->SQL->Text = «select * from raspisanie, zaredzh_reis where raspisanie. id_r = zaredzh_reis.id_r»;
break;
case 9: InsertForm->ADOQuery1->SQL->Text = «select raspisanie. id_r, bileti. status_bil, bileti. fio_owner, bileti. vrem_buy, raspisanie. marshrut_nach, raspisanie. marshrut_kon from bileti, raspisanie where raspisanie. id_r = bileti. id_r and raspisanie. marshrut_nach = '"+InsertForm->Edit3->Text+"' and raspisanie. marshrut_kon = ' „+InsertForm->Edit4->Text+“ ' and bileti. vrem_buy >= ' „+InsertForm->Edit1->Text+“ ' and bileti. vrem_buy <= ' „+InsertForm->Edit2->Text+“ '»;
break;
case 10: InsertForm->ADOQuery1->SQL->Text = «select * from raspisanie where raspisanie. type_poezd = '"+InsertForm->Edit1->Text+"' and raspisanie. marshrut_kon = ' „+InsertForm->Edit2->Text+“ '»;
break;
case 11: InsertForm->ADOQuery1->SQL->Text = «select * from bileti where bileti. id_r = «+InsertForm->Edit1->Text;
break;
case 12: InsertForm->ADOQuery1->SQL->Text = «select * from bileti where bileti. status_bil = «Π½Π΅Π²ΡΠΊΡΠΏΠ»Π΅Π½» and bileti. id_r = «+InsertForm->Edit1->Text;