Пример #1
0
        /// <summary>
        /// Partitions the elements of a list around a given pivot element. The range to partition is [<paramref name="begin"/>, <paramref name="end"/>), and this range must be at least 2 elements long.
        /// </summary>
        /// <typeparam name="T">The type of items in the list.</typeparam>
        /// <param name="parameters">The source list, comparison object, and other lists that must be kept in sync.</param>
        /// <param name="begin">The beginning of the range to partition.</param>
        /// <param name="end">The ending of the range to partition.</param>
        /// <param name="pivotIndex">The index of the element chosen as the pivot.</param>
        /// <returns>The new index of the pivot element.</returns>
        private static int QuickSortPartition <T>(SortParameters <T> parameters, int begin, int end, int pivotIndex)
        {
            T pivotValue = parameters.List[pivotIndex];

            // Move the pivot value to the end of the list temporarily
            parameters.Swap(pivotIndex, end - 1);

            // Make our way through the list (except the pivot value at the end), moving each element less than the pivot
            int storeIndex = begin;

            for (int i = begin; i != end - 1; ++i)
            {
                if (parameters.Comparer.Compare(parameters.List[i], pivotValue) < 0)
                {
                    parameters.Swap(i, storeIndex);
                    ++storeIndex;
                }
            }

            // Move pivot back to its proper place
            parameters.Swap(storeIndex, end - 1);

            // Return the new index of the pivot element
            return(storeIndex);
        }
Пример #2
0
        public async Task <WrappedResponse <IEnumerable <PaymentRequest> > > SelectPaymentRequests
        (
            string searchColumn,
            string prefix,
            string sortColumn,
            bool descendingOrder
        )
        {
            var searchParameters = new SearchParameters
            {
                Column = searchColumn,
                Prefix = prefix
            };

            var sortParameters = new SortParameters
            {
                Column          = sortColumn,
                DescendingOrder = descendingOrder
            };

            var response = await paymentRepository.SelectPaymentRequestsAsync(searchParameters, sortParameters)
                           .ConfigureAwait(false);

            return(WrappedResponse <IEnumerable <PaymentRequest> > .Success(response));
        }
Пример #3
0
 /// <summary>
 /// 添加排序列名参数
 /// Add by Jason.Song on 2018/10/18
 /// </summary>
 /// <param name="name">待排序的列名</param>
 /// <param name="sort">排序类型</param>
 public void AddSortParameter(string name, SortType sort)
 {
     if (!SortParameters.ContainsKey(name))
     {
         SortParameters.Add(name, sort);
     }
 }
Пример #4
0
        public void SortText_Desc_SortDesc()
        {
            //Given
            RegExProvider.Setup(x => x.GetMatches(It.IsAny <string>(), It.IsAny <string>())).Returns(new List <string>()
            {
                "1", "2", "3"
            });

            var parameters = new SortParameters()
            {
                Asc         = false,
                SortOptions = SortOptions.AlphabeticOrder,
                Text        = "Text"
            };

            //When
            SortTextModel result = SortService.SortText(parameters);

            //Then
            Assert.IsNotNull(result);
            Assert.AreEqual(3, result.SortedText.Count());
            Assert.AreEqual("3", result.SortedText.First());
            Assert.AreEqual("2", result.SortedText.ElementAt(1));
            Assert.AreEqual("1", result.SortedText.Last());
        }
Пример #5
0
        /// <summary>
        /// 煤车篷布资讯
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult Index(int pageIndex = 1, int pageSize = 5, int?id = 0)
        {
            ViewData["pageIndex"] = pageIndex;
            ViewData["pageSize"]  = pageSize;
            ViewData["total"]     = 0;
            int totalcount = 0;

            List <newst> list = new List <newst>();

            // list = newsbll.getall();

            StringBuilder where = new StringBuilder();
            where.Append(" and del =1");
            SortParameter sa = new SortParameter();

            sa.Field     = "creationtime";
            sa.Direction = SortDirection.DESC;
            SortParameters ot = new SortParameters();

            ot.Add(sa);
            list = newsbll.GetPage(out totalcount, pageIndex, pageSize, where.ToString(), "", ot);
            ViewData["total"] = totalcount;

            return(View(list));
        }
