umaddepartmentstockout.pas

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

unit UMADDepartMentStockOut;

interface

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

type
  TMADDepartMentStockOut = class(TQueryDataModel)
    DataSetPSTOCKOUTORDERID: TFloatField;
    DataSetTOTAL: TFloatField;
    DataSetTAXRATE: TFloatField;
    DataSetAMOUNT: TFloatField;
    DataSetISACTIVE: TIntegerField;
    DataSetISVALID: TIntegerField;
    DataSetISAPPROVE: TIntegerField;
    DataSetAPPROVEDATE: TDateTimeField;
    DataSetCREATED: TDateTimeField;
    DataSetUPDATED: TDateTimeField;
    DataSetCHECKOUTDATE: TDateTimeField;
    DataSetPSTOCKMEDICINEID: TFloatField;
    DataSetCREATEBY: TFloatField;
    DataSetUPDATEBY: TFloatField;
    DataSetAPPROVEBY: TFloatField;
    DataSetPRICE: TFloatField;
    DataSetDEPARTMENTID: 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;
  private
    DEPARTMENTID : IIntegerKey;
  protected
    procedure PrepareQuery(Parameters: MyTools.IQueryParameters); override;
  public
    procedure Append(Parameters: IParameters); override;
  end;

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

implementation

uses UDataModel;

{$R *.dfm}

{ TDepartMentStockOutFactory }

function TDepartMentStockOutFactory.NewModel: TModel;
begin
  Result := TMADDepartMentStockOut.Create(GetOwner);
end;

{ TMADDepartMentStockOut }

procedure TMADDepartMentStockOut.Append(Parameters: IParameters);
begin
  inherited;
  GetDataSet.FieldByName('PSTOCKOUTORDER_DEPARTMENTID').AsInteger := DEPARTMENTID.GetKey;
end;

procedure TMADDepartMentStockOut.PrepareQuery(
  Parameters: IQueryParameters);
begin
  inherited;
  DataSet.ParamByName('PSTOCKOUTORDER_DEPARTMENTID').AsInteger := IIntegerKey(Parameters).GetKey;
  DEPARTMENTID := IIntegerKey(Parameters);
end;

end.