畅捷通T+软件 SQL语句分享除去某些功能或菜单

畅捷通T+语句分享除去某些功能
执行前建议备份账套

--不显示凭证表头的备注1和备注2（T3升级上来的账套默认显示）
Update eap_VoucherControls set Visible=0 where  title in('备注1','备注2')

--去掉制单序时控制
update EAP_AccInformation set Value=0 where name='IsControlWhenGenerateDoc'

--不显示总账里的凭证查询,有其他模块不要使用
--update  EAP_Menu set Visibility=0 where Code='SYS2173'

--去除发票管理
update EAP_Menu set Visibility=0 where SupMenuID like 'IN%' or code='IN'

--去除微信营销
update  EAP_Menu set Visibility=0 where  Code in ('WXYX','UME') 

--去除配货仓库关系设置
update  EAP_Menu set Visibility=0 where  Code='AA1075'

--去除电商商品
update  EAP_Menu set Visibility=0 where  Code='AA1056'

--不审核允许记账
UPDATE  dbo.EAP_AccInformation SET [Value]=0,[Default]=0 WHERE   name='IsBookkeepOnlyWhenVoucherAudit'

--制单人审核人允许同一人
UPDATE  dbo.EAP_AccInformation SET [Value]=1,[Default]=1 WHERE   name='CanMakerIsAuditor'

--现金流必录
update EAP_AccInformation set [Value]=1,[Default]=1 where  name='IsCashFlowMustInput'

--去除总账里的发票管理
--update  EAP_Menu set Visibility=0 where  Code='GL0150'

--去除B2B云商
update  EAP_Menu set Visibility=0 where code='ES'  

--禁止备份账套预警
update EAP_AccInformation set Value=0 where Name=N'BackupWarning'

--不显示初始化导航
update EAP_Accinformation set Value=0  where Name='DiaplayNavagationWindow' and sysid='CC' 

--去除云应用菜单
--update  EAP_Menu set Visibility=0 where code='ADDAPP'  

--去除订货商城菜单
update  EAP_Menu set Visibility=0 where code='B2B' 

--去除电商通菜单
update  EAP_Menu set Visibility=0 where code in ('DST','DSTTWO')

--去除移动仓管菜单
update  EAP_Menu set Visibility=0 where  Code='PDA'

--去除质量管理
update  EAP_Menu set Visibility=0 where  Code='NQM'

--去除报表中心下的移动发布
update  EAP_Menu set Visibility=1 where  Code='RT'
update  EAP_Menu set Visibility=0 where  Code in('RT4001','RT4002')

--去除协同办公菜单
update  EAP_Menu set Visibility=0 where code='CSPApp'  

--去除我要贷款菜单
update  EAP_Menu set Visibility=0 where code='InternetFinance'  

--去除采购管理中的进货参谋
update  EAP_Menu set Visibility=0 where code='PU50'  

--去除销售管理中的防伪税控接口
update  EAP_Menu set Visibility=0 where code='SA10'