public virtual string Trim(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" (rtrim(ltrim({0}))) ", parameter.MemberName));
}
public virtual string CharIndex(MethodCallExpressionModel model)
{
return(string.Format("CHARINDEX ({0},{1})", model.Args[0].MemberName, model.Args[1].MemberName));
}
public string ToVarchar(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS VARCHAR(MAX))", parameter.MemberName));
}
public virtual string HasNumber(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format("( {0}>0 AND {0} IS NOT NULL )", parameter.MemberName));
}
public virtual string AggregateDistinctCount(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format("COUNT(DISTINCT{0})", parameter.MemberName));
}
public virtual string Length(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format("LEN({0})", parameter.MemberName));
}
public virtual string AggregateMax(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format("MAX({0})", parameter.MemberName));
}
public virtual string ToDecimal(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS MONEY)", parameter.MemberName));
}
public virtual string ToDate(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS DATETIME)", parameter.MemberName));
}
public virtual string ToGuid(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS UNIQUEIDENTIFIER)", parameter.MemberName));
}
public virtual string ToInt64(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS BIGINT)", parameter.MemberName));
}
public virtual string IsNullOrEmpty(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format("( {0}='' OR {0} IS NULL )", parameter.MemberName));
}
