📄 checkf.pas
字号:
unit CheckF;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
Db, DBTables, StdCtrls, Mask, DBCtrls, ExtCtrls, Grids, DBGrids, ComCtrls;
type
TDbaForm = class(TForm)
Table1: TTable;
DataSource1: TDataSource;
Table1LastName: TStringField;
Table1FirstName: TStringField;
Table1Department: TSmallintField;
Table1Branch: TStringField;
Table1Senior: TBooleanField;
Table1HireDate: TDateField;
DBGrid1: TDBGrid;
DBCheckBox1: TDBCheckBox;
procedure FormCreate(Sender: TObject);
procedure Table1DepartmentGetText(Sender: TField; var Text: String;
DisplayText: Boolean);
procedure Table1DepartmentSetText(Sender: TField; const Text: String);
procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
DataCol: Integer; Column: TColumn; State: TGridDrawState);
procedure DBGrid1ColEnter(Sender: TObject);
procedure DBGrid1KeyPress(Sender: TObject; var Key: Char);
private
{ Private declarations }
end;
var
DbaForm: TDbaForm;
implementation
{$R *.DFM}
procedure TDbaForm.FormCreate(Sender: TObject);
begin
if not Table1.Exists then
begin
Table1.CreateTable;
ShowMessage ('You can add data to this table'#13 +
'by using the DbAware example of Chapter 11');
end;
Table1.Open;
end;
procedure TDbaForm.Table1DepartmentGetText(Sender: TField;
var Text: String; DisplayText: Boolean);
begin
case Sender.AsInteger of
1: Text := 'Sales';
2: Text := 'Accounting';
3: Text := 'Production';
4: Text := 'Management';
else
Text := '[Error]';
end;
end;
procedure TDbaForm.Table1DepartmentSetText(Sender: TField;
const Text: String);
begin
if Text = 'Sales' then
Sender.Value := 1
else if Text = 'Accounting' then
Sender.Value := 2
else if Text = 'Production' then
Sender.Value := 3
else if Text = 'Management' then
Sender.Value := 4
else
raise Exception.Create ('Error in Department field conversion');
end;
procedure TDbaForm.DBGrid1DrawColumnCell(Sender: TObject;
const Rect: TRect; DataCol: Integer; Column: TColumn;
State: TGridDrawState);
begin
if (gdFocused in State) and
(Column.Field = Table1Senior) then
begin
DBCheckBox1.SetBounds (
Rect.Left + DBGrid1.Left + 1,
Rect.Top + DBGrid1.Top + 1,
Rect.Right - Rect.Left,
Rect.Bottom - Rect.Top);
end;
end;
procedure TDbaForm.DBGrid1ColEnter(Sender: TObject);
begin
if DBGrid1.Columns [DBGrid1.SelectedIndex].
Field = Table1Senior then
DBCheckBox1.Visible := True
else
DBCheckBox1.Visible := False;
end;
procedure TDbaForm.DBGrid1KeyPress(Sender: TObject; var Key: Char);
begin
if DBCheckBox1.Visible and (Ord (Key) > 31) then
begin
Key := #0;
DBCheckBox1.Checked := not
DBCheckBox1.Checked;
end;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -