分仓库存报表与资料菜单下的分仓库存中某货

①select * from goods where code=%查出该货品的goodsid② select * from store where goodsid=%查出分仓库对应的storeid③update onhand set onhand=* where goodsid=% and storeid=%