umadsiomaterialdetail.pas

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

unit UMADSIOMaterialDetail;

interface

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

type
  TMADSIOMaterialDetail = class(TQueryDataModel)
    DataSetSIOMATERIALDETAILID: TFloatField;
    DataSetMATURITY: TDateTimeField;
    DataSetPRODUCED: TDateTimeField;
    DataSetPSN: TStringField;
    DataSetPRICE: TFloatField;
    DataSetSPRICE: TFloatField;
    DataSetAMOUNT: TFloatField;
    DataSetTOTAL: TFloatField;
    DataSetSTOCKINORDERID: TFloatField;
    DataSetPOMATERIALDETAILID: TFloatField;
    DataSetMANUFACTURERID: TFloatField;
    DataSetPROVIDERID: TFloatField;
    DataSetMATERIALID: TFloatField;
  private
    StockInOrderID : IIntegerKey;
   protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
  end;

  TSIOMaterialDetailFactory = class(TModelFactory)
    function NewModel: TModel; override;
  end;

implementation

uses UMPDatabase;

{$R *.dfm}

{ TMADSIOMaterialDetailFactory }

function TSIOMaterialDetailFactory.NewModel: TModel;
begin
  Result := TMADSIOMaterialDetail.Create(GetOwner);
end;

{ TMADSIOMaterialDetail }

procedure TMADSIOMaterialDetail.Append(Parameters: IParameters);
begin
  inherited;
   GetDataSet.FieldByName('StockInOrderID').AsInteger := StockInOrderID.GetKey;
end;

procedure TMADSIOMaterialDetail.PrepareQuery(Parameters: IQueryParameters);
begin
  DataSet.ParamByName('StockInOrderID').AsInteger := IIntegerKey(Parameters).GetKey;
  StockInOrderID := IIntegerKey(Parameters);
end;

end.