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