|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
【问题现象】
销售管理——销货单的更多菜单消失
【解决方案】
备份数据后,请在业务库执行如下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 |
|