private StringBuilder GetOperatorClause(EnumSqlOperator sqloperator)
{
switch (sqloperator)
{
case EnumSqlOperator.NotEqual:
return(new StringBuilder().AppendFormat("<>"));
case EnumSqlOperator.GreatThan:
return(new StringBuilder().AppendFormat(">"));
case EnumSqlOperator.GreatThanEqual:
return(new StringBuilder().AppendFormat(">="));
case EnumSqlOperator.LessThan:
return(new StringBuilder().AppendFormat("<"));
case EnumSqlOperator.LesThanEqual:
return(new StringBuilder().AppendFormat("<="));
case EnumSqlOperator.IsNull:
return(new StringBuilder().AppendFormat("= NULL"));
default:
return(new StringBuilder().AppendFormat("="));
}
}
private static StringBuilder GetOperatorNumberLinq(EnumSqlOperator sqloperator, int index)
{
switch (sqloperator)
{
case EnumSqlOperator.NotEqual:
return(new StringBuilder().AppendFormat("<> @{0}", index));
case EnumSqlOperator.GreatThan:
return(new StringBuilder().AppendFormat("> @{0}", index));
case EnumSqlOperator.GreatThanEqual:
return(new StringBuilder().AppendFormat(">= @{0}", index));
case EnumSqlOperator.LessThan:
return(new StringBuilder().AppendFormat("< @{0}", index));
case EnumSqlOperator.LesThanEqual:
return(new StringBuilder().AppendFormat("<= @{0}", index));
case EnumSqlOperator.IsNull:
return(new StringBuilder().AppendFormat("= null"));
default:
return(new StringBuilder().AppendFormat("= @{0}", index));
}
}
private static string GetOperatorCharacterLinq(EnumSqlOperator @operator, int param)
{
switch (@operator)
{
case EnumSqlOperator.NotEqual:
return(string.Format("<> @{0}", param));
case EnumSqlOperator.GreatThan:
return(string.Format("> @{0}", param));
case EnumSqlOperator.GreatThanEqual:
return(string.Format(">= @{0}", param));
case EnumSqlOperator.LessThan:
return(string.Format("< @{0}", param));
case EnumSqlOperator.LesThanEqual:
return(string.Format("<= @{0}", param));
case EnumSqlOperator.BeginWith:
return(string.Format(".StartsWith(@{0})", param));
case EnumSqlOperator.EndWith:
return(string.Format(".EndsWith(@{0})", param));
case EnumSqlOperator.Like:
return(string.Format(".Contains(@{0})", param));
default:
return(string.Format(".Equals(@{0})", param));
}
}
public static IListParameter Default(int value, string column, EnumSqlOperator sqlOperator, string tableName)
{
return(new WhereTerm
{
Value = value,
TableName = tableName,
ParamDataType = EnumParameterDataTypes.Number,
Operator = sqlOperator,
ColumnName = column
});
}
/// <summary>
/// To create where term condition with default value TableName = string.Empty, ParamDataType = EnumParamterDataTypes.Character
/// </summary>
/// <param name="value">Fill string value of where term</param>
/// <param name="column">Fill string value of column name</param>
/// <param name="sqlOperator">Fill sql operator</param>
/// <returns>WhereTerm</returns>
public static WhereTerm Default(string value, string column, EnumSqlOperator sqlOperator)
{
return(new WhereTerm
{
Value = value,
TableName = String.Empty,
ParamDataType = EnumParameterDataTypes.Character,
Operator = sqlOperator,
ColumnName = column
});
}
public static WhereTerm Default(DateTime value, string column, EnumSqlOperator sqlOperator, string tableName)
{
return(new WhereTerm
{
Value = value,
TableName = tableName,
ParamDataType = EnumParameterDataTypes.DateTime,
Operator = sqlOperator,
ColumnName = column
});
}
private static string GetOperatorBooleanLinq(EnumSqlOperator sqlOperator, int index)
{
switch (sqlOperator)
{
case EnumSqlOperator.NotEqual:
return(string.Format("!= @{0}", index));
default:
return(string.Format("= @{0}", index));
}
}
private static object GetOperatorDateTimeLinq(EnumSqlOperator sqlOperator, int index)
{
switch (sqlOperator)
{
case EnumSqlOperator.NotEqual:
return(new StringBuilder().AppendFormat("<> @{0}", index));
case EnumSqlOperator.GreatThan:
return(new StringBuilder().AppendFormat("> @{0}", index));
case EnumSqlOperator.GreatThanEqual:
return(new StringBuilder().AppendFormat(">= @{0}", index));
case EnumSqlOperator.LessThan:
return(new StringBuilder().AppendFormat("< @{0}", index));
case EnumSqlOperator.LesThanEqual:
return(new StringBuilder().AppendFormat("<= @{0}", index));
default:
return(new StringBuilder().AppendFormat("= @{0}", index));
}
}
