public void TestGetObjectNumberValue() {
NumberValue numberValue = new NumberValue();
numberValue.value = "-1";
Assert.AreEqual("-1", PqlUtilities.GetValue(numberValue));
}
public void TestGetObjectNumberSetValue() {
NumberValue numberValue1 = new NumberValue();
NumberValue numberValue2 = new NumberValue();
numberValue1.value = "1";
numberValue2.value = "2";
SetValue setValue = new SetValue();
setValue.values = new Value[] { numberValue1, numberValue2 };
List<object> value = PqlUtilities.GetValue(setValue) as List<object>;
Assert.AreEqual(2, value.Count);
Assert.True(value.Contains("1"));
Assert.True(value.Contains("2"));
}
public void TestGetTextValueNumberSetValue() {
NumberValue numberValue1 = new NumberValue();
NumberValue numberValue2 = new NumberValue();
numberValue1.value = "1";
numberValue2.value = "2";
SetValue setValue = new SetValue();
setValue.values = new Value[] { numberValue1, numberValue2 };
Row row = new Row();
row.values = new Value[] { setValue };
string[] stringValues = PqlUtilities.GetRowStringValues(row);
Assert.AreEqual(1, stringValues.Length);
Assert.AreEqual("1,2", stringValues[0]);
}
/// <summary>
/// Adds a new decimal value to the list of query parameters.
/// </summary>
/// <param name="key">The parameter name.</param>
/// <param name="value">The parameter value.</param>
/// <returns>The statement builder, for chaining method calls.</returns>
public StatementBuilder AddValue(string key, decimal value)
{
NumberValue queryValue = new NumberValue();
queryValue.value = value.ToString();
return AddValue(key, queryValue);
}