"sql": "SELECT [Project2].[ID] AS [ID], [Project2].[ShipmentCode] AS [eventstr], [Project2].[ShippingToCountry] AS [event_to], [Project2].[DispatchDate] AS [datestr], [Project2].[CustomerShortName] AS [event_src], [Project2].[C1] AS [note_a], CASE WHEN (1 = [Project2].[DeliveryMethod]) THEN N'提' ELSE N'送' END AS [note_b] FROM (SELECT [Extent1].[ID] AS [ID], [Extent1].[ShipmentCode] AS [ShipmentCode], [Extent1].[DispatchDate] AS [DispatchDate], [Extent1].[CustomerShortName] AS [CustomerShortName], [Extent1].[ShippingToCountry] AS [ShippingToCountry], [Extent2].[DeliveryMethod] AS [DeliveryMethod], (SELECT TOP (1) [Extent3].[CodeDes] AS [CodeDes] FROM [dbo].[CodeTable] AS [Extent3] WHERE ([Extent3].[CodeID] = [Extent1].[ShipmentWays]) AND (3 = [Extent3].[CodeTypeID])) AS [C1] FROM [dbo].[ShipmentReport] AS [Extent1] INNER JOIN [dbo].[DeliveryInfo] AS [Extent2] ON [Extent1].[ID] = [Extent2].[ShipmentID] WHERE (CONVERT(DATE, [Extent1].[DispatchDate]) >= CONVERT(DATE, @startDate) AND CONVERT(DATE, [Extent1].[DispatchDate]) < CONVERT(DATE, @endDate)) AND ([Extent1].[Status] >= 0) AND ([Extent2].[Status] >= 0) AND (NOT (([Extent1].[WorkFlowStatus] = (N',' + CAST(800 AS nvarchar(max)) + N',')) AND ((CASE WHEN ([Extent1].[WorkFlowStatus] IS NULL) THEN cast(1 as bit) ELSE cast(0 as bit) END) = (CASE WHEN (N',' + CAST(800 AS nvarchar(max)) + N',' IS NULL) THEN cast(1 as bit) ELSE cast(0 as bit) END))))) AS [Project2] ORDER BY [Project2].[DispatchDate], [Project2].[ShipmentCode]"
|
