unit11.pas

药房管理程序实现药房的基本管理功能

unit Unit11;

interface

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

type
  Tjsgl_form = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    cmdclose: TButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Edit1: TEdit;
    DBGrid2: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    DataSource2: TDataSource;
    procedure Edit1Change(Sender: TObject);
    procedure cmdcloseClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jsgl_form: Tjsgl_form;

implementation

{$R *.dfm}

procedure Tjsgl_form.Edit1Change(Sender: TObject);
var
    bh,sqlstr:string;
begin

    bh:=Edit1.Text;

    sqlstr:='select 图书编号,数量,单价  from 图书销售 where (编号='''+bh+''')';
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add(sqlstr);
    ADOQuery1.Open;

end;

procedure Tjsgl_form.cmdcloseClick(Sender: TObject);
begin
close;
end;

end.