public Where Like(string property, object value, LikeMatchMode matchMode = LikeMatchMode.Like) { this.Filter.AddFilter(new CompareValueFilter() { Property = property, Value = value, CompareFilterMode = (CompareFilterMode)(int)matchMode }); return(this); }
public static void AddLikeStatement(string fieldName, object fieldValue, LikeMatchMode matchMode, string fieldAlias, ref string whereStatement, IList <object> param) { if (fieldValue == null) { return; } if (fieldValue.GetType() != typeof(string) || !string.IsNullOrWhiteSpace((string)fieldValue)) { if (!string.IsNullOrWhiteSpace(fieldAlias)) { fieldName = fieldAlias + "." + fieldName; } if (whereStatement == string.Empty) { whereStatement = " where " + fieldName + " like ?"; } else { whereStatement += " and " + fieldName + " like ?"; } if (fieldValue.GetType() == typeof(string)) { if (matchMode == LikeMatchMode.Anywhere) { param.Add("%" + fieldValue.ToString().Trim() + "%"); } else if (matchMode == LikeMatchMode.Start) { param.Add(fieldValue.ToString().Trim() + "%"); } else if (matchMode == LikeMatchMode.End) { param.Add("%" + fieldValue.ToString().Trim()); } } else { if (matchMode == LikeMatchMode.Anywhere) { param.Add("%" + fieldValue + "%"); } else if (matchMode == LikeMatchMode.Start) { param.Add(fieldValue + "%"); } else if (matchMode == LikeMatchMode.End) { param.Add("%" + fieldValue); } } } }
public static void AddLikeStatement(string fieldName, object fieldValue, LikeMatchMode matchMode, string fieldAlias, ref string whereStatement, IList<object> param) { if (fieldValue == null) { return; } if (fieldValue.GetType() != typeof(string) || !string.IsNullOrWhiteSpace((string)fieldValue)) { if (!string.IsNullOrWhiteSpace(fieldAlias)) { fieldName = fieldAlias + "." + fieldName; } if (whereStatement == string.Empty) { whereStatement = " where " + fieldName + " like ?"; } else { whereStatement += " and " + fieldName + " like ?"; } if (fieldValue.GetType() == typeof(string)) { if (matchMode == LikeMatchMode.Anywhere) { param.Add("%" + fieldValue.ToString().Trim() + "%"); } else if (matchMode == LikeMatchMode.Start) { param.Add(fieldValue.ToString().Trim() + "%"); } else if (matchMode == LikeMatchMode.End) { param.Add("%" + fieldValue.ToString().Trim()); } } else { if (matchMode == LikeMatchMode.Anywhere) { param.Add("%" + fieldValue + "%"); } else if (matchMode == LikeMatchMode.Start) { param.Add(fieldValue + "%"); } else if (matchMode == LikeMatchMode.End) { param.Add("%" + fieldValue); } } } }