uspckxx_z.~pas

delphi 开发的完整的仓库管理系统（带数据库）

unit USPCKXX_Z;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, ExtCtrls, DBCtrls, Buttons, ToolWin, ComCtrls;

type
  TSPCKXX_Z = class(TForm)
    ToolBar1: TToolBar;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    DBNavigator1: TDBNavigator;
    DBGrid1: TDBGrid;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure SpeedButton2Click(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  SPCKXX_Z: TSPCKXX_Z;

implementation

uses UMAIN, UDM, USPCKXX;

{$R *.dfm}

procedure TSPCKXX_Z.SpeedButton1Click(Sender: TObject);
begin
  Application.CreateForm(TSPCKXX,SPCKXX);
  ActionCD:='M';
  SPCKXX.ShowModal;
  SPCKXX.Free;
end;

procedure TSPCKXX_Z.SpeedButton3Click(Sender: TObject);
begin
  Close;
end;

procedure TSPCKXX_Z.FormCreate(Sender: TObject);
begin                   //创建窗体时，打开数据库表
  with DM.QSPCKXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select * from 商品出库信息');
    Open;
  end;
  DM.DSOSPCKXX.Open;
end;

procedure TSPCKXX_Z.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  DM.QSPCKXX.Close;
  DM.DSOSPCKXX.Close;
end;

procedure TSPCKXX_Z.SpeedButton2Click(Sender: TObject);
begin                     //判断数据库中是否有记录
  if DM.QSPCKXX.RecordCount=0 then
  begin
    Application.MessageBox('已无记录可删除!','提示',0+MB_ICONINFORMATION);
    exit;
  end;
  if DM.DSOSPCKXX.IsEmpty then
    exit;
  if ID_YES=application.MessageBox('确实要删除这条记录吗？','提示',MB_YESNO) then
  begin
    DM.DSOSPCKXX.Delete;
  end;
end;

procedure TSPCKXX_Z.DBGrid1DblClick(Sender: TObject);
begin
  Application.CreateForm(TSPCKXX,SPCKXX);      //创建窗体
  ActionCD:='M';
  SPCKXX.GetAll;
  SPCKXX.ShowModal;
  SPCKXX.Free;
end;

end.