发个专卖9 开启会员储值卡余额查询报表语句

newhander

思迅专卖9 用着不错，后续服务努力，代理商有知道隐藏语句多发几个！ 多共享几个造福大众
delete t_sys_menu where menu_id = '6599'
go

if not exists(select 1 from t_sys_menu where menu_id = '6599')
insert into t_sys_menu(menu_id, menu_name, menu_code, menu_type, open_type, open_parameter, branch_flag, normal_flag )
values('6599', '储值卡余额查询', 'w_rm_vip_savingamt_query', 'BROW', 'S', null, '110000', '0')
go

INSERT INTO t_sys_menu_grant  
SELECT menu_id,   
        substring(branch_flag,1,1),
        substring(branch_flag,2,1),
        substring(branch_flag,3,1),
        substring(branch_flag,4,1),
        substring(branch_flag,5,1),
        substring(branch_flag,6,1),
    null
    FROM t_sys_menu
Where menu_id not in (select func_id from t_sys_menu_grant) and menu_id = '6599'
go

INSERT INTO t_sys_oper_grant(oper_id, func_id, other)
  select a.oper_id, b.menu_id, ''
from t_sys_operator a, t_sys_menu b
where (b.menu_name <> '-') and b.menu_id = '6599'
     and not exists ( select 1 from t_sys_oper_grant c where c.oper_id = a.oper_id and c.func_id = b.menu_id )
order by a.oper_id

update t_sys_oper_grant set grant0='1', grant1='1', grant2='1', grant3='1', grant4='1',grant5='1',grant6='1' where oper_id='1001'
go