spAddUpdate_SiteMenu
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @ContentID | int | IN | |
| @ActiveCSS | nvarchar(2048) | IN | |
| @Orientation | int | IN | |
| @MenuCSS | nvarchar(2048) | IN | |
| @HoverCSS | nvarchar(2048) | IN | |
| @DefaultCSS | nvarchar(2048) | IN | |
| @SubitemCSS | nvarchar(2048) | IN | |
| @SubmenuGlyphID | int | IN | |
| @ClickToOpen | bit | IN | |
| @GlyphLocation | int | IN | |
| @MenuTechnology | int | IN | |
| @ItemsXML | ntext | IN | |
| @UpdateItems | bit | IN | |
| @MSStyleStaticMenu | nvarchar(2048) | IN | |
| @MSStyleStaticItem | nvarchar(2048) | IN | |
| @MSStyleStaticHover | nvarchar(2048) | IN | |
| @MSStyleStaticSelected | nvarchar(2048) | IN | |
| @MSStyleDynamicMenu | nvarchar(2048) | IN | |
| @MSStyleDynamicItem | nvarchar(2048) | IN | |
| @MSStyleDynamicHover | nvarchar(2048) | IN | |
| @MSStyleDynamicSelected | nvarchar(2048) | IN | |
| @MSMenuOptions | nvarchar(2048) | IN | |
| @MenuContainerDivClass | nvarchar(50) | IN | |
| @MenuActiveClass | nvarchar(50) | IN | |
| @MenuClass | nvarchar(50) | IN | |
| @MenuItemClass | nvarchar(50) | IN | |
| @MenuHoverClass | nvarchar(50) | IN | |
| @MenuSubItemClass | nvarchar(50) | IN |
Definition
Copy
CREATE procedure dbo.spAddUpdate_SiteMenu
(
@PKID int output,
@ContentID int,
@ActiveCSS nvarchar(2048),
@Orientation int,
@MenuCSS nvarchar(2048),
@HoverCSS nvarchar(2048),
@DefaultCSS nvarchar(2048),
@SubitemCSS nvarchar(2048),
@SubmenuGlyphID int,
@ClickToOpen bit,
@GlyphLocation int,
@MenuTechnology int,
@ItemsXML ntext,
@UpdateItems bit,
@MSStyleStaticMenu nvarchar(2048),
@MSStyleStaticItem nvarchar(2048),
@MSStyleStaticHover nvarchar(2048),
@MSStyleStaticSelected nvarchar(2048),
@MSStyleDynamicMenu nvarchar(2048),
@MSStyleDynamicItem nvarchar(2048),
@MSStyleDynamicHover nvarchar(2048),
@MSStyleDynamicSelected nvarchar(2048),
@MSMenuOptions nvarchar(2048),
@MenuContainerDivClass nvarchar(50),
@MenuActiveClass nvarchar(50),
@MenuClass nvarchar(50),
@MenuItemClass nvarchar(50),
@MenuHoverClass nvarchar(50),
@MenuSubItemClass nvarchar(50)
)
as
begin transaction
if (@PKID<=0) begin
insert into SiteMenu
(
ContentID,
ActiveCSS,
Orientation,
MenuCSS,
HoverCSS,
DefaultCSS,
SubitemCSS,
SubmenuGlyphID,
ClickToOpen,
GlyphLocation,
MenuTechnology,
MSStyleStaticMenu,
MSStyleStaticItem,
MSStyleStaticHover,
MSStyleStaticSelected,
MSStyleDynamicMenu,
MSStyleDynamicItem,
MSStyleDynamicHover,
MSStyleDynamicSelected,
MSMenuOptions,
MenuContainerDivClass,
MenuActiveClass,
MenuClass,
MenuItemClass,
MenuHoverClass,
MenuSubItemClass
)
values
(
@ContentID,
@ActiveCSS,
@Orientation,
@MenuCSS,
@HoverCSS,
@DefaultCSS,
@SubitemCSS,
@SubmenuGlyphID,
@ClickToOpen,
@GlyphLocation,
@MenuTechnology,
@MSStyleStaticMenu,
@MSStyleStaticItem,
@MSStyleStaticHover,
@MSStyleStaticSelected ,
@MSStyleDynamicMenu ,
@MSStyleDynamicItem ,
@MSStyleDynamicHover,
@MSStyleDynamicSelected,
@MSMenuOptions,
@MenuContainerDivClass,
@MenuActiveClass,
@MenuClass,
@MenuItemClass,
@MenuHoverClass,
@MenuSubItemClass
)
select @PKID = @ContentID
end
else begin
update dbo.SiteMenu
set
ActiveCSS= @ActiveCSS,
Orientation= @Orientation,
MenuCSS= @MenuCSS,
HoverCSS= @HoverCSS,
DefaultCSS= @DefaultCSS,
SubitemCSS= @SubitemCSS,
SubmenuGlyphID= @SubmenuGlyphID,
ClickToOpen= @ClickToOpen,
GlyphLocation= @GlyphLocation,
MenuTechnology= @MenuTechnology,
MSStyleStaticMenu= @MSStyleStaticMenu,
MSStyleStaticItem= @MSStyleStaticItem,
MSStyleStaticHover= @MSStyleStaticHover,
MSStyleStaticSelected = @MSStyleStaticSelected,
MSStyleDynamicMenu = @MSStyleDynamicMenu,
MSStyleDynamicItem = @MSStyleDynamicItem,
MSStyleDynamicHover= @MSStyleDynamicHover,
MSStyleDynamicSelected = @MSStyleDynamicSelected,
MSMenuOptions= @MSMenuOptions,
MenuContainerDivClass= @MenuContainerDivClass,
MenuActiveClass= @MenuActiveClass,
MenuClass= @MenuClass,
MenuItemClass= @MenuItemClass,
MenuHoverClass= @MenuHoverClass,
MenuSubItemClass= @MenuSubItemClass
where ContentID=@PKID
end
if (@UpdateItems=1) begin
exec dbo.spBulkUpdate_MenuItems @PKID, @ItemsXML
end
commit