public IExecuteSql Where(Expression <Func <T, bool> > criteria)
{
_sb.RemoveLastIfEquals(',');
_sb.Append($" where {_writer.GetSql(criteria)}");
return(this);
}
private void Round(MethodCallExpression method, StringBuilder sb, IGenerateSqlFromExpressions writer)
{
sb.Append("round(");
sb.Append(writer.GetColumnsSql(method.Arguments[1]));
sb.Append(",");
sb.Append(writer.GetSql(method.Arguments[2]));
sb.Append(")");
}
IConnectWhere <T> IWhere <T> .Where(Expression <Func <T, bool> > criteria)
{
_sb.Append("where ");
_sb.AppendLine(_writer.GetSql(criteria));
return(this);
}
public void WriteCriteria(LambdaExpression expr)
{
_sb.Append(" where ");
_sb.Append(_writer.GetSql(expr));
}
private void BetweenDates(MethodCallExpression arg1, StringBuilder sb, IGenerateSqlFromExpressions writer)
{
var date = writer.GetColumnsSql(arg1.Arguments[0]);
sb.Append($"{date}>={writer.GetSql(arg1.Arguments[1])} and {date}<={writer.GetSql(arg1.Arguments[2])}");
}