Пример #6
0
        public int Compare(object x, object y)
        {
            if (mOrder == SortOrder.None)
            {
                return(0);
            }

            ListViewItem lvix = (ListViewItem)x;
            ListViewItem lviy = (ListViewItem)y;

            string         sx             = lvix.SubItems[mColumn].Text;
            string         sy             = lviy.SubItems[mColumn].Text;
            SortParameters sort_params    = null;
            int            compare_result = 0;

            if (!mSorters.TryGetValue(mColumn, out sort_params))
            {
                compare_result = CaseInsensitiveComparer.Default.Compare(sx, sy);
            }
            else
            {
                if (sort_params.Converter != null)
                {
                    sx = sort_params.Converter.Convert(sx);
                    sy = sort_params.Converter.Convert(sy);
                }

                compare_result = sort_params.Comparer.Compare(sx, sy);
            }

            return((mOrder == SortOrder.Ascending) ? compare_result : (-compare_result));
        }
Пример #7
0
        public async Task Projects_SortProjectsByName_Succeeds()
        {
            var groupShareClient = Helper.GsClient;
            var sortParameters   = new SortParameters
            {
                Property  = SortParameters.PropertyOption.ProjectName,
                Direction = SortParameters.DirectionOption.ASC
            };
            var projectRequest = new ProjectsRequest(sortParameters);

            var sortedProjects = await groupShareClient.Project.GetProject(projectRequest);

            var projects = await groupShareClient.Project.GetAllProjects();

            Assert.True(sortedProjects.Items.Count == projects.Items.Count);

            var projectsNames = projects.Items.Select(p => p.Name).ToList();

            projectsNames.Sort();

            int i = 0;

            foreach (var proj in sortedProjects.Items)
            {
                Assert.True(string.Compare(proj.Name, projectsNames[i++], StringComparison.CurrentCultureIgnoreCase) == 0);
            }
        }
Пример #8
0
        public PagedDataViewer(ITradeService tradeService, ISchedulerProvider schedulerProvider)
        {
            //build observable predicate from search text
            var filter = this.WhenValueChanged(t => t.SearchText)
                         .Throttle(TimeSpan.FromMilliseconds(250))
                         .Select(BuildFilter);

            //build observable sort comparer
            var sort = SortParameters.WhenValueChanged(t => t.SelectedItem)
                       .Select(prop => prop.Comparer)
                       .ObserveOn(schedulerProvider.Background);

            //build observable comparer
            var currentPageChanged = PageParameters.WhenValueChanged(p => p.CurrentPage);
            var pageSizeChanged    = PageParameters.WhenValueChanged(p => p.PageSize);
            var pager = currentPageChanged.CombineLatest(pageSizeChanged, (page, size) => new PageRequest(page, size))
                        .StartWith(new PageRequest(1, 25))
                        .DistinctUntilChanged()
                        .Sample(TimeSpan.FromMilliseconds(100));

            // filter, sort, page and bind to observable collection
            _cleanUp = tradeService.All.Connect()
                       .Filter(filter) // apply user filter
                       .Transform(trade => new TradeProxy(trade), new ParallelisationOptions(ParallelType.Ordered, 5))
                       .Sort(sort, SortOptimisations.ComparesImmutableValuesOnly)
                       .Page(pager)
                       .ObserveOn(schedulerProvider.MainThread)
                       .Do(changes => PageParameters.Update(changes.Response))
                       .Bind(out _data) // update observable collection bindings
                       .DisposeMany()   // dispose when no longer required
                       .Subscribe();
        }
Пример #9
0
        public async Task <IHttpActionResult> GetVehicleModelsAsync(string search, int?makeId, string sortOrder = "", int?page = 1, int pageSize = 5, string sortBy = "")
        {
            var filter = new FilterParameters
            {
                Search = search,
                MakeId = makeId
            };
            var sort = new SortParameters
            {
                SortBy    = sortBy,
                SortOrder = sortOrder
            };
            var pagep = new PageParameters
            {
                Page     = (int)page,
                PageSize = pageSize,
            };
            var vmlist = await _vehicleModelService.GetVehicleModelsAsync(sort, filter, pagep);

            return(Ok(new
            {
                Data = vmlist,
                PaggingInfo = vmlist.GetMetaData()
            }));
        }
