8,497
社区成员
发帖
与我相关
我的任务
分享
var querydata = from q in query//.Where(xq=>xq.ProductID !="")
join b in stockQuery.Distinct() on q.ProductID equals b.ProductID
into temp
from tempD in temp
join s in db.core_Good on q.SKU equals s.SKU
select new { record = q,good = s,sup = tempD.SupplierID, PurchaseCode = tempD.StockInID };
跟踪出来的sql
SELECT
....
FROM [dbo].[sto_StockRecord] AS [Extent1]
INNER JOIN (SELECT DISTINCT
[Extent2].[ProductID] AS [ProductID],
[Extent3].[StockInID] AS [StockInID],
[Extent3].[SupplierID] AS [SupplierID]
FROM [dbo].[sto_StockInOrderDetail] AS [Extent2]
INNER JOIN [dbo].[sto_StockInOrder] AS [Extent3] ON [Extent2].[StockInID] = [Extent3].[StockInID]
WHERE (2 = [Extent2].[DetailType]) AND (N'305' = [Extent3].[BusinessBillID]) AND (200 = [Extent3].[State]) ) AS [Distinct1]
ON ([Extent1].[ProductID] = [Distinct1].[ProductID]) OR (([Extent1].[ProductID] IS NULL) AND ([Distinct1].[ProductID] IS NULL))
INNER JOIN [dbo].[core_Good] AS [Extent4] ON [Extent1].[SKU] = [Extent4].[SKU]