|
在SQL查询中加入:
use hbposv10
go
insert into t_sys_menu(menu_id,branch_flag,menu_name,menu_code,menu_type,normal_flag)
values ('6801','111111', '日进销存报表','w_rm_jxc_day', 'brow','0')
INSERT INTO t_sys_oper_grant(oper_id, func_id, other)
select o.oper_id, m.menu_id, ''
from t_sys_operator o,
(
select menu_id
from t_sys_menu
where (menu_id NOT LIKE '_000') AND (menu_name <> '-')
and menu_id not in (select distinct func_id from t_sys_oper_grant)
) m
update t_sys_oper_grant set grant0='1', grant1='1', grant2='1', grant3='1', grant4='1'
where oper_id='1001'
go
|
|