package com.app.hxqh.udreport;


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

import java.rmi.RemoteException;

/**
 * 缺陷管理选择故障类别
 * edit 20230424
 */
public class FldFallureCode extends MAXTableDomain{

	public FldFallureCode(MboValue mbv) {
		super(mbv);
		String thisAttr = getMboValue().getAttributeName();
		setRelationship("FAILURELIST", "");
		String[] FromStr = { "FAILURECODE" };
		String[] ToStr = { thisAttr };
		setLookupKeyMapInOrder(ToStr, FromStr);
	}

	public MboSetRemote getList() throws MXException, RemoteException {
		MboSetRemote set = super.getList();
		MboRemote mbo=getMboValue().getMbo();
		String appName = mbo.getThisMboSet().getApp();
		if("UDREPORT".equalsIgnoreCase(appName)) { //缺陷管理
			String orgid=mbo.getString("ORGID");
			String assetnum=mbo.getString("ASSETNUM");
			set.setWhere("FAILURECODE in(select FAILURECODE from UDFAUCLASS where TEMPLATEID=(select TEMPLATEID from ASSET where ASSETNUM='"+assetnum+"') and ORGID ='"+orgid+"')");
			set.reset();
		}
		return set;
	}

}