Banninger/src/apps/tinvoiceapply/tinvoiceapplyMlt.java

package tinvoiceapply;

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

public class tinvoiceapplyMlt extends MultiselectDataBeanCust {
    @Override
    protected PaoSetRemote getPaoSetRemote() throws P2Exception {
        PaoSetRemote paoSet = super.getPaoSetRemote();
        try {
            tinvoiceapply pao = (tinvoiceapply) this.app.getAppBean().getPao();
            String fagentnum = pao.getString("fagentnum");
            String finvoicetaxnumber = pao.getString("finvoicetaxnumber");
            PaoSetRemote detailset = pao.getPaoSet("tinvoiceapplyorder");
            paoSet.setWhere("exists(select *from SAORDER_RECEIVEDVIEW where siteid=saorderdetail.siteid and saorderid=saorderdetail.fparentid and saorderdetailid=saorderdetail.saorderdetailid and isnull(freceivedamount,0)>isnull(saorderdetail.finvoiceamount,0) ) and " +
                    "exists(select * from saorder where fstatus in('ÉóºË','¹Ø±Õ') and siteid=saorderdetail.siteid and saorderid=saorderdetail.fparentid and fpayagentnum='" + fagentnum + "' " +
                    //"and finvoicetaxnumber='" + finvoicetaxnumber + "'" +
                    ") " +
                    "and " +
                    getworlds(detailset, "saorderdetailid", "saorderdetailid"));
        } catch (Exception e) {
            paoSet.setWhere("1=2");
            e.printStackTrace();
        }
        paoSet.reset();
        return paoSet;
    }
}