7,759
社区成员
发帖
与我相关
我的任务
分享
select sum(convert(int,加工重量+0.5)*加工数量) from Insl
dim Iw as integer
dim Lsun as integer
'---strsql = select Iweight,Inum from Insl
do while not rs.eof
Iw=val(RstColor.Fields(0).value)
if int(Iw)<>Iw then Iw=int(Iw)+1
Lsun=Lsun+Iw * val(RstColor.Fields(1).value)
rs.movenext
loop