Esempio n. 1
0
        /// <summary>
        /// return MBO count filter by query object
        /// </summary>
        public static int GetSize(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);
                int count_2 = 0;
                com.sybase.afx.db.DynamicQuery       query_4 = new com.sybase.afx.db.DynamicQuery();
                System.Data.IDbCommand               ps_5    = query_4.CreateCommand(_conn, query, true);
                System.Data.IDataReader              rs_6    = ps_5.ExecuteReader();
                Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
                com.sybase.afx.db.ReaderUtil.Read(profile, rs_6);
                count_2 = com.sybase.afx.db.ReaderUtil.GetInt(profile, rs_6, "count", 0);
                if (rs_6 != null)
                {
                    com.sybase.afx.db.ReaderUtil.Close(profile, rs_6, count_2);
                }
                if (ps_5 != null)
                {
                    ps_5.Dispose();
                }

                return(count_2);
            }
            catch (Sybase.Persistence.PersistenceException ex_10)
            {
                throw ex_10;
            }
            finally
            {
                YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
            }
        }
Esempio n. 2
0
        /// <summary>
        /// Find a List of ChangeLogImpl
        /// </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.ChangeLogImpl> 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);
                int count_2 = 0;
                Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ChangeLogImpl> list_3 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ChangeLogImpl>();
                if (query.Take == 0)
                {
                    return(list_3);
                }
                com.sybase.afx.db.DynamicQuery       query_4 = new com.sybase.afx.db.DynamicQuery();
                System.Data.IDbCommand               ps_5    = query_4.CreateCommand(_conn, query);
                System.Data.IDataReader              rs_6    = ps_5.ExecuteReader();
                Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
                while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_6))
                {
                    YPF.Comercial.RRCC.SUP.ChangeLogImpl entity_9 = new YPF.Comercial.RRCC.SUP.ChangeLogImpl();
                    entity_9.Bind(profile, rs_6);
                    list_3.Add(entity_9);
                    count_2++;
                }
                if (rs_6 != null)
                {
                    com.sybase.afx.db.ReaderUtil.Close(profile, rs_6, count_2);
                }
                if (ps_5 != null)
                {
                    ps_5.Dispose();
                }

                return(list_3);
            }
            catch (Sybase.Persistence.PersistenceException ex_10)
            {
                throw ex_10;
            }
            finally
            {
                YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
            }
        }
 /// <summary>
 /// Find a List of CalendarioInteraccionLocal
 /// </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.CalendarioInteraccionLocal> 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);
         int count_2 = 0;
             Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> list_3 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal>();
             if(query.Take == 0)
             {
                 return list_3;
             }
             com.sybase.afx.db.DynamicQuery query_4 = new com.sybase.afx.db.DynamicQuery();
             System.Data.IDbCommand ps_5 = query_4.CreateCommand(_conn, query);
             System.Data.IDataReader rs_6 = ps_5.ExecuteReader();
             Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
             while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_6))
             {
                 YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal entity_9 = new YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal();
                 entity_9.Bind(profile, rs_6);
                 list_3.Add(entity_9);
                 count_2++;
             }
             if (rs_6 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_6, count_2);
             if (ps_5 != null) ps_5.Dispose();
             
             return list_3;
     }    
     catch (Sybase.Persistence.PersistenceException ex_10)
     {
         throw ex_10;
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     }
 }
 /// <summary>
 /// return MBO count filter by query object
 /// </summary>
 public static int GetSize(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);
         int count_2 = 0;
             com.sybase.afx.db.DynamicQuery query_4 = new com.sybase.afx.db.DynamicQuery();
             System.Data.IDbCommand ps_5 = query_4.CreateCommand(_conn, query,true);
             System.Data.IDataReader rs_6 = ps_5.ExecuteReader();
             Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
             com.sybase.afx.db.ReaderUtil.Read(profile, rs_6);
             count_2 = com.sybase.afx.db.ReaderUtil.GetInt(profile, rs_6, "count", 0);
             if (rs_6 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_6, count_2);
             if (ps_5 != null) ps_5.Dispose();
             
             return count_2;
     }    
     catch (Sybase.Persistence.PersistenceException ex_10)
     {
         throw ex_10;
     }
     finally
     {
         YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
     }
 }