开启偶数特价单

商业之星7需要开启偶数特价单

请备份数据库执行语句开启，开启后在促销管理-更多功能中，请确认，
— 适用范围：所有机构均适用
— 菜单位置：偶数特价单
— 使用限制及风险：无

use hbposv7  —-分部改为hbposv7_branch
go
–前台启用偶数特价功能
insert into t_sys_system (sys_var_id,sys_var_name,sys_var_value,is_changed)
values(‘pos_even_spec’,’偶数特价功能’,’1′,’否’)
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’, ”, ‘5’, ‘PK’,’偶数特价单’,0,’0′,’6′,’4′,’d_pc_specprice_browse’,’w_pc_sheet_pk’,’PK/PK’,’d_pc_sheet_pk_master’, ‘d_pc_sheet_pk_detail’, ‘系统默认’)
go
insert into t_sys_menu(menu_id,branch_flag,menu_name,menu_code,menu_type,open_parameter,normal_flag)
values (‘D218′,’111101’, ‘偶数特价单’, ‘w_pc_sheet_pk’, ‘SHEE’,’/PK’,’0′)
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_id NOT LIKE ‘_000’) AND (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