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()));
}