/// <summary>
/// 值不等于一段子查询返回的值的条件解析，子查询返回的必须是单值
/// </summary>
/// <param name="condition">需要解析的条件对象</param>
/// <returns>返回解析后的条件字符串</returns>
protected override string NotSQLEqualParse(SQLNotEqualCondition 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(" <> (");
conditionStr.Append(condition.SQL);
conditionStr.Append(") ");
return(conditionStr.ToString());
}
/// <summary>
/// 值不等于一段子查询返回的值的条件解析，子查询返回的必须是单值
/// </summary>
/// <param name="condition">需要解析的条件对象</param>
/// <returns>返回解析后的条件字符串</returns>
protected override string NotSQLEqualParse(SQLNotEqualCondition 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(" <> (");
conditionStr.Append(condition.SQL);
conditionStr.Append(") ");
return conditionStr.ToString();
}
/// <summary>
/// 子查询不等于条件
/// </summary>
/// <param name="relation">条件关系</param>
/// <param name="column">查询字段对象</param>
/// <param name="sql">子查询SQL</param>
/// <returns>返回子查询不等于条件对象</returns>
public static SQLNotEqualCondition SQLNotEqual(ConditionRelation relation, SearchColumn column, string sql)
{
SQLNotEqualCondition cond = new SQLNotEqualCondition(relation, column, sql);
return cond;
}
/// <summary>
/// 子查询不等于条件
/// </summary>
/// <param name="column">查询字段对象</param>
/// <param name="sql">子查询SQL</param>
/// <returns>返回子查询不等于条件对象</returns>
public static SQLNotEqualCondition SQLNotEqual(SearchColumn column, string sql)
{
SQLNotEqualCondition cond = new SQLNotEqualCondition(column, sql);
return cond;
}
/// <summary>
/// 子查询不等于条件
/// </summary>
/// <param name="sql">子查询SQL</param>
/// <returns>返回子查询不等于条件对象</returns>
public static SQLNotEqualCondition SQLNotEqual(string sql)
{
SQLNotEqualCondition cond = new SQLNotEqualCondition(sql);
return cond;
}
/// <summary>
/// 子查询不等于条件
/// </summary>
/// <param name="relation">条件关系</param>
/// <param name="column">查询字段对象</param>
/// <param name="sql">子查询SQL</param>
/// <returns>返回子查询不等于条件对象</returns>
public static SQLNotEqualCondition SQLNotEqual(ConditionRelation relation, SearchColumn column, string sql)
{
SQLNotEqualCondition cond = new SQLNotEqualCondition(relation, column, sql);
return(cond);
}
/// <summary>
/// 子查询不等于条件
/// </summary>
/// <param name="sql">子查询SQL</param>
/// <returns>返回子查询不等于条件对象</returns>
public static SQLNotEqualCondition SQLNotEqual(string sql)
{
SQLNotEqualCondition cond = new SQLNotEqualCondition(sql);
return(cond);
}
