/// <summary>
/// Add Range Restriction (BETWEEN)
/// </summary>
/// <param name="ColumnName"></param>
/// <param name="code"></param>
/// <param name="Code_to"></param>
public void AddRangeRestriction(String ColumnName, Object code, Object Code_to)
{
QueryRestriction r = new QueryRestriction(ColumnName, code, Code_to, null, null, null);
_list.Add(r);
_dummyList.Add(r);
} // addRangeRestriction
} // getWhereClause
/// <summary>
///Create the resulting Query WHERE Clause
/// </summary>
/// <param name="fullyQualified">fullyQualified fully qualified Table.ColumnName</param>
/// <returns></returns>
public string GetWhereClause(bool fullyQualified)
{
bool qualified = fullyQualified;
if (qualified && (_tableName == null || _tableName.Length == 0))
{
qualified = false;
}
//
StringBuilder sb = new StringBuilder();
for (int i = 0; i < _list.Count; i++)
{
QueryRestriction r = _list[i];
if (i != 0)
{
sb.Append(r.AndCondition ? " AND " : " OR ");
//sb.Append("");
}
if (qualified)
{
sb.Append(r.GetSQL(_tableName));
}
else
{
sb.Append(r.GetSQL(null));
}
}
return(sb.ToString());
}
/// <summary>
///Add Restriction
/// </summary>
/// <param name="ColumnName"></param>
/// <param name="Operator"></param>
/// <param name="Code"></param>
public void AddRestriction(String columnName, String Operator, int code)
{
QueryRestriction r = new QueryRestriction(columnName, Operator,
code, null, null);
_list.Add(r);
_dummyList.Add(r);
}
/// <summary>
/// Add Range Restriction (BETWEEN)
/// </summary>
/// <param name="columnName">ColumnName</param>
/// <param name="Code">Code, e.g 0, All%</param>
/// <param name="codeTo">Code, e.g 0, All%</param>
/// <param name="infoName">Display Name</param>
/// <param name="infoDisplay">Display of Code (Lookup)</param>
/// <param name="infoDisplay_to">Display of Code (Lookup)</param>
public void AddRangeRestriction(string columnName, object code, object codeTo, string infoName,
string infoDisplay, string infoDisplay_to)
{
QueryRestriction r = new QueryRestriction(columnName, code, codeTo, infoName,
infoDisplay, infoDisplay_to);
_list.Add(r);
_dummyList.Add(r);
}
/// <summary>
/// Get Info Operator
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
public String GetInfoOperator(int index)
{
if (index < 0 || index >= _list.Count)
{
return(null);
}
QueryRestriction r = _list[index];
return(r.GetInfoOperator());
} // getInfoOperator
/// <summary>
///Get Info Name
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
public String GetInfoName(int index)
{
if (index < 0 || index >= _list.Count)
{
return(null);
}
QueryRestriction r = _list[index];
return(r.InfoName);
}
/// <summary>
/// Get Operator of index
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
public Object GetCodeTo(int index)
{
if (index < 0 || index >= _list.Count)
{
return(null);
}
QueryRestriction r = _list[index];
return(r.Code_to);
}
/// <summary>
/// Set ColumnName of index
/// </summary>
/// <param name="index">index</param>
/// <param name="ColumnName">new column name</param>
public void SetColumnName(int index, String ColumnName)
{
if (index < 0 || index >= _list.Count)
{
return;
}
QueryRestriction r = (QueryRestriction)_list[index];
r.ColumnName = ColumnName;
}
} // getWhereClause
public String GetWhereClause(int index)
{
StringBuilder sb = new StringBuilder();
if (index >= 0 && index < _list.Count)
{
QueryRestriction r = _list[index];
sb.Append(r.GetSQL(null));
}
return(sb.ToString());
} // getWhereClause
} // getInfo
/// <summary>
///Add QueryRestriction
/// </summary>
/// <param name="whereClause"></param>
public void AddRestriction(string whereClause)
{
if (whereClause == null || whereClause.Trim().Length == 0)
{
return;
}
QueryRestriction r = new QueryRestriction(whereClause);
_list.Add(r);
_dummyList.Add(r);
_newRecord = whereClause.Equals(NEWRECORD);
}
/// <summary>
///Add Query Restriction
/// </summary>
/// <param name="ColumnName"></param>
/// <param name="Operator"></param>
/// <param name="Code"></param>
/// <param name="InfoName"></param>
/// <param name="InfoDisplay"></param>
public void AddDummyRestriction(String columnName, String Operator,
Object code, String infoName, String infoDisplay)
{
QueryRestriction r = new QueryRestriction(columnName, Operator,
code, infoName, infoDisplay);
if (!(code.ToString().StartsWith("-")))
{
//_list.Add(r);
_dummyList.Add(r);
}
}
} // getInfoOperator
/// <summary>
///Get Display with optional To
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
public String GetInfoDisplayAll(int index)
{
if (index < 0 || index >= _list.Count)
{
return(null);
}
QueryRestriction r = _list[index];
try
{
if (r.Code.GetType().FullName == "System.DateTime")
{
if (r.InfoDisplay.IndexOf("T") > 0)
{
r.InfoDisplay = r.InfoDisplay.Substring(0, r.InfoDisplay.IndexOf("T"));
r.InfoDisplay_to = r.InfoDisplay_to.Substring(0, r.InfoDisplay_to.IndexOf("T"));
}
}
}
catch { }
return(r.GetInfoDisplayAll());
}
} // getCode
/// <summary>
/// Get printable Query Info
/// </summary>
/// <returns></returns>
public String GetInfo()
{
StringBuilder sb = new StringBuilder();
if (_tableName != null)
{
sb.Append(_tableName).Append(": ");
}
//
for (int i = 0; i < _list.Count; i++)
{
QueryRestriction r = _list[i];
if (i != 0)
{
sb.Append(r.AndCondition ? " AND " : " OR ");
}
//
sb.Append(r.GetInfoName())
.Append(r.GetInfoOperator())
.Append(r.GetInfoDisplayAll());
}
return(sb.ToString());
} // getInfo
/// <summary>
///Add Query Restriction
/// </summary>
/// <param name="r"></param>
public void AddRestriction(QueryRestriction r)
{
_list.Add(r);
_dummyList.Add(r);
}
