ASP酒店预订问题
来源:百度知道 编辑:UC知道 时间:2024/06/09 06:12:03
是用SQL语句怎么实现?谢谢!
create proc getprice
@begintime datetime, --开始时间
@endtime datetime , --结束时间
@weekend money, --周末价
@weekday money, --平时价
@num int, --房间数
@sumprice money output --总金额,输出参数
as
declare @date datetime
set @sumprice=0
set @date=@begintime
while(@date<=@endtime) --循环每天
begin
--判断是星期几 小于6是周日到周四 周日是1
if(datepart(weekday,@date)<6)
set @sumprice =@sumprice+money
else
set @sumprice =@sumprice+@weekend
set @date=dateadd(dd,1,@date)
end
set @sumprice=@sumprice*@num
return @sumprice
declare @sumprice money
exec getprice '2008-5-11','2008-5-16',1001,800,2,@sumprice output
print @sumprice
select t.roomNum,sum(s.Money) from
table1 t,
(select roomNum,
(case when
to_char(to_date(orderDate,'yyyy-mm-dd'),'day')
= '星期五' then 10000
when
to_char(to_date(