酒店点评明细新SQL酒店点评明细新SQL
SELECT ho.[SerialId] AS '订单号' ,
hi.[Name] AS '酒店名称' ,
ho.[CreateDate] AS '创建时间' ,
ho.[ComeDate] AS '入住时间' ,
ho.[Rooms] * ho.[Nights] AS '间夜数' ,
ho.[Amount] AS '订单金额' ,
CASE WHEN ho.[Flag] = 'H' THEN '确认入住'
WHEN ho.[Flag] = 'D' THEN '对账中'
WH...
酒店点评明细新SQL
SELECT ho.[SerialId] AS '订单号' ,
hi.[Name] AS '酒店名称' ,
ho.[CreateDate] AS '创建时间' ,
ho.[ComeDate] AS '入住时间' ,
ho.[Rooms] * ho.[Nights] AS '间夜数' ,
ho.[Amount] AS '订单金额' ,
CASE WHEN ho.[Flag] = 'H' THEN '确认入住'
WHEN ho.[Flag] = 'D' THEN '对账中'
WHEN ho.[Flag] = 'O' THEN '已结佣金'
END '订单状态' ,
CASE WHEN ho.[BookType] = 0 THEN '现付'
WHEN ho.[BookType] = 1 THEN '担保'
WHEN ho.[BookType] = 2 THEN '预付'
WHEN ho.[BookType] = 3 THEN '代收代付'
END '订单类型' ,
CASE WHEN ho.BookType IN ( 2, 3 )
AND hone.IsCashBack = 2 THEN hoe.Voucher
ELSE 0
END AS '立减金额'
FROM [TCHotelOrder].[dbo].[HotelOrder] AS ho WITH ( NOLOCK )
INNER JOIN tchotelorder.dbo.HotelOrderExtend AS hoe WITH ( NOLOCK ) ON
ho.SerialId = hoe.OrderSerialId
INNER JOIN tchotelorder.dbo.HotelOrderNewExtend AS hone WITH ( NOLOCK ) ON
hone.SerialId = ho.SerialId
INNER JOIN [TCHotelResource].[dbo].[HotelInfo] hi WITH ( NOLOCK ) ON
ho.[HotelId] = hi.[Id]
WHERE ho.[ComeDate] >= '{0}'
AND ho.[ComeDate] <= '{1} 23:59:59'
AND ho.[SerialId] IN ( {2} )
AND ho.[Flag] IN ( 'H', 'D', 'O' )
本文档为【酒店点评明细新SQL】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑,
图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。