unit UMQDEmployeeFind;

interface

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

type
  TMQDEmployeeFind = class(TQueryDataModel)
  protected
    function NewDataItem: IDataItem; override;
    procedure PrepareQuery(Parameters: IQueryParameters); override;
  public
    function GetKey: IKey; override;
  end;

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

implementation

{$R *.dfm}

{ TEmployeeFindFactory }

function TEmployeeFindFactory.NewModel: TModel;
begin
  Result := TMQDEmployeeFind.Create(GetOwner);
end;

{ TMQDEmployeeFind }

function TMQDEmployeeFind.GetKey: IKey;
begin
  Result := NewKey('EmployeeID');
end;

function TMQDEmployeeFind.NewDataItem: IDataItem;
begin
end;

procedure TMQDEmployeeFind.PrepareQuery(Parameters: IQueryParameters);
begin
  inherited;
  DataSet.SQL.Text := 'SELECT * FROM RALF.EMPLOYEE ' +
                      'WHERE LOGINNAME = ''' + UpperCase(Trim(Parameters.GetParameters.Values['LoginName'])) + ''' AND ' +
                      'PASSWORD = ''' + UpperCase(Trim(Parameters.GetParameters.Values['Password'])) + ''' ' +
                      'AND GRANTC = 1';
end;

end.