dbdwxx.pas

来自「本系统前端界面采用WINDOWS 窗口风格」· PAS 代码 · 共 77 行

unit dbdwxx;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Grids, DBGrids, Buttons, Db, DBTables;

type
  TFrmdbdwxx = class(TForm)
    DBGrid1: TDBGrid;
    Label1: TLabel;
    bm_Edit: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Query_dbdw: TQuery;
    DataSource_dbdw: TDataSource;
    Database: TDatabase;
    procedure FormCreate(Sender: TObject);
    procedure bm_EditChange(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frmdbdwxx: TFrmdbdwxx;

implementation

uses  main;

{$R *.DFM}

procedure TFrmdbdwxx.FormCreate(Sender: TObject);
begin
  Query_dbdw.close;
  Query_dbdw.UnPrepare;
  Query_dbdw.sql.Clear;
  Query_dbdw.sql.Add('select * from dbdwb');
  Query_dbdw.Prepare;
  Query_dbdw.open;
end;

procedure TFrmdbdwxx.bm_EditChange(Sender: TObject);
begin
  Query_dbdw.close;
  Query_dbdw.UnPrepare;
  Query_dbdw.sql.Clear;
  Query_dbdw.sql.Add('select * from dbdwb');
  Query_dbdw.sql.Add(' where kh_bm like'+''''+bm_edit.Text+'%'+'''');
  Query_dbdw.Prepare;
  Query_dbdw.open;
end;

procedure TFrmdbdwxx.BitBtn1Click(Sender: TObject);
begin
  Frmmain.pubedit.Text:=Query_dbdw.FieldByName('kh_mc').asstring;
  Self.Close;
end;

procedure TFrmdbdwxx.BitBtn2Click(Sender: TObject);
begin
  Self.Close;
end;

procedure TFrmdbdwxx.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=CaFree;
end;

end.