umadstockinorder.pas

Software Requirements1. Delphi 6 SP22. Oracle 8i R33. Raize 3.0.94. ExpressQuantumGrid 4.505. Expres

unit UMADStockInOrder;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, UAdapterDataModel, Provider, OraProvider, MemDS, DBAccess, Ora,
  OraSmart, DB, DBClient,
  MyFactory, UModel, MyTools;

type
  TMADStockInOrder = class(TAdapterDataModel)
    DataSetSTOCKINORDERID: TFloatField;
    DataSetCHECKINDATE: TDateTimeField;
    DataSetTOTAL: TFloatField;
    DataSetMEMO: TStringField;
    DataSetISAPPROVE: TIntegerField;
    DataSetAPPROVEDATE: TDateTimeField;
    DataSetCREATED: TDateTimeField;
    DataSetUPDATED: TDateTimeField;
    DataSetAPPROVEBY: TFloatField;
    DataSetCREATEBY: TFloatField;
    DataSetUPDATEBY: TFloatField;
    SPCheckIn: TOraStoredProc;
  private
    { Private declarations }
  public
    function GetKey: IKey; override;
    procedure Save(Parameters: IParameters); override;
    procedure CheckIn(Parameters: IParameters); virtual;
  end;
  
  TStockinorderFactory = class(TModelFactory)
    function NewModel: TModel; override;
  end;

implementation

uses UMPDatabase;
{$R *.dfm}

{ TMADStockinorderFactory }

function TStockInOrderFactory.NewModel: TModel;
begin
  Result :=  TMADStockInOrder.Create(GetOwner);
end;

{ TMADStockInOrder }

procedure TMADStockInOrder.CheckIn(Parameters: IParameters);
begin
  if not GetDataSet.Active or GetDataSet.IsEmpty then Exit;
  SPCheckIn.ParamByName('L_STOCKINORDERID').AsInteger := GetDataSet.FieldByName('STOCKINORDERID').AsInteger;
  try
    SPCheckIn.Execute;
    DataSet.Close;
    DataSet.Open;
  except
    on E: Exception do
      ShowMessage('发生错误,原因如:' + #10 + E.Message);
  end;
end;

function TMADStockInOrder.GetKey: IKey;
begin
  Result := NewKey('StockInOrderID');
end;

procedure TMADStockInOrder.Save(Parameters: IParameters);
begin
  inherited;
end;

end.