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