// 开单时间  
    if (!"".equals(startDate) &&  startDate != null) {  
        queryCondition = queryCondition  
                + " and t.receiptDate >= str\_to\_date('"  
                + startDate + "','%Y-%m-%d')" ;

    }

    if (!"".equals(endDate) && endDate != null) {  
        queryCondition = queryCondition  
               // + " and t.orderDate < '"+ CommonUtil.getAddDate(endDate.toString(), 1) +"','%Y-%m-%d')";  
                + " and t.receiptDate < str\_to\_date('"+ CommonUtil.getAddDate(endDate.toString(), 1) + "','%Y-%m-%d')";  
    }