?? unit4.pas
字號:
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.
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -