public static string GetKeyValues(Column[] columns, string prefix)
{
string returnString = "";
for (int i = 0; i < columns.Length; i++)
{
Column column = columns[i];
returnString += prefix + column.Alias;
if (CSharp.MapColumnType.IsInstanceOfType(column) || (column.IsNullable && CSharp.ColumnIsBasicDataType(column)))
{
returnString += ".Value";
}
if (i < columns.Length - 1)
{
returnString += ", ";
}
}
return(returnString);
}
public static string GetASCXConversion(Column column)
{
string nullableType = "";
if (column.IsNullable && CSharp.ColumnIsBasicDataType(column))
{
nullableType += ".Value";
}
switch (column.DataType)
{
case "bigint":
return(nullableType + ".ToString()");
case "binary":
return(nullableType + ".ToString()");
case "bit":
return(nullableType + "");
case "char":
return(nullableType + "");
case "datetime":
return(nullableType + ".ToString(\"dd MMM yyyy\")");
case "decimal":
return(nullableType + ".ToString()");
case "float":
return(nullableType + ".ToString()");
case "image":
return(nullableType + ".ToString()");
case "int":
return(nullableType + ".ToString()");
case "money":
return(nullableType + ".ToString()");
case "nchar":
return(nullableType + "");
case "ntext":
return(nullableType + "");
case "numeric":
return(nullableType + ".ToString()");
case "nvarchar":
return(nullableType + "");
case "real":
return(nullableType + ".ToString()");
case "smalldatetime":
return(nullableType + ".ToString(\"dd MMM yyyy\")");
case "smallint":
return(nullableType + ".ToString()");
case "smallmoney":
return(nullableType + ".ToString()");
case "sql_variant":
return(nullableType + ".ToString()");
case "text":
return(nullableType + "");
case "timestamp":
return(nullableType + ".ToString()");
case "tinyint":
return(nullableType + ".ToString()");
case "uniqueidentifier":
return(nullableType + ".ToString()");
case "varbinary":
return(nullableType + ".ToString()");
case "varchar":
return(nullableType + "");
case "xml":
return(nullableType + "");
default:
throw new Exception(column.DataType + " data type not supported by the ArchAngel.Providers.Database.Model API yet. Please contact Slyce support: [email protected]");
}
}
