criteria µÄÓï¾ä¼ÓSQLÓï¾äÒ»Æð²éѯ

   if(query.getIsScrapAlert()!=null&&query.getIsScrapAlert()==1){
   //criteria.add(Expression.sql(" add_months(this_.D_RECEIVE_DATE,this_.N_DEPRECIABLE_LIFE*12)<add_months(sysdate,-3) "));
   criteria.add(Expression.sql(" ((add_months(this_.D_RECEIVE_DATE, this_.N_DEPRECIABLE_LIFE * 12) between add_months(sysdate, -3) and sysdate) or (add_months(this_.D_RECEIVE_DATE, this_.N_DEPRECIABLE_LIFE * 12) < sysdate))"));
 
   CriteriaUtil.addEq(criteria, "NTechStatus", Long.valueOf(0));
  }