qing_pi.~pas

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

unit qing_pi;

interface

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

type
  Tqing_p = class(TForm)
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DataSource1: TDataSource;
    Table1: TTable;
    Label1: TLabel;
    Button4: TButton;
    Table2: TTable;
    Query1: TQuery;
    Button5: TButton;
    Query2: TQuery;
    GroupBox1: TGroupBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure RadioButton1Click(Sender: TObject);
    procedure RadioButton2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qing_p: Tqing_p;

implementation
uses qing_pi_liu;
{$R *.dfm}

procedure Tqing_p.Button3Click(Sender: TObject);
begin
close;
end;

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

procedure Tqing_p.Button1Click(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
table1.Edit;
table1.FieldByName('yes_or_no').AsString:='琌';
table1.FieldByName('pi_zhen_ren').AsString:=label1.Caption;
table1.Post;
showmessage('虫腹