public Where <TDto, TProperty, TTable> AndWhere <TProperty>(string columnName)
{
var andWhere = new Where <TDto, TProperty, TTable>(TableImpl, Parameters, columnName);
AndConditions.Add(andWhere);
return(andWhere);
}
public void WhereAndCondition(string WhereClauseContent, int?IntParameter)
{
if (IntParameter == null)
{
return;
}
AndConditions.Add(" " + WhereClauseContent + " ");
}
public void WhereAndCondition(string WhereClauseContent, Guid?GuidParameter)
{
if (GuidParameter == Guid.Empty || GuidParameter == null)
{
return;
}
AndConditions.Add(" " + WhereClauseContent + " ");
}
public void WhereAndCondition(string WhereClauseContent, string StringParameter)
{
if (string.IsNullOrEmpty(StringParameter))
{
return;
}
AndConditions.Add(" " + WhereClauseContent + " ");
}
public void WhereAndCondition(string WhereClauseContent, double?DoubleParameter)
{
if (DoubleParameter == null)
{
return;
}
AndConditions.Add(" " + WhereClauseContent + " ");
}
public Where <TDto, TProperty, TTable> AndWhere <TProperty>(Expression <Func <TDto, TProperty> > columnExpression, string colPrefix = null)
{
var columnName = SpryExpression.GetColumnName(columnExpression);
if (!string.IsNullOrWhiteSpace(colPrefix))
{
columnName = colPrefix + "." + columnName;
}
var andWhere = new Where <TDto, TProperty, TTable>(TableImpl, Parameters, columnName);
AndConditions.Add(andWhere);
return(andWhere);
}
public void WhereAndCondition(string WhereClauseContent)
{
AndConditions.Add(" " + WhereClauseContent + " ");
}