Пример #10
0
        /// <summary>
        /// Get method,
        /// /api/VehicleMake/?page=&pagesize=5&search=&sort=&direction=
        /// </summary>
        /// <param name="page">Current page</param>
        /// <param name="pagesize">Page size, if page size is not given it's set to 0</param>
        /// <param name="search">Search</param>
        /// <param name="sort">Sort by Name or Abrv</param>
        /// <param name="direction">Sort direction it can be ascending or descending</param>
        /// <returns>Returns a list of VehicleMakeVM</returns>
        public async Task <IHttpActionResult> Get(int?page, int?pagesize, string search, string sort, string direction)
        {
            var sortParameters = new SortParameters()
            {
                Sort          = sort,
                SortDirection = direction ?? "Descending"
            };
            var filterParameters = new FilterParameters()
            {
                Search = search
            };
            var pageParameters = new PageParameters()
            {
                Page = page ?? 1,

                /*I set the page size to 0, because as you can see in VehicleMakeService when page size is set to 0 it skips pagging.
                 * Because in one case I need to get all of thevehicle makes.
                 * Example is in angular part when I need to get all VehicleMakes when I'm creating a new VehicleModel,
                 * it needs VehicleMakeId to be created.
                 * So a drop down menu with all Vehicle Makes can be created from which VehicleMakeId can be chosen from.
                 */
                PageSize = pagesize ?? 0
            };
            var vehicleMakeListPaged = AutoMapper.Mapper.Map <IPagedResult <VehicleMakeVM> >(await service.GetVehicleMakesAsync(sortParameters, filterParameters, pageParameters));

            return(Ok(vehicleMakeListPaged));
        }
Пример #11
0
        public async Task <IHttpActionResult> GetVehicleMakesAsync(string search, int?page = 1, int pageSize = 5, string sortOrder = "", string sortBy = "")
        {
            var filter = new FilterParameters
            {
                Search = search
            };
            var sort = new SortParameters
            {
                SortBy    = sortBy,
                SortOrder = sortOrder
            };
            var pagep = new PageParameters
            {
                Page     = (int)page,
                PageSize = pageSize
            };
            var vmlist = await _vehicleMakeService.GetVehicleMakesAsync(sort, filter, pagep);

            var makeVMList = AutoMapper.Mapper.Map <IEnumerable <VehicleMakeVM> >(vmlist);

            return(Ok(new
            {
                Data = makeVMList,
                PaggingInfo = vmlist.GetMetaData()
            }));
        }
Пример #12
0
        public void SortText_ParameterPropertyIsNull_Expetion()
        {
            //Given
            var parameters = new SortParameters();

            //When,Then
            Assert.ThrowsException <ArgumentNullException>(() => { SortService.SortText(parameters); });
        }
Пример #13
0
        public ActionResult videoList(int pageIndex = 1, int pageSize = 10)
        {
            List <video> list = new List <sjth.Model.video>();


            List <video> li = new List <video>();

            ViewData["pageIndex"] = pageIndex;
            ViewData["pageSize"]  = pageSize;
            ViewData["total"]     = 0;

            string name  = Request["name"];
            string start = Request["start"];
            string end   = Request["end"];

            try
            {
                StringBuilder where = new StringBuilder();
                where.Append(" and del =1 ");
                if (!string.IsNullOrWhiteSpace(name))
                {
                    where.Append(" and name like'%" + name.Trim() + "%'");
                }
                if (!string.IsNullOrWhiteSpace(start) && !string.IsNullOrWhiteSpace(end))
                {
                    //where.Append(" and creationtime>='" + start + "'");
                    //creationtime between '2016-12-07' and '2016-12-08 23:59:59'
                    where.Append(" and datatimes between '" + start + "' and '" + end + "  23:59:59'");
                }
                if (!string.IsNullOrWhiteSpace(start) && string.IsNullOrWhiteSpace(end))
                {
                    where.Append(" and datatimes>='" + start + "'");
                }
                if (string.IsNullOrWhiteSpace(start) && !string.IsNullOrWhiteSpace(end))
                {
                    where.Append(" and datatimes<='" + end + " 23:59:59'");
                }
                SortParameter sa = new SortParameter();
                sa.Field     = "datatimes";
                sa.Direction = SortDirection.DESC;
                SortParameters ot = new SortParameters();
                ot.Add(sa);
                int totalcount = 0;
                list = _video.GetPage(out totalcount, pageIndex, pageSize, where.ToString(), "", ot);
                // list = newsbll.getall();
                ViewData["total"] = totalcount;

                // list = _video.allList();
                return(View(list));
            }
            catch (Exception)
            {
                return(View(list));
            }
        }
