コード例 #1
0
        public async Task <IActionResult> GetRolesAllAsync([FromQuery] PageParameters pageParameters)
        {
            //var id = Convert.ToInt32(User.Identity.Name);
            IQueryable <Roles> source = context.Roles.Where(m => m.IsDel == 0);


            //角色名称查询
            if (!string.IsNullOrEmpty(pageParameters.RoleName))
            {
                source = source.Where(m => m.Name.Contains(pageParameters.RoleName) && m.IsDel == 0);
            }

            if (pageParameters.CreateTimeByFind != null)
            {
                source = source.Where(m => m.CreateTime >= pageParameters.CreateTimeByFind);
            }

            var pagelist = await PageList <Roles> .CreatePageList(source, pageParameters.Page, pageParameters.Limit);

            var roleShowDtos = mapper.Map <List <RolesShowDto> >(pagelist.Source);

            //var list = await context.Roles.ToListAsync();
            //return Ok(new { code = 0, data = list });

            return(Ok(new { code = 0, data = roleShowDtos, msg = "", count = pagelist.Count }));
        }
コード例 #2
0
        // GET: Films
        public ActionResult Index(int page = 1)
        {
            var items = db.Films.OrderBy(p => p.Id);
            var model = PageList <Film> .CreatePageList(items.ToList(), _pageSize, page);

            return(View(model));
        }
コード例 #3
0
        public async Task <IActionResult> GetPageListByCustomerByNoReal([FromQuery] PageParameters pageParameters)
        {
            var id = Convert.ToInt32(User.Identity.Name);
            IQueryable <Customers> source;

            #region 查询逻辑

            if (pageParameters.EmployeeIDByFind != 0)  //如果查询的员工ID不为0
            {
                source = context.Customers.Where(m => m.IsReal == pageParameters.Status && m.IsDel == 0 && m.EmployeesID == pageParameters.EmployeeIDByFind);
            }
            else   //如果为0就查询自己的
            {
                source = context.Customers.Where(m => m.IsReal == pageParameters.Status && m.IsDel == 0 && m.EmployeesID == id);
            }

            //分类类别的查询
            if (pageParameters.CustomerSegmentationIDByFind != 0)
            {
                source = source.Where(m => m.CustomerSegmentationID == pageParameters.CustomerSegmentationIDByFind);
            }

            //客户名称查询
            if (!string.IsNullOrEmpty(pageParameters.CustomerNameByFind))
            {
                source = source.Where(m => m.Name.Contains(pageParameters.CustomerNameByFind));
            }

            //时间判断
            //开始时间
            if (pageParameters.StartTimeByFind != null)
            {
                source = source.Where(m => m.CreateTime >= pageParameters.StartTimeByFind);
            }


            //结束时间
            if (pageParameters.EndTimeByFind != null)
            {
                source = source.Where(m => m.CreateTime <= pageParameters.EndTimeByFind);
            }

            //中间时间
            if (pageParameters.StartTimeByFind != null && pageParameters.EndTimeByFind != null)
            {
                source = source.Where(m => m.CreateTime >= pageParameters.StartTimeByFind && m.CreateTime <= pageParameters.EndTimeByFind);
            }

            #endregion

            var pagelist = await PageList <Customers> .CreatePageList(source, pageParameters.Page, pageParameters.Limit);

            //Auto映射
            var customerShowDtos = mapper.Map <List <CustomerShowDto> >(pagelist.Source);

            //返回符合Layui的数据格式
            return(Ok(new { code = 0, msg = "", data = customerShowDtos, count = pagelist.Count }));
        }
コード例 #4
0
        public async Task <ActionResult <PageList <WishDto> > > GetWishDtosAsync(int index, int size)
        {
            int userId = Convert.ToInt32(User.Identity.Name);
            var data   = await _repositoryWrapper.WishRepository.GetWishDtosAsync(userId);

            PageList <WishDto> pageList = await PageList <WishDto> .CreatePageList(data.OrderByDescending(m => m.CreateTime).AsQueryable(), index, size);

            return(pageList);
        }
