bm_shoujiu.pas

DELPHI办公全套管理系统

unit BM_SHOUJIU;

interface

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

type
  TBM_SHOUJIF = class(TForm)
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    SpeedButton1: TSpeedButton;
    Label1: TLabel;
    Label2: TLabel;
    Edit2: TEdit;
    SpeedButton2: TSpeedButton;
    A_shouji: TADOQuery;
    D_shouji: TDataSource;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  BM_SHOUJIF: TBM_SHOUJIF;

implementation

uses BM_DMU;

{$R *.dfm}

procedure TBM_SHOUJIF.SpeedButton1Click(Sender: TObject);
VAR  sql1:string;
begin
  sql1:='select * from 手机 ';

   if  edit1.Text <>'' then
   begin
     sql1:=sql1+'where CODE LIKE"%'+edit1.Text +'%"';
     if  edit2.Text <>'' then  sql1:=sql1+' and city LIKE"%'+edit2.Text +'%"';
   end
   else
   if edit2.Text <>'' then  sql1:=sql1+' where city LIKE"%'+edit2.Text +'%"';



    with A_shouji do
                  begin
                  close;
                  sql.Clear ;
                  sql.Add(sql1);
                  Open ;
                 // bm_OFFICEF.StatusBar1.SimpleText :='共有'+ inttostr(A_shouji.recordcount) +'条记录!';;
              end;
end;

procedure TBM_SHOUJIF.SpeedButton2Click(Sender: TObject);
begin
CLOSE;
end;

procedure TBM_SHOUJIF.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

procedure TBM_SHOUJIF.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
IF KEY=#13 THEN SpeedButton1.Click ;
end;

procedure TBM_SHOUJIF.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
IF KEY=#13 THEN SpeedButton1.Click ;
end;

end.