searchbooklist.pas

现在家庭藏书越来越多

unit searchbooklist;

interface

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

type
  TForm6 = class(TForm)
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    Label1: TLabel;
    ComboBox1: TComboBox;
    Label2: TLabel;
    Edit1: TEdit;
    Label3: TLabel;
    Edit2: TEdit;
    Label4: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Edit4: TEdit;
    Button1: TButton;
    Button2: TButton;
    procedure FormCreate(Sender: TObject);
    procedure FormDestroy(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form6: TForm6;
  booklist6:tbooklist;
implementation
uses
main;
{$R *.dfm}

procedure TForm6.FormCreate(Sender: TObject);
begin
 booklist6:=tbooklist.create;
 booklist6.connect.adoquery:=adoquery1;
 booklist6.connect.datasource2:=datasource1;
 booklist6.connect.dbgrid:=dbgrid1;
 booklist6.connect.doconnection;
 booklist6.connect.displayquery;
 booklist6.displaybookdbgrid(dbgrid1);
end;

procedure TForm6.FormDestroy(Sender: TObject);
begin
 booklist6.Free;
 booklist6:=nil;
end;

procedure TForm6.Button1Click(Sender: TObject);
begin
 if booklist6.searchdetailbook(trim(combobox1.Text),trim(edit1.Text),trim(edit2.Text),trim(edit3.Text),trim(edit4.Text)) then
   messagedlg('共找到'+inttostr(booklist6.connect.adoquery.RecordCount)+'记录',mtinformation ,[mbok],0)
 else
   messagedlg('未找到您想要的数据！',mtinformation,[mbok],0);
end;

procedure TForm6.Button2Click(Sender: TObject);
begin
close;
end;

end.