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)); }