--
两票中明细报表工具栏按钮替换为运行报表
-- select * from sigoption where app='TICKET'
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' TICKET ' and description = ' 两票明细汇报 ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' TICKET ' and description = ' 运行报表 ' ;
commit ;
-- 工单跟踪
-- select * from sigoption where app='WOTRACK' AND description IN ('工单明细汇报','运行报表');
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' WOTRACK ' and description = ' 工单明细汇报 ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' WOTRACK ' and description = ' 运行报表 ' ;
commit ;
-- 采购
-- select * from sigoption where app='PO' AND description IN ('采购单明细汇报','运行报表');
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' PO ' and description = ' 采购单明细汇报 ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' PO ' and description = ' 运行报表 ' ;
commit ;
-- 采购申请
-- select * from sigoption where app='PR' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' PR ' and OPTIONNAME = ' DETAILREP ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' PR ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 发放和转移
select * from sigoption where app = ' INVISSUE ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' INVISSUE ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 标准作业计划
select * from sigoption where app = ' JOBPLAN ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' JOBPLAN ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 接收
select * from sigoption where app = ' RECEIPTS ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' RECEIPTS ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 库存控制
select * from sigoption where app = ' INVENTOR ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' INVENTOR ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 库存
select * from sigoption where app = ' ITEM ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' ITEM ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- select * from sigoption where app='TICKET'
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' TICKET ' and description = ' 两票明细汇报 ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' TICKET ' and description = ' 运行报表 ' ;
commit ;
-- 工单跟踪
-- select * from sigoption where app='WOTRACK' AND description IN ('工单明细汇报','运行报表');
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' WOTRACK ' and description = ' 工单明细汇报 ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' WOTRACK ' and description = ' 运行报表 ' ;
commit ;
-- 采购
-- select * from sigoption where app='PO' AND description IN ('采购单明细汇报','运行报表');
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' PO ' and description = ' 采购单明细汇报 ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' PO ' and description = ' 运行报表 ' ;
commit ;
-- 采购申请
-- select * from sigoption where app='PR' AND OPTIONNAME IN ('DETAILREP','RUNREPORTS');
update sigoption set toolbargroup = null ,toolbarposition = null , IMAGE = NULL where app = ' PR ' and OPTIONNAME = ' DETAILREP ' ;
update sigoption set toolbargroup = 3 ,toolbarposition = 3 , image = ' nav_icon_detreport.gif ' where app = ' PR ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 发放和转移
select * from sigoption where app = ' INVISSUE ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' INVISSUE ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 标准作业计划
select * from sigoption where app = ' JOBPLAN ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' JOBPLAN ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 接收
select * from sigoption where app = ' RECEIPTS ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' RECEIPTS ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 库存控制
select * from sigoption where app = ' INVENTOR ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' INVENTOR ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;
-- 库存
select * from sigoption where app = ' ITEM ' AND OPTIONNAME IN ( ' DETAILREP ' , ' RUNREPORTS ' );
update sigoption set toolbargroup = 3 ,toolbarposition = 1 , image = ' nav_icon_detreport.gif ' where app = ' ITEM ' and OPTIONNAME = ' RUNREPORTS ' ;
commit ;