updcoptd.pas

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

unit updCOPTD;

interface

uses sysUtils, dbtables, bde, updBASE,LibStrs;

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

implementation

function TUpdateCOPTD.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, 'TXNCOPI07') = 0 then
      Result := update_byCOPI07(xQrySource)
    else if (compareText(self.SourceTxnCode, 'TXNCOPI08') = 0) then
      Result := update_byCOPI08(xQrySource)
    else if (compareText(self.SourceTxnCode, 'TXNCOPI09') = 0) then
      Result := update_byCOPI09(xQrySource)
    else
    begin
    end;
  finally
    self.Query1.close;
    self.Query2.close;
  end;
  xMsg := self.Msg;
end;

function TUpdateCOPTD.update_byCOPI07(xQrySource: TQuery): Boolean;
var
  mExist : Boolean ;
  mTD016 : string;
begin
  Result := True;
  self.Msg[0] := 'skip';
  self.Msg[1] := 'COPTD';
  with xQrySource do
    self.Msg[2] := FieldByName('TF001').asString+' '+FieldByName('TF002').asString+' '+
                   FieldByName('TF004').asString;
  try
    with self.Query1 do
    begin
      close;
      SQL.clear;
      RequestLive := False;
      SQL.add('SELECT * from $$COPTD');
      SQL.add(' where TD001=:TD001 and TD002=:TD002 and TD003=:TD003 ');
      ParamByName('TD001').asString := xQrySource.FieldByName('TF001').asString;
      ParamByName('TD002').asString := xQrySource.FieldByName('TF002').asString;
      ParamByName('TD003').asString := xQrySource.FieldByName('TF104').asString;
      open;
      first;
      mExist:= not eof; //