111,093
社区成员




from a in CustomerAccountLogs
join b in (
from s in SendOrders
join sd in SendOrderLines on s.Id equals sd.SendOrderId
select new
{
SendOrderId = sd.SendOrderId,
ProductName = sd.OrderLine.ProductName,
UnitName = sd.OrderLine.UnitName,
Price = sd.OrderLine.Price,
Amount = sd.OrderLine.Price * sd.OrderLine.Count
}
) on a.SendOrderId equals b.SendOrderId
where a.AccountId == 2
select new
{
a.SendOrderId,
a.OperationNumber,
a.OperationType,
b.ProductName,
b.UnitName,
b.Price,
b.Amount
}