package com.webclient.beans.udpdplan;

import psdi.mbo.MboRemote;
import psdi.mbo.MboSetRemote;
import psdi.util.MXException;
import psdi.webclient.system.beans.DataBean;

import java.rmi.RemoteException;
import java.util.Vector;

/**
 * 资产盘点-批量选择部门编号
 * edit 20240624
 */
public class SelectGDZCTableBean extends DataBean {

    //确定按钮的执行
    @Override
    public synchronized int execute() throws MXException, RemoteException {
        int ex = super.execute();
        MboRemote appMbo=app.getAppBean().getMbo();
        DataBean taskDataBean= app.getDataBean("selectasset_Table");//弹出框表ID
        DataBean targetDataBean= app.getDataBean("1687276555043");//子表的DataBean
        Vector<MboRemote> vec= taskDataBean.getSelection();
        if (!vec.isEmpty() && appMbo!=null) {
            for(int i=0;i<vec.size();i++){
                MboRemote vMbo = (MboRemote)vec.get(i);
                targetDataBean.addrow();
                MboRemote targetMbo = targetDataBean.getMbo(targetDataBean.getCurrentRow());
                MboRemote ownerMbo=targetMbo.getOwner();//父表对象
                //设置关联关系：
                targetMbo.setValue("PDNUM",appMbo.getString("PDNUM"));

                //写入子表数据
                targetMbo.setValue("GDZCBH",vMbo.getString("ANLN1"));
            }
        }
        return ex;
    }
    //弹出框过滤选择
    @Override
    public MboSetRemote getMboSetRemote() throws MXException, RemoteException {
        // 获得点检任务
//        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//        MboRemote mbo = app.getAppBean().getMbo();//当前主对象
//        MboSetRemote spotrunSet = MXServer.getMXServer().getMboSet("SPOTRUN",MXServer.getMXServer().getSystemUserInfo());
//        String orgid=mbo.getString("ORGID");
//        String siteid=mbo.getString("SITEID");
//        String appName = mbo.getThisMboSet().getApp();
//        Date TASKDATE = mbo.getDate("TASKDATE");//任务生成时间
//        String taskDateStr = sdf.format(TASKDATE);
//        String sql = " ORGID='"+orgid+"' AND SITEID='"+siteid+"' AND EQUPMNTDESC='EDIT' AND to_char(CREATEDATE,'yyyy-MM-dd')='"+taskDateStr+"'";
//        //设置选择条件
//        spotrunSet.setWhere(sql);
//        //重置列表
//        spotrunSet.reset();
//        return spotrunSet;
        return super.getMboSetRemote();
    }
}