public WriteValue ( DateTimeOffset value ) : void | ||
value | DateTimeOffset | The |
return | void |
public override void WriteValue(DateTimeOffset value)
{
InternalWriteValue(JsonToken.Date);
if (string.IsNullOrEmpty(DateFormatString))
{
EnsureWriteBuffer();
int pos = 0;
_writeBuffer[pos++] = _quoteChar;
pos = DateTimeUtils.WriteDateTimeString(_writeBuffer, pos, (DateFormatHandling == DateFormatHandling.IsoDateFormat) ? value.DateTime : value.UtcDateTime, value.Offset, DateTimeKind.Local, DateFormatHandling);
_writeBuffer[pos++] = _quoteChar;
_writer.Write(_writeBuffer, 0, pos);
}
else
{
_writer.Write(_quoteChar);
_writer.Write(value.ToString(DateFormatString, Culture));
_writer.Write(_quoteChar);
}
}
#endif
JsonTextWriter::WriteValue ( System.DateTime value ) : void | |
JsonTextWriter::WriteValue ( System.Guid value ) : void | |
JsonTextWriter::WriteValue ( System.TimeSpan value ) : void | |
JsonTextWriter::WriteValue ( |
|
JsonTextWriter::WriteValue ( bool value ) : void | |
JsonTextWriter::WriteValue ( byte value ) : void | |
JsonTextWriter::WriteValue ( char value ) : void | |
JsonTextWriter::WriteValue ( decimal value ) : void | |
JsonTextWriter::WriteValue ( double value ) : void | |
JsonTextWriter::WriteValue ( float value ) : void | |
JsonTextWriter::WriteValue ( int value ) : void | |
JsonTextWriter::WriteValue ( long value ) : void | |
JsonTextWriter::WriteValue ( object value ) : void | |
JsonTextWriter::WriteValue ( sbyte value ) : void | |
JsonTextWriter::WriteValue ( short value ) : void | |
JsonTextWriter::WriteValue ( string value ) : void | |
JsonTextWriter::WriteValue ( uint value ) : void | |
JsonTextWriter::WriteValue ( ulong value ) : void | |
JsonTextWriter::WriteValue ( ushort value ) : void |
private static string toJSON(SqlDataReader rdr) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); JsonWriter jsonWriter = new JsonTextWriter(sw); jsonWriter.WriteStartArray(); while (rdr.Read()) { int fieldcount = rdr.FieldCount; // count how many columns are in the row object[] values = new object[fieldcount]; // storage for column values rdr.GetValues(values); // extract the values in each column jsonWriter.WriteStartObject(); for (int index = 0; index < fieldcount; index++) { string colName = rdr.GetName(index); object value = values[index]; jsonWriter.WritePropertyName(colName); if (value == DBNull.Value) value = ""; else if (colName.Contains("date") && !colName.Contains("by")) value = String.Format("{0:MM/dd/yyyy HH:mm tt}", value); jsonWriter.WriteValue(value); } jsonWriter.WriteEndObject(); } jsonWriter.WriteEndArray(); return sb.ToString(); }