ugysxx_z.pas

来自「一个比较实用的仓库管理系统,Delphi+SQL开发」· PAS 代码 · 共 97 行

unit UGYSXX_Z;

interface

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

type
  TGYSXX_Z = class(TForm)
    ToolBar1: TToolBar;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    DBNavigator1: TDBNavigator;
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton1Click(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
  GYSXX_Z: TGYSXX_Z;

implementation

uses UGYSXX, UDM, UMAIN;

{$R *.dfm}

procedure TGYSXX_Z.FormCreate(Sender: TObject);
begin      //创建窗体时，打开数据表
  with DM.QGYSXX do
  begin
    close;
    sql.Clear;
    sql.Add('select * from 供应商基本信息');
    open;
  end;
  dm.DSOGYSXX.Open;
end;

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

procedure TGYSXX_Z.SpeedButton1Click(Sender: TObject);
begin
  Application.CreateForm(TGYSXX,GYSXX);
  GYSXX.GetAll;
  ActionCD:='M';
  GYSXX.ShowModal;
  GYSXX.Free;
end;

procedure TGYSXX_Z.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  DM.QGYSXX.Close;
  DM.DSOGYSXX.Close;
end;

procedure TGYSXX_Z.DBGrid1DblClick(Sender: TObject);
begin
  Application.CreateForm(TGYSXX,GYSXX);
  GYSXX.GetAll;
  ActionCD:='M';
  GYSXX.ShowModal;
  GYSXX.Free;
end;

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

end.