unit Unit4;

interface

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

type
  Tghts = class(TForm)
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Button1: TButton;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Label6: TLabel;
    Label7: TLabel;
    Edit5: TEdit;
    Edit6: TEdit;
    Button2: TButton;
    BitBtn1: TBitBtn;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ghts: Tghts;

implementation

{$R *.dfm}

procedure Tghts.Button1Click(Sender: TObject);
begin
close
end;

procedure Tghts.Button2Click(Sender: TObject);
var a,b,c,d,e:string;
begin
a:=edit1.Text+'%';
b:=edit2.Text+'%';
c:=edit3.Text+'%';
d:=edit4.Text+'%';
e:='借出';
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select tsbm.sh,tsbm.sm,dzmc.jszh,dzmc.xm,tsjy.jcrq from tsbm,dzmc,tsjy');
sql.Add('where (tsbm.sh=tsjy.sh) and(dzmc.jszh=tsjy.jszh)and (tsjy.jcbz=:en)and (tsbm.sh like :an)and(tsbm.sm like :bn)and(dzmc.jszh like :cn)and(dzmc.xm like :dn)');
sql.Add('order by tsbm.sh');
parameters.ParamByName('an').Value:=a;
Parameters.ParamByName('bn').Value:=b;
parameters.ParamByName('cn').Value:=c;
Parameters.ParamByName('dn').Value:=d;
parameters.ParamByName('en').Value:=e;
prepared;
open;
end;
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';


end;

procedure Tghts.BitBtn1Click(Sender: TObject);
var a,b,c,d,e:string;
begin
a:=edit5.Text;
b:='';
c:='';
d:='借出';
e:='在庫';
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('update tsjy');
sql.Add('set jcbz=:en,jszh =:bn,jcrq =:cn');
sql.Add('where sh=:an');
Parameters.ParamByName('an').Value:=a;
Parameters.ParamByName('cn').Value:=c;
Parameters.ParamByName('bn').Value:=b;
Parameters.ParamByName('en').Value:=e;
prepared;
ExecSQL;
end;
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select tsbm.sh,tsbm.sm,dzmc.jszh,dzmc.xm,tsjy.jcrq from tsbm,dzmc,tsjy');
sql.Add('where (tsbm.sh=tsjy.sh) and (tsjy.jcbz=:dn)');
sql.Add('order by tsbm.sh');
parameters.ParamByName('dn').value:=d;
prepared;
open;
end;
edit5.Text:='';
edit6.Text:='';
end;
procedure Tghts.DBGrid1CellClick(Column: TColumn);
begin
edit5.Text:=dbgrid1.Fields[0].AsString;
edit6.Text:=dbgrid1.Fields[2].AsString;
end;

end.