public IProjection GroupAndConcatDia() { return(CustomProjections.SqlGroupAndConcatFunction("DAY({alias}.Data) as DIA", "DAY({alias}.Data)", new[] { "DIA" }, new[] { NHibernateUtil.String }, "/", GroupAndConcatMensal())); }
public IProjection GroupAndConcatMensal() { return(CustomProjections.SqlGroupAndConcatFunction("MONTH({alias}.Data) as MES", "MONTH({alias}.Data)", new[] { "MES" }, new[] { NHibernateUtil.String }, "/", GroupAndConcatAnual())); }
public IProjection GroupAndConcatTrimestral() { return(CustomProjections.SqlGroupAndConcatFunction("QUARTER({alias}.Data) as TRIMESTRE", "QUARTER({alias}.Data)", new[] { "TRIMESTRE" }, new[] { NHibernateUtil.String }, "º Trimestre de ", GroupAndConcatAnual())); }
public IProjection GroupAndConcatSemanal() { return(CustomProjections.SqlGroupAndConcatFunction("WEEK({alias}.Data) as SEMANA", "WEEK({alias}.Data)", new[] { "SEMANA" }, new[] { NHibernateUtil.String }, "ª Semana do Ano de ", GroupAndConcatAnual())); }