/// <summary>
/// Returns a SQL-friendly string representation of Sort criteria.
/// </summary>
/// <returns></returns>
public override string ToString()
{
WordBuilder builder = new WordBuilder(", ");
for (int index = 0; index < this.Count; index++)
{
string var = string.Empty;
if (this[index].IsVarType(VariableType.DataSourceRedefined))
{
string s = string.Empty;
var = ((DataSourceVariableRedefined)this[index]).Expression;
}
else if (this[index].IsVarType(VariableType.Standard))
{
var = ((StandardVariable)this[index]).Expression;
}
else
{
//defect 267
// var = this[index].Expression;
var = this[index].Name;
}
if (tags[index] == SortOrder.Descending)
{
var += CharLiterals.SPACE + "desc";
}
builder.Add(var);
}
return(builder.ToString());
}
public static string ContactTypeConverter(int input)
{
Epi.WordBuilder wb = new Epi.WordBuilder(",");
string bits = Convert.ToString(input, 2);
switch (bits.Length)
{
case 1:
bits = "000" + bits;
break;
case 2:
bits = "00" + bits;
break;
case 3:
bits = "0" + bits;
break;
}
if (bits[0].Equals('1'))
{
wb.Add("1");
}
if (bits[1].Equals('1'))
{
wb.Add("2");
}
if (bits[2].Equals('1'))
{
wb.Add("3");
}
if (bits[3].Equals('1'))
{
wb.Add("4");
}
return(wb.ToString());
}
