public static object GetDefaultValue(CColumn column, int sequenceNum = 0, string tableName = "Value") { var type = GetType(column.DbType); try { var value = Activator.CreateInstance(type); if (sequenceNum > 0) { if (value is int) { value = sequenceNum; } else if (value is long) { value = (long)sequenceNum; } else if (value is Guid) { value = Guid.Parse(sequenceNum.ToString("000") + value.ToString().Substring(3)); } } return(value); } catch (Exception) { if (type == typeof(string)) { return(string.Format("{0} {1}", tableName, sequenceNum)); } return(new object()); } }
public static string ToSelectString(this CColumn column, bool isFirst = false) { var query = new StringBuilder(); query.AppendFormat("{0}[{1}] ", isFirst ? string.Empty : ",", column.name); return(query.ToString().Trim()); }
public static string ToSchemaString(this CColumn column, bool isFirst = false) { var query = new StringBuilder(); query.AppendFormat("{0}[{1}] {2} {3} {4}", isFirst ? string.Empty : ",", column.name, GetTypeString(column.DbType).ToUpper(), column.isNullable ? "NULL" : "NOT NULL", column.isPrimaryKey ? "PRIMARY KEY" : string.Empty); return(query.ToString().Trim()); }
public static string ToWhereString(this CColumn column, IDbDataParameter value, bool isFirst = false, string operatorValue = "=", string andOr = "And") { var query = new StringBuilder(); if (value != null) { query.AppendFormat("{0}{1} {2} {3} ", isFirst ? string.Empty : " " + andOr + " ", column.name, operatorValue, QuoteValue(value.Value)); } return(query.ToString().Trim()); }
public static object GetDefaultValue(CColumn column, string @operator) { if (@operator.ToLower().StartsWith("is")) { return("NULL"); } else if (@operator.ToLower().StartsWith("like")) { return("\"%" + GetDefaultValue(column, 0) + "%\""); } else { return(QuoteValue(GetDefaultValue(column, 0), "\"")); } }