hql between and 查询

  public IList<PrdtStdEntity> QueryPrdtStd(PrdtStdEntity prdtStdEntity)
        {
            try
            {
                var hql = "from PrdtStdEntity t where (t.StdNo=:stdNo or t.ReplacePrdtStdNo=:replacePrdtStdNo)";
                var paramList = new List<Parameter>
                {
                    new Parameter("stdNo", prdtStdEntity.StdNo),
                    new Parameter("replacePrdtStdNo", prdtStdEntity.ReplacePrdtStdNo)
                };


                //hql += " and (t.PublishDate BETWEEN TO_DATE('2015-12-09','yyyy-mm-dd') and TO_DATE('2015-12-10','yyyy-mm-dd')) ";



                hql += " and t.PublishDate between to_date(:beginSampleDate,'yyyy-mm-dd') and to_date(:endSampleDate,'yyyy-mm-dd')  ";
                paramList.Add(new Parameter("beginSampleDate", "2015-12-01"));
                paramList.Add(new Parameter("endSampleDate", "2015-12-19"));

                return DataAccess.FindAll<PrdtStdEntity>(hql, paramList);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

 

转载于:https://www.cnblogs.com/yisheng/p/5089216.html