public static string GetFilterValueAndDataTypeString(Filter filter)
{
string filterValueAndDataTypeString = "";
for (int i = 0; i < filter.FilterColumns.Length; i++)
{
Filter.FilterColumn filterColumn = filter.FilterColumns[i];
string alias = filterColumn.Alias;
if (string.IsNullOrEmpty(alias))
{
alias = Script.GetCamelCase(filterColumn.Column.Alias);
}
else
{
alias = Script.GetCamelCase(alias);
}
filterValueAndDataTypeString += CSharp.GetDataType(filterColumn.Column) + " " + alias;
if (i < filter.FilterColumns.Length - 1)
{
filterValueAndDataTypeString += ", ";
}
}
return(filterValueAndDataTypeString);
}
public static string GetKeyValues2(Column[] columns, bool includeDataType, string prefix)
{
string returnString = "";
for (int i = 0; i < columns.Length; i++)
{
Column column = columns[i];
if (includeDataType)
{
returnString += CSharp.GetDataType(column) + " ";
}
if (prefix == "_")
{
returnString += prefix + Script.GetCamelCase(column.Alias);
}
else
{
returnString += prefix + column.Alias;
}
if (i < columns.Length - 1)
{
returnString += ", ";
}
}
return(returnString);
}
public static string GetStoredProcedureParameterValueAndDataTypeString(StoredProcedure storedProcedure)
{
StringBuilder result = new StringBuilder(100);
for (int i = 0; i < storedProcedure.Parameters.Length; i++)
{
if (i > 0)
{
result.Append(", ");
}
StoredProcedure.Parameter parameter = storedProcedure.Parameters[i];
string alias = Script.GetCamelCase(parameter.Alias);
string modifier = "";
if (parameter.Direction.ToLower().IndexOf("out") >= 0)
{
modifier = "ref ";
}
result.AppendFormat("{0}{1} {2}", modifier, CSharp.GetDataType(parameter.DataType, false), alias);
}
return(result.ToString());
}
public static string GetDataType(StoredProcedure.Parameter parameter)
{
bool isNullable = false; // TODO: need to add a property to Parameters that specify whether they are nullable (have default values).
return(CSharp.GetDataType(parameter.DataType, isNullable));
}
public static string GetDataType(Column column)
{
bool isNullable = column.IsNullable || CSharp.MapColumnType.IsInstanceOfType(column);
return(CSharp.GetDataType(column.DataType, isNullable));
}
