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); } }
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) { byte[] buffToWrite = null; if (val is System.Byte[]) { buffToWrite = (byte[])val; } else if (val is Char[]) { buffToWrite = stream.Encoding.GetBytes(val as char[]); } else { string s = val.ToString(); if (length == 0) { length = s.Length; } else { s = s.Substring(0, length); } buffToWrite = stream.Encoding.GetBytes(s); } // we assume zero length means write all of the value if (length == 0) { length = buffToWrite.Length; } if (buffToWrite == null) { throw new MySqlException("Only byte arrays and strings can be serialized by MySqlBinary"); } if (binary) { stream.WriteLength(length); stream.Write(buffToWrite, 0, length); } else { if (stream.Version.isAtLeast(4, 1, 0)) { stream.WriteStringNoNull("_binary "); } stream.WriteByte((byte)'\''); EscapeByteArray(buffToWrite, length, stream); stream.WriteByte((byte)'\''); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { long num = Convert.ToInt64(val); if (binary) { stream.Write(BitConverter.GetBytes(num)); } else { stream.WriteStringNoNull(num.ToString()); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { sbyte num = ((IConvertible)val).ToSByte(null); if (binary) { stream.WriteByte((byte)num); } else { stream.WriteStringNoNull(num.ToString()); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object v, int length) { uint num = Convert.ToUInt32(v); if (binary) { stream.Write(BitConverter.GetBytes(num)); } else { stream.WriteStringNoNull(num.ToString()); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { string s = Convert.ToDecimal(val).ToString(CultureInfo.InvariantCulture); if (binary) { stream.WriteLenString(s); } else { stream.WriteStringNoNull(s); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { int v = Convert.ToUInt16(val); if (binary) { stream.Write(BitConverter.GetBytes(v)); } else { stream.WriteStringNoNull(v.ToString()); } }
public void WriteValue(MySqlStream stream, bool binary, object value, int length) { ulong v = Convert.ToUInt64(value); if (binary) { stream.Write(BitConverter.GetBytes(v)); } else { stream.WriteStringNoNull(v.ToString()); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { double num = Convert.ToDouble(val); if (binary) { stream.Write(BitConverter.GetBytes(num)); } else { stream.WriteStringNoNull(num.ToString("R", CultureInfo.InvariantCulture)); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { sbyte v = ((IConvertible)val).ToSByte(null); if (binary) { stream.Write(BitConverter.GetBytes(v)); } else { stream.WriteStringNoNull(v.ToString()); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { Single v = Convert.ToSingle(val); if (binary) { stream.Write(BitConverter.GetBytes(v)); } else { stream.WriteStringNoNull(v.ToString( CultureInfo.InvariantCulture)); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { byte[] bytes = null; if (val is byte[]) { bytes = (byte[])val; } else if (val is char[]) { bytes = stream.Encoding.GetBytes(val as char[]); } else { string s = val.ToString(); if (length == 0) { length = s.Length; } else { s = s.Substring(0, length); } bytes = stream.Encoding.GetBytes(s); } if (length == 0) { length = bytes.Length; } if (bytes == null) { throw new MySqlException("Only byte arrays and strings can be serialized by MySqlBinary"); } if (binary) { stream.WriteLength((long)length); stream.Write(bytes, 0, length); } else { if (stream.Version.isAtLeast(4, 1, 0)) { stream.WriteStringNoNull("_binary "); } stream.WriteByte(0x27); this.EscapeByteArray(bytes, length, stream); stream.WriteByte(0x27); } }
private void SerializeText(MySqlStream stream, MySqlDateTime value) { string val = String.Empty; if (type == MySqlDbType.Timestamp && !stream.Version.isAtLeast(4, 1, 0)) { val = String.Format("{0:0000}{1:00}{2:00}{3:00}{4:00}{5:00}", value.Year, value.Month, value.Day, value.Hour, value.Minute, value.Second); } else { val = String.Format("{0:0000}-{1:00}-{2:00} {3:00}:{4:00}:{5:00}", value.Year, value.Month, value.Day, value.Hour, value.Minute, value.Second); } stream.WriteStringNoNull("'" + val + "'"); }
private void SerializeText(MySqlStream stream, MySqlDateTime value) { string str = string.Empty; if ((this.type == MySqlDbType.Timestamp) && !stream.Version.isAtLeast(4, 1, 0)) { str = string.Format("{0:0000}{1:00}{2:00}{3:00}{4:00}{5:00}", new object[] { value.Year, value.Month, value.Day, value.Hour, value.Minute, value.Second }); } else { str = string.Format("{0:0000}-{1:00}-{2:00}", value.Year, value.Month, value.Day); if (this.type != MySqlDbType.Date) { str = string.Format("{0} {1:00}:{2:00}:{3:00}", new object[] { str, value.Hour, value.Minute, value.Second }); } } stream.WriteStringNoNull("'" + str + "'"); }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { string v = val.ToString(); if (length > 0) { v = v.Substring(0, length); } if (binary) { stream.WriteLenString(v); } else { stream.WriteStringNoNull("'" + EscapeString(v) + "'"); } }
void IMySqlValue.WriteValue(MySqlStream stream, bool binary, object val, int length) { string s = val.ToString(); if (length > 0) { length = Math.Min(length, s.Length); s = s.Substring(0, length); } if (binary) { stream.WriteLenString(s); } else { stream.WriteStringNoNull("'" + MySqlHelper.EscapeString(s) + "'"); } }