在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();
}
}
我终于解决了这个问题。我只定义属性totalEntradas
和totalSaidas
到Int64
及其作品。