unit updMOCMA;

interface

uses sysUtils, dbtables, db, bde, updBase, LibStrs,ConstDEF ;

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

implementation

function TUpdateMOCMA.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, 'TXNMOCI10') = 0 then
      Result := update_byMOCI10(xQrySource)
    else
    if ((compareText(self.SourceTxnCode, 'TXNMOCI06') = 0) OR (compareText(self.SourceTxnCode, 'TXNMOCI11') = 0)) then
      Result := update_byMOCI06(xQrySource)
    else
    begin
    end;
  finally
    self.Query1.Close;
    self.Query2.close;
    self.Query1.UnPrepare;
    self.Query2.UnPrepare;
  end;
  xMsg := self.Msg;
end;

function TUpdateMOCMA.update_byMOCI10(xQrySource: TQuery): Boolean;
var
  mExist,mExist2: Boolean;
  mNewFlag : Integer;
  mTM003: string ;
begin
  Result := True;
  self.Msg[0] := 'skip';
  self.Msg[1] := 'MOCMA';
  with xqrySource do
  self.Msg[2] := FieldByName('TN004').asString+' '+  //珇腹
                 FieldByName('TN007').asString+' '+  //籹祘抖