コード例 #1
0
        /// <summary>
        /// Makes a shallow copy of the current DojoPromotionStatusCollection.
        /// as the parent object.
        /// </summary>
        /// <returns>DojoPromotionStatusCollection</returns>
        public DojoPromotionStatusCollection Clone()
        {
            DojoPromotionStatusCollection clonedDojoPromotionStatus = new DojoPromotionStatusCollection(count);

            lock (this)
            {
                foreach (DojoPromotionStatus item in this)
                {
                    clonedDojoPromotionStatus.Add(item);
                }
            }
            return(clonedDojoPromotionStatus);
        }
コード例 #2
0
        /// <summary>
        /// Makes a deep copy of the current DojoPromotionStatus.
        /// </summary>
        /// <param name="isolation">Placeholders are used to isolate the
        /// items in the DojoPromotionStatusCollection from their children.</param>
        public DojoPromotionStatusCollection Copy(bool isolated)
        {
            DojoPromotionStatusCollection isolatedCollection = new DojoPromotionStatusCollection(count);

            lock (this)
            {
                if (isolated)
                {
                    for (int i = 0; i < count; i++)
                    {
                        isolatedCollection.Add(DojoPromotionStatusArray[i].NewPlaceHolder());
                    }
                }
                else
                {
                    for (int i = 0; i < count; i++)
                    {
                        isolatedCollection.Add(DojoPromotionStatusArray[i].Copy());
                    }
                }
            }
            return(isolatedCollection);
        }
コード例 #3
0
        private void cacheStoreCollection(int hashCode, DojoPromotionStatusCollection dojoPromotionStatusCollection)
        {
            CacheManager cache = CacheFactory.GetCacheManager();

            cache.Add(tableName + "_Collection_" + hashCode.ToString(), dojoPromotionStatusCollection);
        }
コード例 #4
0
        public DojoPromotionStatusCollection GetCollection(int topCount, string whereClause, string sortClause)
        {
            StringBuilder query;
            Database      database;
            DbCommand     dbCommand;
            IDataReader   r;
            DojoPromotionStatusCollection dojoPromotionStatusCollection;
            int hashcode;

            // Cache Handling

            hashcode = 0;

            if (cacheEnabled)
            {
                hashcode = topCount.GetHashCode() +
                           whereClause.GetHashCode() +
                           sortClause.GetHashCode() +
                           tableName.GetHashCode();

                DojoPromotionStatusCollection collection = cacheFindCollection(hashcode);
                if (collection != null)
                {
                    return(collection);
                }
            }


            query = new StringBuilder("SELECT ");

            if (topCount > 0)
            {
                query.Append("TOP ");
                query.Append(topCount);
                query.Append(" ");
            }

            foreach (string columnName in InnerJoinFields)
            {
                query.Append("DojoPromotionStatus.");
                query.Append(columnName);
                query.Append(",");
            }

            //
            // Remove trailing comma
            //
            query.Length--;
            query.Append(" FROM kitTessen_PromotionStatuses AS DojoPromotionStatus");
            //
            // Render where clause
            //
            if (whereClause != string.Empty)
            {
                query.Append(" WHERE ");
                query.Append(whereClause);
            }

            //
            // Render sort clause
            //
            if (sortClause != string.Empty)
            {
                query.Append(" ORDER BY ");
                query.Append(sortClause);
            }

            //
            // Render final semicolon
            //
            query.Append(";");
            database  = DatabaseFactory.CreateDatabase();
            dbCommand = database.GetSqlStringCommand(query.ToString());
                        #if DEBUG
            try
            {
                r = database.ExecuteReader(dbCommand);
            }
            catch (Exception e)
            {
                string msg = e.Message;
                throw(new Exception(msg + " --- Query: " + query.ToString()));
            }
                        #else
            r = database.ExecuteReader(dbCommand);
                        #endif

            dojoPromotionStatusCollection = new DojoPromotionStatusCollection();

            while (r.Read())
            {
                DojoPromotionStatus dojoPromotionStatus = ParseFromReader(r, 0, 1);

                dojoPromotionStatusCollection.Add(dojoPromotionStatus);
            }

            // Microsoft DAAB still needs to close readers.
            r.Close();

            if (cacheEnabled)
            {
                cacheStoreCollection(hashcode, dojoPromotionStatusCollection);
            }

            return(dojoPromotionStatusCollection);
        }