criteria 的语句加SQL语句一起查询

hibernate

criteria 的语句加SQL语句一起查询

public DataGrid<StationWorkRec> getDyData(StationWorkRec cb, PageHelper ph, String dycondition){

     Strig dycondition=" carno='D4' and station='3#转炉南';

     Criteria cr =dao.getCurrentSession().createCriteria(
                StationWorkRec.class);

     cr.add(Expression.sql(dycondition));

     cr.add(Restrictions.eq("station", station));

     return dao.findPageByCriteria(cb, ph,cr);

}