代码
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[P_IUD_ReserveScource]
/*************************************************
Desc :操作预定来源表(增删改)
**************************************************/
(
@ret int=-1 output,
@nId int=-1 output,
@nReserveSourceTypeId int,
@cCode nvarchar(50)='',
@cName nvarchar(50)='',
@cAddress nvarchar(100)='',
@cLinkMan nvarchar(50)='',
@cMobileNo nvarchar(50)='',
@cTelphone nvarchar(50)='',
@cFax nvarchar(50)='',
@cMail nvarchar(50)='',
@cKey nvarchar(100)='',
@cValue nvarchar(100)='',
@bIsUse bit=-1,
@nOrder int=-1,
@nHotelId int=1,
@tag int=1,
@nUserId int,
@cComputer nvarchar(100),
@nJobTimeListId int
)
as
begin
if @tag=1 --insert
begin
insert into B_ReserveSource(nReserveSourceTypeId
,cCode
,cName
,cAddress
,cLinkMan
,cMobileNo
,cTelphone
,cFax
,cMail
,cKey
,cValue
,bIsUse
,nOrder
,nHotelId)
values(@nReserveSourceTypeId
,@cCode
,@cName
,@cAddress
,@cLinkMan
,@cMobileNo
,@cTelphone
,@cFax
,@cMail
,@cKey
,@cValue
,@bIsUse
,@nOrder
,@nHotelId)
set @nId=@@identity
set @ret=1
end
else if @tag=2 --update
begin
update B_ReserveSource set
nReserveSourceTypeId=@nReserveSourceTypeId,cCode=@cCode
,cName=@cName,cAddress=@cAddress,cLinkMan=@cLinkMan
,cKey=@cKey,cMobileNo=@cMobileNo,cTelphone=@cTelphone
,cFax=@cFax,cMail=@cMail,cValue=@cValue,bIsUse=@bIsUse,nOrder=@nOrder
where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
else if @tag=3 --delete
begin
delete B_ReserveSource where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
end
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[P_IUD_ReserveScource]
/*************************************************
Desc :操作预定来源表(增删改)
**************************************************/
(
@ret int=-1 output,
@nId int=-1 output,
@nReserveSourceTypeId int,
@cCode nvarchar(50)='',
@cName nvarchar(50)='',
@cAddress nvarchar(100)='',
@cLinkMan nvarchar(50)='',
@cMobileNo nvarchar(50)='',
@cTelphone nvarchar(50)='',
@cFax nvarchar(50)='',
@cMail nvarchar(50)='',
@cKey nvarchar(100)='',
@cValue nvarchar(100)='',
@bIsUse bit=-1,
@nOrder int=-1,
@nHotelId int=1,
@tag int=1,
@nUserId int,
@cComputer nvarchar(100),
@nJobTimeListId int
)
as
begin
if @tag=1 --insert
begin
insert into B_ReserveSource(nReserveSourceTypeId
,cCode
,cName
,cAddress
,cLinkMan
,cMobileNo
,cTelphone
,cFax
,cMail
,cKey
,cValue
,bIsUse
,nOrder
,nHotelId)
values(@nReserveSourceTypeId
,@cCode
,@cName
,@cAddress
,@cLinkMan
,@cMobileNo
,@cTelphone
,@cFax
,@cMail
,@cKey
,@cValue
,@bIsUse
,@nOrder
,@nHotelId)
set @nId=@@identity
set @ret=1
end
else if @tag=2 --update
begin
update B_ReserveSource set
nReserveSourceTypeId=@nReserveSourceTypeId,cCode=@cCode
,cName=@cName,cAddress=@cAddress,cLinkMan=@cLinkMan
,cKey=@cKey,cMobileNo=@cMobileNo,cTelphone=@cTelphone
,cFax=@cFax,cMail=@cMail,cValue=@cValue,bIsUse=@bIsUse,nOrder=@nOrder
where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
else if @tag=3 --delete
begin
delete B_ReserveSource where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
end
代码
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[P_IUD_Room]
/*************************************************
**FN:后台配置专用,增删改房间
**************************************************/
(
@ret int=-1 output,
@nId int=-1 output,
@nAreaId int=-1,
@nFloorId int=-1,
@nDirectionId int=-1,
@nRoomKindId int=-1,
@cCode nvarchar(50)='',
@cName nvarchar(50)='',
@cEngLishName nvarchar(50)='',
@cSpell nvarchar(50)='',
@nBedCount int=-1,
@cLockCode nvarchar(200)='',
@bIsLock bit=-1,
--@nLockUserId int=-1,
--@dLockTime datetime,
--@cLockComputer nvarchar(100)='',
--@cLockRemark nvarchar(100)='',
--@bIsOC bit=-1,
--@nOCUserId int=-1,
--@dOCTime datetime,
--@cOCComputer nvarchar(100)='',
--@cOCRemark nvarchar(100)='',
@bIsUse bit=-1,
@nHotelId int=-1,
@tag int=1,
@nUserId int,
@cComputer nvarchar(100),
@nJobTimeListId int
)
as
begin
if @tag=1 --insert
begin
insert into B_Room
(nAreaId
,nFloorId
,nDirectionId
,nRoomKindId
,cCode
,cName
,cEnglishName
,cSpell
,nBedCount
,cLockCode
,bIsLock
-- ,nLockUserId
-- ,dLockTime
-- ,cLockComputer
-- ,cLockRemark
-- ,bIsOC
-- ,nOCUserId
-- ,dOCTime
-- ,cOCComputer
-- ,cOCRemark
,bIsUse
,nHotelId)
values(@nAreaId
,@nFloorId
,@nDirectionId
,@nRoomKindId
,@cCode
,@cName
,@cEngLishName
,@cSpell
,@nBedCount
,@cLockCode
,@bIsLock
-- ,@nLockUserId
-- ,@dLockTime
-- ,@cLockComputer
-- ,@cLockRemark
-- ,@bIsOC
-- ,@nOCUserId
-- ,@dOCTime
-- ,@cOCComputer
-- ,@cOCRemark
,@bIsUse
,@nHotelId)
set @nId=@@identity
set @ret=1
end
else if @tag=2 --update
begin
update B_Room
set nAreaId=@nAreaId
,nFloorId=@nFloorId
,nDirectionId=@nDirectionId
,nRoomKindId=@nRoomKindId
,cCode=@cCode
,cName=@cName
,cEnglishName=@cEngLishName
,cSpell=@cSpell
,nBedCount=@nBedCount
,cLockCode=@cLockCode
,bIsLock=@bIsLock
-- ,nLockUserId=@nLockUserId
-- ,dLockTime=@dLockTime
-- ,cLockComputer=@cLockComputer
-- ,cLockRemark=@cLockRemark
-- ,bIsOC=@bIsOC
-- ,nOCUserId=@nOCUserId
-- ,dOCTime=@dOCTime
-- ,cOCComputer=@cOCComputer
-- ,cOCRemark=@cOCRemark
,bIsUse=@bIsUse
where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
else if @tag=3 --delete
begin
delete B_Room
where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
end
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[P_IUD_Room]
/*************************************************
**FN:后台配置专用,增删改房间
**************************************************/
(
@ret int=-1 output,
@nId int=-1 output,
@nAreaId int=-1,
@nFloorId int=-1,
@nDirectionId int=-1,
@nRoomKindId int=-1,
@cCode nvarchar(50)='',
@cName nvarchar(50)='',
@cEngLishName nvarchar(50)='',
@cSpell nvarchar(50)='',
@nBedCount int=-1,
@cLockCode nvarchar(200)='',
@bIsLock bit=-1,
--@nLockUserId int=-1,
--@dLockTime datetime,
--@cLockComputer nvarchar(100)='',
--@cLockRemark nvarchar(100)='',
--@bIsOC bit=-1,
--@nOCUserId int=-1,
--@dOCTime datetime,
--@cOCComputer nvarchar(100)='',
--@cOCRemark nvarchar(100)='',
@bIsUse bit=-1,
@nHotelId int=-1,
@tag int=1,
@nUserId int,
@cComputer nvarchar(100),
@nJobTimeListId int
)
as
begin
if @tag=1 --insert
begin
insert into B_Room
(nAreaId
,nFloorId
,nDirectionId
,nRoomKindId
,cCode
,cName
,cEnglishName
,cSpell
,nBedCount
,cLockCode
,bIsLock
-- ,nLockUserId
-- ,dLockTime
-- ,cLockComputer
-- ,cLockRemark
-- ,bIsOC
-- ,nOCUserId
-- ,dOCTime
-- ,cOCComputer
-- ,cOCRemark
,bIsUse
,nHotelId)
values(@nAreaId
,@nFloorId
,@nDirectionId
,@nRoomKindId
,@cCode
,@cName
,@cEngLishName
,@cSpell
,@nBedCount
,@cLockCode
,@bIsLock
-- ,@nLockUserId
-- ,@dLockTime
-- ,@cLockComputer
-- ,@cLockRemark
-- ,@bIsOC
-- ,@nOCUserId
-- ,@dOCTime
-- ,@cOCComputer
-- ,@cOCRemark
,@bIsUse
,@nHotelId)
set @nId=@@identity
set @ret=1
end
else if @tag=2 --update
begin
update B_Room
set nAreaId=@nAreaId
,nFloorId=@nFloorId
,nDirectionId=@nDirectionId
,nRoomKindId=@nRoomKindId
,cCode=@cCode
,cName=@cName
,cEnglishName=@cEngLishName
,cSpell=@cSpell
,nBedCount=@nBedCount
,cLockCode=@cLockCode
,bIsLock=@bIsLock
-- ,nLockUserId=@nLockUserId
-- ,dLockTime=@dLockTime
-- ,cLockComputer=@cLockComputer
-- ,cLockRemark=@cLockRemark
-- ,bIsOC=@bIsOC
-- ,nOCUserId=@nOCUserId
-- ,dOCTime=@dOCTime
-- ,cOCComputer=@cOCComputer
-- ,cOCRemark=@cOCRemark
,bIsUse=@bIsUse
where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
else if @tag=3 --delete
begin
delete B_Room
where nId=@nId and nHotelId=@nHotelId
set @ret=1
end
end