Exemple #1
0
        private Result <T> ReturnRows2 <T>(WAHBitArray ba, List <T> trows, int start, int count, List <int> orderby)
        {
            DateTime   dt   = FastDateTime.Now;
            List <T>   rows = new List <T>();
            Result <T> ret  = new Result <T>();
            int        skip = start;
            int        c    = 0;

            ret.TotalCount = (int)ba.CountOnes();
            if (count == -1)
            {
                count = ret.TotalCount;
            }
            if (count > 0)
            {
                foreach (int i in orderby)
                {
                    if (ba.Get(i))
                    {
                        if (skip > 0)
                        {
                            skip--;
                        }
                        else
                        {
                            bool b = OutputRow <T>(rows, i);
                            if (b && count > 0)
                            {
                                c++;
                            }
                        }
                        ba.Set(i, false);
                        if (c == count)
                        {
                            break;
                        }
                    }
                }
                foreach (int i in ba.GetBitIndexes())
                {
                    if (c < count)
                    {
                        if (skip > 0)
                        {
                            skip--;
                        }
                        else
                        {
                            bool b = OutputRow <T>(rows, i);
                            if (b && count > 0)
                            {
                                c++;
                            }
                        }
                        if (c == count)
                        {
                            break;
                        }
                    }
                }
            }
            if (trows != null)// TODO : move to start and decrement in count
            {
                foreach (var o in trows)
                {
                    rows.Add(o);
                }
            }
            _log.Debug("query rows fetched (ms) : " + FastDateTime.Now.Subtract(dt).TotalMilliseconds);
            _log.Debug("query rows count : " + rows.Count.ToString("#,0"));
            ret.OK    = true;
            ret.Count = rows.Count;
            ret.Rows  = rows;
            return(ret);
        }
Exemple #2
0
        internal Result <object> Query(int start, int count, string orderby)
        {
            // no filter query -> just show all the data
            DateTime dt = FastDateTime.Now;

            _log.Debug("query : " + _view.Name);
            int             totalviewrows = _viewData.Count();
            List <object>   rows          = new List <object>();
            Result <object> ret           = new Result <object>();
            int             skip          = start;
            int             cc            = 0;
            WAHBitArray     del           = _deletedRows.GetBits();

            ret.TotalCount = totalviewrows - (int)del.CountOnes();

            var order = SortBy(orderby);

            if (order.Count == 0)
            {
                for (int i = 0; i < totalviewrows; i++)
                {
                    order.Add(i);
                }
            }

            if (count == -1)
            {
                count = totalviewrows;
            }

            foreach (int i in order)
            {
                if (del.Get(i) == true)
                {
                    continue;
                }
                if (skip > 0)
                {
                    skip--;
                }
                else
                {
                    bool b = OutputRow <object>(rows, i);
                    if (b && count > 0)
                    {
                        cc++;
                    }
                }
                if (cc == count)
                {
                    break;
                }
            }

            _log.Debug("query rows fetched (ms) : " + FastDateTime.Now.Subtract(dt).TotalMilliseconds);
            _log.Debug("query rows count : " + rows.Count.ToString("#,0"));
            ret.OK    = true;
            ret.Count = rows.Count;
            //ret.TotalCount = rows.Count;
            ret.Rows = rows;
            return(ret);
        }