8,497
社区成员
发帖
与我相关
我的任务
分享
var outmodel = (from t1 in db.DeleverInfo
join t2 in db.CkHopeInfo
on t1.HopeInfoId equals t2.Identifier
where t2.GoodsId == goodsId
select t1.GoodsNum.GetValueOrDefault());
var outModel2 = (from t1 in db.DeleverInfo
join t2 in db.CkHopeInfo
on t1.HopeInfoId equals t2.Identifier
where t2.GoodsId == goodsId
select t1.GoodsNum);
//var outNum = outmodel.Sum();
var outNum2 = outModel2.Sum().GetValueOrDefault();
var outmodel = (from t1 in db.DeleverInfo
join t2 in db.CkHopeInfo
on t1.HopeInfoId equals t2.Identifier
where t2.GoodsId == goodsId
select t1.GoodsNum==null?0:t1.GoodsNum);
var outNum =outmodel.Any()? outmodel.Sum():0;