/// <summary>
/// Not Like条件解析
/// </summary>
/// <param name="condition">需要解析的条件对象</param>
/// <returns>返回解析后的条件字符串</returns>
protected override string NotLikeParse(NotLikeCondition condition)
{
StringBuilder conditionStr = new StringBuilder(" ");
string queryColName = condition.SearchColumn.CurrentSearcher.TableName + "." + condition.SearchColumn.ColumnName;
if (string.IsNullOrEmpty(condition.SearchColumn.ConditionString))
{
conditionStr.Append(queryColName);
}
else
{
conditionStr.Append(condition.SearchColumn.ConditionString.Replace(SQLPlaceholder.ColName, queryColName));
}
conditionStr.Append(" NOT LIKE ");
if (condition.ParamValue is SearchColumn)
{
SearchColumn tmpColumn = (SearchColumn)condition.ParamValue;
string valueColName = tmpColumn.CurrentSearcher.TableName + "." + tmpColumn.ColumnName;
conditionStr.Append("CONCAT('%', ");
conditionStr.Append(valueColName);
conditionStr.Append(", '%')");
}
else
{
string paramName = "P" + Guid.NewGuid().ToString().ToLower().Replace("-", "");
conditionStr.Append("@" + paramName);
this.ParamCollection.Add(new MySqlParameter(paramName, "%" + condition.ParamValue.ToString() + "%"));
}
conditionStr.Append(" ");
return(conditionStr.ToString());
}
/// <summary>
/// Not Like条件解析
/// </summary>
/// <param name="condition">需要解析的条件对象</param>
/// <returns>返回解析后的条件字符串</returns>
protected override string NotLikeParse(NotLikeCondition condition)
{
StringBuilder conditionStr = new StringBuilder(" ");
string queryColName = condition.SearchColumn.CurrentSearcher.TableName + "." + condition.SearchColumn.ColumnName;
if (string.IsNullOrEmpty(condition.SearchColumn.ConditionString))
{
conditionStr.Append(queryColName);
}
else
{
conditionStr.Append(condition.SearchColumn.ConditionString.Replace(SQLPlaceholder.ColName, queryColName));
}
conditionStr.Append(" NOT LIKE ");
if (condition.ParamValue is SearchColumn)
{
SearchColumn tmpColumn = (SearchColumn)condition.ParamValue;
string valueColName = tmpColumn.CurrentSearcher.TableName + "." + tmpColumn.ColumnName;
conditionStr.Append("'%' +");
conditionStr.Append(valueColName);
conditionStr.Append("+ '%'");
}
else
{
string paramName = "P" + Guid.NewGuid().ToString().ToLower().Replace("-", "");
conditionStr.Append(":" + paramName);
this.ParamCollection.Add(new DBParam(paramName, "%" + condition.ParamValue.ToString() + "%"));
}
conditionStr.Append(" ");
return conditionStr.ToString();
}
/// <summary>
/// 非相似条件
/// </summary>
/// <param name="relation">条件关系</param>
/// <param name="column">查询字段对象</param>
/// <param name="paramVal">比较的值</param>
/// <returns>返回非相似条件对象</returns>
public static NotLikeCondition NotLike(ConditionRelation relation, SearchColumn column, object paramVal)
{
NotLikeCondition cond = new NotLikeCondition(relation, column, paramVal);
return cond;
}
/// <summary>
/// 非相似条件
/// </summary>
/// <param name="column">查询字段对象</param>
/// <param name="paramVal">比较的值</param>
/// <returns>返回非相似条件对象</returns>
public static NotLikeCondition NotLike(SearchColumn column, object paramVal)
{
NotLikeCondition cond = new NotLikeCondition(column, paramVal);
return cond;
}
/// <summary>
/// 非相似条件
/// </summary>
/// <param name="paramVal">比较的值</param>
/// <returns>返回非相似条件对象</returns>
public static NotLikeCondition NotLike(object paramVal)
{
NotLikeCondition cond = new NotLikeCondition(paramVal);
return cond;
}
/// <summary>
/// 非相似条件
/// </summary>
/// <param name="relation">条件关系</param>
/// <param name="column">查询字段对象</param>
/// <param name="paramVal">比较的值</param>
/// <returns>返回非相似条件对象</returns>
public static NotLikeCondition NotLike(ConditionRelation relation, SearchColumn column, object paramVal)
{
NotLikeCondition cond = new NotLikeCondition(relation, column, paramVal);
return(cond);
}
/// <summary>
/// 非相似条件
/// </summary>
/// <param name="paramVal">比较的值</param>
/// <returns>返回非相似条件对象</returns>
public static NotLikeCondition NotLike(object paramVal)
{
NotLikeCondition cond = new NotLikeCondition(paramVal);
return(cond);
}
