dan_jia_wei.~pas

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

unit dan_jia_wei;

interface

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

type
  Tdan_jia_we = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    Label7: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton3: TSpeedButton;
    Label9: TLabel;
    SpeedButton4: TSpeedButton;
    DBGrid1: TDBGrid;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBNavigator1: TDBNavigator;
    DBEdit8: TDBEdit;
    DBEdit5: TDBEdit;
    Table1: TTable;
    DataSource1: TDataSource;
    Table2: TTable;
    Query1: TQuery;
    PopupMenu1: TPopupMenu;
    N2: TMenuItem;
    N3: TMenuItem;
    SpeedButton2: TSpeedButton;
    DBEdit4: TDBEdit;
    Table3: TTable;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBEdit8KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton4Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure Table1AfterScroll(DataSet: TDataSet);
    procedure N3Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure DBEdit8Exit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dan_jia_we: Tdan_jia_we;

implementation

{$R *.dfm}

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

procedure Tdan_jia_we.DBEdit8KeyPress(Sender: TObject; var Key: Char);
begin
if key=chr(13) then
DBNavigator1.SetFocus;
end;

procedure Tdan_jia_we.SpeedButton4Click(Sender: TObject);
var xx:string;
begin
table1.Active:=false;
table1.IndexFieldNames:='fmno';
table1.Active:=true;
xx:=inputbox('叫块