umaddaservice.pas

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

unit UMADDAService;

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
  TMADDAService = class(TQueryDataModel)
    DataSetDASERVICEID: TFloatField;
    DataSetSTOPDATE: TDateTimeField;
    DataSetISTEMPORARY: TIntegerField;
    DataSetEXECUTED: TDateTimeField;
    DataSetISACTIVE: TIntegerField;
    DataSetISVALID: TIntegerField;
    DataSetCREATED: TDateTimeField;
    DataSetUPDATED: TDateTimeField;
    DataSetSERVICEID: TFloatField;
    DataSetINPATIENTID: TFloatField;
    DataSetDAYTIMES: TFloatField;
  private
    InpatientID : IIntegerKey;
  protected
    procedure PrepareQuery(Parameters : MyTools.IQueryParameters); override;
  public
    procedure Append (Parameters : IParameters); override;
  end;

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

implementation

uses UDataModel, UPrimaryDataModel;

{$R *.dfm}

{ TDAServiceFactory }

function TDAServiceFactory.NewModel: TModel;
begin
  Result :=  TMADDAService.Create(GetOwner);
end;

{ TMADDAService }

procedure TMADDAService.Append(Parameters: IParameters);
begin
  inherited;
  GetDataSet.FieldByName('INPATIENTID').AsInteger := InpatientID.GetKey;
end;

procedure TMADDAService.PrepareQuery(Parameters: IQueryParameters);
begin
  InpatientID := IIntegerKey(Parameters);
  DataSet.ParamByName('INPATIENTID').AsInteger := InpatientID.GetKey;
end;

end.