umaddaexecuted.pas

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

unit UMADDAExecuted;

interface

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

type
  TMADDAExecuted = class(TMADDAInput)
    DAExecute: TOraStoredProc;
  private
    { Private declarations }
  protected
    procedure PrepareQuery (Parameters : MyTools.IQueryParameters); override;
  public
    function GetKey : IKey; override;
    procedure DoctorAdviceExecute;
  end;

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

implementation

uses UDataModel, UPrimaryDataModel;

{$R *.dfm}

{ TDAExecutedFactory }

function TDAExecutedFactory.NewModel: TModel;
begin
  Result := TMADDAExecuted.Create(GetOwner);
end;

{ TMADDAExecuted }

procedure TMADDAExecuted.DoctorAdviceExecute;
begin
  if not GetDataSet.Active or GetDataSet.IsEmpty then Exit;
  DAExecute.ParamByName('l_inpatientid').AsInteger := GetDataSet.FieldByName('i_inpatientid').AsInteger;
  DAExecute.ParamByName('l_createby').AsInteger := MPSysEnv.EmployeeKey.GetKey;
  try
    DAExecute.ExecProc;
    ShowMessage('执行成功,请不要重复执行!'); 
  except
    on E: Exception do
      ShowMessage('发生错误: ' + E.Message);
  end;
end;

function TMADDAExecuted.GetKey: IKey;
begin
  Result := NewKey('I_INPATIENTID');
end;

procedure TMADDAExecuted.PrepareQuery(Parameters: IQueryParameters);
begin
  DataSet.ParamByName('I_SECTIONOFFICEID').AsInteger := MPSysEnv.SectionOfficeKey.GetKey;
end;

end.