pdqd1.pas

来自「思微POS连锁超市管理系统 (商业代码),几年前的东西了」· PAS 代码 · 共 72 行

unit pdqd1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ExtCtrls, StdCtrls, Buttons, ComCtrls, Db, DBTables, ADODB;

type
  Tpdqd = class(TForm)
    Bevel1: TBevel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Label4: TLabel;
    Query1: TADOQuery;
    procedure BitBtn2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  pdqd: Tpdqd;

implementation

uses MainForm1;

{$R *.DFM}

procedure Tpdqd.BitBtn2Click(Sender: TObject);
begin
  close;
end;

procedure Tpdqd.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  action := cafree;
end;

procedure Tpdqd.BitBtn1Click(Sender: TObject);
begin
  Query1.close;
  Query1.sql.clear;
  Query1.sql.add('delete from SPSJ001');
  Query1.ExecSQL;
  Query1.close;
  Query1.sql.clear;
  Query1.sql.add('delete from pdykb');
  Query1.ExecSQL;
  Query1.close;
  Query1.sql.clear;
  Query1.sql.add('delete from pdzcb');
  Query1.ExecSQL;
  try
    Query1.close;
    Query1.sql.clear;
    Query1.sql.add('insert into pdzcb select ckcode,spcode,kcsl from spkcda');
    Query1.ExecSQL;
    Application.MessageBox('盘点清单建立成功.', '提示', MB_OK + MB_ICONASTERISK);
    close;
  except
    Application.MessageBox('出现异常.', '错误', MB_OK + MB_ICONERROR);
    exit;
  end;
end;

end.