umadrmedicine.pas

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

unit UMADRmedicine;

interface

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

type
  TMADRmedicine = class(TQueryDataModel)
    DataSetRMEDICINEID: TFloatField;
    DataSetPRICE: TFloatField;
    DataSetTOTAL: TFloatField;
    DataSetAMOUNT: TFloatField;
    DataSetRECKONINGID: TFloatField;
    DataSetPSTOCKMEDICINEID: TFloatField;
    DataSetISACTIVE: TIntegerField;
    DataSetMEDICINE_CODE: TStringField;
    DataSetMEDICINE_MEMO: TStringField;
    DataSetMEDICINE_ALAIS: TStringField;
    DataSetMEDICINE_MODEL: TStringField;
    DataSetMEDICINE_CAPTION: TStringField;
    DataSetMEDICINE_DOSEID: TFloatField;
    DataSetMEDICINE_UNITSID: TFloatField;
    DataSetMEDICINE_USEMETHODID: TFloatField;
    DataSetMEDICINE_MEDICINECATALOGID: TFloatField;
  private
    ReckoningID: IIntegerKey;
  protected
    procedure PrepareQuery(Parameters: IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
  end;

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

implementation

uses UMPDatabase;

{$R *.dfm}

{ TMADRmedicineFactory }

function TRmedicineFactory.NewModel: TModel;
begin
  Result := TMADRmedicine.Create(GetOwner);
end;

{ TMADRmedicine }

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

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



end.