/// <summary>
/// 访问 EndWidth 方法
/// </summary>
/// <param name="m">方法表达式</param>
protected override Expression VisitEndsWith(MethodCallExpression m)
{
if (m != null)
{
_visitor.Visit(m.Object);
if (this.NotOperands != null && this.NotOperands.Contains(m))
{
_builder.Append(" NOT");
}
_builder.Append(" LIKE ");
if (m.Arguments[0].CanEvaluate())
{
ColumnAttribute column = null;
bool isUnicode = NpgUtils.IsUnicode(_visitedMark.Current, out column);
string value = _constor.GetSqlValue(m.Arguments[0].Evaluate().Value, _builder.TranslateContext, column);
if (!_builder.Parameterized && value != null)
{
value = value.TrimStart('N').Trim('\'');
}
if (_builder.Parameterized)
{
_builder.Append("('%' || ");
_builder.Append(value);
_builder.Append(")");
}
else
{
if (isUnicode)
{
_builder.Append('N');
}
_builder.Append("'%");
_builder.Append(value);
_builder.Append("'");
}
}
else
{
_builder.Append("('%' || ");
_visitor.Visit(m.Arguments[0]);
_builder.Append(")");
}
}
return(m);
}
/// <summary>
/// 检查字段或属性成员声明的 DbType 是否为 Unicode 数据类型
/// </summary>
/// <param name="m">将要检查的字段或属性成员</param>
/// <param name="column">字段或属性成员显示声明的列特性</param>
/// <returns></returns>
public static bool IsUnicode(MemberVisitedStack.VisitedMember m, out ColumnAttribute column)
{
column = m != null?TypeUtils.GetColumnAttribute(m.Member, m.ReflectedType) : null;
return(NpgUtils.IsUnicode(column == null ? null : column.DbType));
}
/// <summary>
/// 检查字段或属性成员声明的 DbType 是否为 Unicode 数据类型
/// </summary>
/// <param name="m">将要检查的字段或属性成员</param>
/// <returns></returns>
public static bool IsUnicode(MemberVisitedStack.VisitedMember m)
{
ColumnAttribute column = null;
return(NpgUtils.IsUnicode(m, out column));
}
