【问题描述】
营业员一但建立了后期就无法修改门店,营业员换了门店就莫法玩呢!
【问题答案】
此为隐藏功能,请备份数据库,在查询分析器中执行以下开启语句,隐藏语句开启后需要重启应用池或者iis才生效.
–开启
IF NOT EXISTS(SELECT 1 FROM t_sys_system WHERE sys_var_id=’u_saleman_branch’)
INSERT INTO t_sys_system(sys_var_id,sys_var_name,sys_var_value)
VALUES(‘u_saleman_branch’,’u_saleman_branch’,’1′)
ELSE
UPDATE t_sys_system SET sys_var_value=’1′ WHERE sys_var_id=’u_saleman_branch’
–关闭
DELETE FROM t_sys_system WHERE sys_var_id=’u_saleman_branch’