/// <summary> /// /// </summary> /// <param name="pGroupIndex"></param> /// <param name="pTableName"></param> /// <param name="pFieldName"></param> /// <param name="pType"></param> /// <param name="pOperator"></param> /// <param name="value"></param> /// <param name="pCondition"></param> /// <returns></returns> public Query AddWhere(int pGroupIndex, string pTableName, string pFieldName, FieldType pType, Operator pOperator = Operator._Equal, string value = "", Condition pCondition = Condition._And) { WhereGroup wg; if (this.WhereGroups.Count > pGroupIndex) { wg = this.WhereGroups[pGroupIndex]; wg.whereCases.Add(new WhereCase(pGroupIndex, pTableName, pFieldName, pType, pOperator, value, pCondition)); } else { wg = new WhereGroup(); wg.whereCases.Add(new WhereCase(pGroupIndex, pTableName, pFieldName, pType, pOperator, value, pCondition)); this.WhereGroups.Add(wg); } return(this); }
/// <summary> /// /// </summary> /// <param name="pGroupIndex"></param> /// <param name="pTableName"></param> /// <param name="pFieldName"></param> /// <param name="pJoinTable"></param> /// <param name="pJoinField"></param> /// <param name="pJoinType"></param> /// <param name="pCondition"></param> /// <returns></returns> public Query AddWhere(int pGroupIndex, string pTableName, string pFieldName, string pJoinTable, string pJoinField, JoinType pJoinType = JoinType._InnerJoin, Condition pCondition = Condition._And) { WhereGroup wg; if (this.WhereGroups.Count > pGroupIndex) { wg = this.WhereGroups[pGroupIndex]; wg.whereCases.Add(new WhereCase(pGroupIndex, pTableName, pFieldName, pJoinTable, pJoinField, pJoinType, pCondition)); } else { wg = new WhereGroup(); wg.whereCases.Add(new WhereCase(pGroupIndex, pTableName, pFieldName, pJoinTable, pJoinField, pJoinType, pCondition)); this.WhereGroups.Add(wg); } return(this); }