qing_jue_dan.~pas

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

unit qing_jue_dan;

interface

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

type
  Tqing_jue_da = class(TForm)
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Query1: TQuery;
    DataSource1: TDataSource;
    Database1: TDatabase;
    Table1: TTable;
    Table2: TTable;
    DataSource2: TDataSource;
    Query2: TQuery;
    Table3: TTable;
    Table4: TTable;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qing_jue_da: Tqing_jue_da;

implementation

{$R *.dfm}

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

procedure Tqing_jue_da.FormCreate(Sender: TObject);
begin
query1.Active:=false;
query1.SQL.Clear;
query1.SQL.Add('select qing_gou_no from qing_gou_wei_zhu where yes_or_no=:uu ');
query1.ParamByName('uu').AsString:='琌';
query1.Prepare;
 query1.Active:=true;
end;

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