Esempio n. 1
0
        public APIResult GetSkuItems([FromBody] GetSkuItemsArgsModel args)
        {
            var query = db.Query <ShopBrandCommoditySkuItem>()
                        .Where(m => !m.IsDel);

            var list = query
                       .Where(m => m.Sku.CommodityId == args.CommodityId)
                       .OrderByDescending(m => m.Id)
                       .Select(m => new SkuItem()
            {
                Id    = m.Id,
                SkuId = m.SkuId,
                Value = m.ParameterValue.Value
            })
                       .ToList();

            return(Success(new GetSkuItemsModel()
            {
                Items = list
            }));
        }
Esempio n. 2
0
        public APIResult GetSkuItems([FromBody] GetSkuItemsArgsModel args)
        {
            if (!args.CommodityId.HasValue)
            {
                throw new ArgumentNullException("CommodityId");
            }
            var commodity = db.Query <ShopBrandCommodity>()
                            .Where(m => !m.IsDel)
                            .Where(m => m.Id == args.CommodityId.Value)
                            .Select(m => new
            {
                Id          = m.Id,
                ShopBrandId = m.ShopBrandId
            })
                            .FirstOrDefault();

            CheckShopBrandActor(commodity.ShopBrandId, ShopBrandActorType.超级管理员);

            var query = db.Query <ShopBrandCommoditySkuItem>()
                        .Where(m => !m.IsDel)
                        .Where(m => !m.ParameterValue.IsDel);

            var list = query
                       .Where(m => m.Sku.CommodityId == args.CommodityId.Value)
                       .OrderByDescending(m => m.Id)
                       .Select(m => new SkuItem()
            {
                Id    = m.Id,
                SkuId = m.SkuId,
                Value = m.ParameterValue.Value
            })
                       .ToList();

            return(Success(new GetSkuItemsModel()
            {
                Items = list
            }));
        }