package com.app.hxqh.udCostCenter;


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 by liuxq  20230928
 */
public class FldDeptCost extends MAXTableDomain{

	public FldDeptCost(MboValue mbv) {
		super(mbv);
		String thisAttr = getMboValue().getAttributeName();
		setRelationship("UDCOSTMOVE", "");
		String[] FromStr = { "KOSTL","ZKLEXT_ZH","ZKLEXT_EN" };//成本中心编号、中文描述、英文描述
		String[] ToStr = { thisAttr,"COST_CENTER_NAME","COST_CENTER_ENNAME" };
		setLookupKeyMapInOrder(ToStr, FromStr);
	}

	public MboSetRemote getList() throws MXException, RemoteException {
		MboSetRemote set = super.getList();
		MboRemote mbo=getMboValue().getMbo();
		String appName = mbo.getThisMboSet().getApp();
		String ORGID = mbo.getString("ORGID");
		String SITEID = mbo.getString("SITEID");
		set.setWhere(" UDCOSTMOVEID IN(select max(UDCOSTMOVEID) from UDCOSTMOVE where orgid='"+ORGID+"' and siteid='"+SITEID+"' GROUP BY KOSTL,ZKLEXT_ZH,ZKLEXT_EN)");
		set.reset();
		return set;
	}
}