string ISqlBuilderConvert.GetInsertValueSql(DatabaseProvider provider)
{
var table = (ITableConvert)_tables[0];
var cols = table.GetInsertColumns();
if (cols.Count == 0)
{
return(null);
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("(");
for (int i = 0; i < cols.Count; i++)
{
var col = cols[i];
if (col._isPrimaryKey && col._isAutoIncrement)
{
continue;
}
if ("boolean|int16|int32|int64|uint16|uint32|uint64|single|double|decimal".Contains(col._fieldType) == false)
{
if (col._changeType == Enums.ColumnChangeType.None)
{
continue;
}
}
var obj = provider.ConvertTo(col.GetValue());
stringBuilder.Append(obj);
stringBuilder.Append(",");
}
stringBuilder[stringBuilder.Length - 1] = ')';
return(stringBuilder.ToString());
}
string IConditionConvert.ToSql(DatabaseProvider provider, int tableCount)
{
if (isSetValaue == false)
{
return(((IColumnConvert)leftColumn).ToSql(provider, tableCount) + " " + op);
}
return(((IColumnConvert)leftColumn).ToSql(provider, tableCount) + " " + op + " "
+ provider.ConvertTo(value));
}
void IConditionConvert.ToSql(StringBuilder stringBuilder, DatabaseProvider provider, int tableCount)
{
stringBuilder.Append(((IColumnConvert)leftColumn).ToSql(provider, tableCount));
stringBuilder.Append(" ");
stringBuilder.Append(op);
if (isSetValaue)
{
stringBuilder.Append(" ");
stringBuilder.Append(provider.ConvertTo(value));
}
}
