思讯商云X进销存日报表加明细

xmpcw

在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