updmoctb.pas

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

unit updMOCTB;

interface

uses sysUtils, dbtables, bde, updBASE,LibStrs;

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

implementation

function TUpdateMOCTB.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, 'TXNMOCI03') = 0 then
      Result := update_byMOCI03(xQrySource)
    else
    if compareText(self.SourceTxnCode, 'TXNMOCI04') = 0 then
      Result := update_byMOCI04(xQrySource)
    else
    if compareText(self.SourceTxnCode, 'TXNMOCI12') = 0 then
      Result := update_byMOCI12(xQrySource)
    else
    begin
    end;
  finally
    self.Query1.close;
    self.Query2.close;
  end;
  xMsg := self.Msg;
end;

function TUpdateMOCTB.update_byMOCI03(xQrySource: TQuery): Boolean;
var
  mExist: Boolean;
  mTB005,mQUANTY:Double;
  mTB016:String;
  mTA011,mTA012 : String ;
  mTA016,mSum:Double;
begin
  Result := True;
  self.Msg[0] := '';
  self.Msg[1] := 'MOCTB';
  With xQrySource do
  self.Msg[2] := FieldByName('TE001').asString+' '+
                 FieldByName('TE002').asString+' '+
                 FieldByName('TE003').asString;

  if (((xQrySource.FieldByName('TE011').asString='') or (xQrySource.FieldByName('TE011').isnull)) or
      ((xQrySource.FieldByName('TE012').asString='') or (xQrySource.FieldByName('TE012').isnull))) then Exit;

  mQUANTY := FOtherVar[1]; //畐