ΠΠ°ΠΊΠ»ΡΡΠ΅Π½ΠΈΠ΅.
Π Π°Π·ΡΠ°Π±ΠΎΡΠΊΠ° ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΎΠ½Π½ΠΎΠΉ ΡΠΈΡΡΠ΅ΠΌΡ "ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°"
Π ΡΠ΅Π·ΡΠ»ΡΡΠ°ΡΠ΅ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π΄Π°Π½Π½ΠΎΠ³ΠΎ Π΄ΠΈΠΏΠ»ΠΎΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ° Π±ΡΠ»ΠΈ ΡΠ΅ΡΠ΅Π½Ρ Π·Π°Π΄Π°ΡΠΈ, ΠΏΠΎΡΡΠ°Π²Π»Π΅Π½Π½ΡΠ΅ Π² Π½Π°ΡΠ°Π»Π΅ ΡΠ°Π±ΠΎΡΡ. ΠΡΠ»Π° ΡΠ°Π·ΡΠ°Π±ΠΎΡΠ°Π½Π° ΡΡΡΡΠΊΡΡΡΠ° Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ; Π² ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ Π±ΡΠ»ΠΈ Π²ΠΊΠ»ΡΡΠ΅Π½Ρ ΡΡΠ½ΠΊΡΠΈΠΈ ΠΏΠΎΠΈΡΠΊΠ°, Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ ΡΠ°Π·Π»ΠΈΡΠ½ΡΡ Π·Π°ΠΏΡΠΎΡΠΎΠ². ΠΡΠΈ ΡΡΠΎΠΌ Π±ΡΠ»ΠΈ ΡΡΡΠ΅Π½Ρ Π²ΡΠ΅ ΡΡΠ΅Π±ΠΎΠ²Π°Π½ΠΈΡ, Π²ΡΠ΄Π²ΠΈΠ½ΡΡΡΠ΅ Π² Π½Π°ΡΠ°Π»Π΅ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π΄Π°Π½Π½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ°. Π Π°Π·ΡΠ°Π±ΠΎΡΠ°Π½Π½Π°Ρ Π² Ρ ΠΎΠ΄Π΅ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π΄ΠΈΠΏΠ»ΠΎΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ° ΠΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΎΠ½Π½Π°Ρ ΡΠΈΡΡΠ΅ΠΌΠ° «ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°», ΡΠ²Π»ΡΠ΅ΡΡΡ… Π§ΠΈΡΠ°ΡΡ Π΅ΡΡ >
ΠΠ°ΠΊΠ»ΡΡΠ΅Π½ΠΈΠ΅. Π Π°Π·ΡΠ°Π±ΠΎΡΠΊΠ° ΠΈΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΎΠ½Π½ΠΎΠΉ ΡΠΈΡΡΠ΅ΠΌΡ "ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°" (ΡΠ΅ΡΠ΅ΡΠ°Ρ, ΠΊΡΡΡΠΎΠ²Π°Ρ, Π΄ΠΈΠΏΠ»ΠΎΠΌ, ΠΊΠΎΠ½ΡΡΠΎΠ»ΡΠ½Π°Ρ)
Π Π°Π·ΡΠ°Π±ΠΎΡΠ°Π½Π½Π°Ρ Π² Ρ ΠΎΠ΄Π΅ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π΄ΠΈΠΏΠ»ΠΎΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ° ΠΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΎΠ½Π½Π°Ρ ΡΠΈΡΡΠ΅ΠΌΠ° «ΠΠΎΡΡΠΈΠ½ΠΈΡΠ°», ΡΠ²Π»ΡΠ΅ΡΡΡ Π°ΠΊΡΡΠ°Π»ΡΠ½ΠΎΠΉ Π½Π° ΡΠ΅Π³ΠΎΠ΄Π½ΡΡΠ½ΠΈΠΉ Π΄Π΅Π½Ρ ΠΈ ΠΈΠΌΠ΅Π΅Ρ Π±ΠΎΠ»ΡΡΡΡ ΠΏΡΠ°ΠΊΡΠΈΡΠ΅ΡΠΊΡΡ Π·Π½Π°ΡΠΈΠΌΠΎΡΡΡ.
Π ΡΠ΅Π·ΡΠ»ΡΡΠ°ΡΠ΅ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π΄Π°Π½Π½ΠΎΠ³ΠΎ Π΄ΠΈΠΏΠ»ΠΎΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ° Π±ΡΠ»ΠΈ ΡΠ΅ΡΠ΅Π½Ρ Π·Π°Π΄Π°ΡΠΈ, ΠΏΠΎΡΡΠ°Π²Π»Π΅Π½Π½ΡΠ΅ Π² Π½Π°ΡΠ°Π»Π΅ ΡΠ°Π±ΠΎΡΡ. ΠΡΠ»Π° ΡΠ°Π·ΡΠ°Π±ΠΎΡΠ°Π½Π° ΡΡΡΡΠΊΡΡΡΠ° Π±Π°Π·Ρ Π΄Π°Π½Π½ΡΡ ; Π² ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ Π±ΡΠ»ΠΈ Π²ΠΊΠ»ΡΡΠ΅Π½Ρ ΡΡΠ½ΠΊΡΠΈΠΈ ΠΏΠΎΠΈΡΠΊΠ°, Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ ΡΠ°Π·Π»ΠΈΡΠ½ΡΡ Π·Π°ΠΏΡΠΎΡΠΎΠ². ΠΡΠΈ ΡΡΠΎΠΌ Π±ΡΠ»ΠΈ ΡΡΡΠ΅Π½Ρ Π²ΡΠ΅ ΡΡΠ΅Π±ΠΎΠ²Π°Π½ΠΈΡ, Π²ΡΠ΄Π²ΠΈΠ½ΡΡΡΠ΅ Π² Π½Π°ΡΠ°Π»Π΅ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ Π΄Π°Π½Π½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ°.
Π Π°Π·ΡΠ°Π±ΠΎΡΠ°Π½Π½Π°Ρ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ° ΡΡΡΠΎΠΉΡΠΈΠ²ΠΎ Π²ΡΠΏΠΎΠ»Π½ΡΠ΅Ρ Π²ΡΠ΅ ΡΠ²ΠΎΠΈ ΡΡΠ½ΠΊΡΠΈΠΈ.
Π‘ΠΠΠ‘ΠΠ ΠΠΠ’ΠΠ ΠΠ’Π£Π Π«
- 1. ΠΠΠ‘Π’ 2. 105−95 ΠΠ‘ΠΠ. ΠΠ±ΡΠΈΠ΅ ΡΡΠ΅Π±ΠΎΠ²Π°Π½ΠΈΠ΅ ΠΊ ΡΠ΅ΠΊΡΡΠΎΠ²ΡΠΌ Π΄ΠΎΠΊΡΠΌΠ΅Π½ΡΠ°ΠΌ
- 2. ΠΠΠ‘Π’ 2. 004−68 ΠΠ‘ΠΠ. ΠΠ±ΡΠΈΠ΅ ΡΡΠ΅Π±ΠΎΠ²Π°Π½ΠΈΡ ΠΊ Π²ΡΠΏΠΎΠ»Π½Π΅Π½ΠΈΡ ΠΊΠΎΠ½ΡΡΡΡΠΊΡΠΎΡΡΠΊΠΈΡ ΠΈ ΡΠ΅Ρ Π½ΠΎΠ»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΈΡ Π΄ΠΎΠΊΡΠΌΠ΅Π½ΡΠΎΠ² Π½Π° ΠΏΠ΅ΡΠ°ΡΠ½ΡΡ Π³ΡΠ°ΡΠΈΡΠ΅ΡΠΊΠΈΡ ΡΡΡΡΠΎΠΉΡΡΠ²Π°Ρ Π²ΡΠ²ΠΎΠ΄Π° ΠΠΠ
- 3. ΠΠΠ‘Π’ 2. 104−68 ΠΠ‘ΠΠ. ΠΡΠ½ΠΎΠ²Π½ΡΠ΅ Π½Π°Π΄ΠΏΠΈΡΠΈ
- 4. ΠΠΠ‘Π’ 2. 106−96 ΠΠ‘ΠΠ. Π’Π΅ΠΊΡΡΠΎΠ²ΡΠ΅ Π΄ΠΎΠΊΡΠΌΠ΅Π½ΡΡ
- 5. ΠΡΡ Π°Π½Π³Π΅Π»ΡΡΠΊΠΈΠΉ Π. Π―. ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ Delphi7 — ΠΠΎΡΠΊΠ²Π°, 2005;
- 6. ΠΠ»Π°Π³ΠΎΠ΄Π°ΡΡΠΊΠΈΡ Π. Π. ΠΈ Π΄Ρ. ΠΠΊΠΎΠ½ΠΎΠΌΠΈΠΊΠ°, ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠ° ΠΈ ΠΈΡΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°Π½ΠΈΠ΅ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΠΎΠ³ΠΎ ΠΎΠ±Π΅ΡΠΏΠ΅ΡΠ΅Π½ΠΈΡ ΠΠΠ — ΠΠΎΡΠΊΠ²Π°, 1995;
- 7. ΠΠ»Π°Π³ΠΎΠ΄Π°ΡΡΠΊΠΈΡ Π. Π. ΠΈ Π΄Ρ. Π‘ΡΠ°Π½Π΄Π°ΡΡΠΈΠ·Π°ΡΠΈΡ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΡ ΡΡΠ΅Π΄ΡΡΠ² — ΠΠΎΡΠΊΠ²Π°, 2003;
- 8. ΠΠΎΠ±ΡΠΎΠ²ΡΠΊΠΈΠΉ Π‘. Π. Delphi 7 — ΠΠΎΡΠΊΠ²Π°, 2005;
- 9. ΠΠΎΠ»ΠΈΡΠΈΠ½Π° Π. Π., ΠΠ°ΠΊΡΠΈΠΌΠΎΠ² Π. Π. ΠΈ Π΄Ρ. ΠΠ°Π·Π° Π΄Π°Π½Π½ΡΡ — ΠΠΎΡΠΊΠ²Π°, 2003;
- 10. ΠΠΎΠ½Π½ΠΎΠ»Π»ΠΈ Π’. Π., ΠΠ΅Π³ Π. Π. ΠΠ°Π·Ρ Π΄Π°Π½Π½ΡΡ . ΠΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅, ΡΠ΅Π°Π»ΠΈΠ·Π°ΡΠΈΡ ΠΈ ΡΠΎΠΏΡΠΎΠ²ΠΎΠΆΠ΄Π΅Π½ΠΈΠ΅ — ΠΠΎΡΠΊΠ²Π°, 2001;
- 11. ΠΠΊΠ΅Π°Π½ΠΎΠ²Π° Π. Π. ΠΡΠ½ΠΎΠ²Ρ ΡΠΊΠΎΠ½ΠΎΠΌΠΈΡΠ΅ΡΠΊΠΎΠΉ ΡΠ΅ΠΎΡΠΈΠΈΠΠΎΡΠΊΠ²Π°, 2003;
- 12. ΠΡΠ»ΠΎΠ² Π‘. Π. Π’Π΅Ρ Π½ΠΎΠ»ΠΎΠ³ΠΈΠΈ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΠΎΠ³ΠΎ ΠΎΠ±Π΅ΡΠΏΠ΅ΡΠ΅Π½ΠΈΡ — Π‘Π°Π½ΠΊΡ-ΠΠ΅ΡΠ΅ΡΠ±ΡΡΠ³, 2002;
- 13. ΠΠΎΠ»Π΅ΡΡΠΊ Π. Π. AutoCAD 2005, Π‘Π°Π½ΠΊΡ — ΠΠ΅ΡΠ΅ΡΠ±ΡΡΠ³, 2004;
- 14. Π ΡΠ΄Π°ΠΊΠΎΠ² Π. Π. Π’Π΅Ρ Π½ΠΎΠ»ΠΎΠ³ΠΈΡ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΡ ΠΏΡΠΎΠ΄ΡΠΊΡΠΎΠ² — ΠΠΎΡΠΊΠ²Π°, 2005;
- 15. Π‘Π΅ΠΌΠ°ΠΊΠΈΠ½ Π. Π., Π¨Π΅ΡΡΠ°ΠΊΠΎΠ² Π. Π. ΠΡΠ½ΠΎΠ²Ρ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠΈΡΠΎΠ²Π°Π½ΠΈΡ — ΠΠΎΡΠΊΠ²Π°, 2001;
- 16. Π€Π°ΡΠΎΠ½ΠΎΠ² Π. Π. ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ Π±Π°Π· Π΄Π°Π½Π½ΡΡ Π² Delphi 7, Π‘Π°Π½ΠΊΡ-ΠΠ΅ΡΠ΅ΡΠ±ΡΡΠ³, 2003;
- 17. Π€ΠΈΠ³ΡΠ½ΠΎΠ² Π. Π. IBM PC Π΄Π»Ρ ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Π΅ΠΉ — ΠΠΎΡΠΊΠ²Π°, 1996;
- 18. Π―ΠΊΡΠ±Π°ΠΉΡΠΈΡ Π. Π. ΠΠ½ΡΠΎΡΠΌΠ°ΡΠΈΠΎΠ½Π½ΡΠ΅ ΡΠ΅ΡΠΈ ΠΈ ΡΠΈΡΡΠ΅ΠΌΡ — ΠΠΎΡΠΊΠ²Π°, 1996.
ΠΠ ΠΠΠΠΠΠΠΠ―
ΠΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π
ΠΡΡ ΠΎΠ΄Π½ΡΠΉ ΠΊΠΎΠ΄ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ
ΠΠ»Π°Π²Π½Π°Ρ ΡΠΎΡΠΌΠ°.
unit Unit1;
interface.
uses.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,.
Dialogs, Menus, jpeg, ExtCtrls;
type.
TForm1 = class (TForm).
Image1: TImage;
MainMenu1: TMainMenu;
N1: TMenuItem;
N2: TMenuItem;
N3: TMenuItem;
N4: TMenuItem;
N5: TMenuItem;
N6: TMenuItem;
N7: TMenuItem;
N8: TMenuItem;
procedure N2Click (Sender: TObject);
procedure N4Click (Sender: TObject);
procedure N3Click (Sender: TObject);
procedure N7Click (Sender: TObject);
procedure N8Click (Sender: TObject);
procedure N5Click (Sender: TObject);
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
Form1: TForm1;
implementation.
uses Unit2, Unit3, Unit4, Unit5, Unit6, Unit7;
{$R *.dfm}.
procedure TForm1. N2Click (Sender: TObject);
begin.
Form3.Show;
end;
procedure TForm1. N4Click (Sender: TObject);
begin.
Form4.Show;
end;
procedure TForm1. N3Click (Sender: TObject);
begin.
Form5.Show;
end;
procedure TForm1. N7Click (Sender: TObject);
begin.
Application.Terminate;
end;
procedure TForm1. N8Click (Sender: TObject);
begin.
AboutBox.ShowModal;
end;
procedure TForm1. N5Click (Sender: TObject);
begin.
Form7.Show;
end;
end.
ΠΠΎΠ΄ΡΠ»Ρ Π΄Π°Π½Π½ΡΡ .
unit Unit2;
interface.
uses.
SysUtils, Classes, DB, ADODB;
type.
TDataModule2 = class (TdataModule).
ADOConnection1: TADOConnection;
ADOTable1: TADOTable;
DataSource1: TdataSource;
ADOTable2: TADOTable;
DataSource2: TdataSource;
ADOTable3: TADOTable;
DataSource3: TdataSource;
ADOTable4: TADOTable;
DataSource4: TdataSource;
ADOQuery1: TADOQuery;
DataSource5: TdataSource;
ADOQuery2: TADOQuery;
DataSource6: TdataSource;
ADOQuery3: TADOQuery;
DataSource7: TdataSource;
procedure DataModuleCreate (Sender: Tobject);
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
DataModule2: TdataModule2;
implementation.
uses.
Unit1, Unit3, Unit4, Unit5, Unit7;
{$R *.dfm}.
procedure TdataModule2. DataModuleCreate (Sender: Tobject);
begin.
AdoConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+GetCurrentDir+'Gost.mdb;Persist Security Info=False';
AdoConnection1.Connected:=true;
AdoTable1.Connection:=AdoConnection1;
AdoTable1.TableName:='ΠΠ°ΡΠ΅Π»Π΅Π½ΠΈΠ΅';
AdoTable1.Active:=True;
AdoTable2.Connection:=AdoConnection1;
AdoTable2.TableName:='ΠΠ»ΠΈΠ΅Π½Ρ';
AdoTable2.Active:=True;
//AdoTable3.Connection:=AdoConnection1;
//AdoTable3.TableName:='ΠΠΎΠΌΠ΅Ρ';
//AdoTable3.Active:=True;
AdoTable4.Connection:=AdoConnection1;
AdoTable4.TableName:='ΠΠΏΠ»Π°ΡΠ°';
AdoTable4.Active:=True;
AdoQuery1.Connection:=AdoConnection1;
AdoQuery1.Close;
AdoQuery1.SQL.Text:='Select ΠΠΎΠ΄, Π‘Π²ΠΎΠ±ΠΎΠ΄Π½ΡΠ΅, ΠΠ°ΠΈΠΌΠ΅Π½ΠΎΠ²Π°Π½ΠΈΠ΅, ΠΠΏΠΈΡΠ°Π½ΠΈΠ΅, Π‘ΡΠΎΠΈΠΌΠΎΡΡΡ From ΠΠΎΠΌΠ΅Ρ';
AdoQuery1.ExecSQL;
AdoQuery1.Open;
{AdoQuery3.Connection:=AdoConnection1;
AdoQuery3.Close;
AdoQuery3.SQL.Text:='Select ΠΠΎΠ΄, ΠΠΎΠ΄ Π·Π°ΡΠ΅Π»Π΅Π½ΠΈΡ, Π€ΠΠ ΠΏΠ»Π°ΡΠ΅Π»ΡΡΠΈΠΊΠ°, Π‘ΡΠΌΠΌΠ° From ΠΠΏΠ»Π°ΡΠ°';
AdoQuery3.ExecSQL;
AdoQuery3.Open; }.
end;
end.
Π€ΠΎΡΠΌΠ° ΠΠΠ‘ΠΠΠΠΠΠ ΠΠΠΠΠΠ’ΠΠ.
unit Unit3;
interface.
uses.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,.
Dialogs, Grids, DBGrids, DBCtrls, ExtCtrls, StdCtrls, Buttons, ComCtrls;
type.
TForm3 = class (Tform).
Panel1: Tpanel;
Splitter1: Tsplitter;
Panel2: Tpanel;
DBNavigator1: TDBNavigator;
DBGrid1: TDBGrid;
Label1: Tlabel;
Edit1: Tedit;
SpeedButton1: TspeedButton;
GroupBox1: TgroupBox;
Label2: Tlabel;
DateTimePicker1: TdateTimePicker;
Label3: Tlabel;
DateTimePicker2: TdateTimePicker;
BitBtn1: TbitBtn;
BitBtn2: TbitBtn;
RadioGroup1: TradioGroup;
procedure FormActivate (Sender: Tobject);
procedure FormClose (Sender: Tobject; var Action: TcloseAction);
procedure Edit1Change (Sender: Tobject);
procedure SpeedButton1Click (Sender: Tobject);
procedure FormCreate (Sender: Tobject);
procedure BitBtn1Click (Sender: Tobject);
procedure BitBtn2Click (Sender: Tobject);
procedure RadioGroup1Click (Sender: Tobject);
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
Form3: Tform3;
implementation.
uses.
Unit2, Unit1;
{$R *.dfm}.
procedure Tform3. FormActivate (Sender: Tobject);
begin.
DataModule2.ADOTable1.Close;
DataModule2.AdoQuery2.Connection:=DataModule2.AdoConnection1;
DataModule2.AdoQuery2.Close;
DataModule2.AdoQuery2.SQL.Text:='Select * From ΠΠ°ΡΠ΅Π»Π΅Π½ΠΈΠ΅';
DataModule2.AdoQuery2.ExecSQL;
DataModule2.AdoQuery2.Open;
DBGrid1.DataSource:=DataModule2.DataSource6;
end;
procedure Tform3. FormClose (Sender: Tobject; var Action: TcloseAction);
begin.
DataModule2.AdoQuery2.Close;
DataModule2.AdoTable1.Open;
end;
procedure Tform3. Edit1Change (Sender: Tobject);
begin.
with DataModule2. ADOQuery2 do.
begin.
close;
SQL.Clear;
SQL.Add (`Select *');
SQL.Add (`From ΠΠ°ΡΠ΅Π»Π΅Π½ΠΈΠ΅');
SQL.Add (`Where (ΠΠ»ΠΈΠ΅Π½Ρ Like «%'+Edit1.Text+'%»)');
//SQL.Add (`Order By Name');
OPEN;
end;
DataModule2.DataSource6.DataSet:=DataModule2.ADOQuery2;
end;
procedure Tform3. SpeedButton1Click (Sender: Tobject);
begin.
Form3.Close;
end;
procedure Tform3. FormCreate (Sender: Tobject);
begin.
DateTimePicker1.DateTime:=now;
DateTimePicker2.DateTime:=now;
RadioGroup1.ItemIndex:=-1;
end;
procedure Tform3. BitBtn1Click (Sender: Tobject);
begin.
Datamodule2.ADOQuery2.Filter:='[ΠΠ°ΡΠ° Π·Π°ΡΠ΅Π»Π΅Π½ΠΈΡ]>=' + DateToStr (DateTimePicker1.Date) +.
` AND [ΠΠ°ΡΠ° Π·Π°ΡΠ΅Π»Π΅Π½ΠΈΡ]<=' + DateToStr (DateTimePicker2.Date) ;
Datamodule2.ADOQuery2.Filtered :=True;
end;
procedure Tform3. BitBtn2Click (Sender: Tobject);
begin.
Datamodule2.ADOQuery2.Filtered :=False;
end;
procedure Tform3. RadioGroup1Click (Sender: Tobject);
begin.
case RadioGroup1. ItemIndex of.
- 0: DataModule2. ADOQuery2. Sort:='ΠΠ»ΠΈΠ΅Π½Ρ';
- 1: DataModule2. ADOQuery2. Sort:='[ΠΠ°ΡΠ° Π·Π°ΡΠ΅Π»Π΅Π½ΠΈΡ]';
- 2: DataModule2. ADOQuery2. Sort:='ΠΠΎΠ΄';
end;
end;
end.
Π€ΠΎΡΠΌΠ° ΠΠΠΠΠ Π ΠΠΠ‘Π’ΠΠΠΠ¦Π«.
unit Unit4;
interface.
uses.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,.
Dialogs, Grids, DBGrids, DBCtrls, ExtCtrls, StdCtrls, Buttons;
type.
TForm4 = class (Tform).
Panel1: Tpanel;
Panel2: Tpanel;
DBNavigator1: TDBNavigator;
DBGrid1: TDBGrid;
DBMemo1: TDBMemo;
Panel3: Tpanel;
Splitter1: Tsplitter;
Splitter2: Tsplitter;
RadioGroup1: TradioGroup;
SpeedButton1: TspeedButton;
RadioGroup2: TradioGroup;
procedure DBGrid1CellClick (Column: Tcolumn);
procedure FormCreate (Sender: Tobject);
procedure RadioGroup1Click (Sender: Tobject);
procedure SpeedButton1Click (Sender: Tobject);
procedure RadioGroup2Click (Sender: Tobject);
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
Form4: Tform4;
implementation.
uses.
Unit2, Unit1;
{$R *.dfm}.
procedure Tform4. DBGrid1CellClick (Column: Tcolumn);
begin.
DBMemo1.Text:=DataModule2.ADOQuery1.Fields[3]. AsString;
end;
procedure Tform4. FormCreate (Sender: Tobject);
begin.
DBGrid1.Columns[0]. FieldName:='ΠΊΠΎΠ΄';
DBGrid1.Columns[1]. FieldName:='ΠΠ°ΠΈΠΌΠ΅Π½ΠΎΠ²Π°Π½ΠΈΠ΅';
DBGrid1.Columns[2]. FieldName:='Π‘Π²ΠΎΠ±ΠΎΠ΄Π½ΡΠ΅';
DBGrid1.Columns[3]. FieldName:='Π‘ΡΠΎΠΈΠΌΠΎΡΡΡ';
RadioGroup1.ItemIndex:=1;
RadioGroup2.ItemIndex:=1;
end;
procedure Tform4. RadioGroup1Click (Sender: Tobject);
begin.
Case RadioGroup1. ItemIndex of.
0: begin DataModule2. AdoQuery1.Connection:=DataModule2.AdoConnection1;
DataModule2.AdoQuery1.Close;
DataModule2.AdoQuery1.SQL.Text:='Select * From ΠΠΎΠΌΠ΅Ρ Where Π‘Π²ΠΎΠ±ΠΎΠ΄Π½ΡΠ΅=true';
DataModule2.AdoQuery1.ExecSQL;
DataModule2.AdoQuery1.Open;
end;
1: begin DataModule2. AdoQuery1.Connection:=DataModule2.AdoConnection1;
DataModule2.AdoQuery1.Close;
DataModule2.AdoQuery1.SQL.Text:='Select * From ΠΠΎΠΌΠ΅Ρ';
DataModule2.AdoQuery1.ExecSQL;
DataModule2.AdoQuery1.Open;
end;
end;
end;
procedure Tform4. SpeedButton1Click (Sender: Tobject);
begin.
form4.Close;
end;
procedure Tform4. RadioGroup2Click (Sender: Tobject);
begin.
Case RadioGroup2. ItemIndex of.
0: begin.
DataModule2.AdoQuery1.Sort:='ΠΠ°ΠΈΠΌΠ΅Π½ΠΎΠ²Π°Π½ΠΈΠ΅';
end;
1: begin.
DataModule2.AdoQuery1.Sort:='ΠΠΎΠ΄';
end;
end;
end;
end.
Π€ΠΎΡΠΌΠ° ΠΠΠΠΠΠ’Π«.
unit Unit5;
interface.
uses.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,.
Dialogs, StdCtrls, DBCtrls, Grids, DBGrids, ExtCtrls, Mask, Buttons,.
ComCtrls;
type.
TForm5 = class (TForm).
Panel1: TPanel;
Panel2: TPanel;
Splitter1: TSplitter;
GroupBox1: TGroupBox;
Splitter2: TSplitter;
DBNavigator1: TDBNavigator;
DBGrid1: TDBGrid;
GroupBox2: TGroupBox;
DBComboBox1: TDBComboBox;
Label1: TLabel;
Label2: TLabel;
Edit1: TEdit;
Label3: TLabel;
DateTimePicker1: TDateTimePicker;
BitBtn1: TBitBtn;
Label4: TLabel;
ComboBox1: TComboBox;
Label5: TLabel;
Splitter3: TSplitter;
GroupBox3: TGroupBox;
BitBtn2: TBitBtn;
Label6: TLabel;
DateTimePicker3: TDateTimePicker;
Label7: TLabel;
Edit2: TEdit;
DateTimePicker2: TDateTimePicker;
Label8: TLabel;
ComboBox2: TComboBox;
BitBtn3: TBitBtn;
SpeedButton1: TSpeedButton;
procedure FormCreate (Sender: TObject);
procedure BitBtn1Click (Sender: TObject);
procedure ComboBox1Change (Sender: TObject);
procedure BitBtn2Click (Sender: TObject);
procedure BitBtn3Click (Sender: TObject);
procedure SpeedButton1Click (Sender: TObject);
procedure FormActivate (Sender: TObject);
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
Form5: TForm5;
k, k1: byte;
i, j: Integer;
implementation.
uses Unit1, Unit2;
{$R *.dfm}.
procedure TForm5. FormCreate (Sender: TObject);
begin.
DateTimePicker1.Date:=now;
DateTimePicker2.Date:=now;
DateTimePicker3.Date:=now;
DateTimePicker1.Time:=0;
i:=0; j:=0;
While not DataModule2. ADOTable1. Eof do.
begin.
if DateTimePicker1. Date>DataModule2.ADOTable1.Fields[2]. AsDateTime then.
i:=DataModule2.ADOTable1.Fields[4]. AsInteger;
if DateTimePicker1. Date<=DataModule2.ADOTable1.Fields[2]. AsDateTime then.
j:=DataModule2.ADOTable1.Fields[4]. AsInteger;
while not DataModule2. ADOQuery1. Eof do.
begin.
if i=DataModule2.ADOQuery1.Fields[0]. AsInteger Then.
begin.
DataModule2.ADOQuery1.Edit;
DataModule2.ADOQuery1.Fields[1]. AsBoolean:=true;
end;
if j=DataModule2.ADOQuery1.Fields[0]. AsInteger Then.
begin.
DataModule2.ADOQuery1.Edit;
DataModule2.ADOQuery1.Fields[1]. AsBoolean:=false;
end;
DataModule2.ADOQuery1.Next;
end;
DataModule2.ADOTable1.Next;
end;
DBComboBox1.ItemIndex:=-1;
DataModule2.ADOTable2.Open;
DataModule2.ADOTable2.First;
while not DataModule2. ADOTable2. Eof do.
begin.
Form5.DBComboBox1.Items.Add (DataModule2.ADOTable2.Fields[1]. AsString);
DataModule2.ADOTable2.Next;
end;
DBComboBox1.DataField:='Π€ΠΠ';
ComboBox1.ItemIndex:=-1;
DataModule2.ADOQuery1.Open;
DataModule2.ADOQuery1.First;
While not DataModule2. ADOQuery1. Eof do.
begin.
if DataModule2. ADOQuery1.Fields[1]. AsBoolean=true then.
ComboBox1.Items.Add (IntToStr (DataModule2.ADOQuery1.Fields[0]. AsInteger));
DataModule2.ADOQuery1.Next;
end;
end;
procedure TForm5. BitBtn1Click (Sender: TObject);
begin.
k:=0;
DataModule2.ADOTable2.Open;
DataModule2.ADOTable2.First;
while not DataModule2. ADOTable2. Eof do.
begin.
if Edit1. Text=DataModule2.ADOTable2.Fields[1]. AsString then k:=1;
DataModule2.ADOTable2.Next;
end;
if k=0 then.
begin.
DataModule2.ADOTable2.Append;
DataModule2.ADOTable2.Fields[1]. AsString:=Edit1.Text;
DataModule2.ADOTable2.Fields[2]. AsDateTime:=DateTimePicker1.Date;
DBComboBox1.Clear;
DBComboBox1.ItemIndex:=-1;
DataModule2.ADOTable2.Open;
DataModule2.ADOTable2.First;
while not DataModule2. ADOTable2. Eof do.
begin.
Form5.DBComboBox1.Items.Add (DataModule2.ADOTable2.Fields[1]. AsString);
DataModule2.ADOTable2.Next;
end;
end.
else ShowMessage ('ΠΠ»ΠΈΠ΅Π½Ρ ΡΠΆΠ΅ Π·Π°ΡΠ΅Π³ΠΈΡΡΡΠΈΡΠΎΠ²Π°Π½!');
end;
procedure TForm5. ComboBox1Change (Sender: TObject);
begin.
DataModule2.ADOQuery1.First;
While not DataModule2. ADOQuery1. Eof do.
begin.
If DataModule2. ADOQuery1.Fields[0]. AsInteger=StrToInt (ComboBox1.Text) then.
Edit2.Text:=IntToStr (DataModule2.ADOQuery1.Fields[4]. AsInteger);
DataModule2.ADOQuery1.Next;
end;
end;
procedure TForm5. BitBtn2Click (Sender: TObject);
begin.
if (DBComboBox1.Text'') and ((ComboBox1.Text'')or (ComboBox1.Text'Π½Π΅Ρ')) then.
Begin.
DataModule2.ADOTable1.Append;
DataModule2.ADOTable1.Fields[3]. AsString:=DBComboBox1.Text;
DataModule2.ADOTable1.Fields[4]. AsInteger:=StrToInt (ComboBox1.Text);
DateTimePicker2.Time:=0;
DateTimePicker3.Time:=0;
DataModule2.ADOTable1.Fields[1]. AsDateTime:=DateTimePicker2.Date;
DataModule2.ADOTable1.Fields[2]. AsDateTime:=DateTimePicker3.Date;
DataModule2.ADOTable1.Post;
DataModule2.ADOTable1.Refresh;
DataModule2.ADOTable4.Append;
DataModule2.ADOTable4.Fields[1]. AsInteger:=DataModule2.ADOTable1.Fields[0].AsInteger;
DataModule2.ADOTable4.Fields[2]. AsString:=DataModule2.ADOTable1.Fields[3].AsString;
DataModule2.ADOTable4.Fields[3]. AsFloat:=(DateTimePicker3.Date-DateTimePicker2.Date)*strtoint (Edit2.Text);
DataModule2.ADOTable4.Post;
DataModule2.ADOTable4.Refresh;
DataModule2.ADOQuery1.First;
While not DataModule2. ADOQuery1. Eof do.
begin.
if strtoint (ComboBox1.Text)=DataModule2.ADOQuery1.Fields[0]. AsInteger Then.
begin.
DataModule2.ADOQuery1.Edit;
DataModule2.ADOQuery1.Fields[1]. AsBoolean:=false;
//if DataModule2. ADOQuery1.State in [dsEdit, dsInsert] then DataModule2. ADOQuery1. Post;
end;
DataModule2.ADOQuery1.Next;
end;
end.
else ShowMessage ('ΠΠ΅ Π²ΡΠ΅ ΠΏΠΎΠ»Ρ Π·Π°ΠΏΠΎΠ»Π½Π΅Π½Ρ');
Form5.Close;
end;
procedure TForm5. BitBtn3Click (Sender: TObject);
begin.
if ComboBox2. Text'' then.
begin.
Case ComboBox2. ItemIndex of.
- 0:DataModule2.ADOTable2.Sort:='Π€ΠΠ';
- 1:DataModule2.ADOTable2.Sort:='[ΠΠ°ΡΠ° ΡΠ΅Π³ΠΈΡΡΡΠ°ΡΠΈΠΉ]';
end;
end.
else ShowMessage ('ΠΡΠ±Π΅ΡΠΈΡΠ΅ ΠΏΠΎΠ»Π΅ Π΄Π»Ρ ΡΠΎΡΡΠΈΡΠΎΠ²ΠΊΠΈ!');
end;
procedure TForm5. SpeedButton1Click (Sender: TObject);
begin.
Form5.Close;
end;
procedure TForm5. FormActivate (Sender: TObject);
begin.
k1:=0;
While not DataModule2. ADOQuery1. Eof do.
begin.
if DataModule2. ADOQuery1.Fields[1]. AsBoolean=true Then k:=1;
DataModule2.ADOQuery1.Next;
end;
if k1=1 then ComboBox1. Text:='';
if k1=0 Then ComboBox1. Text:='Π½Π΅Ρ';
end;
end.
Π€ΠΎΡΠΌΠ° Π ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ΅.
unit Unit6;
interface.
uses Windows, SysUtils, Classes, Graphics, Forms, Controls, StdCtrls,.
Buttons, ExtCtrls;
type.
TAboutBox = class (Tform).
Panel1: Tpanel;
ProgramIcon: Timage;
ProductName: Tlabel;
Version: Tlabel;
Copyright: Tlabel;
Comments: Tlabel;
OKButton: Tbutton;
procedure OKButtonClick (Sender: Tobject);
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
AboutBox: TaboutBox;
implementation.
{$R *.dfm}.
procedure TaboutBox. OKButtonClick (Sender: Tobject);
begin.
AboutBox.Close;
end;
end.
Π€ΠΎΡΠΌΠ° ΠΠΠΠΠ’Π.
unit Unit7;
interface.
uses.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,.
Dialogs, Grids, DBGrids, DBCtrls, ExtCtrls;
type.
TForm7 = class (TForm).
Panel1: TPanel;
Splitter1: TSplitter;
Panel2: TPanel;
DBNavigator1: TDBNavigator;
DBGrid1: TDBGrid;
private.
{ Private declarations }.
public.
{ Public declarations }.
end;
var.
Form7: TForm7;
implementation.
uses Unit2;
{$R *.dfm}.
end.
ΠΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ Π
ΠΠ½ΡΠ΅ΡΡΠ΅ΠΉΡ ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΡ
Π ΠΈΡΡΠ½ΠΎΠΊ 6. ΠΠ»Π°Π²Π½Π°Ρ ΡΠΎΡΠΌΠ°.
Π ΠΈΡΡΠ½ΠΎΠΊ 7. ΠΠΊΠ½ΠΎ ΠΠΠ‘ΠΠΠΠΠΠ.
Π ΠΈΡΡΠ½ΠΎΠΊ 8. ΠΠΊΠ½ΠΎ ΠΊΠ»ΠΈΠ΅Π½ΡΡ.
Π ΠΈΡΡΠ½ΠΎΠΊ 9. ΠΠΊΠ½ΠΎ ΠΠΠΠΠ Π.
Π ΠΈΡΡΠ½ΠΎΠΊ 10. ΠΠΊΠ½ΠΎ ΠΠΠΠΠ’Π.
Π ΠΈΡΡΠ½ΠΎΠΊ 11. ΠΠΊΠ½ΠΎ Π ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ΅.