cai_jue.~pas

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

unit cai_jue;

interface

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

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

var
  cai_ju: Tcai_ju;

implementation

{$R *.dfm}

procedure Tcai_ju.FormCreate(Sender: TObject);
begin
//query1.Active:=false;
//query1.SQL.Clear;
//query1.SQL.Add('select ding_gou_no from shou_huo_wei_zhu where yes_or_no_shou_ji=:uu ');
//query1.ParamByName('uu').AsString:='琌';
//query1.Prepare;
//query1.Active:=true;
end;

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

procedure Tcai_ju.Database1Login(Database: TDatabase;
  LoginParams: TStrings);
begin
Database1.Params:= LoginParams;
end;

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

procedure Tcai_ju.BitBtn1Click(Sender: TObject);
var xx:string;
begin
xx:=DBGrid1.SelectedField.AsString;
table1.Active:=false;
table1.IndexFieldNames:='ding_gou_no';
table1.Active:=true;
if table1.FindKey([xx]) then
begin
if MessageDlg('