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), "\""));
}
}
