给列表界面添加过滤条件

    @Override
    protected FilterInfo getDefaultFilterForQuery()
    {
        return new FilterInfo();
    }
    
    @Override
    protected IQueryExecutor getQueryExecutor(IMetaDataPK arg0, EntityViewInfo arg1)
    {
        //查询
        FilterInfo filter = new FilterInfo();
        Object objDateFrom = planDateFrom.getValue();//开始时间
        if(objDateFrom!=null)
        {
            Calendar c = Calendar.getInstance();
            c.setTime((Date)objDateFrom);
            c.set(Calendar.HOUR_OF_DAY, 0);
            c.set(Calendar.MINUTE, 0);
            c.set(Calendar.SECOND, 0);
            filter.getFilterItems().add(new FilterItemInfo("planDate",c.getTime(),CompareType.GREATER_EQUALS));
        }
        Object objDateTo = planDateTo.getValue();//结束时间
        if(objDateTo!=null)
        {
            Calendar c = Calendar.getInstance();
            c.setTime((Date)objDateTo);
            c.set(Calendar.HOUR_OF_DAY, 23);
            c.set(Calendar.MINUTE, 59);
            c.set(Calendar.SECOND, 59);
            filter.getFilterItems().add(new FilterItemInfo("planDate",c.getTime(),CompareType.LESS_EQUALS));
        }
        //模糊查询：单号，车牌，司机,接收方
        String queryStr = planSearch.getText();
        if(queryStr!=null && queryStr.length()!=0)
        {
            FilterInfo filter2 = new FilterInfo();
            queryStr = "%" + queryStr + "%";
            filter2.getFilterItems().add(new FilterItemInfo("number", queryStr, CompareType.LIKE));
            filter2.getFilterItems().add(new FilterItemInfo("truckLicence.name", queryStr, CompareType.LIKE));
            filter2.getFilterItems().add(new FilterItemInfo("driver.name", queryStr, CompareType.LIKE));
            filter2.getFilterItems().add(new FilterItemInfo("entrys.otherLicence", queryStr, CompareType.LIKE));
            filter2.getFilterItems().add(new FilterItemInfo("entrys.otherDriver", queryStr, CompareType.LIKE));
            filter2.getFilterItems().add(new FilterItemInfo("cmpanyOrgUnit.name", queryStr, CompareType.LIKE));
            filter2.setMaskString("#0 or #1 or #2 or #3 or #4 or #5");
            try
            {
                filter.mergeFilter(filter2, "and");
            }
            catch (BOSException e)
            {
                e.printStackTrace();
            }
        }
        //排除未确认和全部派车的，显示待派车和部分派车
        filter.getFilterItems().add(new FilterItemInfo("billState",1,CompareType.NOTEQUALS));
        filter.getFilterItems().add(new FilterItemInfo("billState",4,CompareType.NOTEQUALS));
        //排除数量-已派车收运数量=0的派车计划分录
        Set<String> planIdSet = getPlanEntryIdSet();
        if(planIdSet.size()>0)
        {
            filter.getFilterItems().add(new FilterItemInfo("entrys.id",planIdSet,CompareType.INCLUDE));
        }

        EntityViewInfo evi = (EntityViewInfo) arg1.clone();
        IQueryExecutor executor = null;
        try
        {        
            FilterInfo filter1 = evi.getFilter();
            if(filter1==null || filter1.getFilterItems().size()==0)
            {
                evi.setFilter(filter);
            }else
            {
                filter1.mergeFilter(filter, "and");
                evi.setFilter(filter1);
            }
            executor = super.getQueryExecutor(arg0, evi);
            System.out.println(executor.getSQL());
        }
        catch (BOSException e)
        {
            e.printStackTrace();
        }
        return executor;
    }