Banninger/src/apps/tpriceadjust/AddTitemMlt.java

package tpriceadjust;

import baseclass.MultiselectDataBeanCust;
import p2.pao.PaoRemote;
import p2.pao.PaoSetRemote;
import p2.util.P2Exception;

public class AddTitemMlt extends MultiselectDataBeanCust {
    @Override
    protected PaoSetRemote getPaoSetRemote() throws P2Exception {
        PaoRemote pao = this.app.getAppBean().getPao();
        PaoSetRemote paoSet = super.getPaoSetRemote();
        if (pao != null) {
            //paoSet.setWhere(getworlds(pao.getPaoSet("TPRICEADJUSTDETAIL"), "fitemno", "fitemno") + " and fstatus='ÉóºË' and exists(select * from titem_saleclsnum where titem_saleclsnum.siteid='" + pao.getString("siteid") + "' and titem_saleclsnum.fitemno=titem.fitemno)");
            paoSet.setWhere(getworlds(pao.getPaoSet("TPRICEADJUSTDETAIL"), "fitemno", "fitemno") + " and fstatus='ÉóºË' ");
        }
        paoSet.reset();
        return paoSet;
    }
}