예제 #1
0
        public Paging <Like> FindPageList(Paging <Like> pagingLike, int?order)
        {
            OrderParamcs _order;

            switch (order)
            {
            case 0:
                _order = new OrderParamcs()
                {
                    PropertyName = "ID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 1:
                _order = new OrderParamcs()
                {
                    PropertyName = "ID", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            default:
                _order = new OrderParamcs()
                {
                    PropertyName = "ID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;
            }
            pagingLike.Items = Repository.FindPageList(pagingLike.PageSize, pagingLike.PageIndex, out pagingLike.TotalNumber, _order).ToList();
            return(pagingLike);
        }
예제 #2
0
        public Search <Movie> Search(Search <Movie> searchMovie, string keyword, int?order)
        {
            var _where = PredicateBuilder.True <Movie>();

            _where = _where.And(m => m.MovieName.Contains(keyword) || m.Actors.Contains(keyword) || m.Director.Contains(keyword));
            _where = _where.And(m => m.Hidden == Movie.Hiddens.显示);
            OrderParamcs _order;

            switch (order)
            {
            case 0:
                _order = new OrderParamcs()
                {
                    PropertyName = "Score", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 1:
                _order = new OrderParamcs()
                {
                    PropertyName = "Score", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            default:
                _order = new OrderParamcs()
                {
                    PropertyName = "Score", Method = OrderParamcs.OrderMethod.ASC
                };
                break;
            }
            searchMovie.Items = Repository.FindWhere(_where.Expand(), _order).ToList();
            return(searchMovie);
        }
예제 #3
0
        public Paging <Article> FindAuditPageList(Paging <Article> pagingArticle, int?order)
        {
            var _where = PredicateBuilder.True <Article>();

            _where = _where.And(u => u.Auditstatus == Article.Status.待审核);
            OrderParamcs _order;

            switch (order)
            {
            case 0:
                _order = new OrderParamcs()
                {
                    PropertyName = "Releasetime", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 1:
                _order = new OrderParamcs()
                {
                    PropertyName = "Releasetime", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            default:
                _order = new OrderParamcs()
                {
                    PropertyName = "Releasetime", Method = OrderParamcs.OrderMethod.ASC
                };
                break;
            }
            pagingArticle.Items = Repository.FindWherePageList(pagingArticle.PageSize, pagingArticle.PageIndex, out pagingArticle.TotalNumber, _where.Expand(), _order).ToList();
            return(pagingArticle);
        }
예제 #4
0
        /// <summary>
        /// 分页排序
        /// </summary>
        /// <param name="pagingHistory"></param>
        /// <param name="order">【0】HistoryID-正序,【1】HistoryID-倒序,【2】userID-正序,【3】UserID-倒序,【4】ViewTime-正序,【5】ViewTime-倒序</param>
        /// <returns></returns>
        public Paging <History> FindPageList(Paging <History> pagingHistory, int?order)
        {
            OrderParamcs _order;

            switch (order)
            {
            case 0:
                _order = new OrderParamcs()
                {
                    PropertyName = "HistoryID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 1:
                _order = new OrderParamcs()
                {
                    PropertyName = "HistoryID", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            case 2:
                _order = new OrderParamcs()
                {
                    PropertyName = "UserID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 3:
                _order = new OrderParamcs()
                {
                    PropertyName = "UserID", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            case 4:
                _order = new OrderParamcs()
                {
                    PropertyName = "ViewTime", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 5:
                _order = new OrderParamcs()
                {
                    PropertyName = "ViewTime", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            default:
                _order = new OrderParamcs()
                {
                    PropertyName = "HistoryID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;
            }
            pagingHistory.Items = Repository.FindPageList(pagingHistory.PageSize, pagingHistory.PageIndex, out pagingHistory.TotalNumber, _order).ToList();
            return(pagingHistory);
        }
예제 #5
0
        public Paging <User> FindKeywordPageList(Paging <User> pagingUser, int?order, string keyword, int selectval)
        {
            var _where = PredicateBuilder.True <User>();

            if (keyword != null)
            {
                _where = _where.And(m => m.Username.Contains(keyword));
            }
            if (selectval != 2)
            {
                _where = _where.And(m => m.Userstatus == (User.UserStatus)selectval);
            }
            OrderParamcs _order;

            switch (order)
            {
            case 0:
                _order = new OrderParamcs()
                {
                    PropertyName = "ID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;

            case 1:
                _order = new OrderParamcs()
                {
                    PropertyName = "ID", Method = OrderParamcs.OrderMethod.DESC
                };
                break;

            default:
                _order = new OrderParamcs()
                {
                    PropertyName = "ID", Method = OrderParamcs.OrderMethod.ASC
                };
                break;
            }
            pagingUser.Items = Repository.FindWherePageList(pagingUser.PageSize, pagingUser.PageIndex, out pagingUser.TotalNumber, _where.Expand(), _order).ToList();
            return(pagingUser);
        }