unit2.pas

一个很不错的仓库管理系统,能容进各种软件中去,

unit Unit2;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, TEMPLETFORM, ADODB, DB, Grids, DBGrids, NewDBGrid, StdCtrls,
  Menus, ComCtrls, ToolWin, ExtCtrls;

type
  TTEMPLETF2 = class(TTEMPLETF)
    Button1: TButton;
    NewDBGrid1: TNewDBGrid;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    ADOQuery1a: TStringField;
    ADOQuery1b: TStringField;
    ADOQuery1c: TStringField;
    ADOQuery1d: TStringField;
    ADOQuery1e: TStringField;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    ADOTable1: TADOTable;
    DataSource3: TDataSource;
    proc: TADOStoredProc;
    Edit1: TEdit;
    procedure ADOQuery1BeforePost(DataSet: TDataSet);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  TEMPLETF2: TTEMPLETF2;

implementation

{$R *.dfm}

procedure TTEMPLETF2.ADOQuery1BeforePost(DataSet: TDataSet);
begin
  inherited;
adoquery1.FieldByName('e').AsString:='aaa';
end;

procedure TTEMPLETF2.FormShow(Sender: TObject);
begin
  inherited;
with proc do   //生成一个新的单号
begin
parameters.ParamByName('@name').Value:='goodsin';
execproc;
edit1.text:=parameters.ParamByName('@value').Value
end;

adoquery1.Open;


end;

end.