C# Collections.GenericList类代码示例

 public override void Synchronize (Sybase.Persistence.ServerSyncData ssd)
 {
     object _userContext = new Sybase.Persistence.SynchronizationNotification();
     Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> _sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
     _sgs.Add(CRMMobileDesaDB.GetSynchronizationGroup(ssd.Publication));
     CRMMobileDesaDB.BeginSynchronize(_sgs, _userContext);
 }

 public void OnMessage(com.sybase.afx.json.JsonMessage msg)
 {
     string _notification = msg.GetHeaders().GetNullableString("SUPObjCmd");
     bool _reregistered = (_notification != null && _notification.Equals("reregister"));
     if(_reregistered)
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSubscriptionEnd();
         return;
     }
     string method = msg.GetHeaders().GetString("method");
     bool _isAsync = "asyncReplayCompleted".Equals(method);
     string serverRemoteId = msg.GetHeaders().GetNullableString("remoteId");
     string clientRemoteId = GetRemoteId();
     if(serverRemoteId != null && clientRemoteId != null && !serverRemoteId.Equals(clientRemoteId))
     {
         return;
     }
     bool _isTcn = "tcn".Equals(method);
     if(!_isAsync && !_isTcn)
     {
         return;
     }
     com.sybase.afx.json.JsonObject _content = (com.sybase.afx.json.JsonObject)(msg.GetContent());
     string userContext = _content.GetString("userContext");
     string synchronizationGroup = _content.GetString("synchronizationGroup");
         
     Sybase.Persistence.SynchronizationContext syncContext = new Sybase.Persistence.SynchronizationContext();
     syncContext.UserContext = userContext;
     Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
     foreach(string sg in com.sybase.afx.util.StringUtil.GetCommaSeparatedList(synchronizationGroup))
     {
         sgs.Add(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetSynchronizationGroup(sg));
     }
     if(_isTcn)
     {
         syncContext.Status = Sybase.Persistence.SynchronizationStatus.STARTING_ON_NOTIFICATION;
     }
     else
     {
         syncContext.Status = Sybase.Persistence.SynchronizationStatus.ASYNC_REPLAY_COMPLETED;
     }
     if(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext) == Sybase.Persistence.SynchronizationAction.CANCEL)
     {
         return;
     }
     try
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.BeginSynchronize(sgs, userContext);
     }
     catch(Sybase.Persistence.SynchronizeException ex)
     {
         syncContext.Exception = ex;
         syncContext.Status = Sybase.Persistence.SynchronizationStatus.ERROR;
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext);            
         throw ex;
     }
     syncContext.Status = Sybase.Persistence.SynchronizationStatus.FINISHING;
     YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext);
 }

 /// <summary>
 /// Find a List of YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario
 /// </summary>
 /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
 /// <remarks> </remarks>
 public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> GetReplayPendingObjects(int skip, int take)
 {
     Sybase.Persistence.ConnectionWrapper _conn = null;
     try
     {
         _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
     
         string _selectSQL = " x.\"a\",x.\"b\",x.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"interaccionFK\",x.\"g\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_respuestainteraccionformulario\" x where (((x.\"pending\" = 1 or not exists (select x_os.\"g\" from \"crmmobiledesa_1_0_respuestainteraccio"
                                 + "nformulario_os\" x_os where x_os.\"g\" = x.\"g\")))) and ( x.\"_rp\" != 0)";
         skip = skip + 1;
         _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
         Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> _outList = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario>();
         Sybase.Persistence.AbstractEntity.FindWithoutParameters(_conn, skip, take, 
                 _outList, _selectSQL, typeof(YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario));
         return _outList;
     }
     catch (Sybase.Persistence.PersistenceException pe)
     {        
         throw pe;
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     }
 }

 /// <summary>
 /// Find a List of RespuestaInteraccionFormulario
 /// </summary>
 /// <param name="query">The query to be filter.</param>
 /// <exception cref="PersistenceException">Thrown if unable to retrieve mobile business object.</exception>
 /// <remarks> </remarks>
 public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> FindWithQuery(Sybase.Persistence.Query query)
 {
     Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
     try
     {
         query.SetEntity(META_DATA);
         query.SetDatabaseMetaData(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.Metadata);
         Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> list_3 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario>();
         Sybase.Persistence.AbstractEntity.FindWithQuery(_conn, query, list_3, typeof(YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario));
         return list_3;
     }    
     catch (Sybase.Persistence.PersistenceException ex_10)
     {
         throw ex_10;
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     }
 }

 /// <summary>
 /// Find a List of YPF.Comercial.RRCC.SUP.ClientPersonalization
 /// </summary>
 /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
 /// <remarks> </remarks>
 public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClientPersonalization> FindByUser(string user, int skip, int take)
 {
         skip = skip + 1;
     Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClientPersonalization> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClientPersonalization>();
     System.Data.IDataReader rs_4 = null;
     int count_5 = 0;
     Sybase.Persistence.ConnectionWrapper _conn = null;
     try
     {
         _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
         string _selectSQL = " p.\"key_name\",p.\"user\",p.\"value\",p.\"user_defined\",p.\"description\",p.\"id\" from \"co_crmmobiledesa_1_0_clientpersonalization\" p where p.\"user\" = ?";
         _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
         System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL);
         com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "user", user);
         rs_4 = ps_3.ExecuteReader();
         Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
         while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4))
         {       
             YPF.Comercial.RRCC.SUP.ClientPersonalization entity_6 = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
             entity_6.Bind(profile, rs_4);
             count_5++;
             result_2.Add(entity_6);
         }
         if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5);
         if (ps_3 != null) ps_3.Dispose();
         _selectSQL = null;
     }
     catch (System.Data.DataException ex)
     {
         throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex);
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     } 
     return result_2; 
   
 }

 /// <summary>
 /// Find a List of YPF.Comercial.RRCC.SUP.TablaRelevamiento
 /// </summary>
 /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
 /// <remarks> </remarks>
 public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.TablaRelevamiento> FindAll(int skip, int take)
 {
     Sybase.Persistence.ConnectionWrapper _conn = null;
     try
     {
         _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
     
         string _selectSQL = " x.\"a\",x.\"b\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"c\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_tablarelevamiento\" x where (((x.\"pending\" = 1 or not exists (select x_os.\"c\" from \"crmmobiledesa_1_0_tablarelevamiento_os\" x_os where x_os.\"c\" = x.\"c\"))))";
         skip = skip + 1;
         _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
         Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.TablaRelevamiento> _outList = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.TablaRelevamiento>();
         Sybase.Persistence.AbstractEntity.FindWithoutParameters(_conn, skip, take, 
                 _outList, _selectSQL, typeof(YPF.Comercial.RRCC.SUP.TablaRelevamiento));
         return _outList;
     }
     catch (Sybase.Persistence.PersistenceException pe)
     {        
         throw pe;
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     }
 }

 /// <summary>
 /// Find a List of YPF.Comercial.RRCC.SUP.PreguntaFormulario
 /// </summary>
 /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
 /// <remarks> </remarks>
 public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> GetPreguntaFormularios_for_Pregunta(long? surrogateKey, int skip, int take)
 {
         skip = skip + 1;
     Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>();
     System.Data.IDataReader rs_4 = null;
     int count_5 = 0;
     Sybase.Persistence.ConnectionWrapper _conn = null;
     try
     {
         _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
         string _selectSQL = " x.\"a\",x.\"b\",x.\"c\",x.\"d\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"preguntaFK\",x.\"formulario1FK\",x.\"e\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_preguntaformulario\" x where (((x.\"pending\" = 1 or not exists (select x_os.\"e\" from \"crmmobiledesa_1_0_preguntaformulario_os\" x_os "
                                 + "where x_os.\"e\" = x.\"e\")))) and ( x.\"preguntaFK\"=?)";
         _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
         System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL);
         com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps_3, "surrogateKey", surrogateKey);
         rs_4 = ps_3.ExecuteReader();
         Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
         while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4))
         {       
             YPF.Comercial.RRCC.SUP.PreguntaFormulario entity_6 = new YPF.Comercial.RRCC.SUP.PreguntaFormulario();
             entity_6.Bind(profile, rs_4);
             count_5++;
             result_2.Add(entity_6);
         }
         if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5);
         if (ps_3 != null) ps_3.Dispose();
         _selectSQL = null;
     }
     catch (System.Data.DataException ex)
     {
         throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex);
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     } 
     return result_2; 
   
 }

 /// <summary>
 /// Find a List of YPF.Comercial.RRCC.SUP.ClienteDetallePedido
 /// </summary>
 /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
 /// <remarks> </remarks>
 public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido> FindByCuenta(string cuenta, int skip, int take)
 {
         skip = skip + 1;
     Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido>();
     System.Data.IDataReader rs_4 = null;
     int count_5 = 0;
     Sybase.Persistence.ConnectionWrapper _conn = null;
     try
     {
         _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
         string _selectSQL = " x.\"a\",x.\"b\",x.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"h\",x.\"i\",x.\"j\",x.\"l\",x.\"m\",x.\"n\",x.\"o\",x.\"p\",x.\"q\",x.\"r\",x.\"s\",x.\"t\",x.\"u\",x.\"v\",x.\"w\",x.\"x\",x.\"y\",x.\"z\",x.\"ba\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"bb\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_clientedetallepedido\" x WHERE"
                                 + " (((x.\"pending\" = 1 or not exists (select x_os.\"bb\" from \"crmmobiledesa_1_0_clientedetallepedido_os\" x_os where x_os.\"bb\" = x.\"bb\")))) and ( x.\"b\" = ?)";
         _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
         System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL);
         com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "cuenta", cuenta);
         rs_4 = ps_3.ExecuteReader();
         Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
         while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4))
         {       
             YPF.Comercial.RRCC.SUP.ClienteDetallePedido entity_6 = new YPF.Comercial.RRCC.SUP.ClienteDetallePedido();
             entity_6.Bind(profile, rs_4);
             count_5++;
             result_2.Add(entity_6);
         }
         if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5);
         if (ps_3 != null) ps_3.Dispose();
         _selectSQL = null;
     }
     catch (System.Data.DataException ex)
     {
         throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex);
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     } 
     return result_2; 
   
 }

 /// <summary>
 /// Sybase internal use only.
 /// <summary>
 internal Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario> GetSeleccionFormularios(bool ignoreNonPending,bool ignoreDisableSubmit)
 {
     if (__seleccionFormularios == null)
     {
         __seleccionFormularios = YPF.Comercial.RRCC.SUP.SeleccionFormulario.GetSeleccionFormularios_for_Formulario(__surrogateKey);
     }
     return (Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario>)FilterChildren(__seleccionFormularios, ignoreNonPending, ignoreDisableSubmit, new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario>());
 }

 /// <summary>
 /// Set the value of seleccionFormularios
 /// </summary>
 internal void SetSeleccionFormularios(Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario> x)
 {
     __seleccionFormularios = x;
 }

 /// <summary>
 /// Sybase internal use only.
 /// <summary>
 private Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento> GetSeleccionTablasRelevamiento(bool ignoreNonPending,bool ignoreDisableSubmit)
 {
     if (__seleccionTablasRelevamiento == null)
     {
         __seleccionTablasRelevamiento = YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento.GetSeleccionTablasRelevamiento_for_Formulario(__surrogateKey);
     }
     return (Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento>)FilterChildren(__seleccionTablasRelevamiento, ignoreNonPending, ignoreDisableSubmit, new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento>());
 }

 /// <summary>
 /// Set the value of seleccionTablasRelevamiento
 /// </summary>
 private void SetSeleccionTablasRelevamiento(Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento> x)
 {
     __seleccionTablasRelevamiento = x;
 }

 /// <summary>
 /// Sybase internal use only.
 /// <summary>
 private Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> GetPreguntasFormulario(bool ignoreNonPending,bool ignoreDisableSubmit)
 {
     if (__preguntasFormulario == null)
     {
         __preguntasFormulario = YPF.Comercial.RRCC.SUP.PreguntaFormulario.GetPreguntasFormulario_for_Formulario(__surrogateKey);
     }
     return (Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>)FilterChildren(__preguntasFormulario, ignoreNonPending, ignoreDisableSubmit, new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>());
 }

 /// <summary>
 /// Set the value of preguntasFormulario
 /// </summary>
 private void SetPreguntasFormulario(Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> x)
 {
     __preguntasFormulario = x;
 }

 //Returns list of available IP addresses on this device.
 //One of the IPs can be set in ConnectionProfile object before synchronization.
 //Ultralite will bind to the specified IP and use that network for synchronization.
 ////
 //MyDatabase.GetSynchronizationProfile().SetString("client_ip", "1.23.456.789");
 //MyDatabase.Synchronize();
 //
 public static Sybase.Collections.GenericList<string> GetAvailableIPAdresses()
 {
     Sybase.Collections.GenericList<string> _list = new Sybase.Collections.GenericList<string>();
     string _strHostName = System.Net.Dns.GetHostName();
     System.Net.IPHostEntry _ipEntry = System.Net.Dns.GetHostEntry(_strHostName);
     System.Net.IPAddress[] _addr = _ipEntry.AddressList;
     for (int i = 0; i < _addr.Length; i++)
     {
          _list.Add(_addr[i].ToString());
     }    
     return _list;    
 }