/// <summary>
/// 產出link語法
/// </summary>
/// <param name="Value">值</param>
/// <param name="Colname">欄位名稱</param>
/// <param name="Like"></param>
/// <returns></returns>
public static String[] GetLike(String Value, String Colname, LikeMode Like)
{
string COL = CharFilter(Colname);
string LikeString = LinkTemp.Replace("<COL1>", Colname)
.Replace("<COL2>", Colname.Replace("[", "").Replace("]", ""));
switch (Like)
{
case LikeMode.Right:
LikeString = LikeString.Replace("<R>", "'%'").Replace("<L>", "");
break;
case LikeMode.Left:
LikeString = LikeString.Replace("<R>", "").Replace("<L>", "'%'");
break;
case LikeMode.Both:
LikeString = LikeString.Replace("<R>", "'%'").Replace("<L>", "'%'");
break;
}
return(new String[] { CharFilter(Value), LikeString });
}
public static WhereFilterCollection WhereColumnLike(this WhereFilterCollection query, string leftTableAlias, string leftField, string text, LikeMode mode = LikeMode.Default)
{
query.Add(new ColumnLikeWhereFilter()
{
LeftColumn = new Column(leftTableAlias, leftField),
LikeMode = mode,
Text = text
});
return(query);
}
public static WhereFilterCollection WhereColumnLike(this WhereFilterCollection query, Table leftTable, string leftField, string text, LikeMode mode = LikeMode.Default)
{
query.WhereColumnLike(leftTable.Alias, leftField, text, mode);
return(query);
}
public static SelectQuery WhereColumnLike(this SelectQuery query, string leftTableAlias, string leftField, string text, LikeMode mode = LikeMode.Default)
{
query.WhereFilters.WhereColumnLike(leftTableAlias, leftField, text, mode);
return(query);
}
public LikePart(IPart left, IPart right, LikeMode mode)
{
Left = left;
Right = right;
Mode = mode;
}
private static MatchMode ConvertLikeMode2NHMatchMode(LikeMode likeMode)
{
switch (likeMode)
{
case LikeMode.Exact:
return MatchMode.Exact;
case LikeMode.Start:
return MatchMode.Start;
case LikeMode.End:
return MatchMode.End;
case LikeMode.Anywhere:
return MatchMode.Anywhere;
default:
return null;
}
}
public ExampleCondition(object entity,bool isLikeEnabled,LikeMode likeMode)
{
_entity = entity;
_isLikeEnabled = isLikeEnabled;
_likeMode = likeMode;
}
public LikeCondition(string propertyName, object value, LikeMode matchMode)
{
_propertyName = propertyName;
_value = value;
_likeMode = matchMode;
}
public LikeCondition(string propertyName, object value)
{
_propertyName = propertyName;
_value = value;
_likeMode = LikeMode.Start;
}