public tgCase Else(tgQueryItem queryItem)
{
tgExpression expression = queryItem;
this.data.Else = expression;
return(this);
}
public tgCase Then(tgExpression expression)
{
tgSimpleCaseData.tgCaseClause clause = new tgSimpleCaseData.tgCaseClause();
clause.When = this.WhenItem;
clause.Then = expression;
if (data.Cases == null)
{
data.Cases = new List <tgSimpleCaseData.tgCaseClause>();
}
this.data.Cases.Add(clause);
return(this);
}
protected static string GetExpressionColumn(StandardProviderParameters std, tgDynamicQuerySerializable query, tgExpression expression, bool inExpression, bool useAlias)
{
string sql = String.Empty;
if (expression.CaseWhen != null)
{
return GetCaseWhenThenEnd(std, query, expression.CaseWhen);
}
if (expression.HasMathmaticalExpression)
{
sql += GetMathmaticalExpressionColumn(std, query, expression.MathmaticalExpression);
}
else
{
sql += GetColumnName(expression.Column);
}
if (expression.SubOperators != null)
{
if (expression.Column.Distinct)
{
sql = BuildSubOperationsSql(std, "DISTINCT " + sql, expression.SubOperators);
}
else
{
sql = BuildSubOperationsSql(std, sql, expression.SubOperators);
}
}
if (!inExpression && useAlias)
{
if (expression.SubOperators != null || expression.Column.HasAlias)
{
sql += " AS " + Delimiters.StringOpen + expression.Column.Alias + Delimiters.StringClose;
}
}
return sql;
}
public tgCase When(tgExpression ex)
{
return(this);
}
public tgCase Else(tgExpression expression)
{
this.data.Else = expression;
return(this);
}
public tgCase Else(tgExpression expression)
{
this.data.Else = expression;
return this;
}
public tgCase When(tgExpression ex)
{
return this;
}
public tgCase Then(tgExpression expression)
{
tgSimpleCaseData.tgCaseClause clause = new tgSimpleCaseData.tgCaseClause();
clause.When = this.WhenItem;
clause.Then = expression;
if (data.Cases == null)
{
data.Cases = new List<tgSimpleCaseData.tgCaseClause>();
}
this.data.Cases.Add(clause);
return this;
}