CabaretDBProject/Create Scripts/Roominfo_view.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'RoomInfo_value')
	BEGIN
		PRINT 'Dropping View RoomInfo_value'
		DROP  View RoomInfo_value
	END
GO

/******************************************************************************
**		File: 
**		Name: RoomInfo_value
**		Desc: 房间信息
**
**		This template can be customized:
Rid,--房间号
stateType,--状态
roomtel,--房间电话
ingroup,--所在区域
ttype,--房间类型
Uname--宾客姓名
OderPrice--预设单价
WorkPrice --折后单价
NdepositMoney--已交押金
totalMoney=--消费金额
ndatetime--进店时间
leaveTime--预离时间
UseTime--已用时间
Remark--备注
**              
**
**		Auth: 
**		Date: 
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/

PRINT 'Creating View RoomInfo_value'
GO
CREATE View RoomInfo_value
as

select 
Rid,--房间号
stateType,--状态
roomtel,--房间电话
ingroup,--所在区域
ttype,--房间类型
Aname=(Select Aname from AdminInfo where Aid=(select Naid from newroom where Nrid=rid )),--备注
Uname=case
when(select Uname from userinfo where uid=(select Nuid from Newroom where Nrid=rid ))!=''
then (select Uname from userinfo where uid=(select Nuid from Newroom where Nrid=rid ))
else ''end ,--宾客姓名

OderPrice=--预设单价
(case
when (select Nistimeroom from NewRoom where Nrid=rid)=1
then convert(varchar(20),priceByhour)+'￥/小时'