/// <summary>
///
/// </summary>
public static string ConvertCString(Cell Value)
{
if (Value.IsNull)
{
return(Cell.NULL_STRING_TEXT);
}
switch (Value.Affinity)
{
case CellAffinity.BYTE:
return(Value.BYTE.ToString());
case CellAffinity.SHORT:
return(Value.SHORT.ToString());
case CellAffinity.INT:
return(Value.INT.ToString());
case CellAffinity.LONG:
return(Value.LONG.ToString());
case CellAffinity.SINGLE:
return(Math.Round(Value.SINGLE, Cell.NUMERIC_ROUNDER).ToString());
case CellAffinity.DOUBLE:
return(Math.Round(Value.DOUBLE, Cell.NUMERIC_ROUNDER).ToString());
case CellAffinity.BOOL:
return(Value.BOOL ? Cell.TRUE_STRING : Cell.FALSE_STRING);
case CellAffinity.DATE_TIME:
return(CellFormater.ToShortDate(Value.DATE));
case CellAffinity.BSTRING:
return(Value.BSTRING.ToString());
case CellAffinity.CSTRING:
return(Value.CSTRING);
case CellAffinity.BINARY:
return(Cell.HEX_LITERARL + BitConverter.ToString(Value.BINARY).Replace("-", ""));
case CellAffinity.ARRAY:
return(ArrayStringBuilder(Value.ARRAY));
case CellAffinity.TREF:
return(Value.valueTREF);
default:
return("");
}
}
/// <summary>
///
/// </summary>
public static BString ConvertBString(Cell Value)
{
if (Value.IsNull)
{
return(new BString(Cell.NULL_STRING_TEXT));
}
switch (Value.Affinity)
{
case CellAffinity.BYTE:
return(new BString(Value.BYTE.ToString()));
case CellAffinity.SHORT:
return(new BString(Value.SHORT.ToString()));
case CellAffinity.INT:
return(new BString(Value.INT.ToString()));
case CellAffinity.LONG:
return(new BString(Value.LONG.ToString()));
case CellAffinity.SINGLE:
return(new BString(Math.Round(Value.SINGLE, Cell.NUMERIC_ROUNDER).ToString()));
case CellAffinity.DOUBLE:
return(new BString(Math.Round(Value.DOUBLE, Cell.NUMERIC_ROUNDER).ToString()));
case CellAffinity.BOOL:
return(new BString(Value.BOOL ? Cell.TRUE_STRING : Cell.FALSE_STRING));
case CellAffinity.DATE_TIME:
return(new BString(CellFormater.ToLongDate(Value.DATE)));
case CellAffinity.BSTRING:
return(Value.BSTRING);
case CellAffinity.CSTRING:
return(new BString(Value.CSTRING));
case CellAffinity.BINARY:
return(new BString(Cell.HEX_LITERARL + BitConverter.ToString(Value.BINARY).Replace("-", "")));
default:
return(BString.Empty);
}
}