package com.app.hxqh.udworkorder;

import psdi.mbo.MAXTableDomain;
import psdi.mbo.MboRemote;
import psdi.mbo.MboSetRemote;
import psdi.mbo.MboValue;
import psdi.util.MXException;

import java.rmi.RemoteException;

/**
 * 大修工单-选择项目立项号
 */
public class FldPRONUM extends MAXTableDomain {

    public FldPRONUM(MboValue mbv) throws MXException,RemoteException {
        super(mbv);
        String thisAttr = getMboValue().getAttributeName();
        setRelationship("UDBUDGET", "");//从资产表弹出选择的表
        String[] FromStr = { "PROJECTNUM" };
        String[] ToStr = { thisAttr };
        setLookupKeyMapInOrder(ToStr, FromStr);

    }

    public void init() throws RemoteException, MXException {
        MboRemote mbo = getMboValue().getMbo();
//        String sql = " ORGID='"+mbo.getString("ORGID")+"' and SITEID='"+mbo.getString("SITEID")+"' and ISFLAG='Y'";
        String sql = "ISFLAG='N' AND projectnum IN (select projectnum from udbudget where ORGID='"+mbo.getString("ORGID")+"' AND SITEID='"+mbo.getString("SITEID")+"' AND ISFLAG='Y')";
        setListCriteria(sql);
        super.init();
    }

    public void action() throws RemoteException, MXException {
        super.action();
    }

    public MboSetRemote getList() throws RemoteException, MXException {
        return super.getList();
    }
}