kh.pas

来自「药品进销存管理系统(Delphi版),适合中小企业管理」· PAS 代码 · 共 77 行

unit kh;

interface

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

type
  TFrmkh = class(TForm)
    Label1: TLabel;
    Edit_bm: TEdit;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Query_khxx: TQuery;
    DataSource_khxx: TDataSource;
    Database: TDatabase;
    procedure BitBtn1Click(Sender: TObject);
    procedure Edit_bmChange(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frmkh: TFrmkh;

implementation

uses main;

{$R *.DFM}

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

procedure TFrmkh.Edit_bmChange(Sender: TObject);
begin
  Query_khxx.close;
  Query_khxx.UnPrepare;
  Query_khxx.sql.Clear;
  Query_khxx.sql.Add('select * from khxxb');
  Query_khxx.sql.Add(' where kh_bm like'+''''+edit_bm.Text+'%'+'''');
  Query_khxx.Prepare;
  Query_khxx.open;
end;

procedure TFrmkh.FormCreate(Sender: TObject);
begin
  Query_khxx.close;
  Query_khxx.UnPrepare;
  Query_khxx.sql.Clear;
  Query_khxx.sql.Add('select * from khxxb');
  Query_khxx.Prepare;
  Query_khxx.open;
end;

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

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

end.