unit UMADSIOMedicineDetail;

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
  TMADSIOMedicineDetail = class(TQueryDataModel)
    DataSetSIOMEDICINEDETAILID: TFloatField;
    DataSetPSN: TStringField;
    DataSetPRODUCED: TDateTimeField;
    DataSetMATURITY: TDateTimeField;
    DataSetSPRICE: TFloatField;
    DataSetPRICE: TFloatField;
    DataSetAMOUNT: TFloatField;
    DataSetTOTAL: TFloatField;
    DataSetSTOCKINORDERID: TFloatField;
    DataSetPOMEDICINEDETAILID: TFloatField;
    DataSetMANUFACTURERID: TFloatField;
    DataSetPROVIDERID: TFloatField;
    DataSetMEDICINEID: TFloatField;
  private
    StockInOrderID : IIntegerKey;
   protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
  end;

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

implementation

uses UMPDatabase;

{$R *.dfm}

{ TMADSIOMedicineDetailFactory }

function TSIOMedicineDetailFactory.NewModel: TModel;
begin
  Result := TMADSIOMedicineDetail.Create(GetOwner);
end;

{ TMADSIOMedicineDetail }

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

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

end.