public SqlUpdateQuery Where(string columnName, Criteria constraint) { constraint.CriteriaType = CriteriaType.And; constraint.ColumnName = columnName; Template.Criteria.Add(constraint); return this; }
/// <summary> /// /// </summary> /// <param name="columnName"></param> /// <returns></returns> public SqlSelectQuery And(string columnName, Criteria constraint) { constraint.CriteriaType = CriteriaType.And; constraint.ColumnName = columnName; Template.Criteria.Add(constraint); return this; }
public SqlDeleteQuery Or(string columnName, Criteria constraint) { constraint.CriteriaType = CriteriaType.Or; constraint.ColumnName = columnName; Template.Criteria.Add(constraint); return this; }
private string SetupParameters(IDataCommand cmd, Criteria criteriaItem) { var paramNames = ""; switch (criteriaItem.Comparison) { case ComparisonOperator.Equals: case ComparisonOperator.NotEquals: case ComparisonOperator.GreaterThan: case ComparisonOperator.GreaterThanEquals: case ComparisonOperator.LessThan: case ComparisonOperator.LessThanEquals: case ComparisonOperator.Like: case ComparisonOperator.NotLike: paramNames = AddParameter(cmd, criteriaItem.ValueList[0]); break; case ComparisonOperator.In: case ComparisonOperator.NotIn: var nameList = new List<string>(); foreach (var valueItem in criteriaItem.ValueList) { var name = AddParameter(cmd, valueItem); nameList.Add(name); } paramNames = "(" + string.Join(",", nameList.ToArray()) + ")"; break; case ComparisonOperator.Between: var startName = AddParameter(cmd, criteriaItem.ValueList[0]); var endName = AddParameter(cmd, criteriaItem.ValueList[1]); paramNames = startName + " AND " + endName; break; } return paramNames; }