-- 适用范围：所有机构适用
-- 菜单位置：营运子系统——库管
-- 使用限制及风险：

use hbposev9
go

insert into t_sys_menu(menu_id,branch_flag,menu_name,menu_code,menu_type,open_parameter,normal_flag,open_type)
  values ('8211','111111', '复盘单','w_im_sheet_pb', 'SHEE','/CB','1','S'); 
go
insert t_sys_oper_grant(oper_id, func_id, grant0, other)
 select a.oper_id,a.menu_id, '1', ''
 from (select oper_id, menu_id from t_sys_operator,t_sys_menu
         where  (menu_name <> '-')
      ) as a
 where not exists (select * from t_sys_oper_grant b where a.oper_id = b.oper_id and a.menu_id = b.func_id);
go
update t_sys_oper_grant set grant0='1', grant1='1', grant2='1', grant3='1', grant4='1',grant5='1',grant6='1',grant7='1'
       where oper_id='1001';
go

--复盘单，隐藏功能
insert into t_sys_sheet_no(other1, default_price1, default_price2, trans_type, sheet_id,sheet_name,sheet_value,approve_flag, sheet_type, sheet_flag, dw_code,w_code,parm, master_dwo, detail_dwo,current_temp)
  values('', '', '', '2', 'CB','复盘单',2,'0','3','3','','w_im_sheet_pb','CB/CB','d_im_form_pb_master', 'd_im_form_pb_detail', '系统默认');
go