public static string EncodeValue(object value, SharpValueType valueType, char delimiter = '\0', bool quoteQuotes = false)
{
if (value == null)
{
return("");
}
if (value is DateTime)
{
return(EncodedString.TrimStandardDate((DateTime)value));
}
if (!(value is string))
{
return(value.ToString());
}
var result = value.ToString();
if (EncodedString.IsQuotedStringEncodingRequired(result, delimiter: delimiter, quoteQuotes: quoteQuotes))
{
return(EncodedString.EncodeQuotedString(result));
}
return(result);
}
public void WriteDelimited(IEnumerable <SharpRow> rows, SharpMapType mapType = SharpMapType.None, char delimiter = ',', List <string> columns = null, Dictionary <string, string> aliases = null)
{
columns = columns ?? new List <string>();
if (mapType == SharpMapType.Variable && IncludeHeader)
{
var columnNames =
columns.Select(x => aliases != null && aliases.ContainsKey(x) ? aliases[x] : x);
var header = string.Join(delimiter.ToString(), AlwaysQuote ? columns.Select(x => EncodedString.EncodeQuotedString(x)) : columns);
_writer.WriteLine(header);
}
var includeNodes = new HashSet <string>(columns);
foreach (var row in rows)
{
var nodeRow = row as SharpNodeRow;
if (nodeRow != null)
{
var next = nodeRow.First;
var valRow = next as SharpValueRow;
var rowValues = new Dictionary <string, string>();
if (valRow != null && valRow.Node is SharpNodeMap)
{
var nodeMap = valRow.Node as SharpNodeMap;
var columnValues = valRow.Values;
if (nodeMap.MapType == SharpMapType.Fixed || nodeMap.MapType == SharpMapType.Variable)
{
if (valRow.Values.Count == 1)
{
columnValues = nodeMap.ExpandRow((string)valRow.Values[0]).Select(x => x.Value).ToList();
}
}
for (int i = 0; i < nodeMap.Columns.Count && i < columnValues.Count; i++)
{
var col = nodeMap.Columns[i];
if (includeNodes.Contains(col.Node.Name))
{
rowValues[col.Node.Name] = SharpValue.ToString(columnValues[i], col.ValueType);
}
}
}
else
{
while (next != null)
{
if (!includeNodes.Contains(next.Node.Name))
{
next = next.Next;
continue;
}
valRow = next as SharpValueRow;
var val = "";
if (valRow != null && valRow.Node.IsSingleValueNode)
{
val = SharpValue.ToString(valRow.Values[0], valRow.Node.ValueType);
}
rowValues[next.Node.Name] = val;
next = next.Next;
}
}
StringBuilder line = new StringBuilder();
bool first = true;
foreach (var col in columns)
{
if (!first)
{
line.Append(delimiter);
}
first = false;
if (rowValues.ContainsKey(col))
{
var val = rowValues[col];
if (AlwaysQuote || (AllowQuotes && EncodedString.IsQuotedStringEncodingRequired(val, delimiter : delimiter, allowOnlyWhitespace : true)))
{
val = EncodedString.EncodeQuotedString(val);
}
line.Append(val);
}
}
_writer.WriteLine(line);
}
}
}
