/// <summary>Agrega un campo con funcion agregada al listado de campos</summary>
public Query AggAs(dbAgr aggregate, Query field, string fieldAlias)
{
instruction = dbItr.sel;
Field fld = new Field(SanitizeSQL(fieldAlias), field);
curUnion.lstAggFields.Add(new Aggregate(aggregate, fld, SanitizeSQL(fieldAlias)));
return(this);
}
public Particle(dbWTy wty, dbAgr agg, dbWin win, Expression expr, Dictionary <string, Constructor.dbOrd> orderBy, string[] partitionBy)
{
Operation = dbOpe.Over;
Wty = wty;
OrderBy = orderBy;
PartitionBy = partitionBy;
SetValue(expr);
}
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary>
public Query AggAs(dbAgr aggregate, Expression expr, string fieldAlias)
{
instruction = dbItr.sel;
Field fld = new Field(SanitizeSQL(fieldAlias), expr);
fld.expression = expr;
curUnion.lstAggFields.Add(new Aggregate(aggregate, fld, SanitizeSQL(fieldAlias)));
return(this);
}
public Aggregate(dbAgr aggregateFunct, Field insideField, string alias)
{
funct = aggregateFunct;
field = insideField;
fieldAlias = alias;
}
private Expression(dbWTy wty, dbAgr agg, dbWin win, Expression expr, Dictionary <string, Constructor.dbOrd> orderBy, string[] partitionBy)
{
particles.Add(new Particle(wty, agg, win, expr, orderBy, partitionBy));
}
private Expression(dbAgr agg, Expression expr)
{
particles.Add(new Particle(agg, expr));
}
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary>
public Query Agg(dbAgr aggregate, Expression field)
{
return(AggAs(aggregate, field, ""));
}
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary>
public Query Agg(dbAgr aggregate, Query field)
{
return(AggAs(aggregate, field, ""));
}
/// <summary>Agrega un campo con funcion agregada al listado de campos</summary>
public Query Agg(dbAgr aggregate, string field)
{
AggAs(aggregate, SanitizeSQL(field), "");
return(this);
}
public Particle(dbAgr agg, Expression expr)
{
Operation = dbOpe.Agg;
Agg = agg;
SetValue(expr);
}
