public override string AddAggregationFce(AggregationFunctionsEnum _fceType, string _tableName, string _columnName)
{
String _sbAggreg = "";
switch (_fceType)
{
case AggregationFunctionsEnum.Sum:
_sbAggreg = "SUM([" + _tableName + "].[" + _columnName + "])";
break;
case AggregationFunctionsEnum.Min:
_sbAggreg = "MIN([" + _tableName + "].[" + _columnName + "])";
break;
case AggregationFunctionsEnum.Max:
_sbAggreg = "MAX([" + _tableName + "].[" + _columnName + "])";
break;
case AggregationFunctionsEnum.Avg:
_sbAggreg = "AVG([" + _tableName + "].[" + _columnName + "])";
break;
default:
break;
}
return(_sbAggreg);
}
//public override String AddAggregationFce(AggregationFunctionsEnum _fceType, string _columnName)
//{
// String _sbAggreg = "";
// switch (_fceType)
// {
// case AggregationFunctionsEnum.Sum:
// _sbAggreg = "SUM(" + _columnName + ")";
// break;
// case AggregationFunctionsEnum.Min:
// _sbAggreg = "MIN(" + _columnName + ")";
// break;
// case AggregationFunctionsEnum.Max:
// _sbAggreg = "MAX(" + _columnName + ")";
// break;
// case AggregationFunctionsEnum.Avg:
// _sbAggreg = "AVG(" + _columnName + ")";
// break;
// case AggregationFunctionsEnum.Count:
// _sbAggreg = "COUNT(" + _columnName + ")";
// break;
// default:
// break;
// }
// return _sbAggreg;
//}
//public override String AddMathFce(string _columnNameLeft, string _columnNameRight, MathOperatorEnum _operator, Boolean _addParenthises)
//{
// string _retVal = "";
// switch (_operator)
// {
// case MathOperatorEnum.Plus:
// _retVal = _columnNameLeft + " + " + _columnNameRight;
// break;
// case MathOperatorEnum.Minus:
// _retVal = _columnNameLeft + " - " + _columnNameRight;
// break;
// case MathOperatorEnum.Multiple:
// _retVal = _columnNameLeft + " * " + _columnNameRight;
// break;
// case MathOperatorEnum.Divide:
// _retVal = _columnNameLeft + " / " + _columnNameRight;
// break;
// default:
// break;
// }
// if (_retVal.Length > 0)
// {
// if (_addParenthises)
// {
// _retVal = "(" + _retVal + ")";
// }
// }
// return _retVal;
//}
public override string AddAggregationFce(AggregationFunctionsEnum _fceType, string _mathFce)
{
String _sbAggreg = "";
switch (_fceType)
{
case AggregationFunctionsEnum.Sum:
_sbAggreg = "SUM(" + _mathFce + ")";
break;
case AggregationFunctionsEnum.Min:
_sbAggreg = "MIN(" + _mathFce + ")";
break;
case AggregationFunctionsEnum.Max:
_sbAggreg = "MAX(" + _mathFce + ")";
break;
case AggregationFunctionsEnum.Avg:
_sbAggreg = "AVG(" + _mathFce + ")";
break;
default:
break;
}
return(_sbAggreg);
}
public abstract String AddAggregationFce(AggregationFunctionsEnum _fceType, String _mathFce);
public abstract String AddAggregationFce(AggregationFunctionsEnum _fceType, String _tableName, String _columnName);
