[Adapdev-commits] Adapdev/src/Adapdev.CodeGen NVelocityTableCodeTemplate.cs,1.3,1.4

[Sean M. <int...@us...>]

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.CodeGen
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11385/src/Adapdev.CodeGen

Modified Files:
	NVelocityTableCodeTemplate.cs 
Log Message:
Added stored procedure parameter lengths for appropriate types for Codus
Added external config file support for Zanebug
Added ExpectedException message support

Index: NVelocityTableCodeTemplate.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.CodeGen/NVelocityTableCodeTemplate.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** NVelocityTableCodeTemplate.cs	25 Mar 2005 02:14:28 -0000	1.3
--- NVelocityTableCodeTemplate.cs	27 Apr 2005 04:36:02 -0000	1.4
***************
*** 302,309 ****
  		public string GetParameterValue(ColumnSchema c)
  		{
! 			if (c.NetType.Equals("System.DateTime")) return c.Alias + ".ToOADate()";
  			else return c.Alias;
  		}
  
  		/// <summary>
  		/// Gets or sets the template file.
--- 302,328 ----
  		public string GetParameterValue(ColumnSchema c)
  		{
! 			if (c.NetType.Equals("System.DateTime")) return c.Alias + ".Subtract(new TimeSpan(2,0,0,0)).ToOADate()";
  			else return c.Alias;
  		}
  
+ 		public string GetParameterLength(ColumnSchema c)
+ 		{
+ 			switch(c.DataType.ToLower())
+ 			{
+ 				case "char":
+ 				case "nchar":
+ 				case "nvarchar":
+ 				case "varchar":
+ 					return "(" + c.Length + ")";
+ 					break;
+ 			}
+ 			return String.Empty;
+ 		}
+ 
+ 		public string GetParameterText(ColumnSchema cs)
+ 		{
+ 			return this.GetParameterName(cs.Name) + " " + cs.DataType.ToLower()	+ this.GetParameterLength(cs);
+ 		}
+ 
  		/// <summary>
  		/// Gets or sets the template file.
***************
*** 354,362 ****
  				if(i < al.Count)
  				{
! 					sb.Append(this.GetParameterName(cs.Name) + " " + cs.DataType.ToLower() + "," + Environment.NewLine);
  				}
  				else 
  				{
! 					sb.Append(this.GetParameterName(cs.Name) + " " + cs.DataType.ToLower() + Environment.NewLine);
  				}
  				i++;
--- 373,381 ----
  				if(i < al.Count)
  				{
! 					sb.Append(this.GetParameterText(cs) + "," + Environment.NewLine);
  				}
  				else 
  				{
! 					sb.Append(this.GetParameterText(cs) + Environment.NewLine);
  				}
  				i++;
***************
*** 375,383 ****
  					if(i < ts.SortedColumns.Count)
  					{
! 						sb.Append(this.GetParameterName(columnSchema.Name) + " " + columnSchema.DataType.ToLower() + "," + Environment.NewLine);
  					}
  					else
  					{
! 						sb.Append(this.GetParameterName(columnSchema.Name) + " " + columnSchema.DataType.ToLower() + Environment.NewLine);
  					}
  				}
--- 394,402 ----
  					if(i < ts.SortedColumns.Count)
  					{
! 						sb.Append(this.GetParameterText(columnSchema) + "," + Environment.NewLine);
  					}
  					else
  					{
! 						sb.Append(this.GetParameterText(columnSchema) + Environment.NewLine);
  					}
  				}