umadsick.pas

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

unit UMADSick;

interface

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

type
  TMADSick = class(TAdapterDataModel)
    DataSetSICKID: TFloatField;
    DataSetBIRTHDAY: TDateTimeField;
    DataSetCNAME: TStringField;
    DataSetCREATED: TDateTimeField;
    DataSetISACTIVE: TIntegerField;
    DataSetISVALID: TIntegerField;
    DataSetST: TIntegerField;
    DataSetUPDATED: TDateTimeField;
    DataSetPROFESSIONID: TFloatField;
    DataSetWEDLOCKID: TFloatField;
    DataSetNATIVEPLACEID: TFloatField;
    DataSetNATIONID: TFloatField;
    DataSetPAYMENTMETHODID: TFloatField;
    DataSetCREATEBY: TFloatField;
    DataSetUPDATEBY: TFloatField;
    DataSetCODE: TStringField;
    DataSetTOLLSTATIONID: TFloatField;
    DataSetISARREARAGE: TIntegerField;
    DataSetSEX: TIntegerField;
    SPAfterInser: TOraStoredProc;
    DataSetDEPARTMENT: TStringField;
  private
    { Private declarations }
  public
    function GetKey : IKey; override;
    procedure Save(Parameters: IParameters); override;
    function GetDataSet: TDataSet; override;
  end;

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

implementation

uses UDataModel;

{$R *.dfm}

{ TSickFactory }

function TSickFactory.NewModel: TModel;
begin
  Result := TMADSick.Create(GetOwner);
end;

{ TMADSick }

function TMADSick.GetDataSet: TDataSet;
begin
  Result := ClientDataSet;
end;

function TMADSick.GetKey: IKey;
begin
  Result := NewKey('SICKID');
end;

procedure TMADSick.Save(Parameters: IParameters);
begin
  inherited;
  SPAfterInser.ParamByName('l_createby').AsInteger := ClientDataSet.FieldByName('createby').AsInteger;
  SPAfterInser.ParamByName('l_sickid').AsInteger := ClientDataSet.FieldByName('sickid').AsInteger;
  SPAfterInser.Execute;
end;

end.