unit3.~pas

《Delphi案例设计》源代码

unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, DBCtrls, Grids, DBGrids, DB, DBTables, StdCtrls,
  Buttons;

type
  TForm3 = class(TForm)
    Label1: TLabel;
    Table1: TTable;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    Bevel1: TBevel;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TStringField;
    Table1BDEDesigner5: TStringField;
    Table1BDEDesigner6: TStringField;
    Table1BDEDesigner7: TCurrencyField;
    Table1BDEDesigner8: TCurrencyField;
    Table1BDEDesigner9: TCurrencyField;
    Table1BDEDesigner10: TCurrencyField;
    Table1BDEDesigner11: TCurrencyField;
    Table1BDEDesigner12: TCurrencyField;
    Table1BDEDesigner13: TCurrencyField;
    Table1BDEDesigner14: TCurrencyField;
    Table1BDEDesigner15: TCurrencyField;
    Table1BDEDesigner16: TCurrencyField;
    Table1BDEDesigner17: TCurrencyField;
    Table1BDEDesigner18: TCurrencyField;
    Table1BDEDesigner19: TCurrencyField;
    Table1BDEDesigner20: TCurrencyField;
    Table1BDEDesigner21: TCurrencyField;
    ComboBox1: TComboBox;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    SpeedButton1: TSpeedButton;
    Memo1: TMemo;
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

{$R *.dfm}

procedure TForm3.SpeedButton1Click(Sender: TObject);
var
bookmark1:tbookmark;
begin
table1.refresh;
with table1 do
try
  disablecontrols;
  filtered:=false;
  if ComboBox1.text='按个人工资号查询'  then memo1.Text:='个人工资号='+''''+edit1.Text+'''';
  if ComboBox1.text='按单位名称查询'  then memo1.Text:='单位名称='+''''+edit1.Text+'''';
  if ComboBox1.text='按职工姓名查询'  then memo1.Text:='职工姓名='+''''+edit1.Text+'''';
  if ComboBox1.text='按工资年份查询'  then memo1.Text:='工资年份='+''''+edit1.Text+'''';
  if ComboBox1.text='按工资月份查询'  then memo1.Text:='工资月份='+''''+edit1.Text+'''';
  filter:=memo1.text;
  filtered:=true;
finally
  enablecontrols;
if table1.recordcount=0 then begin
messagebeep(1);
showmessage('没有符合条件的记录,请确认条件或放弃查询!');
if messageDlg('是否继续查询？,只有结束查询才能作其它操作!',mtinformation,[mbYes,mbNo],0)=mrno then begin
  filtered:=false;
 table1.close;
 table1.open;
end;
end else begin
showmessage('记录已经找到！');
bookmark1:=table1.getbookmark;
end;
end;
end;

end.