public String getQueryCondition(Boolean saveIt, HandlingTypeForFilter type, String fieldName, params Object[] values)
{
String queryCondition = "";
int added = 0;
foreach (Object value in values)
{
if (type == HandlingTypeForFilter.Number)
{
if (added != 0)
{
queryCondition += " " + _conditionAdder.ToString() + " ";
}
queryCondition += fieldName + "=" + value.ToString();
added++;
}
else //string
{
if (added != 0)
{
queryCondition += " " + _conditionAdder.ToString() + " ";
}
queryCondition += fieldName + " LIKE '%%" + value.ToString() + "%%'";
added++;
}
/*
* if (_fieldType.Values.ElementAt(0) == HandlingTypeForFilter.Number)
* {
* if (added != 0) queryCondition += " " + _conditionAdder.ToString() + " ";
* queryCondition += _fieldType.Keys.ElementAt(0) + "=" + value.ToString();
* added++;
* }
* else //string
* {
* if (added != 0) queryCondition += " " + _conditionAdder.ToString() + " ";
* queryCondition += _fieldType.Keys.ElementAt(0) + " LIKE '%%" + value.ToString() + "%%'";
* added++;
* }
*/
}
queryCondition = (queryCondition.Length > 0) ? " (" + queryCondition + ") ": "";
if (saveIt)
{
_queryCondition = queryCondition;
}
return(queryCondition);
}
/// <summary>
///
/// </summary>
/// <param name="fieldName"></param>
/// <param name="handlingTypeForFilter"></param>
public RtwFilter(String fieldName, HandlingTypeForFilter handlingTypeForFilter = HandlingTypeForFilter.String, ConditionAdder condAdd = ConditionAdder.OR)
{
if (fieldName.Length > 0)
{
if (handlingTypeForFilter == HandlingTypeForFilter.String)
{
_fieldType[fieldName] = HandlingTypeForFilter.String;
}
else if (handlingTypeForFilter == HandlingTypeForFilter.Number)
{
_fieldType[fieldName] = HandlingTypeForFilter.Number;
}
}
else
{
throw new Exception("fieldName은 비어있을 수 없습니다. DB의 Field를 적으세요");
}
_conditionAdder = condAdd;
}
