/// <summary> /// 值包含在一段子查询中的条件解析,子查询返回的必须是单列数据 /// </summary> /// <param name="condition">需要解析的条件对象</param> /// <returns>返回解析后的条件字符串</returns> protected override string SQLInParse(SQLInCondition 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(" IN ( "); conditionStr.Append(condition.SQL); conditionStr.Append(") "); return(conditionStr.ToString()); }
/// <summary> /// 值包含在一段子查询中的条件解析,子查询返回的必须是单列数据 /// </summary> /// <param name="condition">需要解析的条件对象</param> /// <returns>返回解析后的条件字符串</returns> protected override string SQLInParse(SQLInCondition 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(" IN ( "); 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 SQLInCondition SQLIn(ConditionRelation relation, SearchColumn column, string sql) { SQLInCondition cond = new SQLInCondition(relation, column, sql); return cond; }
/// <summary> /// 子查询包含条件 /// </summary> /// <param name="column">查询字段对象</param> /// <param name="sql">子查询SQL</param> /// <returns>返回子查询包含条件对象</returns> public static SQLInCondition SQLIn(SearchColumn column, string sql) { SQLInCondition cond = new SQLInCondition(column, sql); return cond; }
/// <summary> /// 子查询包含条件 /// </summary> /// <param name="sql">子查询SQL</param> /// <returns>返回子查询包含条件对象</returns> public static SQLInCondition SQLIn(string sql) { SQLInCondition cond = new SQLInCondition(sql); return cond; }
/// <summary> /// 子查询包含条件 /// </summary> /// <param name="relation">条件关系</param> /// <param name="column">查询字段对象</param> /// <param name="sql">子查询SQL</param> /// <returns>返回子查询包含条件对象</returns> public static SQLInCondition SQLIn(ConditionRelation relation, SearchColumn column, string sql) { SQLInCondition cond = new SQLInCondition(relation, column, sql); return(cond); }
/// <summary> /// 子查询包含条件 /// </summary> /// <param name="sql">子查询SQL</param> /// <returns>返回子查询包含条件对象</returns> public static SQLInCondition SQLIn(string sql) { SQLInCondition cond = new SQLInCondition(sql); return(cond); }