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 商品数量=商品数量+: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.