public bool EqualCondition(DBCondition condition) { return(this._ColumnName == condition.ColumnName && this._FilterType == condition.FilterType && this._Value == condition.Value && this._Bracket == condition.Bracket && this._FollowedOperand == condition.FollowedOperand && this._FilterCatalog == condition.FilterCatalog && this._IgnoreCase == condition.IgnoreCase); }
public SectionFilter GetReportFilter(ScAFilter scFilter) { SectionFilter sectionFilter = new SectionFilter(); if (scFilter == null) { return(sectionFilter); //Modified at 2008-11-24 15:54:17@Scott } sectionFilter.FilterName = scFilter.Name; foreach (ScFilterElement element in scFilter.Elements) { Webb.Data.DBCondition condition = new Webb.Data.DBCondition(); condition.ColumnName = element.Field; condition.Value = element.Value; condition.FilterType = this.GetFilterOper(element.Oper); condition.FollowedOperand = this.GetFilterOpr(element.Opr); condition.IgnoreCase = true; sectionFilter.Filter.PlayAfter = scFilter.PlayAfter == 1; sectionFilter.Filter.Add(condition); } sectionFilter.Filter.IsCustomFilter = false; //2010-11-1 12:11:46@Simon Add this Code sectionFilter.Filter.Name = scFilter.Name; //2009-4-29 12:11:46@Simon Add this Code return(sectionFilter); }
private DBFilter ModifyFilter(DBFilter lastFilter) //2009-11-13 10:08:21@Simon Add this Code { if (lastFilter.Count <= 0) { return(lastFilter); } DBFilter newFilter = new DBFilter(); if (lastFilter[0].Bracket == Bracket.Start) { DBCondition condition = new DBCondition(); condition.ColumnName = string.Empty; condition.Bracket = Bracket.NONE; condition.FollowedOperand = FilterOperands.Or; newFilter.Add(condition); } foreach (DBCondition condition in lastFilter) { newFilter.Add(condition.Copy()); } newFilter._PlayAfter = lastFilter._PlayAfter; newFilter._Name = lastFilter._Name; if (newFilter[lastFilter.Count - 1].Bracket == Bracket.End) { newFilter[newFilter.Count - 1].FollowedOperand = FilterOperands.Or; DBCondition condition = new DBCondition(); condition.ColumnName = string.Empty; condition.Bracket = Bracket.NONE; condition.FollowedOperand = FilterOperands.And; newFilter.Add(condition); } else { newFilter[newFilter.Count - 1].FollowedOperand = FilterOperands.And; } if (newFilter.Count > 1) { newFilter[0].Bracket = Bracket.Start; newFilter[newFilter.Count - 1].Bracket = Bracket.End; } return(newFilter); }
public DBCondition Copy() { DBCondition m_Condition = new DBCondition(); m_Condition._ColumnName = this._ColumnName; m_Condition._FilterCatalog = this._FilterCatalog; m_Condition._FilterType = this._FilterType; m_Condition._Bracket = this._Bracket; m_Condition._FollowedOperand = this._FollowedOperand; m_Condition._Value = this._Value; m_Condition._IgnoreCase = this._IgnoreCase; return(m_Condition); }
public DBFilter GetPassOffenseEffFilter(ScFilterList scFilterList) { DBFilter EffFilter = new DBFilter(); foreach (ScAFilter scFilter in scFilterList.ScFilters) { if (scFilter.ReportScType != 20 || !(scFilter.Name.EndsWith("-PASSEFF-O"))) { continue; } for (int i = 0; i < scFilter.Elements.Count; i++) { ScFilterElement element = scFilter.Elements[i]; Webb.Data.DBCondition condition = new Webb.Data.DBCondition(); condition.ColumnName = element.Field; condition.Value = element.Value; condition.FilterType = GetFilterOper(element.Oper); condition.FollowedOperand = this.GetFilterOpr(element.Opr); if (i == scFilter.Elements.Count - 1) { condition.FollowedOperand = FilterOperands.Or; } condition.IgnoreCase = true; EffFilter.Add(condition); } EffFilter.PlayAfter = scFilter.PlayAfter == 1; } EffFilter.IsCustomFilter = true; //2010-11-1 12:11:46@Simon Add this Code EffFilter.Name = "PassOffenseEFF"; //2009-4-29 12:11:46@Simon Add this Code return(EffFilter); }
public void Remove(DBCondition i_Obj) { this.InnerList.Remove(i_Obj); }
//ctor //Methods #region Add/remove filter public int Add(DBCondition i_Object) { return(this.InnerList.Add(i_Object)); }