unit updNOTMB;

interface

uses sysUtils, dbtables, bde, updBASE;

type
  TUpdateNOTMB = class(TBaseUpdateUnit)
  private
    FOtherVar: variant;
    function update_byNOTI09(xQrySource: TQuery): Boolean;
    function update_byNOTI02(xQrySource: TQuery): Boolean;
  public
    function update(xQrySource: TQuery; xAction: string;
       var xMsg: variant; xOtherVar: variant; xUserData: variant): Boolean;
  end;

implementation

uses LibStrs,CONSTDEF;

function TUpdateNOTMB.update(xQrySource: TQuery; xAction: string;
          var xMsg: variant; xOtherVar: variant; xUserData: variant): Boolean;
begin
  Result := True;
  self.saveVar(xAction, xOtherVar, xUserData);
  FOtherVar:= xOtherVar;  
  try
    self.setDBname(xQrySource.DatabaseName);
    if compareText(self.SourceTxnCode, 'TXNNOTI09') = 0 then
      Result := update_byNOTI09(xQrySource)
    else
    if compareText(self.SourceTxnCode, 'TXNNOTI02') = 0 then
      Result := update_byNOTI02(xQrySource)
    else
    begin
    end;
  finally
    self.Query1.close;
    self.Query2.close;
  end;
  xMsg := self.Msg;
end;

function TUpdateNOTMB.update_byNOTI09(xQrySource: TQuery): Boolean;
var
  mMB003: Double;
begin
  Result := True;
  self.Msg[0] := 'skip';
  self.Msg[1] := 'NOTMB';
  With xQrySource do
    self.Msg[2] := FieldByName('TL001').asString+' '+
                   FieldByName('TL002').asString+' '+
                   FieldByName('TL003').asString;

  mMB003:=0;

  if not (xQrySource.FieldByName('TL008').asString='2') then Exit;

  if not ((xQrySource.FieldByName('MQ003').asString='84')
       or (xQrySource.FieldByName('MQ003').asString='85')
       or (xQrySource.FieldByName('MQ003').asString='86')
       or (xQrySource.FieldByName('MQ003').asString='87')) then Exit;


  if self.Action = 'A' then
    self.Sign := 1
  else
    self.Sign := -1;

  try
    with self.Query1 do
    begin
      close;
      SQL.clear;
      RequestLive := False;
      SQL.add('select * from $$NOTMB ');
      SQL.add(' where MB001=:MB001 AND MB002=:MB002 ');
      ParamByName('MB001').asString := xQrySource.FieldByName('TL009').asString;
      ParamByName('MB002').asString := xQrySource.FieldByName('TK008').asString;
      Open;
      first;

      if not eof then //