xing_jia_jue_dan.pas

采购管理系统：delphi+sql实现了企业采购自动化作业流程

unit xing_jia_jue_dan;

interface

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

type
  Txing_jia_jue_da = class(TForm)
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Table1: TTable;
    Table2: TTable;
    DataSource1: TDataSource;
    Table3: TTable;
    StoredProc1: TStoredProc;
    Database1: TDatabase;
    Table4: TTable;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure Database1Login(Database: TDatabase; LoginParams: TStrings);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  xing_jia_jue_da: Txing_jia_jue_da;

implementation

{$R *.dfm}

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

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

procedure Txing_jia_jue_da.BitBtn1Click(Sender: TObject);
var xx:string;
begin
xx:=DBGrid1.SelectedField.AsString;
table1.Active:=false;
table1.IndexFieldNames:='xing_jia_no';
table1.Active:=true;

if table1.FindKey([xx]) then
begin
if MessageDlg('