查询库存时点现有量 Function

时间：2019-06-09 14:14:33 阅读：110 评论：0 收藏：0 [点我收藏+]

static qty  availQty(ItemId             itemId,

                     InventLocationId   locationId    = "",

                     wmsLocationid      wmsLocationId = "",

                     InventBatchId      batchId       = "",

                     InventSerialId     serialId      = "",

                     TransDate          pointDate     = systemDateGet())

{

    Query                    _Query;

    QueryRun                 _QueryRun;

    InventSum                _inventsum;

    InventDim                _InventDim;

    inventDim                inventDimCriteria;

    inventdimparm            inventDimparmCriteria;

    inventDimParm            inventDimparmGroupby;

    InventSumDatePhysicalDim inventSumDateDim;

    Qty                      availQty ;

;

    inventDimCriteria.clear();

    if (locationId)

        inventDimCriteria.InventLocationId = locationId;

    if (wmsLocationid)

        inventDimCriteria.wMSLocationId    = wmsLocationid;

    if (batchId)

        inventDimCriteria.inventBatchId    = batchId;

    if (serialId)

        inventDimCriteria.inventSerialId   = serialId;

    inventDimparmCriteria.clear();

    inventDimparmCriteria.ItemIdFlag = Noyes::Yes;

    if (locationId)

        inventDimparmCriteria.InventLocationIdFlag = Noyes::Yes;

    if (wmsLocationid)

        inventDimParmCriteria.WMSLocationIdFlag    = NoYes::Yes;

    if (batchId)

        inventDimParmCriteria.InventBatchIdFlag    = NoYes::Yes;

    if (serialId)

        inventDimParmCriteria.InventSerialIdFlag   = NoYes::Yes;

    inventDimparmGroupby.clear();

    inventDimparmGroupby.ItemIdFlag = Noyes::Yes;

    if (locationId)

        inventDimparmGroupby.InventLocationIdFlag = Noyes::Yes;

    if (wmsLocationid)

        inventDimparmGroupby.WMSLocationIdFlag    = NoYes::Yes;

    if (batchId)

        inventDimparmGroupby.InventBatchIdFlag    = NoYes::Yes;

    if (serialId)

        inventDimparmGroupby.InventSerialIdFlag   = NoYes::Yes;

    _Query = new Query();

    Inventsum::newQuery(_Query,itemId,inventDimCriteria,inventDimparmCriteria,inventDimparmGroupby);

    _queryRun = new QueryRun(_query);

    while(_queryrun.next())

{

        _inventsum = _Queryrun.get(tablenum(InventSum));

        _inventDim = _QueryRun.get(tablenum(InventDim));

        inventSumDateDim = InventSumDatePhysicalDim::newParameters(pointDate,_InventSum.ItemId,_inventdim,inventDimparmCriteria);

        availQty = inventSumDateDim.postedQty()   + inventSumDateDim.receivedQty()   -

                   InventSumDateDim.deductedQty() + InventSumDateDim.registeredQty() - InventSumDateDim.pickedQty();

}

    return availQty;

}

原文：https://www.cnblogs.com/xtwkh1973/p/10993122.html

踩

(0)

评论一句话评论（0）

分享档案

更多>