forrep.pas

信息管理系统

unit forrep;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB;

type
  Tforrepfrm = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    look_btn: TButton;
    cancel_btn: TButton;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    procedure cancel_btnClick(Sender: TObject);
    procedure look_btnClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  forrepfrm: Tforrepfrm;

implementation

uses wagerep;

{$R *.dfm}

procedure Tforrepfrm.cancel_btnClick(Sender: TObject);
begin
combobox1.Clear;combobox2.Clear;         //清空combobox2
adoquery1.Close;adoquery2.Close;         //关闭数据连接
forrepfrm.Close;                         //关闭数据报表
end;

procedure Tforrepfrm.look_btnClick(Sender: TObject);
begin
wagerepfrm.ADOQuery1.Close;               //查看符合条件的司机工资报表
wagerepfrm.ADOQuery1.SQL.Clear;
wagerepfrm.ADOQuery1.SQL.Add('select * from wage_info  '
+' where worker_id='''+combobox1.Text+''' and give_date='''+combobox2.Text+'''  ');
wagerepfrm.ADOQuery1.Open;

if   wagerepfrm.ADOQuery1.Eof  then           //如果记录不存在,向用户提示
begin
showmessage('对不起，该记录不存在，无法查看报表！');
exit;
end;
wagerepfrm.quickrep1.preview;
end;

end.