02.00.00.sqldataprovider

SharpNuke源代码

  values (
    @UserId,
    @RoleId,
    @ExpiryDate
  )

  select SCOPE_IDENTITY()
end


GO
drop procedure dbo.AddVendor
GO


create procedure {databaseOwner}{objectQualifier}AddVendor

@PortalId 	int,
@VendorName 	nvarchar(50),
@Unit    	nvarchar(50),
@Street 	nvarchar(50),
@City		nvarchar(50),
@Region	        nvarchar(50),
@Country	nvarchar(50),
@PostalCode	nvarchar(50),
@Telephone	nvarchar(50),
@Fax   	        nvarchar(50),
@Email    	nvarchar(50),
@Website	nvarchar(100),
@FirstName	nvarchar(50),
@LastName	nvarchar(50),
@UserName       nvarchar(100),
@LogoFile       nvarchar(100),
@KeyWords       text,
@Authorized     bit

as

insert into {objectQualifier}Vendors (
  VendorName,
  Unit,
  Street,
  City,
  Region,
  Country,
  PostalCode,
  Telephone,
  PortalId,
  Fax,
  Email,
  Website,
  FirstName,
  Lastname,
  ClickThroughs,
  Views,
  CreatedByUser,
  CreatedDate,
  LogoFile,
  KeyWords,
  Authorized
)
values (
  @VendorName,
  @Unit,
  @Street,
  @City,
  @Region,
  @Country,
  @PostalCode,
  @Telephone,
  @PortalId,
  @Fax,
  @Email,
  @Website,
  @FirstName,
  @LastName,
  0,
  0,
  @UserName,
  getdate(), 
  @LogoFile,
  @KeyWords,
  @Authorized
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddVendorClassification
GO


create procedure {databaseOwner}{objectQualifier}AddVendorClassification

@VendorId           int,
@ClassificationId   int

as

insert into {objectQualifier}VendorClassification ( 
  VendorId,
  ClassificationId
)
values (
  @VendorId,
  @ClassificationId
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.CopyTab
GO
drop procedure dbo.DeleteAnnouncement
GO


create procedure {databaseOwner}{objectQualifier}DeleteAnnouncement

@ItemId int

as

delete
from {objectQualifier}Announcements
where  ItemId = @ItemId


GO
drop procedure dbo.DeleteBanner
GO


create procedure {databaseOwner}{objectQualifier}DeleteBanner

@BannerId int

as

delete
from {objectQualifier}Banners
where  BannerId = @BannerId


GO
drop procedure dbo.DeleteContact
GO


create procedure {databaseOwner}{objectQualifier}DeleteContact

@ItemId int

as

delete
from {objectQualifier}Contacts
where  ItemId = @ItemId


GO
drop procedure dbo.DeleteDocument
GO


create procedure {databaseOwner}{objectQualifier}DeleteDocument

@ItemId int

as

delete
from {objectQualifier}Documents
where  ItemId = @ItemId


GO
drop procedure dbo.DeleteFAQ
GO


create procedure {databaseOwner}{objectQualifier}DeleteFAQ

@ItemId int

as

delete
from {objectQualifier}FAQs
where  ItemId = @ItemId


GO
drop procedure dbo.DeleteFile
GO


create procedure {databaseOwner}{objectQualifier}DeleteFile

@FileName nvarchar(100),
@PortalId int

as

delete 
from {objectQualifier}Files
where  FileName = @FileName
and    ((PortalId = @PortalId) or (@PortalId is null and PortalId is null))

GO
drop procedure dbo.DeleteFiles
GO


create procedure {databaseOwner}{objectQualifier}DeleteFiles

@PortalId int

as

delete 
from   {objectQualifier}Files
where  ((PortalId = @PortalId) or (@PortalId is null and PortalId is null))

GO
drop procedure dbo.DeleteLink
GO


create procedure {databaseOwner}{objectQualifier}DeleteLink

@ItemId int

as

delete
from {objectQualifier}Links
where  ItemId = @ItemId


GO
drop procedure dbo.DeleteMessage
GO


create procedure {databaseOwner}{objectQualifier}DeleteMessage

@ModuleId int,
@Start    int,
@Parent   nvarchar(19)

as

delete
from {objectQualifier}Discussion
where  ModuleId = @ModuleId
and    substring(DisplayOrder, @Start, 19) = @Parent


GO
drop procedure dbo.DeleteModule
GO


create procedure {databaseOwner}{objectQualifier}DeleteModule

@ModuleId       int

as

delete
from {objectQualifier}Modules 
where  ModuleId = @ModuleId


GO
drop procedure dbo.DeleteModuleDefinition
GO


create procedure {databaseOwner}{objectQualifier}DeleteModuleDefinition

@ModuleDefId int

as

delete
from {objectQualifier}ModuleDefinitions
where  ModuleDefId = @ModuleDefId


GO
drop procedure dbo.DeleteModuleEvent
GO


create procedure {databaseOwner}{objectQualifier}DeleteModuleEvent

@ItemId int

as

delete
from {objectQualifier}ModuleEvents
where  ItemId = @ItemId


GO
drop procedure dbo.DeletePortalInfo
GO


create procedure {databaseOwner}{objectQualifier}DeletePortalInfo

@PortalId int

as

delete
from {objectQualifier}Portals
where  PortalId = @PortalId


GO
drop procedure dbo.DeleteRole
GO


create procedure {databaseOwner}{objectQualifier}DeleteRole

@RoleId int

as

delete 
from {objectQualifier}Roles
where  RoleId = @RoleId


GO
drop procedure dbo.DeleteSearch
GO


create procedure {databaseOwner}{objectQualifier}DeleteSearch

@SearchId int

as

delete
from {objectQualifier}Search
where  SearchId = @SearchId


GO

drop procedure dbo.DeleteTab
GO


create procedure {databaseOwner}{objectQualifier}DeleteTab

@TabId int

as

delete
from {objectQualifier}Tabs
where  TabId = @TabId

GO
create procedure {databaseOwner}{objectQualifier}DeletePortalUser

@PortalId int,
@UserId   int

as

delete
from {objectQualifier}UserPortals
where  PortalId = @PortalId
and    UserId = @UserId
GO

create procedure {databaseOwner}{objectQualifier}GetUserPortals

@UserId   int

as

select *
from   {objectQualifier}UserPortals
where  UserId = @UserId
GO

drop procedure dbo.DeleteUser
GO


create procedure {databaseOwner}{objectQualifier}DeleteUser

@UserId   int

as

delete
from {objectQualifier}Users
where  UserId = @UserId


GO
create procedure {databaseOwner}{objectQualifier}DeleteUserDefinedData

@UserDefinedRowId    int, 
@UserDefinedFieldId  int

as

delete 
from {objectQualifier}UserDefinedData
where  UserDefinedFieldId = @UserDefinedFieldId
or     UserDefinedRowId = @UserDefinedRowId
GO

drop procedure dbo.DeleteUserDefinedField
GO


create procedure {databaseOwner}{objectQualifier}DeleteUserDefinedField

@UserDefinedFieldId    int 

as

delete 
from {objectQualifier}UserDefinedFields
where  UserDefinedFieldId = @UserDefinedFieldId


GO
drop procedure dbo.DeleteUserDefinedRow
GO


create procedure {databaseOwner}{objectQualifier}DeleteUserDefinedRow

@UserDefinedRowId    int 

as

delete 
from {objectQualifier}UserDefinedRows
where  UserDefinedRowId = @UserDefinedRowId


GO
drop procedure dbo.DeleteUserRole
GO


create procedure {databaseOwner}{objectQualifier}DeleteUserRole

@UserId int,
@RoleId int

as

delete
from {objectQualifier}UserRoles
where  UserId = @UserId
and    RoleId = @RoleId


GO
drop procedure dbo.DeleteUsers
GO

drop procedure dbo.DeleteVendor
GO


create procedure {databaseOwner}{objectQualifier}DeleteVendor

@VendorId int

as

delete
from {objectQualifier}Vendors
where  VendorId = @VendorId


GO
drop procedure dbo.DeleteVendorClassifications
GO


create procedure {databaseOwner}{objectQualifier}DeleteVendorClassifications

@VendorId  int

as

delete
from {objectQualifier}VendorClassification
where  VendorId = @VendorId


GO
drop procedure dbo.DeleteVendorFeedback
GO


drop procedure dbo.DeleteVendors
GO


drop procedure dbo.FindBanners
GO


create procedure {databaseOwner}{objectQualifier}FindBanners

@PortalId int,
@BannerTypeId int

as

select {objectQualifier}Banners.*
from   {objectQualifier}Banners
inner join {objectQualifier}Vendors on {objectQualifier}Banners.VendorId = {objectQualifier}Vendors.VendorId
where  {objectQualifier}Banners.BannerTypeId = @BannerTypeId
and    (({objectQualifier}Vendors.PortalId = @PortalId) or (@PortalId is null and {objectQualifier}Vendors.PortalId is null))
and    ({objectQualifier}Banners.Impressions > {objectQualifier}Banners.Views Or {objectQualifier}Banners.Impressions = 0)
and    ({objectQualifier}Banners.StartDate is null Or getdate() >= {objectQualifier}Banners.StartDate )
and    ({objectQualifier}Banners.EndDate is null Or getdate() <= {objectQualifier}Banners.EndDate )
order by BannerId

GO

create procedure {databaseOwner}{objectQualifier}UpdateBannerViews