protected virtual string GetSqlExpression(PropertyElement p) { return(p.GetSqlExpression()); }
protected override string GetSqlExpression(PropertyElement p) { return(p.GetSqlExpression(true)); }
/* * /// <summary> * /// Replaces embedded property references in the string with sql cocde. * /// </summary> * /// <param name="withEmbedded">Expression to be replaced.</param> * /// <param name="idString">Id to use when reporting errors.</param> * /// <param name="vd">Validation delegate for error reporting.</param> * /// <returns>String with embedded references replaced.</returns> * private string PrepareExpression(string withEmbedded, string idString, ParserValidationDelegate vd) * { * string checkExpression = withEmbedded; * string retVal = String.Empty; * int leftBrace = 0; * int startPos = 0; * for(leftBrace=checkExpression.IndexOf("{", startPos); startPos >=0; leftBrace=checkExpression.IndexOf("{", startPos)) * { * if (leftBrace == -1) * { * // No more strings to replace. * retVal += checkExpression.Substring(startPos, checkExpression.Length - startPos); * break; * } * else * { * // Concatenate portion of string without embedded references. * retVal += checkExpression.Substring(startPos, leftBrace - startPos); * } * int rightBrace = checkExpression.IndexOf("}", leftBrace); * if (rightBrace == -1) * { * if (vd != null) * { * vd(ParserValidationArgs.NewError("The " + idString + " has a left brace({} with no corresonding right brace(}}")); * } * return ""; * } * * // Isolate the property reference. * string expression = checkExpression.Substring(leftBrace+1, rightBrace - leftBrace - 1); * * // Create list of property references seen to check for circular references. * ArrayList repeList = new ArrayList(); * * string[] parts = expression.Split('.'); * string leftPart = ""; * string rightPart = ""; * if (parts.Length == 1) * { * // Default the left part to this report extraction if not specified. * leftPart = this.Name; * rightPart = parts[0]; * } * else if (parts.Length == 2) * { * leftPart = parts[0]; * rightPart = parts[1]; * } * else * { * if (vd != null) * { * vd(ParserValidationArgs.NewError("The expression " + expression + " in the " + idString + " does not contain exactly one dot(.).")); * } * return ""; * } * * * if (leftPart.ToLower() == this.Name.ToLower()) * { * // Refers to a property in this report extraction. * ReportExtractionPropertyElement repe = this.FindComputedFieldByName(rightPart); * if (repe != null) * { * // Refers to a computed property. Check for circular references. * foreach(ReportExtractionPropertyElement repel in repeList) * { * if(repel.Name == repe.Name) * { * if (vd != null) * { * vd(ParserValidationArgs.NewError("The expression " + expression + " in the " + idString + " has a circular reference.")); * } * return ""; * } * } * * // Add in the expansion of this property.e * retVal += "(" + repe.GetSqlExpression() + ")"; * } * else * { * EntityReferencePropertyElement pre = this.FindReferenceFieldByName(rightPart); * if (pre != null) * { * // Refers to a property reference. Get the expression. * retVal += pre.GetSqlExpression(); * } * else * { * if (vd != null) * { * vd(ParserValidationArgs.NewError("The expression " + expression + " in the " + idString + " refers to a property in the report extraction that does not exist.")); * } * return ""; * } * } * } * else * { * EntityReferenceElement er = FindEntityReferenceByName(leftPart); * if (er == null) * { * if (vd != null) * { * vd(ParserValidationArgs.NewError("The expression " + expression + " in the " + idString + " refers to an entity that is not an entity reference in the extraction nor the extraction itself.")); * } * return ""; * } * else * { * // Refers to an entity reference. * EntityReferencePropertyElement pre = er.FindFieldBySqlAlias(rightPart); * if (pre != null) * { * // Refers to a property reference in the entity. * retVal += pre.GetSqlExpression(); * } * else * { * PropertyElement p = er.Entity.FindFieldByName(rightPart); * if (p != null) * { * // Refers to a property in the entity referenced that is not in the property referenced. * retVal += "[" + er.Name + "].[" + p.Column.Name + "]"; * } * else * { * if (vd != null) * { * vd(ParserValidationArgs.NewError("The expression " + expression + " in the " + idString + " refers to a property that is not in the referenced entity reference nor it's associated entity.")); * } * else * { * return ""; * } * } * } * } * } * * startPos = rightBrace + 1; * } * * return retVal; * }*/ public string GetExpressionSubstitution(string substitutionExpression, string idString, ParserValidationDelegate vd) { // Create list of property references seen to check for circular references. ArrayList repeList = new ArrayList(); string[] parts = substitutionExpression.Split('.'); string leftPart = ""; string rightPart = ""; if (parts.Length == 1) { // Default the left part to this report extraction if not specified. leftPart = this.Name; rightPart = parts[0]; } else if (parts.Length == 2) { leftPart = parts[0]; rightPart = parts[1]; } else { if (vd != null) { vd(ParserValidationArgs.NewError("The expression " + substitutionExpression + " in the " + idString + " does not contain exactly one dot(.).")); } return(""); } if (leftPart.ToLower() == this.Name.ToLower()) { // Refers to a property in this report extraction. PropertyElement repe = this.FindComputedFieldByName(rightPart); if (repe != null) { // Refers to a computed property. Check for circular references. foreach (PropertyElement repel in repeList) { if (repel.Name == repe.Name) { if (vd != null) { vd(ParserValidationArgs.NewError("The expression " + substitutionExpression + " in the " + idString + " has a circular reference.")); } return(""); } } // Add in the expansion of this property.e return("(" + repe.GetSqlExpression() + ")"); } else { PropertyElement pre = this.FindReferenceFieldByName(rightPart); if (pre != null) { // Refers to a property reference. Get the expression. return(pre.GetSqlExpression()); } else { if (vd != null) { vd(ParserValidationArgs.NewError("The expression " + substitutionExpression + " in the " + idString + " refers to a property in the report extraction that does not exist.")); } return(""); } } } else { EntityReferenceElement er = FindEntityReferenceByName(leftPart); if (er == null) { if (vd != null) { vd(ParserValidationArgs.NewError("The expression " + substitutionExpression + " in the " + idString + " refers to an entity that is not an entity reference in the extraction nor the extraction itself.")); } return(""); } else { // Refers to an entity reference. PropertyElement pre = er.FindFieldBySqlAlias(rightPart); if (pre != null) { // Refers to a property reference in the entity. return(pre.GetSqlExpression()); } else { PropertyElement p = er.Entity.FindFieldByName(rightPart); if (p != null) { // Refers to a property in the entity referenced that is not in the property referenced. return("[" + er.Name + "].[" + p.Column.Name + "]"); } else { if (vd != null) { vd(ParserValidationArgs.NewError("The expression " + substitutionExpression + " in the " + idString + " refers to a property that is not in the referenced entity reference nor it's associated entity.")); } return(""); } } } } }