public string[] AdicionarCondicaoEntre(string campo, object inicio, object fim) { var parametros = new[] { string.Empty, string.Empty }; var parametroInicio = string.Concat("_p", _proximoParametro.ToString(), "a"); var parametroFim = string.Concat("_p", _proximoParametro.ToString(), "b"); if ((inicio != null) && (fim != null)) { parametros[0] = parametroInicio; parametros[1] = parametroFim; Wheres.Add(string.Concat("([", campo, "]between @", parametroInicio, " and @", parametroFim, ")")); } else if (inicio != null) { parametros[0] = parametroInicio; Wheres.Add(string.Concat("([", campo, "]>=@", parametroInicio, ")")); } else { parametros[1] = parametroFim; Wheres.Add(string.Concat("([", campo, "]<=@", parametroFim, ")")); } _proximoParametro++; return(parametros); }
public string[] AdicionarCondicaoEntre(string campo, object inicio, object fim) { var parametros = new[] { string.Empty, string.Empty }; var parametroInicio = "_p" + _proximoParametro.ToString() + "a"; var parametroFim = "_p" + _proximoParametro.ToString() + "b"; if ((inicio != null) && (fim != null)) { parametros[0] = parametroInicio; parametros[1] = parametroFim; Wheres.Add("([" + campo + "]between @" + parametroInicio + " and @" + parametroFim + ")"); } else if (inicio != null) { parametros[0] = parametroInicio; Wheres.Add("([" + campo + "]>=@" + parametroInicio + ")"); } else { parametros[1] = parametroFim; Wheres.Add("([" + campo + "]<=@" + parametroFim + ")"); } _proximoParametro++; return(parametros); }
/// <summary> /// Instancie o objeto e clona /// </summary> /// <param name="pTableQuery">Objeto table query</param> public TableQuery(TableQuery pTableQuery) : this() { DbName = pTableQuery.DbName; TableName = pTableQuery.TableName; FieldName = pTableQuery.FieldName; Alias = pTableQuery.Alias; SchemaTable = pTableQuery.SchemaTable; Top = pTableQuery.Top; Distinct = pTableQuery.Distinct; Fields = new TableAdapterFieldCollection(pTableQuery.Fields); foreach (OrderBy myItem in pTableQuery.OrderBy) { OrderBy.Add(new OrderBy(myItem)); } pTableQuery.Wheres.ForEach( w => Wheres.Add(new WhereCollection(w))); if (pTableQuery.Joins != null) { pTableQuery.Joins.ForEach( j => Joins.Add(new Join(j))); } if (pTableQuery.Union != eUnionType.eutNone) { pTableQuery.InternalQuery.ForEach( c => InternalQuery.Add(new TableQuery(c))); } }
/// <summary> /// Add a another condition to the WHERE Clause that need to be true /// </summary> /// <param name="where">The WHERE Clause to add</param> public virtual Where And(Where where) { if (where == null) { throw new System.ArgumentNullException(); } Wheres.Add(where); return(this); }
/// <summary> /// Add a another condition to the WHERE Clause that can be true instead /// </summary> /// <param name="where">The WHERE Clause to add</param> public virtual Where Or(Where where) { if (where == null) { throw new System.ArgumentNullException(); } where.IsAnd = false; Wheres.Add(where); return(this); }
public string AdicionarCondicao(string campo, int operador, object valor) { var parametro = "_p" + _proximoParametro.ToString(); if ((valor == null) || (valor == DBNull.Value)) { Wheres.Add("([" + campo + "]IS NULL)"); } else { Wheres.Add("([" + campo + "]" + ConsultarSinalDoOperador(operador) + "@" + parametro + ")"); } _proximoParametro++; return(parametro); }
public SqlBuilderUpdate Where(string name, object value) { Wheres.Add(Provider.CreateTag(name), value); return(this); }
public void AdicionarCondicaoApenasCampoNaoNulo(string campo) { Wheres.Add("([" + campo + "]IS NOT NULL)"); }
public void AdicionarCondicaoPersonalizada(string condicao) { Wheres.Add("(" + condicao + ")"); }
public void AdicionarCondicaoApenasCampoNaoNulo(string campo) { Wheres.Add(string.Concat("([", campo, "]IS NOT NULL)")); }
public void AdicionarCondicaoPersonalizada(string condicao) { Wheres.Add(string.Concat("(", condicao, ")")); }
/// <summary> /// Add a basic where clause with a custom operator to the query. /// </summary> /// <param name="column">The column to which the clause applies.</param> /// <param name="ope">The operator for the where clause.</param> /// <param name="value">The value of the clause.</param> /// <param name="boolean">The boolean that applies for the where clause.</param> /// <returns>The current query.</returns> public Builder <T> Where(string column, string ope, dynamic value, string boolean = "AND") { Wheres.Add(new WhereClause(column, ope, value, boolean)); return(this); }