umadsicknesshistory.pas

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

unit UMADSickNesshistory;

interface

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

type
  TMADSickNesshistory = class(TQueryDataModel)
    DataSetSICKNESSCODE: TStringField;
    DataSetINPATIENTID: TFloatField;
    DataSetBEGINSTATEID: TFloatField;
    DataSetENDSTATEID: TFloatField;
    DataSetDIAGNOSEID: TFloatField;
    DataSetSICKNESSLEVELID: TFloatField;
    DataSetDIAGNOSEDATE: TDateTimeField;
  private
    INPATIENTID : IIntegerKey;
  protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;       
  end;

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

implementation

uses UMPDatabase, UPrimaryDataModel;

{$R *.dfm}

function TSickNesshistoryFactory.NewModel: TModel;
begin
  Result :=  TMADSickNesshistory.Create(GetOwner);
end;

{ TMADSickNesshistory }

procedure TMADSickNesshistory.Append(Parameters: IParameters);
begin
  inherited;
  DataSet.FieldByName('INPATIENTID').AsInteger := INPATIENTID.GetKey;
end;

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

end.