T+销货单菜单栏的更多菜单消失

【问题现象】

销售管理——销货单的更多菜单消失

【解决方案】

备份数据后，请在业务库执行如下sql来解决该问题：

delete EAP_BusOperation_User where code='SA04' and ViewType=2

delete EAP_BusOperation where code='SA04' and ViewType=2 and OperationName in ('AssociateInfo','Tool','More')

Insert into EAP_BusOperation(OperationName,FunctionCode,Description,Code,ViewType,TabIndex,IsSplit,SourceKey,IsAuthControl,Title,Visibility,ShortCut,ToolTip,issystem,IsHasAction,IsEnd,ExpressionName,CreatedTime,ParentID,idbusoperationmain,idfunctionauth,viewid,Position,Icon,Args,CanSetDefault)

values('AssociateInfo',null,'销货单联查','SA04','2','19','False',null,'False','联查','True','J','','False',null,'0',null,null,null,null,null,'48','left',null,null,null)

Insert into EAP_BusOperation(OperationName,FunctionCode,Description,Code,ViewType,TabIndex,IsSplit,SourceKey,IsAuthControl,Title,Visibility,ShortCut,ToolTip,issystem,IsHasAction,IsEnd,ExpressionName,CreatedTime,ParentID,idbusoperationmain,idfunctionauth,viewid,Position,Icon,Args,CanSetDefault)

values('Tool',null,'销货单工具','SA04','2','18','False',null,'False','工具','True',' ','','False',null,'0',null,null,null,null,null,'48','left',null,null,null)

Insert into EAP_BusOperation(OperationName,FunctionCode,Description,Code,ViewType,TabIndex,IsSplit,SourceKey,IsAuthControl,Title,Visibility,ShortCut,ToolTip,issystem,IsHasAction,IsEnd,ExpressionName,CreatedTime,ParentID,idbusoperationmain,idfunctionauth,viewid,Position,Icon,Args,CanSetDefault)

values('More','','更多','SA04','2','23','False','','False','更多','True',' ','','False','False','1',null,null,null,null,null,null,'left',null,null,'False')

declare @parentid int

declare @curparentid int

select @parentid=id from EAP_BusOperation where code='SA04' and ViewType=2 and OperationName='More'

select @curparentid = ParentID from EAP_BusOperation where code='SA04' and ViewType=2 and OperationName='ExportTemplate'

update EAP_BusOperation set ParentID=@parentid where ParentID=@curparentid

select @parentid=id from EAP_BusOperation where code='SA04' and ViewType=2 and OperationName='AssociateInfo'

select @curparentid = ParentID from