【问题描述】
如何修改会员使用模式?
–备份数据库后总部执行
USE issyytprov3
GO
–更新会员连锁模式为加盟总部独立使用
IF EXISTS(SELECT * FROM t_sys_system where sys_var_id = ‘pos_vip_model’)
update t_sys_system set sys_var_value = ‘0’ where sys_var_id = ‘pos_vip_model’
ELSE
insert into t_sys_system(sys_var_id, sys_var_name, sys_var_value, is_changed, sys_var_desc, sys_ver_flag, sys_inited, memo, branch_no, oper_id, vch_file)
values(‘pos_vip_model’,”,’0′,’否’,null,null,null,null,’000′,’1001′,null)
–备份数据库后加盟总部执行
USE issyytprov3_join
go
–更新会员连锁模式为加盟总部独立使用
IF EXISTS(SELECT * FROM t_sys_system where sys_var_id = ‘pos_vip_model’)
update t_sys_system set sys_var_value = ‘0’ where sys_var_id = ‘pos_vip_model’
ELSE
insert into t_sys_system(sys_var_id, sys_var_name, sys_var_value, is_changed, sys_var_desc, sys_ver_flag, sys_inited, memo, branch_no, oper_id, vch_file)
values(‘pos_vip_model’,”,’0′,’否’,null,null,null,null,’000′,’1001′,null)