void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object value, int length)
{
MySqlDateTime dtValue;
if (value is DateTime)
{
dtValue = new MySqlDateTime(type, (DateTime)value);
}
else if (value is string)
{
dtValue = new MySqlDateTime(type, DateTime.Parse((string)value,
System.Globalization.CultureInfo.CurrentCulture));
}
else if (value is MySqlDateTime)
{
dtValue = (MySqlDateTime)value;
}
else
{
throw new MySqlException("Unable to serialize date/time value.");
}
if (!binary)
{
SerializeText(stream, dtValue);
return;
}
if (type == MySqlDbType.Timestamp)
{
stream.WriteByte(11);
}
else
{
stream.WriteByte(7);
}
stream.WriteInteger(dtValue.Year, 2);
stream.WriteByte((byte)dtValue.Month);
stream.WriteByte((byte)dtValue.Day);
if (type == MySqlDbType.Date)
{
stream.WriteByte(0);
stream.WriteByte(0);
stream.WriteByte(0);
}
else
{
stream.WriteByte((byte)dtValue.Hour);
stream.WriteByte((byte)dtValue.Minute);
stream.WriteByte((byte)dtValue.Second);
}
if (type == MySqlDbType.Timestamp)
{
stream.WriteInteger(dtValue.Millisecond, 4);
}
}
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length)
{
if (!(val is TimeSpan))
{
throw new MySqlException("Only TimeSpan objects can be serialized by MySqlTimeSpan");
}
TimeSpan ts = (TimeSpan)val;
bool negative = ts.TotalMilliseconds < 0;
ts = ts.Duration();
if (binary)
{
stream.WriteByte(8);
stream.WriteByte((byte)(negative ? 1 : 0));
stream.WriteInteger(ts.Days, 4);
stream.WriteByte((byte)ts.Hours);
stream.WriteByte((byte)ts.Minutes);
stream.WriteByte((byte)ts.Seconds);
}
else
{
String s = String.Format("'{0}{1} {2:00}:{3:00}:{4:00}.{5}'",
negative ? "-" : "", ts.Days, ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds);
stream.WriteStringNoNull(s);
}
}
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length)
{
if (!(val is TimeSpan))
{
throw new MySqlException("Only TimeSpan objects can be serialized by MySqlTimeSpan");
}
TimeSpan span = (TimeSpan)val;
bool flag = span.TotalMilliseconds < 0.0;
span = span.Duration();
if (binary)
{
stream.WriteByte(8);
stream.WriteByte(flag ? ((byte)1) : ((byte)0));
stream.WriteInteger((long)span.Days, 4);
stream.WriteByte((byte)span.Hours);
stream.WriteByte((byte)span.Minutes);
stream.WriteByte((byte)span.Seconds);
}
else
{
string v = string.Format("'{0}{1} {2:00}:{3:00}:{4:00}.{5}'", new object[] { flag ? "-" : "", span.Days, span.Hours, span.Minutes, span.Seconds, span.Milliseconds });
stream.WriteStringNoNull(v);
}
}