Пример #14
0
        public SortTextModel SortText(SortParameters parameters)
        {
            if (parameters == null || parameters.Text == null)
            {
                throw new ArgumentNullException();
            }
            var           sortStrategy = GetSortStrategy(parameters.SortOptions);
            SortTextModel result       = sortStrategy.Sort(parameters.Text, parameters.Asc);

            return(result);
        }
Пример #15
0
        public void TestInvalidUpdateTemplatesInjection(SortParameters param, Enums.InvalidInjection invalid)
        {
            var handler = new DefaultManager();
            var request = BuildSortRequest(1, new List <int> {
                Id
            });

            request[param.GetEnumStringValue()] = MapperData.InvalidInjectionMapper[invalid];
            var response = handler.Send <object>(TemplatesEndPoint, JsonConvert.SerializeObject(request), HttpMethod.PUT);

            PrAssert.That(response, PrIs.ErrorResponse().And.HttpCode(System.Net.HttpStatusCode.BadRequest));
        }
Пример #16
0
 private bool _isSorted(Figure[] array, SortParameters parameters)
 {
     if (array == null)
     {
         throw new ArgumentException("Передайте существующий массив для проверки.");
     }
     for (int i = 1; i < array.Length; i++)
     {
         if (parameters == SortParameters.Square
             ? (array[i - 1].GetSquare() > array[i].GetSquare())
             : (array[i - 1].GetPerimeter() > array[i].GetPerimeter()))
         {
             return(false);
         }
     }
     return(true);
 }
Пример #17
0
        public ActionResult school(int pageIndex = 1, int pageSize = 10, int?id = 0)
        {
            List <newstype> typelist = new List <newstype>();
            string          whereS   = " PPID=2 and del =1";

            typelist     = newstypeBLL.GetAll(whereS);
            ViewBag.data = typelist;
            List <newst>    list = new List <newst>();
            List <newsName> li   = new List <newsName>();

            ViewData["pageIndex"] = pageIndex;
            ViewData["pageSize"]  = pageSize;
            ViewData["total"]     = 0;
            ViewData["name"]      = newstypeBLL.GetById((int)id).typename;
            int totalcount = 0;

            StringBuilder where = new StringBuilder();
            where.Append(" and del =1 and newstype = " + id);
            SortParameter sa = new SortParameter();

            sa.Field     = "creationtime";
            sa.Direction = SortDirection.DESC;
            SortParameters ot = new SortParameters();

            ot.Add(sa);
            list = newsbll.GetPage(out totalcount, pageIndex, pageSize, where.ToString(), "", ot);
            // list = newsbll.getall();
            ViewData["total"] = totalcount;
            if (list.Count > 0)
            {
                foreach (var item in list)
                {
                    newsName model = new newsName();
                    model.id           = item.id;
                    model.headline     = item.headline;
                    model.newstype     = item.newstype;
                    model.newstypename = newstypeBLL.GetById((int)item.newstype).typename;
                    model.userid       = item.userid;
                    model.del          = item.del;
                    model.creationtime = item.creationtime;
                    model.contenttext  = item.contenttext;
                    li.Add(model);
                }
            }
            return(View(li));
        }
Пример #18
0
        /// <summary>
        /// Sorts a portion of a list. The range to sort is [<paramref name="begin"/>, <paramref name="end"/>).
        /// </summary>
        /// <typeparam name="T">The type of items in the list.</typeparam>
        /// <param name="parameters">The source list, comparison object, and other lists that must be kept in sync.</param>
        /// <param name="begin">The beginning of the range to sort.</param>
        /// <param name="end">The ending of the range to sort.</param>
        private static void QuickSortCore <T>(SortParameters <T> parameters, int begin, int end)
        {
            // Empty lists and single-element lists are sorted by definition
            if (begin >= end - 1)
            {
                return;
            }

            // Choose a pivot element (we just choose the first one), and partition around it
            int newPivotIndex = QuickSortPartition(parameters, begin, end, begin);

            // Sort the left side (not including the pivot element)
            QuickSortCore(parameters, begin, newPivotIndex);

            // Sort the right side (not including the pivot element)
            QuickSortCore(parameters, newPivotIndex + 1, end);
        }
        public async Task SortProjectsByName()
        {
            var groupShareClient = await Helper.GetGroupShareClient();

            var sortParameters = new SortParameters()
            {
                Property  = SortParameters.PropertyOption.ProjectName,
                Direction = SortParameters.DirectionOption.DESC
            };
            var projectRequest = new ProjectsRequest(sortParameters);

            var sortedProjects = await groupShareClient.Project.GetProject(projectRequest);

            var projects = await groupShareClient.Project.GetAllProjects();

            Assert.True(sortedProjects.Items.Count == projects.Items.Count);
        }
