/// <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 }