简单包装汇总存储过程

2卷货物合成一筒，包装后将卷的重量汇总成筒的重量,goodsid自动递加1-2(2卷合成一筒),及添加现在包装的筒的数量(sl)
a表
id（自动序号）   smallid（筒的编码，对应b表的smallid）        goodsid(包装序号)             zl
1                    1                                            1                         10
2                    1                                             2                        15
3                    2                                             1                        12
b表
id（自动序号）   smallid     sl(卷的数量)      zl(重量)
1                 1            2                25(10+15)
2                 2             1               12