8,497
社区成员
发帖
与我相关
我的任务
分享
SELECT [t0].[HCRoomTypeID], [t0].[HCRoomPriceID], [t0].[GuestTypeCode], [t0].[ValidStartDate], [t0].[ValidEndDate], [t0].[CommendLevelCode], [t0].[RoomPriceStatusCode], [t0].[Setting], [t0].[IsDel], [t0].[IsSpecial]
FROM [dbo].[HCRoomPrice] AS [t0]
INNER JOIN [dbo].[HCRoomType] AS [t1] ON [t1].[HCRoomTypeID] = [t0].[HCRoomTypeID]
WHERE ([t1].[HCHotelInfoID] = @p0) AND ((([t0].[ValidStartDate] >= @p1) AND ([t0].[ValidStartDate] <= @p2)) OR (([t0].[ValidEndDate] >= @p3) AND ([t0].[ValidEndDate] <= @p4)) OR (([t0].[ValidStartDate] <= @p5) AND ([t0].[ValidEndDate] >= @p6))) AND (([t0].[ValidStartDate] < @p7) OR (([t0].[ValidStartDate] > @p8) AND ([t0].[ValidEndDate] < @p9)) OR ([t0].[ValidEndDate] > @p10)) AND ([t1].[HCHotelSupplierID] IN (@p11, @p12, @p13))
ORDER BY [t0].[HCRoomPriceID]
-------------------------------
@p0 [Int32]: 10615
@p1 [DateTime]: 2009-3-16 0:00:00
@p2 [DateTime]: 2009-3-17 0:00:00
@p3 [DateTime]: 2009-3-16 0:00:00
@p4 [DateTime]: 2009-3-17 0:00:00
@p5 [DateTime]: 2009-3-16 0:00:00
@p6 [DateTime]: 2009-3-17 0:00:00
@p7 [DateTime]: 2009-3-16 0:00:00
@p8 [DateTime]: 2009-3-17 0:00:00
@p9 [DateTime]: 2009-3-16 0:00:00
@p10 [DateTime]: 2009-3-17 0:00:00
@p11 [Int32]: 12
@p12 [Int32]: 9
@p13 [Int32]: 0
但现在他转换成SQL 并不是这样的,而是
SELECT [t0].[HCRoomTypeID], [t0].[HCRoomPriceID], [t0].[GuestTypeCode], [t0].[ValidStartDate], [t0].[ValidEndDate], [t0].[CommendLevelCode], [t0].[RoomPriceStatusCode], [t0].[Setting], [t0].[IsDel], [t0].[IsSpecial]
FROM [dbo].[HCRoomPrice] AS [t0]
INNER JOIN [dbo].[HCRoomType] AS [t1] ON [t1].[HCRoomTypeID] = [t0].[HCRoomTypeID]
WHERE ([t1].[HCHotelInfoID] = 10615) AND ((([t0].[ValidStartDate] >= '2009-3-16 0:00:00') AND ([t0].[ValidStartDate] <= '2009-3-17 0:00:00')) OR (([t0].[ValidEndDate] >= '2009-3-16 0:00:00') AND ([t0].[ValidEndDate] <= '2009-3-17 0:00:00')) OR (([t0].[ValidStartDate] <= '2009-3-16 0:00:00') AND ([t0].[ValidEndDate] >= '2009-3-17 0:00:00'))) AND (([t0].[ValidStartDate] < '2009-3-16 0:00:00') OR (([t0].[ValidStartDate] > '2009-3-17 0:00:00') AND ([t0].[ValidEndDate] < '2009-3-16 0:00:00')) OR ([t0].[ValidEndDate] > '2009-3-16 0:00:00'0)) AND
([t1].[HCHotelSupplierID] IN ('2009-3-16 0:00:00'1, '2009-3-16 0:00:00'2, '2009-3-16 0:00:00'3))
ORDER BY [t0].[HCRoomPriceID]