Update of /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source
In directory sc8-pr-cvs1:/tmp/cvs-serv25914
Modified Files:
PgParameter.cs
Log Message:
Updated file
Index: PgParameter.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient_10/PostgreSql.Data.PgSqlClient/source/PgParameter.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** PgParameter.cs 14 Dec 2003 15:06:50 -0000 1.9
--- PgParameter.cs 3 Jan 2004 15:42:16 -0000 1.10
***************
*** 21,24 ****
--- 21,26 ----
using System.ComponentModel;
+ using PostgreSql.Data.PgTypes;
+
namespace PostgreSql.Data.PgSqlClient
{
***************
*** 220,224 ****
#endregion
! #region ICLONEABLE_METHOD
object ICloneable.Clone()
--- 222,226 ----
#endregion
! #region ICloneable Method
object ICloneable.Clone()
***************
*** 238,241 ****
--- 240,379 ----
#endregion
+ #region Methods
+
+ public override string ToString()
+ {
+ return this.parameterName;
+ }
+
+ #endregion
+
+ #region Internal Methods
+
+ internal string ConvertToPgString()
+ {
+ bool addQuotes = true;
+ string returnValue = String.Empty;
+
+ switch (this.pgDbType)
+ {
+ case PgDbType.Array:
+ break;
+
+ case PgDbType.Binary:
+ break;
+
+ case PgDbType.Boolean:
+ returnValue = Convert.ToBoolean(this.value).ToString().ToLower();
+ break;
+
+ case PgDbType.Box:
+ returnValue = ((PgBox)this.value).ToString();
+ break;
+
+ case PgDbType.Byte:
+ returnValue = Convert.ToByte(this.value).ToString();
+ break;
+
+ case PgDbType.Char:
+ case PgDbType.VarChar:
+ case PgDbType.Text:
+ returnValue = Convert.ToString(this.value);
+ break;
+
+ case PgDbType.Circle:
+ returnValue = ((PgCircle)this.value).ToString();
+ break;
+
+ case PgDbType.Currency:
+ returnValue = "$" + Convert.ToSingle(this.value).ToString();
+ break;
+
+ case PgDbType.Date:
+ returnValue = Convert.ToDateTime(this.value).ToString("MM/dd/yyyy");
+ break;
+
+ case PgDbType.Decimal:
+ case PgDbType.Numeric:
+ returnValue = Convert.ToDecimal(this.value).ToString();
+ break;
+
+ case PgDbType.Double:
+ returnValue = Convert.ToDouble(this.value).ToString();
+ break;
+
+ case PgDbType.Float:
+ returnValue = Convert.ToSingle(this.value).ToString();
+ break;
+
+ case PgDbType.Int2:
+ returnValue = Convert.ToInt16(this.value).ToString();
+ break;
+
+ case PgDbType.Int4:
+ returnValue = Convert.ToInt32(this.value).ToString();
+ break;
+
+ case PgDbType.Int8:
+ returnValue = Convert.ToInt64(this.value).ToString();
+ break;
+
+ case PgDbType.Interval:
+ break;
+
+ case PgDbType.Line:
+ returnValue = ((PgLine)this.value).ToString();
+ break;
+
+ case PgDbType.LSeg:
+ returnValue = ((PgLSeg)this.value).ToString();
+ break;
+
+ case PgDbType.Path:
+ returnValue = ((PgPath)this.value).ToString();
+ break;
+
+ case PgDbType.Point:
+ returnValue = ((PgPoint)this.value).ToString();
+ break;
+
+ case PgDbType.Polygon:
+ returnValue = ((PgPolygon)this.value).ToString();
+ break;
+
+ case PgDbType.Time:
+ returnValue = Convert.ToDateTime(this.value).ToString("HH:mm:ss");
+ break;
+
+ case PgDbType.Timestamp:
+ returnValue = Convert.ToDateTime(this.value).ToString("MM/dd/yyy HH:mm:ss");
+ break;
+
+ case PgDbType.TimestampWithTZ:
+ returnValue = Convert.ToDateTime(this.value).ToString("MM/dd/yyy HH:mm:ss zz");
+ break;
+
+ case PgDbType.TimeWithTZ:
+ returnValue = Convert.ToDateTime(this.value).ToString("HH:mm:ss zz");
+ break;
+
+ case PgDbType.Vector:
+ break;
+
+ default:
+ returnValue = this.value.ToString();
+ break;
+ }
+
+ if (addQuotes)
+ {
+ returnValue = "'" + returnValue + "'";
+ }
+
+ return returnValue;
+ }
+
+ #endregion
+
#region Private Methods
***************
*** 421,429 ****
}
- public override string ToString()
- {
- return this.parameterName;
- }
-
#endregion
}
--- 559,562 ----
|
