package com.app.hxqh.udItemSafe;

import psdi.mbo.MboRemote;
import psdi.mbo.MboSetRemote;
import psdi.mbo.MboValue;
import psdi.mbo.MboValueAdapter;
import psdi.server.MXServer;
import psdi.util.MXException;

import java.rmi.RemoteException;

/**
 * 安全库存设定-清单余量
 * edit 2023-09-11
 */
public class FldQdyl extends MboValueAdapter {

    public FldQdyl(MboValue mbv) throws MXException {
        super(mbv);
    }

    @Override
    public void initValue() throws MXException, RemoteException {
        super.initValue();
        MboRemote mbo=getMboValue().getMbo();
        MboSetRemote udmatusetrans = MXServer.getMXServer().getMboSet("UDMATUSETRANS", MXServer.getMXServer().getSystemUserInfo());
        String sql="ITEMNUM='"+mbo.getString("ITEMNUM")+"' and DEPTNUM='"+mbo.getString("DEPTNUM")+"'";
        udmatusetrans.setWhere(sql);
        udmatusetrans.reset();
        mbo.setValue("QDYL", udmatusetrans.sum("QUANTITY"), 11L);
    }
}