?? unit3.~pas
字號:
unit Unit3;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, DBTables, DBCtrls, Mask;
type
TForm3 = class(TForm)
Label1: TLabel;
Label2: TLabel;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Button1: TButton;
Button2: TButton;
Label6: TLabel;
Table1: TTable;
DataSource1: TDataSource;
DBEdit1: TDBEdit;
DBComboBox1: TDBComboBox;
DBComboBox2: TDBComboBox;
DBEdit2: TDBEdit;
DBEdit3: TDBEdit;
DBEdit4: TDBEdit;
Query1: TQuery;
Table2: TTable;
procedure Button1Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form3: TForm3;
implementation
{$R *.dfm}
procedure TForm3.Button1Click(Sender: TObject);
var
ii:integer;
spmc,dw:string;
begin
ii:=strtoint(dbedit2.Text);
spmc:=dbcombobox1.Text ;
dw:= dbcombobox2.Text ;
table1.Insert ;
table1.Post ;
query1.Close ;
query1.SQL.Clear ;
query1.SQL.Add('select 商品名稱 from 庫存總表 where 商品名稱=:ssp');
query1.ParamByName('ssp').Value :=spmc;
query1.Prepare ;
query1.Open ;
if spmc<>query1.Fields[0].Value then
begin
table2.Open ;
table2.appendRecord([spmc ,dw ,ii]);
end
else
begin
query1.Close ;
query1.SQL.Clear ;
query1.SQL.Add('update 庫存總表 ');
query1.SQL.Add ('set 商品數(shù)量=商品數(shù)量+:sl');
query1.SQL.add(' where 商品名稱=:sp');
query1.ParamByName('sp').Value :=spmc ;
query1.ParamByName('sl').Value :=ii ;
query1.Prepare ;
query1.ExecSQL ;
end;
end;
procedure TForm3.FormCreate(Sender: TObject);
begin
table1.Open ;
end;
procedure TForm3.Button2Click(Sender: TObject);
begin
close;
end;
end.
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -