umadsoomedicinedetailnotapprove.pas

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

unit UMADSOOMedicineDetailNOTApprove;

interface

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

type
  TMADSOOMedicineDetailNOTApprove = class(TQueryDataModel)
    DataSetSOOMEDICINEDETAILID: TFloatField;
    DataSetPRICE: TFloatField;
    DataSetAMOUNT: TFloatField;
    DataSetTOTAL: TFloatField;
    DataSetSTOCKOUTORDERID: TFloatField;
    DataSetMEDICINESTOCKID: TFloatField;
    DataSetISAPPROVE: TIntegerField;
  private
    StockoutorderID: IIntegerKey;
  protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
    function GetKey: IKey; override;
  end;

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

implementation

{$R *.dfm}

{ TMADSOOMedicineDetailNOTApprove }

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

function TMADSOOMedicineDetailNOTApprove.GetKey: IKey;
begin
  Result := NewKey('SOOMEDICINEDETAILID');
end;

{ TSOOMedicineDetailNOTApprove }

function TSOOMedicineDetailNOTApproveFactory.NewModel: TModel;
begin
  Result := TMADSOOMedicineDetailNOTApprove.Create(GetOwner);
end;

procedure TMADSOOMedicineDetailNOTApprove.PrepareQuery(
  Parameters: IQueryParameters);
begin
  DataSet.ParamByName('StockoutorderID').AsInteger := IIntegerKey(Parameters).GetKey;
  StockoutorderID := IIntegerKey(Parameters);

end;

end.