Пример #20
0
        public ActionResult Sort(TextInputModel text, SortOptionInputModel sortOption)
        {
            if (!ModelState.IsValid)
            {
                return(GetErrorResponse());
            }

            SortParameters parameters = new SortParameters()
            {
                Text        = GetText(text.File),
                SortOptions = sortOption.SortOptions,
                Asc         = sortOption.Asc
            };

            var order = sortService.SortText(parameters);

            return(Json(order));
        }
Пример #21
0
        public void TestInvalidSortTemplate(SortParameters param, InvalidValue invalid)
        {
            var handler = new DefaultManager();
            var request = BuildSortRequest(1, Ids);
            var item    = request["template_0"] as Dictionary <string, object>;

            if (invalid == InvalidValue.MissingParam)
            {
                item.Remove(param.GetEnumStringValue());
            }
            else
            {
                InvalidValueMapper[invalid](item, param.GetEnumStringValue());
            }
            request["template_0"] = item;
            var response = handler.Send <object>(TemplatesEndPoint, JsonConvert.SerializeObject(request), HttpMethod.PUT);

            PrAssert.That(response, PrIs.ErrorResponse().And.HttpCode(System.Net.HttpStatusCode.BadRequest));
        }
Пример #22
0
        public async Task <IEnumerable <PaymentRequest> > SelectPaymentRequestsAsync
        (
            SearchParameters searchParameters,
            SortParameters sortParameters
        )
        {
            using (var context = ContextFactory.CreateDbContext(ConnectionString))
            {
                var query = context.PaymentRequests.AsQueryable();

                if (searchParameters?.Column != null && searchParameters.Prefix != null)
                {
                    query = query.Where(request =>
                                        typeof(PaymentRequest)
                                        .GetProperty(searchParameters.Column)
                                        .GetValue(request)
                                        .ToString()
                                        .StartsWith(searchParameters.Prefix));
                }

                if (sortParameters?.Column != null)
                {
                    if (sortParameters.DescendingOrder)
                    {
                        query = query.OrderByDescending(payment =>
                                                        typeof(PaymentRequest)
                                                        .GetProperty(sortParameters.Column)
                                                        .GetValue(payment)
                                                        .ToString());
                    }
                    else
                    {
                        var columnProp = typeof(PaymentRequest).GetProperty(sortParameters.Column);
                        query = query.OrderBy(payment =>
                                              columnProp
                                              .GetValue(payment)
                                              .ToString());
                    }
                }

                return(await query.ToListAsync().ConfigureAwait(false));
            }
        }
Пример #23
0
        public PagedDataViewer(ILogger logger, ITradeService tradeService, ISchedulerProvider schedulerProvider)
        {
            _logger = logger;

            //watch for filter changes and change filter
            var filterController = new FilterController <Trade>(trade => true);
            var filterApplier    = this.ObservePropertyValue(t => t.SearchText)
                                   .Throttle(TimeSpan.FromMilliseconds(250))
                                   .Select(propargs => BuildFilter(propargs.Value))
                                   .Subscribe(filterController.Change);

            //watch for changes to sort and apply when necessary
            var sortContoller = new SortController <TradeProxy>(SortExpressionComparer <TradeProxy> .Ascending(proxy => proxy.Id));
            var sortChange    = SortParameters.ObservePropertyValue(t => t.SelectedItem).Select(prop => prop.Value.Comparer)
                                .ObserveOn(schedulerProvider.TaskPool)
                                .Subscribe(sortContoller.Change);

            //watch for page changes and change filter
            var pageController     = new PageController();
            var currentPageChanged = PageParameters.ObservePropertyValue(p => p.CurrentPage).Select(prop => prop.Value);
            var pageSizeChanged    = PageParameters.ObservePropertyValue(p => p.PageSize).Select(prop => prop.Value);
            var pageChanger        = currentPageChanged.CombineLatest(pageSizeChanged,
                                                                      (page, size) => new PageRequest(page, size))
                                     .DistinctUntilChanged()
                                     .Sample(TimeSpan.FromMilliseconds(100))
                                     .Subscribe(pageController.Change);

            // filter, sort, page and bind to loaded data
            var loader = tradeService.All.Connect()
                         .Filter(filterController) // apply user filter
                         .Transform(trade => new TradeProxy(trade), new ParallelisationOptions(ParallelType.Ordered, 5))
                         .Sort(sortContoller, SortOptimisations.ComparesImmutableValuesOnly)
                         .Page(pageController)
                         .ObserveOn(schedulerProvider.MainThread)
                         .Do(changes => _pageParameters.Update(changes.Response))
                         .Bind(_data)   // update observable collection bindings
                         .DisposeMany() //since TradeProxy is disposable dispose when no longer required
                         .Subscribe();

            _cleanUp = new CompositeDisposable(loader, filterController, filterApplier, sortChange, sortContoller, pageChanger, pageController);
        }
