unit7.pas

数据库编程 人事档案管理

unit Unit7;

interface

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

type
  TForm7 = class(TForm)
    Query1: TQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    R1: TRadioGroup;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;

implementation

{$R *.dfm}

procedure TForm7.Button2Click(Sender: TObject);
begin
close;
end;

procedure TForm7.Button1Click(Sender: TObject);
begin
case r1.ItemIndex of
0:begin
if length(trim(edit1.Text))=0 then
begin
showmessage('');
edit1.SetFocus ;
end;
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from 出库单');
sql.Add('where 商品名称=:id');
ParamByName('id').asstring:=edit1.text ;
prepare;
open;
end;
end;
 end;
 
end;

end.