启用菜品编码生成规则

启用菜品编码生成规则语句

菜品编码生成规则请参考以下语句：

use isscyms3
go
—vch_value=true启用
if not exists( Select * from cybr_sys_parameter where vch_parameter = ‘Auto_Dcode_flag’)
Insert Into cybr_sys_parameter (vch_parameter,vch_value,vch_explain)
values (‘Auto_Dcode_flag’,’true’,’系统菜品编码-启用’)
else
update cybr_sys_parameter set vch_value = ‘true’,vch_explain = ‘系统菜品编码-启用’
where vch_parameter = ‘Auto_Dcode_flag’;
go

—-

if not exists( Select * from cybr_sys_parameter where vch_parameter = ‘Auto_Dcode_codelen’)
Insert Into cybr_sys_parameter (vch_parameter,vch_value,vch_explain)
values (‘Auto_Dcode_codelen’,’3′,’系统品码位长度’)
else
update cybr_sys_parameter set vch_value = ‘3’,vch_explain = ‘系统品码位长度’    –3是编码长度可自己修改。
where vch_parameter = ‘Auto_Dcode_codelen’;
go

if not exists( Select * from cybr_sys_parameter where vch_parameter = ‘Auto_Dcode_rule’)
Insert Into cybr_sys_parameter (vch_parameter,vch_value,vch_explain)
values (‘Auto_Dcode_rule’,’TN’,’系统品码方式’)
else
update cybr_sys_parameter set vch_value = ‘TN’,vch_explain = ‘系统品码方式’    –TN是以小类编码为前缀，SN是以大类
where vch_parameter = ‘Auto_Dcode_rule’;
go