【问】如何自动生成自编码? | ||
【适用版本】商业之星6 | 【模块】常见问题 | 【点击数】233 |
【知识编号】P2016111500028 | ||
【问题描述】设置自编码生成规格是当前类别的前2位+6位流水号,总共8位,怎么自动按照规格生成? |
use hbposv8
go
declare
@item_clsno varchar(20),
@id int,
@no varchar(20),
@clsno varchar(20),
@item_no varchar(20)
select @id=0
select @clsno=”
declare cur_1 cursor for
select item_clsno,item_no from t_bd_item_info order by item_clsno
open cur_1
fetch cur_1 into @item_clsno,@item_no
while @@fetch_status = 0
begin
if @clsno<>left(ltrim(@item_clsno),2) and @clsno<>”
set @id=1
else
select @id = @id+1
select @no = right(‘000000’ + convert(varchar(6),@id),6)
update t_bd_item_info set item_subno=left(ltrim(@item_clsno),2)+@no where item_no=@item_no and
item_subno in(”,’0′)
select @clsno=left(ltrim(@item_clsno),2)
fetch cur_1 into @item_clsno,@item_no
end
close cur_1
deallocate cur_1
go