コード例 #5
0
        public async Task <PageList <Product> > GetProductAllByAdmin(int index = 1, int size = 10, string name = "")
        {
            var data = await repositoryWrapper.ProductRepository.GetAllAsync();

            if (!string.IsNullOrEmpty(name))
            {
                data = data.Where(m => m.Title.Contains(name));
            }
            var source = await PageList <Product> .CreatePageList(data, index, size);

            return(source);
        }
コード例 #6
0
        public async Task <IActionResult> GetPageListByEmployee_Roles([FromQuery] PageParameters pageParameters, string employee_RoleIDByFind)
        {
            var id = Convert.ToInt32(User.Identity.Name);
            IQueryable <Employees_Roles> source;

            source = context.Employees_Roles.Where(m => m.IsDel == 0);
            //角色名称查询
            if (!string.IsNullOrEmpty(employee_RoleIDByFind))
            {
                var ent = Convert.ToInt32(employee_RoleIDByFind);
                source = source.Where(m => m.RoleID.Equals(ent) && m.IsDel == 0);
            }
            if (!string.IsNullOrEmpty(pageParameters.CustomerNameByFind))
            {
                source = source.Where(m => m.EmployeeName.Contains(pageParameters.CustomerNameByFind) && m.IsDel == 0);
            }

            var pagelist = await PageList <Employees_Roles> .CreatePageList(source, pageParameters.Page, pageParameters.Limit);

            var employee_roleShowDto = mapper.Map <List <Employees_RolesShowDto> >(pagelist.Source);

            //返回符合Layui的数据格式
            return(Ok(new { code = 0, msg = "", data = employee_roleShowDto, count = pagelist.Count }));
        }
コード例 #7
0
        public async Task <PageList <Product> > GetPageListsAsync(PageParameters pageParameters, int typeId)
        {
            IQueryable <Product> source = context.Set <Product>().Where(m => m.Product_CategoryId == typeId && m.Status.Equals(0) && m.Stock > 0);

            if (typeId == 0)
            {
                source = context.Set <Product>().Where(m => m.Status.Equals(0) && m.Stock > 0);
            }

            if (!string.IsNullOrEmpty(pageParameters.Name))
            {
                source = source.Where(m => m.Title.Contains(pageParameters.Name) && m.Status.Equals(0) && m.Stock > 0);
            }

            //价格区间
            if (pageParameters.BottomPrice != 0 && pageParameters.TopPrice != 0)
            {
                source = source.Where(m => m.Price > pageParameters.BottomPrice && m.Price < pageParameters.TopPrice && m.Status.Equals(0) && m.Stock > 0);
            } //价格区间

            //价格排序
            if (pageParameters.IsPriceSort != null)
            {
                if ((bool)pageParameters.IsPriceSort) //价格升序
                {
                    source = source.Where(m => m.Status.Equals(0) && m.Stock > 0).OrderBy <Product, decimal>(m => m.Price);
                }
                else //价格倒序
                {
                    source = source.Where(m => m.Status.Equals(0) && m.Stock > 0).OrderByDescending <Product, decimal>(m => m.Price);
                }
            }//价格排序


            //销量排序
            if (pageParameters.IsPurchaseSort != null)
            {
                if ((bool)pageParameters.IsPurchaseSort) //销量升序
                {
                    source = source.Where(m => m.Status.Equals(0) && m.Stock > 0).OrderBy <Product, int>(m => m.Purchase);
                }
                else //销量倒序
                {
                    source = source.Where(m => m.Status.Equals(0) && m.Stock > 0).OrderByDescending <Product, int>(m => m.Purchase);
                }
            }//销量排序

            //日期排序
            if (pageParameters.IsTimeSort != null)
            {
                if ((bool)pageParameters.IsTimeSort) //日期升序
                {
                    source = source.Where(m => m.Status.Equals(0) && m.Stock > 0).OrderBy <Product, DateTime>(m => m.CreateTime);
                }
                else //日期倒序
                {
                    source = source.Where(m => m.Status.Equals(0) && m.Stock > 0).OrderByDescending <Product, DateTime>(m => m.CreateTime);
                }
            }//日期排序
            return(await PageList <Product> .CreatePageList(source, pageParameters.PageIndex, pageParameters.PageSize));;
        }