Пример #24
0
        public ActionResult product(int pageIndex = 1, int pageSize = 10)
        {
            ViewData["pageIndex"] = pageIndex;
            ViewData["pageSize"]  = pageSize;
            ViewData["total"]     = 0;
            int            totalcount = 0;
            List <product> list       = new List <product>();

            StringBuilder where = new StringBuilder();
            SortParameter sa = new SortParameter();

            sa.Field     = "datatimes";
            sa.Direction = SortDirection.DESC;
            SortParameters ot = new SortParameters();

            ot.Add(sa);
            where.Append(" and del =1 ");
            list = _productbll.GetPage(out totalcount, pageIndex, pageSize, where.ToString(), "", ot);
            ViewData["total"] = totalcount;
            return(View(list));
        }
Пример #25
0
        public async Task <IHttpActionResult> Get(int?page, int?pagesize, string search, string sort, string direction, int?makeid)
        {
            var sortParameters = new SortParameters()
            {
                Sort          = sort,
                SortDirection = direction ?? "Descending"
            };
            var filterParameters = new FilterParameters()
            {
                Search        = search,
                VehicleMakeId = makeid
            };
            var pageParameters = new PageParameters()
            {
                Page     = page ?? 1,
                PageSize = pagesize ?? 5
            };
            var vehicleModelListPaged = AutoMapper.Mapper.Map <IPagedResult <VehicleModelVM> >(await service.GetVehicleModelsAsync(sortParameters, filterParameters, pageParameters));

            return(Ok(vehicleModelListPaged));
        }
        public ActionResult VehicleMakeList(int?page, string sort, string direction, string search)
        {
            var sortParameters = new SortParameters()
            {
                Sort = sort, Direction = direction
            };
            var filterParameters = new FilterParameters()
            {
                Search = search
            };
            var pagingParameters = new PageParameters()
            {
                Page = page ?? 1, PageSize = 3
            };
            var vehicleMakeList = vehicleMakeService.GetVehicleMakePaged(sortParameters, filterParameters, pagingParameters);

            ViewBag.search    = search;
            ViewBag.sort      = sort;
            ViewBag.direction = direction;
            var makeListViewModel = AutoMapper.Mapper.Map <IEnumerable <MakeViewModel> >(vehicleMakeList);

            return(View(new StaticPagedList <MakeViewModel>(makeListViewModel, vehicleMakeList.GetMetaData())));
        }
Пример #27
0
        public ActionResult newsList(int pageIndex = 1, int pageSize = 10)
        {
            List <newst>    list = new List <newst>();
            List <newsName> li   = new List <newsName>();

            ViewData["pageIndex"] = pageIndex;
            ViewData["pageSize"]  = pageSize;
            ViewData["total"]     = 0;
            try
            {
                string name       = Request["name"];
                string start      = Request["start"];
                string end        = Request["end"];
                int    totalcount = 0;
                StringBuilder where = new StringBuilder();
                where.Append(" and del =1 ");
                if (!string.IsNullOrWhiteSpace(name))
                {
                    where.Append(" and headline like'%" + name.Trim() + "%'");
                }
                if (!string.IsNullOrWhiteSpace(start) && !string.IsNullOrWhiteSpace(end))
                {
                    //where.Append(" and creationtime>='" + start + "'");
                    //creationtime between '2016-12-07' and '2016-12-08 23:59:59'
                    where.Append(" and creationtime between '" + start + "' and '" + end + "  23:59:59'");
                }
                if (!string.IsNullOrWhiteSpace(start) && string.IsNullOrWhiteSpace(end))
                {
                    where.Append(" and creationtime>='" + start + "'");
                }
                if (string.IsNullOrWhiteSpace(start) && !string.IsNullOrWhiteSpace(end))
                {
                    where.Append(" and creationtime<='" + end + " 23:59:59'");
                }
                SortParameter sa = new SortParameter();
                sa.Field     = "creationtime";
                sa.Direction = SortDirection.DESC;
                SortParameters ot = new SortParameters();
                ot.Add(sa);
                list = newsbll.GetPage(out totalcount, pageIndex, pageSize, where.ToString(), "", ot);
                // list = newsbll.getall();
                ViewData["total"] = totalcount;
                if (list.Count > 0)
                {
                    foreach (var item in list)
                    {
                        newsName model = new newsName();
                        model.id           = item.id;
                        model.headline     = item.headline;
                        model.newstype     = item.newstype;
                        model.newstypename = newstypeBLL.GetById((int)item.newstype).typename;
                        model.userid       = item.userid;
                        model.del          = item.del;
                        model.creationtime = item.creationtime;
                        model.contenttext  = item.contenttext;
                        li.Add(model);
                    }
                }
            }
            catch (Exception)
            {
            }
            return(View(li));
        }
