/*
  焊接数据分析：管道预制汇总菜单
  可重复执行，已有菜单时同步修正名称、地址、父级和排序。
*/
DECLARE @MenuId NVARCHAR(50) = N'9A28D681-0C91-49B8-9A63-DA3FEEA25BC2';
DECLARE @SuperMenuId NVARCHAR(50) = N'F3B157B7-9BEE-4150-80CB-087828F1C51D';

IF NOT EXISTS (SELECT 1 FROM dbo.Sys_Menu WHERE MenuId = @SuperMenuId)
BEGIN
    RAISERROR(N'未找到父菜单“焊接数据分析”，请先执行焊接管理菜单初始化脚本。', 16, 1);
    RETURN;
END;

IF EXISTS (SELECT 1 FROM dbo.Sys_Menu WHERE MenuId = @MenuId)
BEGIN
    UPDATE dbo.Sys_Menu
    SET MenuName = N'管道预制汇总',
        Icon = NULL,
        Url = N'HJGL/WeldingReport/PipePrefabricationSummary.aspx',
        SortIndex = 85,
        SuperMenu = @SuperMenuId,
        MenuType = N'Menu_HJGL',
        IsOffice = 0,
        IsEnd = 1,
        IsUsed = 1
    WHERE MenuId = @MenuId;
END
ELSE
BEGIN
    INSERT INTO dbo.Sys_Menu
    (
        MenuId,
        MenuName,
        Icon,
        Url,
        SortIndex,
        SuperMenu,
        MenuType,
        IsOffice,
        IsEnd,
        IsUsed
    )
    VALUES
    (
        @MenuId,
        N'管道预制汇总',
        NULL,
        N'HJGL/WeldingReport/PipePrefabricationSummary.aspx',
        85,
        @SuperMenuId,
        N'Menu_HJGL',
        0,
        1,
        1
    );
END;

IF NOT EXISTS
(
    SELECT 1
    FROM dbo.Sys_ButtonToMenu
    WHERE MenuId = @MenuId
      AND ButtonName = N'查看'
)
BEGIN
    INSERT INTO dbo.Sys_ButtonToMenu
    (
        ButtonToMenuId,
        MenuId,
        ButtonName,
        SortIndex
    )
    VALUES
    (
        N'40D01F4E-D38C-4480-ABF3-5FE45C0E8650',
        @MenuId,
        N'查看',
        1
    );
END;
GO