Mathematics is not a strong point of XSLT. XSLT v1.0 has very poor mathematic support, whilst XSLT v2.0 has better support, but only by a small amount. Therefore most of the functoids in this category can only be implemented in C#.
So if you want to perform a complicated mathematical function (i.e. anything more
than addition or subtraction!) you’re better off using one of these functoids, or
an external assembly.
Once again, inline C# isn’t the fastest, but given a choice between a slow function
and no function, you might not have a choice.
For each functoid I’ve shown:
- Whether XSLT or C# is emitted
- Whether an XSLT equivalent exists
- The XSLT or C# emitted by the functoid
- Where C# is emitted, the equivalent XSLT to achieve the same functionality (in both
XSLT v1.0 and v2.0)
Functoids covered in this category:
| Absolute Value | Modulo |
| Addition | Multiplication |
| Division | Round |
| Integer | Square Root |
| Maximum Value | Subtraction |
| Minimum Value | Common Code |
Note:
This is the fourth in a series of 13 posts about the BizTalk Mapper.
The other posts in this series are (links will become active as the posts become active):
Understanding
the BizTalk Mapper: Part 1 – Introduction
Understanding
the BizTalk Mapper: Part 2 – Functoids Overview
Understanding
the BizTalk Mapper: Part 3 – String Functoids
Understanding the BizTalk Mapper: Part 4 – Mathematical Functoids
Understanding
the BizTalk Mapper: Part 5 – Logical Functoids
Understanding
the BizTalk Mapper: Part 6 – Date/Time Functoids
Understanding
the BizTalk Mapper: Part 7 – Conversion Functoids
Understanding
the BizTalk Mapper: Part 8 – Scientific Functoids
Understanding
the BizTalk Mapper: Part 9 – Cumulative Functoids
Understanding
the BizTalk Mapper: Part 10 – Database Functoids
Understanding
the BizTalk Mapper: Part 11 – Advanced Functoids
Understanding
the BizTalk Mapper: Part 12 – Performance and Maintainability
Download the complete series as a single Microsoft
Word document (1.2MB) or Adobe
PDF document (620kb).
| Mathematical Functoids | ||
| Absolute Value | ||
| Generates: C# | Has XSLT Equivalent: in 2.0 only | |
| Emitted Code:public string MathAbs(string val)
{ string retval double d if (IsNumeric(val, ref d)) { double abs
} return retval; } |
||
| XSLT 1.0 Equivalent: (none) | ||
| XSLT 2.0 Equivalent: abs(number)Note: In XSLT 1.0, you can achieve the desired result through use of an XSLT template and the xsl:when statement (i.e. check if number is < 0). |
||
| Addition | ||
| Generates: C# | Has XSLT Equivalent: in 1.0 and 2.0 | |
| Emitted Code:Note: there will be one overload per unique number of parameters.
Here we show an example with two input parameters. public string MathAdd(string param0, string param1) { System.Collections.ArrayList listValues listValues.Add(param0); listValues.Add(param1); double ret foreach (string obj in listValues) { double d if (IsNumeric(obj, ref d))
else
return “”;
} return ret.ToString(System.Globalization.CultureInfo.InvariantCulture); } |
||
| XSLT 1.0 Equivalent: Use the “+” operator e.g. ((number + number) + number) or the sum(number, number, …) function |
||
| XSLT 2.0 Equivalent: Use the “+” operator e.g. ((number + number) + number) or the sum(number, number, …) function |
||
| Division | ||
| Generates: C# | Has XSLT Equivalent: in 1.0 and 2.0 | |
| Emitted Code:Note: there will be one overload per unique number of parameters.
Here we show an example with two input parameters. public string MathDivide(string val1, string val2) { string retval double d1 double d2 if (IsNumeric(val1, ref d1) { if (d2
double ret
} return retval; } |
||
| XSLT 1.0 Equivalent: Use the div operator e.g. number div number | ||
| XSLT 2.0 Equivalent: Use the div operator e.g. number div number | ||
| Integer | ||
| Generates: C# | Has XSLT Equivalent: No | |
| Emitted Code:public string MathInt(string val)
{ string retval double d if (IsNumeric(val, ref d)) { try
int i if (i
}
catch (Exception)
} return retval; } |
||
| XSLT 1.0 Equivalent: (none) | ||
| XSLT 2.0 Equivalent: (none)Note: the floor() function will give an equivalent result e.g. floor(3.90) will give ‘3’. |
||
| Maximum Value | ||
| Generates: C# | Has XSLT Equivalent: in 2.0 only | |
| Emitted Code:public string MathMax(string param0, string param1)
{ double max System.Collections.ArrayList listValues listValues.Add(param0); listValues.Add(param1); foreach (string obj in listValues) { double d if (IsNumeric(obj, ref d)) {
} else
return “”;
} if (Double.NegativeInfinity { return “”; } else { return max.ToString(System.Globalization.CultureInfo.InvariantCulture); } } |
||
| XSLT 1.0 Equivalent: (none) | ||
| XSLT 2.0 Equivalent: Use the max(number, number, …) functionNote: in XSLT 1.0 you could write a fairly complicated XPath statement to achieve this |
||
| Minimum Value | ||
| Generates: C# | Has XSLT Equivalent: in 2.0 only | |
| Emitted Code:public string MathMin(string param0, string param1)
{ double min System.Collections.ArrayList listValues listValues.Add(param0); listValues.Add(param1); foreach (string obj in listValues) { double d if (IsNumeric(obj, ref d)) {
} else
return “”;
} if (Double.PositiveInfinity { return “”; } else { return min.ToString(System.Globalization.CultureInfo.InvariantCulture); } } |
||
| XSLT 1.0 Equivalent: (none) | ||
| XSLT 2.0 Equivalent: Use the min(number, number, …) functionNote: in XSLT 1.0 you could write a fairly complicated XPath statement to achieve this |
||
| Modulo | ||
| Generates: C# | Has XSLT Equivalent: in 1.0 and 2.0 | |
| Emitted Code:public string MathMod(string val, string denominator)
{ string retval double v double d if (IsNumeric(val, ref v) { if (d
} return retval; } |
||
| XSLT 1.0 Equivalent: Use the “mod” operator e.g. number mod number | ||
| XSLT 2.0 Equivalent: Use the “mod” operator e.g. number mod number | ||
| Multiplication | ||
| Generates: C# | Has XSLT Equivalent: in 1.0 and 2.0 | |
| Emitted Code:Note: there will be one overload per unique number of parameters.
Here we show an example with two input parameters. public string MathMultiply(string param0, string param1) { System.Collections.ArrayList listValues listValues.Add(param0); listValues.Add(param1); double ret bool first foreach (string obj in listValues) { double d if (IsNumeric(obj, ref d))
if (first)
else
else
return “”;
} return ret.ToString(System.Globalization.CultureInfo.InvariantCulture); } |
||
| XSLT 1.0 Equivalent: Use the “*” operator e.g. ((number * number) * number) |
||
| XSLT 2.0 Equivalent: Use the “*” operator e.g. ((number * number) * number) |
||
| Round | ||
| Generates: C# | Has XSLT Equivalent: in 1.0 and 2.0 | |
| Emitted Code:public string MathRound(string val)
{ return MathRound(val, “0”); }
public string MathRound(string val, string decimals) { string retval double v double db if (IsNumeric(val, ref v) { try
int d double ret
catch (Exception)
} return retval; } |
||
| XSLT 1.0 Equivalent: round(number) | ||
| XSLT 2.0 Equivalent: round(number)Note: the XSLT round() function does not take a second parameter – all number are rounded to 0 decimal places. You can achieve rounding to x dp’s through use of the format-number(number, string) function:e.g. format-number(3.55555, ‘#.00’) – but be aware that rounding in this way might not always give the result you’re looking for e.g. 9.2850 rounds to 9.28 using format-number() (although this can be coded around in XSLT). |
||
| Square Root | ||
| Generates: C# | Has XSLT Equivalent: No | |
| Emitted Code:public string MathSqrt(string val)
{ string retval double d if (IsNumeric(val, ref d)) { if (d
double ret
} return retval; } |
||
| XSLT 1.0 Equivalent: (none) | ||
| XSLT 2.0 Equivalent: (none)Note: A square-root can be calculated using an XSLT template – see here for an example. |
||
| Subtraction | ||
| Generates: C# | Has XSLT Equivalent: in 1.0 and 2.0 | |
| Emitted Code:Note: there will be one overload per unique number of parameters.
Here we show an example with two input parameters. public string MathSubtract(string param0, string param1) { System.Collections.ArrayList listValues listValues.Add(param0); listValues.Add(param1); double ret bool first foreach (string obj in listValues) { if (first)
double d if (IsNumeric(obj, ref d))
else
return “”;
else
double d if (IsNumeric(obj, ref d))
else
return “”;
} return ret.ToString(System.Globalization.CultureInfo.InvariantCulture); } |
||
| XSLT 1.0 Equivalent: Use the “-” operator e.g. ((number – number) – number) |
||
| XSLT 2.0 Equivalent: Use the “-” operator e.g. ((number – number) – number) |
||
| Common Code(this is common code used by all the mathematical functoids) | ||
| public bool IsNumeric(string val){
if (val { return false; } double d return Double.TryParse(val, }
public bool IsNumeric(string val, ref double d) { if (val { return false; } return Double.TryParse(val, } |
||