Package com.knowgate.hipergate

Examples of com.knowgate.hipergate.Term


  oSum.setString(3, getString(DB.gu_workarea));
  oSum.setString(4, getString(DB.gu_product));
  oSum.setString(5, getString(DB.gu_workarea));
  oSum.setString(7, getString(DB.gu_workarea));
   
    Term oZone = new Term();
    oZone.load(oConn, getString(DB.gu_geozone));
    LinkedList oChlds = oZone.getChilds(oConn, Term.SCOPE_ALL);
    ListIterator oIter = oChlds.listIterator();
    while (oIter.hasNext()) {
      oZone = (Term) oIter.next();
    oSum.setString(6, oZone.getString(DB.gu_term));
    oSum.setString(8, oZone.getString(DB.gu_term));
    oRst = oSum.executeQuery();
      oRst.next();
    if (DebugFile.trace)
        DebugFile.writeln("  sales for "+oZone.getString(DB.tx_term)+" = "+String.valueOf(oRst.getFloat(1)));
      fSum += oRst.getFloat(1);
      oRst.close();
    } // wend

  if (DebugFile.trace)
      DebugFile.writeln("  subtotal sales for all child zones = "+String.valueOf(fSum));
   
  oSum.setString(6, getString(DB.gu_geozone));
  oSum.setString(8, getString(DB.gu_geozone));
  oRst = oSum.executeQuery();
    oRst.next();
  if (DebugFile.trace) {
      oZone.load(oConn, getString(DB.gu_geozone));
      DebugFile.writeln("  sales for zone "+oZone.getString(DB.tx_term)+" = "+String.valueOf(oRst.getFloat(1)));
  }
    fSum += oRst.getFloat(1);
    oRst.close();

    oSum.close();
View Full Code Here


  oUpdt.setString(1,sGuWorkArea);
  oUpdt.setString(2,sGuZone);
  oUpdt.setString(3,sGuProduct);
  iAffected += oUpdt.executeUpdate();

  Term oZone = new Term();
  oZone.load(oConn, sGuZone);
  String sGuParent = oZone.getParent(oConn);
 
  while (sGuParent!=null) {   
    oUpdt.setString(1,sGuWorkArea);
    oUpdt.setString(2,sGuParent);
    oUpdt.setString(3,sGuProduct);
    iAffected += oUpdt.executeUpdate();
    oZone.load(oConn, sGuParent);
    sGuParent = oZone.getParent(oConn);   
  } // wend
 
  oUpdt.close();
  return iAffected;                                
View Full Code Here

TOP

Related Classes of com.knowgate.hipergate.Term

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.