updepstb.pas

拥有全套神州数码马易飞ERP源码,现上传部分源码

unit updEPSTB;

interface

uses sysUtils, dbtables, Bde, updBase, ComObj, CONSTDEF,LibStrs;

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

implementation

function TUpdateEPSTB.update(xQrySource: TQuery; xAction: string;
           var xMsg: variant; xOtherVar: variant; xUserData: variant): Boolean;
begin
  Result := True;
  self.saveVar(xAction, xOtherVar, xUserData);
  FOtherVar:= xOtherVar;
  try
    setDBName(xQrySource.databaseName);
    if compareText(self.SourceTxnCode, 'TXNEPSI06') = 0 then
      Result := update_byEPSI06(xQrySource)
    else
    begin
    end;
  finally
    self.Query1.close;
    self.Query1.UnPrepare;
  end;
  xMsg := self.Msg;
end;

function TUpdateEPSTB.update_byEPSI06(xQrySource: TQuery): Boolean;
var
  mFirst,mExist: Boolean;
  mTB001,mTB002,mTB003,mMF004,X_SER:String;
  mTB015,mTB017,mTB012,mTD026,mTB009,mTB011,mTB013: Double;
begin
  Result := True;
  self.Msg[0] := 'skip';
  self.Msg[1] := 'EPSTB';
  with xQrySource do
  begin
    self.Msg[2] := FieldByName('TC001').asString+' '+FieldByName('TC002').asString+' '+
                   FieldByName('TC003').asString;
  end;

  mFirst:=FOtherVar[1];

  if self.Action = 'A' then self.Sign:=1 else self.Sign:=-1 ;
  mMF004:=xQrySource.FieldByName('MF004').asString; //