Exemple #1
0
        public async Task <MainGoodsTypeSearchResult> GetModelListAsync(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
        {
            using (MyDbContext dbc = new MyDbContext())
            {
                MainGoodsTypeSearchResult result = new MainGoodsTypeSearchResult();
                var entities = dbc.GetAll <MainGoodsTypeEntity>();
                if (!string.IsNullOrEmpty(keyword))
                {
                    entities = entities.Where(g => g.Name.Contains(keyword) || g.Description.Contains(keyword));
                }
                if (startTime != null)
                {
                    entities = entities.Where(a => a.CreateTime >= startTime);
                }
                if (endTime != null)
                {
                    entities = entities.Where(a => SqlFunctions.DateDiff("day", endTime, a.CreateTime) <= 0);
                }
                result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize);
                var mainGoodsTypesResult = await entities.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();

                result.MainGoodsTypes = mainGoodsTypesResult.Select(a => ToDTO(a)).ToArray();
                return(result);
            }
        }
Exemple #2
0
        public async Task <ApiResult> MainList()
        {
            MainGoodsTypeSearchResult result = await mainGoodsTypeService.GetModelListAsync(null, null, null, 1, 100);

            List <GoodsTypeMainListApiModel> model;

            model = result.MainGoodsTypes.Select(g => new GoodsTypeMainListApiModel {
                id = g.Id, name = g.Name
            }).ToList();
            return(new ApiResult {
                status = 1, data = model
            });
        }