unit4.~pas

数据库编程 人事档案管理

unit Unit4;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DBCtrls, Mask, DB, DBTables;

type
  TForm4 = class(TForm)
    Table1: TTable;
    Query1: TQuery;
    Label1: TLabel;
    DataSource1: TDataSource;
    DBEdit1: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}

procedure TForm4.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 ii>query1.Fields[1].Value then
begin
showmessage('库存数量不足，只有'+inttostr(query1.Fields[1].value));
dbedit2.SetFocus ;
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 TForm4.FormCreate(Sender: TObject);
begin
table1.Open;
end;

end.