【delphi开源代码栏目提醒】:本文主要为网学会员提供forrep.pas,希望对需要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.