public static string CRUDParams(SqlNames Property, bool enableComa) { var result = ""; result += "@" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + (enableComa ? " ," : "") + Enter; return(result); }
public static string CreateSample(SqlNames Property, bool enableComa) { var result = ""; result += "[" + Property.COLUMN_NAME + "] " + DataTypeDeclare(Property, Property.DATA_TYPE) + " " + (enableComa ? "," : "") + Enter; return(result); }
public static string ConditionFilters(SqlNames Property, bool enableComa) { var result = ""; if (MinMaxDataTypes(Property.DATA_TYPE)) { result += Enter + "@" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + " = NULL ," + Enter; result += "@MultiText_" + Property.COLUMN_NAME + " nvarchar(MAX) = '' ," + Enter; result += "@Min" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + " = NULL ," + Enter; result += "@Max" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + (enableComa ? " = NULL ," : " = NULL") + Enter + Enter; } else { result += Enter + "@" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + " = NULL ," + Enter; result += "@MultiText_" + Property.COLUMN_NAME + " nvarchar(MAX) = '' " + (enableComa ? "," : "") + Enter + Enter; } return(result); }
public static string ConditionStatement(SqlNames Property, bool enableComa, string constName) { var result = "-- || Auto Generated Conditions || --" + Enter; var readSelectTemplateMinMax = System.IO.File.ReadAllText("sqlTemplates\\minMaxConditionsTemplate.txt"); var readSelectTemplateSimple = System.IO.File.ReadAllText("sqlTemplates\\simpleConditionsTemplate.txt"); var readSelectTemplateChar = System.IO.File.ReadAllText("sqlTemplates\\charConditionTemplate.txt"); if (MinMaxDataTypes(Property.DATA_TYPE)) { result += readSelectTemplateMinMax. Replace("#COLNAME#", Property.COLUMN_NAME). Replace("#CONST#", constName). Replace("#AND#", (enableComa ? "And" : "")) + Enter + Enter; } else if (!CharType(Property.DATA_TYPE)) { result += readSelectTemplateSimple. Replace("#COLNAME#", Property.COLUMN_NAME). Replace("#CONST#", constName). Replace("#AND#", (enableComa ? "And" : "")) + Enter + Enter; } else { result += readSelectTemplateChar. Replace("#COLNAME#", Property.COLUMN_NAME). Replace("#CONST#", constName). Replace("#AND#", (enableComa ? "And" : "")) + Enter + Enter; } return(result); }
public static string DataTypeDeclare(SqlNames Property, string type) { var result = type; switch (type) { case "datetime2": { result += "(" + Property.DATETIME_PRECISION + ")"; return(result); } case "datetimeoffset": { result += "(" + Property.DATETIME_PRECISION + ")"; return(result); } case "decimal": { //result += "(" + Property.NUMERIC_PRECISION + "," + Property.NUMERIC_SCALE + ")"; return(result); } case "nchar": { result += "(" + Property.CHARACTER_MAXIMUM_LENGTH + ")"; return(result); } case "numeric": { //result += "(" + Property.NUMERIC_PRECISION + "," + Property.NUMERIC_SCALE + ")"; return(result); } case "nvarchar": { result += "(" + (Property.CHARACTER_MAXIMUM_LENGTH == -1 ? "MAX" : Property.CHARACTER_MAXIMUM_LENGTH.ToString()) + ")"; return(result); } case "time": { result += "(" + Property.DATETIME_PRECISION + ")"; return(result); } case "varbinary": { result += "(" + (Property.CHARACTER_MAXIMUM_LENGTH == -1 ? "MAX" : Property.CHARACTER_MAXIMUM_LENGTH.ToString()) + ")"; return(result); } case "varchar": { result += "(" + (Property.CHARACTER_MAXIMUM_LENGTH == -1 ? "MAX" : Property.CHARACTER_MAXIMUM_LENGTH.ToString()) + ")"; return(result); } case "binary": { result += "(" + Property.CHARACTER_OCTET_LENGTH + ")"; return(result); } case "char": { result += "(" + Property.CHARACTER_OCTET_LENGTH + ")"; return(result); } default: return(result); } }