【問題現(xiàn)象】

銷售管理——銷貨單的更多菜單消失

【解決方案】

備份數(shù)據(jù)后，請(qǐng)?jiān)跇I(yè)務(wù)庫執(zhí)行如下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,'銷貨單聯(lián)查','SA04','2','19','False',null,'False','聯(lián)查','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