unit USPRKXX_Z;

interface

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

type
  TSPRKXX_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 DBGrid1DblClick(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  SPRKXX_Z: TSPRKXX_Z;

implementation

uses UDM, UMAIN, USPRKXX;

{$R *.dfm}

procedure TSPRKXX_Z.SpeedButton1Click(Sender: TObject);
begin
  Application.CreateForm(TSPRKXX,SPRKXX);
  ActionCD:='M';
  SPRKXX.GetAll;
  SPRKXX.ShowModal;
  SPRKXX.Free;
end;

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

procedure TSPRKXX_Z.FormCreate(Sender: TObject);
begin
  with DM.QSPRKXX do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select * from 商品入庫信息');
    Open;
  end;
  DM.DSOSPRKXX.Open;
end;

procedure TSPRKXX_Z.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  DM.QSPRKXX.Close;
  DM.DSOSPRKXX.Close;
end;

procedure TSPRKXX_Z.DBGrid1DblClick(Sender: TObject);
begin
  Application.CreateForm(TSPRKXX,SPRKXX);
  ActionCD:='M';
  SPRKXX.GetAll;
  SPRKXX.ShowModal;
  SPRKXX.Free;
end;

procedure TSPRKXX_Z.SpeedButton2Click(Sender: TObject);
begin
  if DM.QSPRKXX.RecordCount=0 then
  begin
    Application.MessageBox('已無記錄可刪除!','提示',0+MB_ICONINFORMATION);
    exit;
  end;
  if DM.DSOSPRKXX.IsEmpty then
    exit;
  if ID_YES=application.MessageBox('確實要刪除這條記錄嗎？','提示',MB_YESNO) then
  begin
    DM.DSOSPRKXX.Delete;
  end;
end;

end.