Beispiel #1
0
        /// <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());
        }
Beispiel #2
0
        /// <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();
        }
Beispiel #3
0
 /// <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;
 }
Beispiel #4
0
 /// <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;
 }
Beispiel #5
0
 /// <summary>
 /// 子查询包含条件
 /// </summary>
 /// <param name="sql">子查询SQL</param>
 /// <returns>返回子查询包含条件对象</returns>
 public static SQLInCondition SQLIn(string sql)
 {
     SQLInCondition cond = new SQLInCondition(sql);
     return cond;
 }
Beispiel #6
0
        /// <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);
        }
Beispiel #7
0
        /// <summary>
        /// 子查询包含条件
        /// </summary>
        /// <param name="sql">子查询SQL</param>
        /// <returns>返回子查询包含条件对象</returns>
        public static SQLInCondition SQLIn(string sql)
        {
            SQLInCondition cond = new SQLInCondition(sql);

            return(cond);
        }