/************************
* ********************/
public DynSql AndField(string field, string matchField)
{
var rec = new DWhere(WhereType.Field, field, matchField);
DRecords.Add(rec);
return(this);
}
public DynSql WhereBetween(string field, object rangeStart, object rangeEnd)
{
var rec = new DWhere(WhereType.Between, field, rangeStart, rangeEnd);
DRecords.Add(rec);
return(this);
}
public DynSql Where(string field, object value = null)
{
var rec = new DWhere(WhereType.Equal, field, value);
DRecords.Add(rec);
return(this);
}
public DynSql Where(object multiValue)
{
var rec = new DWhere(multiValue);
DRecords.Add(rec);
return(this);
}
/**
* Adds a Where record to the active record stack
* @param thisElem
* @param elemIs
* @param escapeValue - set this to true when handling user inputted values, false when like "lucas.arts=rulez.row"
* @returns {DynSQL}
*/
public DynSQL Where(string thisElem, object elemIs = null, bool escapeValue = true)
{
var equalValue = escapeValue ? PrepValue(elemIs) : Convert.ToString(elemIs);
var rec = new DWhere(thisElem, equalValue);
DRecords.Add(rec);
return(this);
}