Пример #28
0
        /// <summary>
        ///  获取简单分页数据,默认按照Id升序排序
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="totalCount">总记录数</param>
        /// <param name="pageNumber">页索引</param>
        /// <param name="pageSize">页大小</param>
        /// <param name="condition">查询条件</param>
        /// <param name="param">查询参数</param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public List <T> GetPage(out int count, int pageNumber = 1, int pageSize = 20, string condition = null, object param = null, SortParameters sort = null)
        {
            T      t   = new T();
            string key = string.Format(NEWS_PAGE, pageNumber, pageSize, condition, t.GetType().Name);
            int    totalCount;
            var    list = _iBaseManager.GetPage(out totalCount, pageNumber, pageSize, condition, param, sort);

            count = totalCount;
            return(new PageModel <T>(pageSize, pageNumber, totalCount, list));
        }
Пример #29
0
        /// <summary>
        ///  获取简单分页数据,默认按照Id升序排序
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="totalCount">总记录数</param>
        /// <param name="pageNumber">页索引</param>
        /// <param name="pageSize">页大小</param>
        /// <param name="condition">查询条件</param>
        /// <param name="param">查询参数</param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public List <T> GetPage(out int totalCount, int pageNumber = 1, int pageSize = 20, string condition = null, object param = null, SortParameters sort = null)
        {
            string sql4list = string.Empty;

            try
            {
                string subsql4sort = "ORDER BY [id]";
                if (sort != null && sort.Count > 0)
                {
                    List <string> list = new List <string>();
                    foreach (var item in sort)
                    {
                        list.Add(string.Format(" [{0}] {1}", item.Field, item.Direction == SortDirection.ASC ? "ASC" : "DESC"));
                    }

                    subsql4sort = string.Format("ORDER BY {0}", string.Join(",", list));
                }

                sql4list = @"   SELECT id,{0} 
                                FROM (
	                                SELECT ROW_NUMBER() OVER({5}) AS ROW_NUM,{0},id FROM [{1}] WHERE 1 = 1 {4}
                                )AS TEMP
                                WHERE TEMP.ROW_NUM BETWEEN {2} AND {3}";
                string sql4count = string.Format("SELECT COUNT(1) FROM {0} WHERE 1 = 1 {1}", TableName <T>(), condition);

                int beginIndex = (pageNumber - 1) * pageSize + 1;
                int endIndex   = pageNumber * pageSize;

                sql4list   = string.Format(sql4list, FieldNames(typeof(T)), TableName <T>(), beginIndex, endIndex, condition, subsql4sort);
                totalCount = Run(conn => Convert.ToInt32(conn.ExecuteScalar(sql4count, param)));
                return(Run(conn => conn.Query <T>(sql4list, param).ToList()));
            }
            catch (Exception e)
            {
                Logger.writeInfos("-----------public List<T> GetPage(out int totalCount, int pageNumber = 1, int pageSize = 20, string condition = null, object param = null, SortParameters sort = null)-----------\r\n" + sql4list + "\r\n" + e.Message + "\r\n");
                totalCount = 0;
                return(null);
            }
        }
Пример #30
0
        static void startSort(Object obj)
        {
            SortParameters sortParams = (SortParameters)obj;

            sortParams.instance.QuickSorting(sortParams.ints, sortParams.left, sortParams.right);
        }