package com.app.hxqh.spotcan;


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

import java.rmi.RemoteException;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 *  子表选择点检任务主表的任务编号
 */
public class FldSpotRunNum extends MAXTableDomain{

	public FldSpotRunNum(MboValue mbv) {
		super(mbv);
		String thisAttr = getMboValue().getAttributeName();
		setRelationship("SPOTRUN", "");
		String[] FromStr = { "SPOTRUNNUM" };
		String[] ToStr = { thisAttr };
		setLookupKeyMapInOrder(ToStr, FromStr);
	}

	public MboSetRemote getList() throws MXException, RemoteException {
		MboSetRemote set = super.getList();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		MboRemote mbo=getMboValue().getMbo();
		String orgid=mbo.getString("ORGID");
		String siteid=mbo.getString("SITEID");
		String appName = mbo.getThisMboSet().getApp();
		MboRemote owner = mbo.getOwner();//父级
		Date TASKDATE = owner.getDate("TASKDATE");//任务生成时间
		String taskDateStr = sdf.format(TASKDATE);
		set.setWhere(" ORGID='"+orgid+"' AND SITEID='"+siteid+"' AND EQUPMNTDESC='EDIT' AND to_char(CREATEDATE,'yyyy-MM-dd')='"+taskDateStr+"'");//选择”未下载”的数据
		set.reset();
		return set;
	}

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