public void Select(string tableName, string fieldName, SelectFunction selectFunction, string alias = null)
{
string selectionString = null;
if (string.IsNullOrEmpty(alias))
{
selectionString = string.Format("{0}({1})", selectFunction.ToString(), Adapter.Field(tableName, fieldName));
}
else
{
selectionString = string.Format("{0}({1}) AS {2}", selectFunction.ToString(), Adapter.Field(tableName, fieldName), alias);
}
_selectionList.Add(selectionString);
}
public string AddHaving(string tableName, string fieldName, SelectFunction selectFunction, string opr, string parameter)
{
var func = selectFunction.ToString();
_componentList.Add(string.Format("{2}({0}.{1}) {3} {4}", tableName, fieldName, func, opr, _adapter.Parameter(parameter)));
return(parameter);
}
internal void Aggregate(LambdaExpression expression, SelectFunction selectFunction)
{
expression.ThrowIfNull(nameof(expression));
var fieldName = TableInfo.GetColumnName(expression.Body.GetMemberExpression());
var memberNode = new MemberNode {
TableName = TableName, FieldName = fieldName
};
var selectionString = SqlFormatter.SelectAggregate(memberNode, selectFunction.ToString());
Context.Selection.Add(selectionString);
}
public void Select(string tableName, string fieldName, SelectFunction selectFunction, string aliasName)
{
string name = string.IsNullOrEmpty(aliasName) ? fieldName : aliasName;
name = _adapter.Field(name);
var fname = fieldName;
if (fieldName != "*")
{
fname = _adapter.Field(tableName, fieldName);
}
var selectionString = string.Format("{0}({1}) AS {2}", selectFunction.ToString(), fname, name);
_selectionList.Add(selectionString);
}
internal void Select(string tableName, string columnName, SelectFunction selectFunction, string tableAlias, string columnAlias)
{
var functionNoHasColumnName = !String.IsNullOrEmpty(columnName);
var functionName = selectFunction.ToString();
var existsAlias = !String.IsNullOrEmpty(columnAlias);
var tableNameToUse = String.IsNullOrEmpty(tableAlias) ? tableName : tableAlias;
var columnNameToUserFunction = functionNoHasColumnName ? _sqlAdapter.GetColumnName(tableNameToUse, columnName) : "1";
var functionClause = new StringBuilder($"{functionName.ToUpper()}({columnNameToUserFunction}) ");
if (existsAlias)
{
functionClause.Append($"AS {columnAlias} ");
}
_sqlQueryBuilderExtension.AddFunctionsName(functionClause.ToString());
}
public void Select(string tableName, string fieldName, SelectFunction selectFunction)
{
var selectionString = string.Format("{0}({1})", selectFunction.ToString(), Adapter.Field(tableName, fieldName));
_selectionList.Add(selectionString);
}
private void AddHavingClause(ClauseInput clauseInput, SelectFunction selectFunction)
{
var havingEpression = $"{selectFunction.ToString().ToUpper()}({clauseInput.Column}) {clauseInput.Operation} {clauseInput.ParameterFormated}";
_havingClause.Add(havingEpression);
}
public void Select(SelectFunction selectFunction, string fieldName)
{
var selectionString = string.Format("{0}({1})", selectFunction.ToString(), fieldName);
_selectionList.Add(selectionString);
}
public void Select(string tableName, string fieldName, SelectFunction selectFunction)
{
var selectionString = string.Format("{0}({1})", selectFunction.ToString(), Adapter.Field(tableName, fieldName));
_selectionList.Add(selectionString);
}
public void Select(string tableName, string fieldName, SelectFunction selectFunction)
{
var selectionString = $"{selectFunction.ToString()}({Adapter.Field(tableName, fieldName)})";
SelectionList.Add(selectionString);
}