銷售單位與庫存單位不同時有庫存但銷貨單會提示庫存不足

TViewVouSDSlip

bool TViewVouSDSlip::CheckVaryItemDepot(SVoucherSDSPact* pSQVaryInfo)


因為float 轉換後 小數位數有餘值  導致 認定 庫存量不足

select i_item from Store Where  i_depot=:i_depot  and i_item=:i_item  group by i_item  having ISNULL(sum(ISNULL(i_vol,0)),0)>=2880

select i_item from Store Where  i_depot='A00000000101'  and i_item='A00000000029'
group by i_item  having ISNULL(sum(ISNULL(i_vol,0)),0)>=2880.000


改成


pQry->ParamByName("i_vol")->AsFloat           = Round((FItemVol * pSQVaryInfo->m_pVary[iRowBeg].m_fUnitCvt) *q.get()->FieldByName("i_vol")->AsFloat,2);