linq 成员访问权限"INT32 nums"在类型"t_order_items" 上非法

 var datasource = (
                from oi in db.t_order_items
                where oi.t_orders.audit && oi.t_orders.status == t_orders.status_active && oi.t_orders.t_dly_type.dt_type == "delivery" && oi.t_orders.t_payments.Where(p => p.audit).Sum(p => p.money) >= oi.t_orders.final_amount
                && (oi.t_delivery_items.Count() == 0 || oi.nums > oi.t_delivery_items.Sum(di => di.nums))
                group oi by new
                {
                    oi.order_id,
                   member_id=oi.t_orders.member_id??0,                  
                    oi.t_orders.receiver_region_id,
                    oi.t_orders.receiver_name,
                    oi.t_orders.receiver_addr,
                    oi.t_orders.receiver_mobile,
                    oi.t_orders.receiver_phone,
                    seller_memo = oi.t_orders.seller_memo.ToString(),
                    buyer_memo = oi.t_orders.buyer_memo.ToString(),
                    oi.t_orders.receiver_zip,
                    oi.t_orders.t_members.members_name,
                } into g
                select new
                {
                    key= g.Key.member_id+"_"+g.Key.receiver_addr,
                    g.Key.member_id,
                    g.Key.members_name,
                    g.Key.receiver_addr,
                    g.Key.receiver_mobile,
                    g.Key.receiver_name,
                    g.Key.receiver_phone,
                    g.Key.receiver_region_id,
                    g.Key.seller_memo,
                    g.Key.buyer_memo,
                    g.Key.receiver_zip,
                    products = g.Select(oi => new
                    {
                        oi.item_id,
                        oi.product_id,
                        oi.t_products.bn,
                        oi.t_products.t_goods.name,
                        oi.t_products.prop_str,

                        nums = oi.nums - (oi.t_delivery_items.Select(d => (int?)d.nums).Sum() ?? 0),  //正确的
                          nums = oi.nums - (oi.t_delivery_items.Sum(t => t.nums) == null ? 0 : oi.t_delivery_items.Sum(t => t.nums)),//错误的


                        oi.t_products.t_goods.pic_url,
                        stores = oi.t_products.t_storage.Where(s => s.nums > 0).Select(s => new StoreInfo(s.product_id, s.store_id, s.t_store.store_name, s.store.Value, s.store.Value, s.t_store.dly_center_id)).ToArray()
                    }),
                });

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值