ghs.pas

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

unit ghs;

interface

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

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

var
  Frmghs: TFrmghs;

implementation

uses  main;

{$R *.DFM}

procedure TFrmghs.Edit_bmChange(Sender: TObject);
begin
  Query_ghs.close;
  Query_ghs.UnPrepare;
  Query_ghs.sql.Clear;
  Query_ghs.sql.Add('select * from ghsxxb');
  Query_ghs.sql.Add(' where ghs_bm like '+''''+Edit_bm.text+'%'+'''');
  Query_ghs.Prepare;
  Query_ghs.open;
end;

procedure TFrmghs.FormCreate(Sender: TObject);
begin
  Query_ghs.close;
  Query_ghs.UnPrepare;
  Query_ghs.sql.Clear;
  Query_ghs.sql.Add('select * from ghsxxb');
  Query_ghs.Prepare;
  Query_ghs.open;
end;

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

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

procedure TFrmghs.BitBtn1Click(Sender: TObject);
begin
  Frmmain.pubedit.Text:=Query_ghs.FieldByName('ghs_mc').asstring;
  Self.Close;
end;

end.