private string getWhere()
{
System.Text.StringBuilder sbWhereGroup = new System.Text.StringBuilder();
// System.Text.StringBuilder sbWherecase = new System.Text.StringBuilder();
for (int iwhereg = 0; iwhereg < this.WhereGroups.Count; iwhereg++)
{
if (iwhereg == 0)
{
sbWhereGroup.Append(" Where (");
}
else
{
if (this.WhereGroups[iwhereg].condition == Condition._And)
{
sbWhereGroup.Append(" AND (");
}
else if (this.WhereGroups[iwhereg].condition == Condition._Or)
{
sbWhereGroup.Append(" OR (");
}
else
{
sbWhereGroup.Append(" ");
}
}
System.Text.StringBuilder sbWherecase = new System.Text.StringBuilder();
for (int iwhere = 0; iwhere < this.WhereGroups[iwhereg].whereCases.Count; iwhere++)
{
WhereCase ws = this.WhereGroups[iwhereg].whereCases[iwhere];
WhereCase psws = null;
if (iwhere != 0)
{
psws = this.WhereGroups[iwhereg].whereCases[iwhere - 1];
}
if (iwhere != 0)
{
if (psws.condition == Condition._And)
{
sbWherecase.Append(" AND ");
}
else if (psws.condition == Condition._Or)
{
sbWherecase.Append(" OR ");
}
else
{
sbWherecase.Append(" ");
}
}
sbWherecase.Append(FieldSelector + getTableAlias(ws.TableName) + FieldSelector + "." + FieldSelector + ws.FieldName + FieldSelector + getOperator(ws.Operation,
MakeValidateData(ws.Type, ws.ConditionValue, ws.FieldName)));
}
sbWhereGroup.Append(sbWherecase + " ) ");
}
return(sbWhereGroup.ToString());
}
/// <summary>
///
/// </summary>
/// <returns></returns>
internal string toString()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
if (this.Type == QueryType._Select)
{
System.Text.StringBuilder sbField = new System.Text.StringBuilder();
System.Text.StringBuilder sbJoin = new System.Text.StringBuilder();
System.Text.StringBuilder sbWhereGroup = new System.Text.StringBuilder();
for (int ifld = 0; ifld < this.QueryFields.Count; ifld++)
{
Field fld = this.QueryFields[ifld];
sbField.Append("," + FieldSelector + fld.TableName + FieldSelector + "." + fld.Name);
}
string fd = "";
fd = sbField.ToString();
if (fd.StartsWith(","))
{
fd = fd.Substring(1);
}
for (int ijoin = 0; ijoin < this.Joins.Count; ijoin++)
{
Join jn = this.Joins[ijoin];
string joinType = "";
if (jn.Type == JoinType._InnerJoin)
{
joinType = " Inner Join ";
}
else if (jn.Type == JoinType._LeftJoin)
{
joinType = " Left Join ";
}
else if (jn.Type == JoinType._RightJoin)
{
joinType = " Right Join ";
}
if (ijoin == 0)
{
sbJoin.Append(FieldSelector + jn.TableName + FieldSelector + " " + getTableAlias(jn.TableName) + joinType
+ FieldSelector + getTableAlias(jn.JoinTable) + FieldSelector + " on " + getTableAlias(jn.TableName) + "." + jn.FieldName + " = "
+ FieldSelector + getTableAlias(jn.JoinTable) + FieldSelector + "." + jn.JoinField);
}
else
{
sbJoin.Append(joinType
+ FieldSelector + getTableAlias(jn.JoinTable) + FieldSelector + " on " + getTableAlias(jn.TableName) + "." + jn.FieldName + " = "
+ FieldSelector + getTableAlias(jn.JoinTable) + FieldSelector + "." + jn.JoinField);
}
}
if (this.Joins.Count == 0)
{
if (this.Tables.Count > 1)
{
throw new Exception("More than one table to select");
}
else
{
sbJoin.Append(" " + this.Tables[0].TableName + " ");
}
}
for (int iwhereg = 0; iwhereg < this.WhereGroups.Count; iwhereg++)
{
if (iwhereg == 0)
{
sbWhereGroup.Append(" Where (");
}
else
{
if (this.WhereGroups[iwhereg].condition == Condition._And)
{
sbWhereGroup.Append(" AND (");
}
else if (this.WhereGroups[iwhereg].condition == Condition._Or)
{
sbWhereGroup.Append(" OR (");
}
else
{
sbWhereGroup.Append(" ");
}
}
System.Text.StringBuilder sbWherecase = new System.Text.StringBuilder();
for (int iwhere = 0; iwhere < this.WhereGroups[iwhereg].whereCases.Count; iwhere++)
{
WhereCase ws = this.WhereGroups[iwhereg].whereCases[iwhere];
if (iwhere != 0)
{
if (ws.condition == Condition._And)
{
sbWherecase.Append(" AND ");
}
else if (ws.condition == Condition._Or)
{
sbWherecase.Append(" OR ");
}
else
{
sbWherecase.Append(" ");
}
}
sbWherecase.Append(FieldSelector + getTableAlias(ws.TableName) + FieldSelector + "." + FieldSelector + ws.FieldName + FieldSelector + getOperator(ws.Operation,
MakeValidateData(ws.Type, ws.ConditionValue, ws.FieldName)));
}
sbWhereGroup.Append(sbWherecase + " ) ");
}
sb.AppendFormat(Select, fd, sbJoin, sbWhereGroup);
}
else if (this.Type == QueryType._Insert)
{
System.Text.StringBuilder sbField = new System.Text.StringBuilder();
System.Text.StringBuilder sbFieldvalue = new System.Text.StringBuilder();
for (int ifld = 0; ifld < this.QueryFields.Count; ifld++)
{
Field fld = this.QueryFields[ifld];
sbField.Append("," + FieldSelector + fld.TableName + FieldSelector + "." + fld.Name);
sbFieldvalue.Append("," + MakeValidateData(fld.Type, fld.Value, fld.Name));
}
sb.AppendFormat(Insert, FieldSelector + this.Tables[0].TableName + FieldSelector, sbField.ToString().Substring(1), sbFieldvalue.ToString().Substring(1));
}
else if (this.Type == QueryType._Delete)
{
if (this.Tables.Count > 1)
{
throw new Exception(QueryResource._delete_table_more_exist);
}
sb.AppendFormat(Delete, this.Tables[0].TableName);
}
else if (this.Type == QueryType._Update)
{
System.Text.StringBuilder sbField = new System.Text.StringBuilder();
System.Text.StringBuilder sbWhereGroup = new System.Text.StringBuilder();
for (int ifld = 0; ifld < this.QueryFields.Count; ifld++)
{
if (ifld != 0)
{
sbField.Append(",");
}
Field fd;
fd = this.QueryFields[ifld];
sbField.Append(FieldSelector + getTableAlias(fd.TableName) + FieldSelector + "." + FieldSelector + fd.Name + FieldSelector + " = ");
sbField.Append(MakeValidateData(fd.Type, fd.Value, fd.Name));
}
for (int iwhereg = 0; iwhereg < this.WhereGroups.Count; iwhereg++)
{
if (iwhereg == 0)
{
sbWhereGroup.Append(" Where (");
}
else
{
if (this.WhereGroups[iwhereg].condition == Condition._And)
{
sbWhereGroup.Append(" AND (");
}
else if (this.WhereGroups[iwhereg].condition == Condition._Or)
{
sbWhereGroup.Append(" OR (");
}
else
{
sbWhereGroup.Append(" ");
}
}
System.Text.StringBuilder sbWherecase = new System.Text.StringBuilder();
for (int iwhere = 0; iwhere < this.WhereGroups[iwhereg].whereCases.Count; iwhere++)
{
WhereCase ws = this.WhereGroups[iwhereg].whereCases[iwhere];
if (iwhere != 0)
{
if (ws.condition == Condition._And)
{
sbWherecase.Append(" AND ");
}
else if (ws.condition == Condition._Or)
{
sbWherecase.Append(" OR ");
}
else
{
sbWherecase.Append(" ");
}
}
sbWherecase.Append(FieldSelector + getTableAlias(ws.TableName) + FieldSelector + "." + FieldSelector + ws.FieldName + FieldSelector + getOperator(ws.Operation,
MakeValidateData(ws.Type, ws.ConditionValue, ws.FieldName)));
}
sbWhereGroup.Append(sbWherecase + " ) ");
// sbWhereGroup.Append(")");
}
sb.AppendFormat(Update, this.Tables[0].TableName + " as " + getTableAlias(this.Tables[0].TableName), sbField.ToString(), sbWhereGroup.ToString());
}
return(sb.ToString());
}