/// <summary>
///
/// </summary>
/// <param name="customer"></param>
public void Add(
DBCondition condition)
{
#region
this.init();
if (this.IsExist(condition) == null)
{
_DBConditions.Add(condition);
}
#endregion
}
/// <summary>
///
/// </summary>
/// <param name="oldCustomer"></param>
/// <returns></returns>
private bool existContent(
DBCondition oldCondition)
{
#region
return((newCondition._ParamValue == oldCondition._ParamValue) &&
(newCondition._ParamsName == oldCondition._ParamsName) &&
(newCondition._ConditionsRelation == oldCondition._ConditionsRelation) &&
(newCondition._EnumCondition == oldCondition._EnumCondition) &&
(newCondition._FieldName == oldCondition._FieldName));
#endregion
}
/// <summary>
///
/// </summary>
/// <param name="customer"></param>
/// <returns></returns>
public DBCondition IsExist(
DBCondition condition)
{
#region
lock (condition)
{
newCondition = condition;
if (_DBConditions.Count > 0)
{
return(_DBConditions.Find(existContent));
}
else
{
return(null);
}
}
#endregion
}
/// <summary>
///
/// </summary>
/// <param name="customer"></param>
public void Remove(
DBCondition customer)
{
#region
foreach (DBCondition temp in _DBConditions)
{
if ((customer._ParamValue == temp._ParamValue) &&
(customer._ParamsName == temp._ParamsName) &&
(customer._ConditionsRelation == temp._ConditionsRelation) &&
(customer._EnumCondition == temp._EnumCondition) &&
(customer._FieldName == temp._FieldName))
{
_DBConditions.Remove(temp);
break;
}
}
#endregion
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public override string ToString()
{
#region
string allconditions = "";
if (this._DBConditions != null)
{
for (int i = 0; i < this._DBConditions.Count; i++)
{
DBCondition condition = this._DBConditions[i];
EnumCondition conditiontype = condition._EnumCondition;
EnumSqlType fieldtype = condition._FieldType;
EnumConditionsRelation conditionsrelation = condition._ConditionsRelation;
allconditions += condition.ToString(conditiontype, condition._FieldName,
condition._ParamValue, fieldtype, conditionsrelation, condition._AlisaOfTable);
}
if (allconditions != string.Empty)
{
allconditions = allconditions.Remove(allconditions.Length - 4, 4);
}
}
return(allconditions);
#endregion
}
