宾馆客房管理系统(VB).rar

if exists (select * from dbo.sysobjects where id=object_id(N'dbo.CustomerByOrderDate2') and OBJECTPROPERTY(id,N'Isprocedure')=1) drop procedure dbo.CustomerByOrderDate2 GO create procedure dbo.CostomerByOrderDate1 @BeginningDate datetime='01/01/1900', @endingDate datetime='12/31/2001' as select Takeover.SubstituteUserName as 缴款人帐号,Takeover.SubstituteRealName as 交班人名称,Takeover.Cash as 转交现金,Takeover.jiaobanqianCash as 交班前现金,Takeover.jiaobanhouCash as 交班后现金,Takeover.SuccessorUserName as 接班人帐号,Takeover.SuccessorRealName as 接班人名称,Takeover.jiebanqianCash as 接班前现金,Takeover.jiebanhouCash as 接班后现金,Takeover.datetimes as 时间 from Takeover where Takeover.datetimes between @BeginningDate and @endingDate order by Takeover.UserId GO create procedure dbo.CostomerByOrderDate2 @BeginningDate datetime='01/01/1900', @endingDate datetime='12/31/2001' as select jiezhang.GuestName as 姓名,jiezhang.Sex as 性别,jiezhang.RoomId as 客房号,jiezhang.roomtype as 客房类型,jiezhang.gusetroomprice as 客房价格,jiezhang.PrepayaSecurityDeposit as 预付押金,jiezhang.Gointotype as 入住类型,jiezhang.PrepayAWay as 付款方式,jiezhang.Discount as 折扣,jiezhang.Source as 客人来源,jiezhang.Number as 人数,jiezhang.CarId as 身份证号,jiezhang.Address as 地址,jiezhang.Gointodate as 入住日期,jiezhang.LeaveDate as 离店日期,jiezhang.Phone as 联系电话,jiezhang.Remarks as 备注,jiezhang.countprice as 房款合计,jiezhang.bukuan as 补款 from jiezhang where jiezhang.LeaveDate between @BeginningDate and @endingDate order by jiezhang.Id GO create procedure dbo.CostomerByOrderDate @BeginningDate datetime='01/01/1900', @endingDate datetime='12/31/2001' as select payform.UserId as 编号,payform.payUserName as 缴款人帐号,payform.payRealName as 缴款人名称,payform.ReceiveUserName as 接收人帐号,payform.ReceiveRealName as 接收人姓名,payform.cash as 缴款现金,payform.bankpos as 缴款Pos刷卡,payform.checks as 缴款支票,payform.datetimes as 时间 from payform where payform.datetimes between @BeginningDate and @endingDate order by payform.UserId GO