public int buildSQL(DatabaseConnection dbConn, int index, StringBuilder b) { if (notExist) { b.Append(" NOT"); } b.Append(" EXISTS (SELECT ").Append(selectFieldList).Append(" FROM ").Append(tableName); int out_index = 0; if (filter != null) { b.Append(filter.getWhereClause(dbConn, true, index, out out_index)); b.Append(filter.getGroupCluase()); } b.Append(")"); return(out_index); }
public DbCommand CreateSelectCommand(string SelectQueryWithoutConstraint, DBFilter dbFilter, ListInfo info) { int commandIndex = 1; int buildSQLIndex = 1; string query = SelectQueryWithoutConstraint; DbCommand command = CreateCommand(); command.CommandType = CommandType.Text; if (dbFilter != null) { query += dbFilter.getWhereClause(this, false, buildSQLIndex, out buildSQLIndex); query += dbFilter.getGroupCluase(); query += dbFilter.getOrderClause(info); dbFilter.setParams(commandIndex, command); } command.CommandText = query; return(command); }