DbDocAddress.java :  » ERP-CRM-Financial » Evaristo-4.0 » com » m16e » mpbiz » tables » Java Open Source

/*
 * $Log$
 *
 * DO NOT CHANGE THIS FILE or CHANGE IT WITH CARE!!!
 * FILE GENERATED BY Gaud ( version 1.4 - build (build 376)
 *
 * on Wed Apr 14 18:19:19 WEST 2010
 *
 *
 *
 */

package com.m16e.mpbiz.tables;

import java.io.*;
import java.math.*;
import java.sql.*;
import java.text.*;
import java.util.*;

import com.m16e.tools.*;
import com.m16e.tools.db.*;
import com.m16e.tools.xgm.*;
import com.m16e.tools.xml.*;
import java.math.BigDecimal;
import org.apache.log4j.Logger;


////////////////////////////////////////////////////////////
public class DbDocAddress
extends DbTab
implements DbTableInterface
{
  static Logger logger = Logger.getLogger( DbDocAddress.class );

  public final static String XGM_FORM_DOC_ADDRESS =
    "xgm-form-doc-address.xml";
  public final static String XGM_FORM_DOC_ADDRESS_FRAME =
    "form-doc-address-frame";
  public final static String XGM_LIST_DOC_ADDRESS =
    "xgm-list-doc-address.xml";
  public final static String XGM_LIST_DOC_ADDRESS_FRAME =
    "list-doc-address-frame";

  public final static String T_NAME = "doc_address";

  public final static String[] FIELDS = 
    {  "tipo_ent_id",
      "tipo_doc_id",
      "doc_id",
      "address_type",
      "ent_id",
      "name",
      "corporation",
      "address1",
      "address2",
      "city",
      "zip",
      "country",
      "email",
      "phone1",
      "order_payement_name",
      "obs" };

  public final static int TIPO_ENT_ID = 0;
  public final static int TIPO_DOC_ID = 1;
  public final static int DOC_ID = 2;
  public final static int ADDRESS_TYPE = 3;
  public final static int ENT_ID = 4;
  public final static int NAME = 5;
  public final static int CORPORATION = 6;
  public final static int ADDRESS1 = 7;
  public final static int ADDRESS2 = 8;
  public final static int CITY = 9;
  public final static int ZIP = 10;
  public final static int COUNTRY = 11;
  public final static int EMAIL = 12;
  public final static int PHONE1 = 13;
  public final static int ORDER_PAYEMENT_NAME = 14;
  public final static int OBS = 15;

  public final static String FN_TIPO_ENT_ID = "tipo_ent_id";
  public final static String FN_TIPO_DOC_ID = "tipo_doc_id";
  public final static String FN_DOC_ID = "doc_id";
  public final static String FN_ADDRESS_TYPE = "address_type";
  public final static String FN_ENT_ID = "ent_id";
  public final static String FN_NAME = "name";
  public final static String FN_CORPORATION = "corporation";
  public final static String FN_ADDRESS1 = "address1";
  public final static String FN_ADDRESS2 = "address2";
  public final static String FN_CITY = "city";
  public final static String FN_ZIP = "zip";
  public final static String FN_COUNTRY = "country";
  public final static String FN_EMAIL = "email";
  public final static String FN_PHONE1 = "phone1";
  public final static String FN_ORDER_PAYEMENT_NAME = "order_payement_name";
  public final static String FN_OBS = "obs";

  XmlTreeNode xtnTabLayout = null;
  XmlTreeNode xtnFormLayout = null;

  ////////////////////////////////////////////////////////////
  public DbDocAddress()

    throws SQLException
  {
    super( T_NAME );
    setDataModel( getDataModel() );
  }

  ////////////////////////////////////////////////////////////
  public DbDocAddress( ResultSet rs )
    throws SQLException
  {
    this();
    setTuple( rs );
  }

  ////////////////////////////////////////////////////////////
  public DbDocAddress( Tuple t )
    throws SQLException
  {
    this();
    setTuple( t );
  }

  ////////////////////////////////////////////////////////////
  public static DbDocAddress getTable( Object... pkey )
  throws SQLException, MpToolsException
  {
    DbDocAddress table = new DbDocAddress();
    java.util.List<Integer> lstPK = table.getPrimaryKey();
    int i = 0;
    for( Object o : pkey )
    {
      table.setValue( lstPK.get( i++ ), o );
    }
    if( !table.getById() )
    {
      table = null;
    }
    return table;
  }

  ////////////////////////////////////////////////////////////
  public static DbDocAddress getSingleRecord(
    String where, Object... args )
  throws SQLException, DatabaseException
  {
    DbDocAddress obj = new DbDocAddress();
    StringBuffer select = new StringBuffer();
    select.append( "select * from " + DbDocAddress.T_NAME );
    if( where != null && where.trim().length() > 0 )
    {
      select.append( " where " + where );
    }
    int i = 1;
    PreparedStatement ps =
      MpAppContext.getInstance().getDatabase().getPreparedStatement( select.toString() );
    for( Object arg : args )
    {
      ps.setObject( i++, arg );
    }
    if( logger.isTraceEnabled() )
    {
      logger.trace( "query: \n" + ps.toString() );
    }
    ResultSet rs = ps.executeQuery();
    if( rs.next() )
      obj = new DbDocAddress( rs );
    else
      obj = null;
    rs.close();
    ps.close();
    return obj;
  }

  ////////////////////////////////////////////////////////////
  public static java.util.List<DbDocAddress> getList(
    String where, String order, Object... args )
  throws SQLException, DatabaseException
  {
    DbDocAddress obj = new DbDocAddress();
    java.util.List<Tuple> lst =
      obj.selectWithArgs( false, where, order, args );
    java.util.List<DbDocAddress> lstObj = new Vector<DbDocAddress>( DbWorkingTable.ARR_INIT_CAP, DbWorkingTable.ARR_CAP_INCR );
    for( Tuple t : lst )
    {
      obj = new DbDocAddress();
      obj.setTuple( t );
      lstObj.add( obj );
    }
    return lstObj;
  }

  ////////////////////////////////////////////////////////////
  public static java.util.List<DbDocAddress> getList(
    boolean validateMaxRows, String where, String order, Object... args )
  throws SQLException, DatabaseException
  {
    DbDocAddress obj = new DbDocAddress();
    java.util.List<Tuple> lst =
      obj.selectWithArgs( validateMaxRows, where, order, args );
    java.util.List<DbDocAddress> lstObj = new Vector<DbDocAddress>( DbWorkingTable.ARR_INIT_CAP, DbWorkingTable.ARR_CAP_INCR );
    for( Tuple t : lst )
    {
      obj = new DbDocAddress();
      obj.setTuple( t );
      lstObj.add( obj );
    }
    return lstObj;
  }

  ////////////////////////////////////////////////////////////
  public TupleDataModel getDataModel()
  {
    java.util.List<TupleColDataModel> tcdm = new Vector<TupleColDataModel>( 10, 10 );
    for( int f = 0; f < FIELDS.length; f++ )
    {
      DbField dbField = super.getField( f );
      int len = dbField.getTotalLen();
      switch( dbField.getDbFieldType() )
      {
        case INT:
          len = 8;
          break;
        case DOUBLE:
          len = 15;
          break;
        default:
          if( len > 40 )
            len = 40;
          break;
      }
      tcdm.add( new TupleColDataModel( dbField ) );
    }
    TupleDataModel tdm =
      new TupleDataModel( getDbTable(), "DbDocAddress.class", tcdm );
    return tdm;
  }
  ////////////////////////////////////////////////////////////
  public DbTableInterface createTab(  String tableName, ResultSet rs)
    throws SQLException
  {
    DbDocAddress dbDocAddress = new DbDocAddress( rs );
    return dbDocAddress;
  }

  ////////////////////////////////////////////////////////////
  public XmlTreeNode getTabLayout()
  throws XgmException
  {
    if( xtnTabLayout == null )
    {
      try
      {
        String s = XgmFactory.getInstance().readLayout( XGM_FORM_DOC_ADDRESS );
        xtnFormLayout = new XmlTreeNode();
        xtnFormLayout.fromXml( s );
        s = XgmFactory.getInstance().readLayout( XGM_LIST_DOC_ADDRESS );
        xtnTabLayout = new XmlTreeNode();
        xtnTabLayout.fromXml( s );
      }
      catch( Exception e )
      {
        String msg = e.getLocalizedMessage();
        logger.error( e.getMessage(), e );
        throw new XgmException( XgmException.IO_ERROR, e.getMessage() );
      }
    }
    return xtnTabLayout;
  }

  ////////////////////////////////////////////////////////////
  public XmlTreeNode getFormLayout()
  throws XgmException
  {
    if( xtnFormLayout == null )
    {
      try
      {
        String s = XgmFactory.getInstance().readLayout( XGM_FORM_DOC_ADDRESS );
        xtnFormLayout = new XmlTreeNode();
        xtnFormLayout.fromXml( s );
        s = XgmFactory.getInstance().readLayout( XGM_FORM_DOC_ADDRESS );
        xtnFormLayout = new XmlTreeNode();
        xtnFormLayout.fromXml( s );
      }
      catch( Exception e )
      {
        String msg = e.getLocalizedMessage();
        logger.error( e.getMessage(), e );
        throw new XgmException( XgmException.IO_ERROR, e.getMessage() );
      }
    }
    return xtnFormLayout;
  }

  ////////////////////////////////////////////////////////////
  public String getTabLayoutFilename()
  {
    return XGM_LIST_DOC_ADDRESS;
  }

  ////////////////////////////////////////////////////////////
  public String getFormLayoutFilename()
  {
    return XGM_FORM_DOC_ADDRESS;
  }

  ////////////////////////////////////////////////////////////
  public boolean getById()
  throws SQLException
  {
    Database db = MpAppContext.getInstance().getDatabase();
    Tuple tuple = getTuple();
    java.util.List<Integer> kFields = getPrimaryKey();
    int nCols = getFieldCount();
    PreparedStatement ps =
      db.getPreparedStatement(
        "select * from doc_address where tipo_ent_id = ? and tipo_doc_id = ? and doc_id = ? and address_type = ?" );
    ps.setObject( 1, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 2, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 3, tuple.get( kFields.get( 2 ) ) );
    ps.setObject( 4, tuple.get( kFields.get( 3 ) ) );
    if( logger.isTraceEnabled() )
    {
      logger.trace( "query: \n" + ps.toString() );
    }
    boolean found = false;
    ResultSet rs = ps.executeQuery();
    if ( rs.next() )
    {
      found = true;
      for( int f = 0; f < nCols; f++ )
      {
        Object o = rs.getObject( f + 1 );
        if( o instanceof String )
          o = ((String) o).trim();
        tuple.setAll( f, o );
      }
    }
    rs.close();
    ps.close();
    return found;
  }

  ////////////////////////////////////////////////////////////
  public static DbDocAddress getById(
    Integer tipoEntId,
    Integer tipoDocId,
    Integer docId,
    Integer addressType )
  throws SQLException, DatabaseException
  {
    return
      DbDocAddress.getSingleRecord(
        DbDocAddress.FN_TIPO_ENT_ID + " = ? and " +
        DbDocAddress.FN_TIPO_DOC_ID + " = ? and " +
        DbDocAddress.FN_DOC_ID + " = ? and " +
        DbDocAddress.FN_ADDRESS_TYPE + " = ?",
        tipoEntId,
        tipoDocId,
        docId,
        addressType );
  }

  ////////////////////////////////////////////////////////////
  public boolean fetchNext()
  throws SQLException
  {
    Database db = MpAppContext.getInstance().getDatabase();
    Tuple tuple = getTuple();
    java.util.List<Integer> kFields = getPrimaryKey();
    int nCols = getFieldCount();
    PreparedStatement ps =
      db.getPreparedStatement(
        "select * from doc_address where (tipo_ent_id > ?) or (tipo_ent_id = ? and tipo_doc_id > ?) or (tipo_ent_id = ? and tipo_doc_id = ? and doc_id > ?) or (tipo_ent_id = ? and tipo_doc_id = ? and doc_id = ? and address_type > ?) order by  tipo_ent_id, tipo_doc_id, doc_id, address_type limit 1" );
    ps.setObject( 1, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 2, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 3, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 4, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 5, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 6, tuple.get( kFields.get( 2 ) ) );
    ps.setObject( 7, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 8, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 9, tuple.get( kFields.get( 2 ) ) );
    ps.setObject( 10, tuple.get( kFields.get( 3 ) ) );
    if( logger.isTraceEnabled() )
    {
      logger.trace( "query: \n" + ps.toString() );
    }
    boolean fetched = false;
    ResultSet rs = ps.executeQuery();
    if ( rs.next() )
    {
      fetched = true;
      setTuple( rs );
    }
    rs.close();
    ps.close();
    return fetched;
  }
  ////////////////////////////////////////////////////////////
  public boolean fetchPrev()
  throws SQLException
  {
    Database database = MpAppContext.getInstance().getDatabase();
    Tuple tuple = getTuple();
    java.util.List<Integer> kFields = getPrimaryKey();
    int nCols = getFieldCount();
    PreparedStatement ps =
      database.getPreparedStatement(
        "select * from doc_address where (tipo_ent_id < ?) or (tipo_ent_id = ? and tipo_doc_id < ?) or (tipo_ent_id = ? and tipo_doc_id = ? and doc_id < ?) or (tipo_ent_id = ? and tipo_doc_id = ? and doc_id = ? and address_type < ?) order by  tipo_ent_id desc, tipo_doc_id desc, doc_id desc, address_type desc limit 1" );
    ps.setObject( 1, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 2, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 3, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 4, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 5, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 6, tuple.get( kFields.get( 2 ) ) );
    ps.setObject( 7, tuple.get( kFields.get( 0 ) ) );
    ps.setObject( 8, tuple.get( kFields.get( 1 ) ) );
    ps.setObject( 9, tuple.get( kFields.get( 2 ) ) );
    ps.setObject( 10, tuple.get( kFields.get( 3 ) ) );
    if( logger.isTraceEnabled() )
    {
      logger.trace( "query: \n" + ps.toString() );
    }
    boolean fetched = false;
    ResultSet rs = ps.executeQuery();
    if ( rs.next() )
    {
      fetched = true;
      setTuple( rs );
    }
    rs.close();
    ps.close();
    return fetched;
  }
  ////////////////////////////////////////////////////////////
  // Get/Set methods: BEGIN
  ////////////////////////////////////////////////////////////

  ////////////////////////////////////////////////////////////
  public Integer getTipoEntId()
  {
    return getTipoEntId( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static Integer getTipoEntId( Tuple tuple )
  {
    Integer value = (Integer) tuple.get( TIPO_ENT_ID );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setTipoEntId( Integer value )
  {
    setTipoEntId( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setTipoEntId( Integer value, boolean changed )
  {
    setTipoEntId( getTuple(), value );
    setChangedField( TIPO_ENT_ID, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setTipoEntId( Tuple tuple, Integer value )
  {
    setValue( tuple, TIPO_ENT_ID, value );
  }

  ////////////////////////////////////////////////////////////
  public Integer getTipoDocId()
  {
    return getTipoDocId( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static Integer getTipoDocId( Tuple tuple )
  {
    Integer value = (Integer) tuple.get( TIPO_DOC_ID );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setTipoDocId( Integer value )
  {
    setTipoDocId( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setTipoDocId( Integer value, boolean changed )
  {
    setTipoDocId( getTuple(), value );
    setChangedField( TIPO_DOC_ID, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setTipoDocId( Tuple tuple, Integer value )
  {
    setValue( tuple, TIPO_DOC_ID, value );
  }

  ////////////////////////////////////////////////////////////
  public Integer getDocId()
  {
    return getDocId( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static Integer getDocId( Tuple tuple )
  {
    Integer value = (Integer) tuple.get( DOC_ID );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setDocId( Integer value )
  {
    setDocId( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setDocId( Integer value, boolean changed )
  {
    setDocId( getTuple(), value );
    setChangedField( DOC_ID, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setDocId( Tuple tuple, Integer value )
  {
    setValue( tuple, DOC_ID, value );
  }

  ////////////////////////////////////////////////////////////
  public Integer getAddressType()
  {
    return getAddressType( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static Integer getAddressType( Tuple tuple )
  {
    Integer value = (Integer) tuple.get( ADDRESS_TYPE );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setAddressType( Integer value )
  {
    setAddressType( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setAddressType( Integer value, boolean changed )
  {
    setAddressType( getTuple(), value );
    setChangedField( ADDRESS_TYPE, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setAddressType( Tuple tuple, Integer value )
  {
    setValue( tuple, ADDRESS_TYPE, value );
  }

  ////////////////////////////////////////////////////////////
  public Integer getEntId()
  {
    return getEntId( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static Integer getEntId( Tuple tuple )
  {
    Integer value = (Integer) tuple.get( ENT_ID );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setEntId( Integer value )
  {
    setEntId( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setEntId( Integer value, boolean changed )
  {
    setEntId( getTuple(), value );
    setChangedField( ENT_ID, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setEntId( Tuple tuple, Integer value )
  {
    setValue( tuple, ENT_ID, value );
  }

  ////////////////////////////////////////////////////////////
  public String getName()
  {
    return getName( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getName( Tuple tuple )
  {
    String value = (String) tuple.get( NAME );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setName( String value )
  {
    setName( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setName( String value, boolean changed )
  {
    setName( getTuple(), value );
    setChangedField( NAME, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setName( Tuple tuple, String value )
  {
    setValue( tuple, NAME, value );
  }

  ////////////////////////////////////////////////////////////
  public String getCorporation()
  {
    return getCorporation( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getCorporation( Tuple tuple )
  {
    String value = (String) tuple.get( CORPORATION );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setCorporation( String value )
  {
    setCorporation( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setCorporation( String value, boolean changed )
  {
    setCorporation( getTuple(), value );
    setChangedField( CORPORATION, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setCorporation( Tuple tuple, String value )
  {
    setValue( tuple, CORPORATION, value );
  }

  ////////////////////////////////////////////////////////////
  public String getAddress1()
  {
    return getAddress1( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getAddress1( Tuple tuple )
  {
    String value = (String) tuple.get( ADDRESS1 );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setAddress1( String value )
  {
    setAddress1( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setAddress1( String value, boolean changed )
  {
    setAddress1( getTuple(), value );
    setChangedField( ADDRESS1, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setAddress1( Tuple tuple, String value )
  {
    setValue( tuple, ADDRESS1, value );
  }

  ////////////////////////////////////////////////////////////
  public String getAddress2()
  {
    return getAddress2( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getAddress2( Tuple tuple )
  {
    String value = (String) tuple.get( ADDRESS2 );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setAddress2( String value )
  {
    setAddress2( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setAddress2( String value, boolean changed )
  {
    setAddress2( getTuple(), value );
    setChangedField( ADDRESS2, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setAddress2( Tuple tuple, String value )
  {
    setValue( tuple, ADDRESS2, value );
  }

  ////////////////////////////////////////////////////////////
  public String getCity()
  {
    return getCity( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getCity( Tuple tuple )
  {
    String value = (String) tuple.get( CITY );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setCity( String value )
  {
    setCity( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setCity( String value, boolean changed )
  {
    setCity( getTuple(), value );
    setChangedField( CITY, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setCity( Tuple tuple, String value )
  {
    setValue( tuple, CITY, value );
  }

  ////////////////////////////////////////////////////////////
  public String getZip()
  {
    return getZip( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getZip( Tuple tuple )
  {
    String value = (String) tuple.get( ZIP );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setZip( String value )
  {
    setZip( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setZip( String value, boolean changed )
  {
    setZip( getTuple(), value );
    setChangedField( ZIP, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setZip( Tuple tuple, String value )
  {
    setValue( tuple, ZIP, value );
  }

  ////////////////////////////////////////////////////////////
  public String getCountry()
  {
    return getCountry( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getCountry( Tuple tuple )
  {
    String value = (String) tuple.get( COUNTRY );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setCountry( String value )
  {
    setCountry( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setCountry( String value, boolean changed )
  {
    setCountry( getTuple(), value );
    setChangedField( COUNTRY, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setCountry( Tuple tuple, String value )
  {
    setValue( tuple, COUNTRY, value );
  }

  ////////////////////////////////////////////////////////////
  public String getEmail()
  {
    return getEmail( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getEmail( Tuple tuple )
  {
    String value = (String) tuple.get( EMAIL );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setEmail( String value )
  {
    setEmail( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setEmail( String value, boolean changed )
  {
    setEmail( getTuple(), value );
    setChangedField( EMAIL, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setEmail( Tuple tuple, String value )
  {
    setValue( tuple, EMAIL, value );
  }

  ////////////////////////////////////////////////////////////
  public String getPhone1()
  {
    return getPhone1( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getPhone1( Tuple tuple )
  {
    String value = (String) tuple.get( PHONE1 );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setPhone1( String value )
  {
    setPhone1( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setPhone1( String value, boolean changed )
  {
    setPhone1( getTuple(), value );
    setChangedField( PHONE1, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setPhone1( Tuple tuple, String value )
  {
    setValue( tuple, PHONE1, value );
  }

  ////////////////////////////////////////////////////////////
  public String getOrderPayementName()
  {
    return getOrderPayementName( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getOrderPayementName( Tuple tuple )
  {
    String value = (String) tuple.get( ORDER_PAYEMENT_NAME );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setOrderPayementName( String value )
  {
    setOrderPayementName( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setOrderPayementName( String value, boolean changed )
  {
    setOrderPayementName( getTuple(), value );
    setChangedField( ORDER_PAYEMENT_NAME, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setOrderPayementName( Tuple tuple, String value )
  {
    setValue( tuple, ORDER_PAYEMENT_NAME, value );
  }

  ////////////////////////////////////////////////////////////
  public String getObs()
  {
    return getObs( getTuple() );
  }

  ////////////////////////////////////////////////////////////
  public static String getObs( Tuple tuple )
  {
    String value = (String) tuple.get( OBS );
    return value;
  }

  ////////////////////////////////////////////////////////////
  public void setObs( String value )
  {
    setObs( getTuple(), value );
  }

  ////////////////////////////////////////////////////////////
  public void setObs( String value, boolean changed )
  {
    setObs( getTuple(), value );
    setChangedField( OBS, changed );
  }

  ////////////////////////////////////////////////////////////
  public static void setObs( Tuple tuple, String value )
  {
    setValue( tuple, OBS, value );
  }

  ////////////////////////////////////////////////////////////
  // Get/Set methods: END
  ////////////////////////////////////////////////////////////


}