在HQL中使用new抛出异常

本文关键字:new 抛出异常 HQL | 更新日期: 2023-09-27 18:11:54

我试图使用new与HQL创建一个查询来选择一个实体的一些值,它的工作无需使用SUM,但我需要SUM这个实体的一些值。为了做到这一点,我创建了一个构造函数到这个实体来接收这个hql查询的参数,如果我传递没有SUM的参数,它可以工作,但传递SUM作为参数不能。我怎么解决这个问题呢?

An unhandled exception of type 'NHibernate.QueryException' occurred in NHibernate.dll
Additional information: Unable to locate appropriate constructor on class [ControleDeVendas.domain.Estoque, ControleDeVendas, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]

public IList<Estoque> findByDateSintetico(DateTime di, DateTime df){            
            ISession _session = getSession();
            String SQL = "SELECT new Estoque(e.dtTransacao, e.produto, e.tipoOperacao, e.qtdTransacao, " + 
                                            "SUM(CASE e.tipoOperacao WHEN 'E' THEN e.qtdTransacao ELSE 0 END), " + 
                                            "SUM(CASE e.tipoOperacao WHEN 'S' THEN e.qtdTransacao ELSE 0 END) " +
                                            ")" +
                         "FROM Estoque e " +
                         "WHERE e.dtTransacao BETWEEN :di AND :df " +
                         "GROUP BY e.dtTransacao, e.produto " +
                         "ORDER BY e.dtTransacao";
            IList<Estoque> list = _session.CreateQuery(SQL)
                .SetParameter("di", di)
                .SetParameter("df", df)
                .List<Estoque>();
            Console.WriteLine("LISTA ESTOQUE: " + list.Count);
            return list;
        }

实体

[Serializable]
    public class Estoque {
        public virtual long id                              { set; get; }
        public virtual DateTime dtTransacao                 { set; get; }
        public virtual Produto produto                      { set; get; }
        public virtual String historico                     { set; get; }
        public virtual String tipoOperacao                  { set; get; }
        public virtual int qtdTransacao                     { set; get; }
        public virtual decimal valorTransacao               { set; get; }
        public virtual String usuario                       { set; get; }
        public virtual int totalEntradas                    { set; get; }
        public virtual int totalSaidas                      { set; get; }
        public Estoque() {            
        }
        //receive params of HQL Query
        public Estoque(DateTime dtTransacao, Produto produto, String tipoOperacao, int qtdTransacao, int totalEntradas, int totalSaidas){
            this.dtTransacao = dtTransacao;
            this.produto = produto;
            this.tipoOperacao = tipoOperacao;
            this.qtdTransacao = qtdTransacao;
            this.totalEntradas = totalEntradas;
            this.totalSaidas = totalSaidas;
        }
        public override bool Equals(object obj){
            return base.Equals(obj);
        }
        public override int GetHashCode(){
            return base.GetHashCode();
        }
    }

在HQL中使用new抛出异常

我终于解决了这个问题。我只定义属性totalEntradastotalSaidasInt64及其作品。