unit UMADRecipe;

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
  TMADRecipe = class(TQueryDataModel)
    DataSetRECIPEID: TFloatField;
    DataSetCREATED: TDateTimeField;
    DataSetISACTIVE: TIntegerField;
    DataSetISVALID: TIntegerField;
    DataSetISPRINTED: TIntegerField;
    DataSetST: TIntegerField;
    DataSetUPDATED: TDateTimeField;
    DataSetDOCTORID: TFloatField;
    DataSetRECKONINGID: TFloatField;
    DataSetCREATEBY: TFloatField;
    DataSetUPDATEBY: TFloatField;
    DataSetSICKID: TFloatField;
  private
    SICKID : IIntegerKey;
  protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
  end;
  TRecipeFactory = class(TModelFactory)
    function NewModel: TModel; override;    
  end;
implementation

uses UMPDatabase, UDataModel;

{$R *.dfm}

{ TRecipeFactory }

function TRecipeFactory.NewModel: TModel;
begin
    Result := TMADRecipe.Create(GetOwner);
end;

{ TMADRecipe }

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



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

end.