// Persist library : Persistence layer
// Copyright (C) 2003 Vincent Daron
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License, or (at your option) any later version.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
using System;
using System.Data;
using System.Collections;
using Persist.Converters;
using Persist.Maps;
using Persist.Sql;
namespace Persist.Criteria{
/**
* Insert the type's description here.
* @author: Artyom Rudoy
*/
public class InCriteria : SelectionCriteria
{
internal InCriteria(ClassMap classMap, AttributeMap attributeMap):base(classMap, attributeMap)
{
}
/**
* asSqlClause method comment.
*/
public override void FillSqlStatement(SqlStatement statement, Queue parameters)
{
object parameter = parameters.Dequeue();
if(!(parameter is IEnumerable))
{
throw new Exception("Bad Parameter Type in InCriteria, must be an IEnumerable");
}
IEnumerable inParameters = (IEnumerable)parameter;
ColumnMap cm = base.AttributeMap.ColumnMap;
IConverter converter = cm.Converter;
statement.AddSqlClause(cm.FullyQualifiedName + " " + base.ClassMap.RelationalDatabase.ClauseStringIn + " (");
int i=0;
foreach(object param in inParameters)
{
// Add a comma, if this is not the first item
statement.AddSqlClause(i > 0 ? ", " : "");
statement.AddSqlParameter();
statement.AddParameter(converter.ConvertFrom(param), cm.DbType);
i++;
}
statement.AddSqlClause(")");
if(i == 0)
{
throw new Exception("Bad parameter in InCriteria, IEnumerable parameter is empty");
}
}
}
}
|