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;

            }

        }