长春鱼熊出入库管理案例选择出库货位时为空,急求查错!

mabaor

KSQL语句为下:
select FI_WhPosition.*,(customSub1.fInboundSum) as fInboundSum,(customSub4.fOutboundSum) as fOutboundSum,( SQL.IFNULL(customSub1.fInboundSum, 0) - SQL.IFNULL(customSub4.fOutboundSum, 0) ) as fcurrentStock
    from FI_WhPosition FI_WhPosition optional
    join (select FI_articleMoveDetail.fReceiverPositionID as fReceiverPositionID, (sum(FI_articleMoveDetail.fQuantity)) as fInboundSum from FI_articleMove FI_articleMove
    join FI_articleMoveDetail FI_articleMoveDetail on FI_articleMove = FI_articleMoveDetail.fMainID
    where FI_articleMove.fReceiverID = :p AND FI_articleMoveDetail.farticleID = :q AND FI_articleMove.fType = '入库单' AND FI_articleMove.fProcState = '已完成'
    group by FI_articleMoveDetail.fReceiverPositionID) customSub1 on FI_WhPosition = customSub1.fReceiverPositionID optional
    join (select FI_articleMoveDetail.fSenderPositionID as fSenderPositionID, (sum(FI_articleMoveDetail.fQuantity)) as fOutboundSum from FI_articleMove FI_articleMove
    join FI_articleMoveDetail FI_articleMoveDetail on FI_articleMove = FI_articleMoveDetail.fMainID where FI_articleMove.fSenderID = :p AND FI_articleMoveDetail.farticleID = :q  AND FI_articleMove.fType = '出库单' AND ( FI_articleMove.fProcState = '已完成' OR FI_articleMove.fProcState = '进行中' )
    group by FI_articleMoveDetail.fSenderPositionID) customSub4 on FI_WhPosition = customSub4.fSenderPositionID where SQL.IFNULL(customSub1.fInboundSum, 0) - SQL.IFNULL(customSub4.fOutboundSum, 0) > 0

为空,库存无数据.

删除俩处的 AND FI_articleMoveDetail.farticleID = :q后,出库货位可用库存为空,

jishuang

根据sql到数据库中查看看是否有数据，确认sql语句是否正确，这个不是平台提供的demo，需要自己跟一下sql语句

mabaor

是解决问题,不是摆清责任

jishuang

1.没说摆清责任
2.上面已经说了跟一下sql
3.由于不是平台的demo,本地没有资源没法跟踪，只能自己跟踪sql

mabaor

问题查出来了,是主窗体传递参数时,字段拼写错误,可以结贴了