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 })); }
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 })); }