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