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