umadsoomedicinedetail.pas

来自「一整套的源代码」· PAS 代码 · 共 89 行

unit UMADSOOMedicineDetail;

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
  TMADSOOMedicineDetail = class(TQueryDataModel)
    DataSetSOOMEDICINEDETAILID: TFloatField;
    DataSetPRICE: TFloatField;
    DataSetAMOUNT: TFloatField;
    DataSetTOTAL: TFloatField;
    DataSetSTOCKOUTORDERID: TFloatField;
    DataSetMEDICINESTOCKID: TFloatField;
    DataSetISAPPROVE: TIntegerField;
    DataSetMEDICINEID: TFloatField;
    DataSetM_MEDICINEID: TFloatField;
    DataSetM_CODE: TStringField;
    DataSetM_TOPQTY: TFloatField;
    DataSetM_DOWNQTY: TFloatField;
    DataSetM_MEMO: TStringField;
    DataSetM_ALAIS: TStringField;
    DataSetM_MODEL: TStringField;
    DataSetM_PINYIN: TStringField;
    DataSetM_CAPTION: TStringField;
    DataSetM_DOSEID: TFloatField;
    DataSetM_UNITSID: TFloatField;
    DataSetM_USEMETHODID: TFloatField;
    DataSetM_MEDICINECATALOGID: TFloatField;
    DataSetM_MINUNITSID: TFloatField;
    DataSetM_PACKAMOUNT: TFloatField;
    DataSetU_CAPTION: TStringField;
    DataSetMC_CPATION: TStringField;
  private
    StockoutorderID: Integer;
  protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
    function GetKey: IKey; override;
  end;

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

implementation

uses UMPDatabase;

{$R *.dfm}

{ TMADSOOMedicineDetailFactory }

function TSOOMedicineDetailFactory.NewModel: TModel;
begin
  Result := TMADSOOMedicineDetail.Create(GetOwner);
end;

{ TMADSOOMedicineDetail }

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

function TMADSOOMedicineDetail.GetKey: IKey;
var
  Key: IKey;
begin
  Key := NewKey('SOOMEDICINEDETAILID');
  Result := Key;  
end;

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



end.