存储过程(增删改)

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 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