1 | unit UFormDatabases;
|
---|
2 |
|
---|
3 | interface
|
---|
4 |
|
---|
5 | uses
|
---|
6 | Classes, SysUtils, FileUtil, Forms, Controls, Graphics, Dialogs, ComCtrls,
|
---|
7 | Menus, ActnList, UDatabase;
|
---|
8 |
|
---|
9 | type
|
---|
10 |
|
---|
11 | { TFormDatabases }
|
---|
12 |
|
---|
13 | TFormDatabases = class(TForm)
|
---|
14 | AAdd: TAction;
|
---|
15 | AOpen: TAction;
|
---|
16 | AModify: TAction;
|
---|
17 | ARemove: TAction;
|
---|
18 | ActionList1: TActionList;
|
---|
19 | ListView1: TListView;
|
---|
20 | MenuItem1: TMenuItem;
|
---|
21 | MenuItem2: TMenuItem;
|
---|
22 | MenuItem3: TMenuItem;
|
---|
23 | MenuItem4: TMenuItem;
|
---|
24 | PopupMenu1: TPopupMenu;
|
---|
25 | ToolBar1: TToolBar;
|
---|
26 | ToolButton1: TToolButton;
|
---|
27 | ToolButton2: TToolButton;
|
---|
28 | ToolButton3: TToolButton;
|
---|
29 | ToolButton4: TToolButton;
|
---|
30 | procedure AAddExecute(Sender: TObject);
|
---|
31 | procedure AModifyExecute(Sender: TObject);
|
---|
32 | procedure AOpenExecute(Sender: TObject);
|
---|
33 | procedure ARemoveExecute(Sender: TObject);
|
---|
34 | procedure FormShow(Sender: TObject);
|
---|
35 | procedure ListView1Data(Sender: TObject; Item: TListItem);
|
---|
36 | procedure ListView1DblClick(Sender: TObject);
|
---|
37 | procedure ListView1SelectItem(Sender: TObject; Item: TListItem;
|
---|
38 | Selected: Boolean);
|
---|
39 | public
|
---|
40 | SelectedProfile: TDbConnectProfile;
|
---|
41 | procedure ReloadList;
|
---|
42 | procedure UpdateInterface;
|
---|
43 | end;
|
---|
44 |
|
---|
45 |
|
---|
46 | implementation
|
---|
47 |
|
---|
48 | {$R *.lfm}
|
---|
49 |
|
---|
50 | uses
|
---|
51 | UCore, UFormConnect;
|
---|
52 |
|
---|
53 | resourcestring
|
---|
54 | SRemoveDatabaseConnection = 'Remove database connection';
|
---|
55 | SRemoveDatabaseConnectionQuery = 'Do you want to really remove database connection %s?';
|
---|
56 | SNewDatabase = 'New database';
|
---|
57 |
|
---|
58 | { TFormDatabases }
|
---|
59 |
|
---|
60 | procedure TFormDatabases.ListView1DblClick(Sender: TObject);
|
---|
61 | begin
|
---|
62 | AOpen.Execute;
|
---|
63 | end;
|
---|
64 |
|
---|
65 | procedure TFormDatabases.AOpenExecute(Sender: TObject);
|
---|
66 | begin
|
---|
67 | if Assigned(ListView1.Selected) then begin
|
---|
68 | SelectedProfile := TDbConnectProfile(ListView1.Selected.Data);
|
---|
69 | ModalResult := mrOk;
|
---|
70 | end;
|
---|
71 | end;
|
---|
72 |
|
---|
73 | procedure TFormDatabases.ARemoveExecute(Sender: TObject);
|
---|
74 | begin
|
---|
75 | if Assigned(ListView1.Selected) then begin
|
---|
76 | if MessageDlg(SRemoveDatabaseConnection, Format(SRemoveDatabaseConnectionQuery, [
|
---|
77 | TDbConnectProfile(ListView1.Selected.Data).Name]), mtConfirmation, [mbYes, mbNo], 0) = mrYes then begin
|
---|
78 | Core.DbManager.ConnectProfiles.Remove(ListView1.Selected.Data);
|
---|
79 | ReloadList;
|
---|
80 | end;
|
---|
81 | end;
|
---|
82 | end;
|
---|
83 |
|
---|
84 | procedure TFormDatabases.AAddExecute(Sender: TObject);
|
---|
85 | var
|
---|
86 | NewConnectProfile: TDbConnectProfile;
|
---|
87 | begin
|
---|
88 | NewConnectProfile := TDbConnectProfile.Create;
|
---|
89 | NewConnectProfile.Name := SNewDatabase;
|
---|
90 | with TFormConnect.Create(nil) do
|
---|
91 | try
|
---|
92 | Load(NewConnectProfile);
|
---|
93 | if ShowModal = mrOk then begin
|
---|
94 | Save(NewConnectProfile);
|
---|
95 | Core.DbManager.ConnectProfiles.Add(NewConnectProfile);
|
---|
96 | ReloadList;
|
---|
97 | end else NewConnectProfile.Free;
|
---|
98 | finally
|
---|
99 | Free;
|
---|
100 | end;
|
---|
101 | end;
|
---|
102 |
|
---|
103 | procedure TFormDatabases.AModifyExecute(Sender: TObject);
|
---|
104 | begin
|
---|
105 | if Assigned(ListView1.Selected) then begin
|
---|
106 | with TFormConnect.Create(nil) do
|
---|
107 | try
|
---|
108 | Load(TDbConnectProfile(ListView1.Selected.Data));
|
---|
109 | if ShowModal = mrOk then begin
|
---|
110 | Save(TDbConnectProfile(ListView1.Selected.Data));
|
---|
111 | ReloadList;
|
---|
112 | end;
|
---|
113 | finally
|
---|
114 | Free;
|
---|
115 | end;
|
---|
116 | end;
|
---|
117 | end;
|
---|
118 |
|
---|
119 | procedure TFormDatabases.FormShow(Sender: TObject);
|
---|
120 | var
|
---|
121 | I: Integer;
|
---|
122 | begin
|
---|
123 | for I := 0 to ToolBar1.ButtonCount - 1 do
|
---|
124 | ToolBar1.Buttons[I].Hint := ToolBar1.Buttons[I].Caption;
|
---|
125 | ReloadList;
|
---|
126 | end;
|
---|
127 |
|
---|
128 | procedure TFormDatabases.ListView1Data(Sender: TObject; Item: TListItem);
|
---|
129 | begin
|
---|
130 | if (Item.Index >= 0) and (Item.Index < Core.DbManager.ConnectProfiles.Count) then
|
---|
131 | with TDbConnectProfile(Core.DbManager.ConnectProfiles[Item.Index]) do begin
|
---|
132 | Item.Caption := Name;
|
---|
133 | Item.SubItems.Add(ClientType.Name);
|
---|
134 | Item.SubItems.Add(Params.ConnectionString);
|
---|
135 | Item.Data := Core.DbManager.ConnectProfiles[Item.Index];
|
---|
136 | end
|
---|
137 | end;
|
---|
138 |
|
---|
139 | procedure TFormDatabases.ListView1SelectItem(Sender: TObject; Item: TListItem;
|
---|
140 | Selected: Boolean);
|
---|
141 | begin
|
---|
142 | UpdateInterface;
|
---|
143 | end;
|
---|
144 |
|
---|
145 | procedure TFormDatabases.ReloadList;
|
---|
146 | begin
|
---|
147 | ListView1.Items.Count := Core.DbManager.ConnectProfiles.Count;
|
---|
148 | ListView1.Repaint;
|
---|
149 | UpdateInterface;
|
---|
150 | end;
|
---|
151 |
|
---|
152 | procedure TFormDatabases.UpdateInterface;
|
---|
153 | begin
|
---|
154 | AModify.Enabled := Assigned(ListView1.Selected);
|
---|
155 | ARemove.Enabled := Assigned(ListView1.Selected);
|
---|
156 | AOpen.Enabled := Assigned(ListView1.Selected);
|
---|
157 | end;
|
---|
158 |
|
---|
159 | end.
|
---|
160 |
|
---|