public override string ToString()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO {0} (", DbMgr.FieldAlias(mTable));
int column_counter = 0;
List <DbElement> values = new List <DbElement>();
foreach (string columnname in mColumns.Keys)
{
DbElement fieldvalue = mColumns[columnname];
if (fieldvalue.IsValidValue)
{
if (column_counter == 0)
{
sb.AppendFormat("{0}", DbMgr.FieldAlias(columnname));
}
else
{
sb.AppendFormat(", {0}", DbMgr.FieldAlias(columnname));
}
values.Add(fieldvalue);
column_counter++;
}
}
sb.Append(") VALUES (");
for (int i = 0; i != values.Count; ++i)
{
if (i == 0)
{
sb.AppendFormat("{0}", values[i]);
}
else
{
sb.AppendFormat(", {0}", values[i]);
}
}
sb.Append(")");
string where_text = WhereText;
if (where_text != "")
{
sb.AppendFormat(" WHERE {0}", where_text);
}
return(sb.ToString());
}
public DbExpression(DbColumn column, DbSelectStatement select_clause, SqlCondition condition)
{
mColumn = column;
mFieldvalue = select_clause;
mCondition = condition;
this[SqlCondition.IsEqual] = "=";
this[SqlCondition.IsLessEqual] = "<=";
this[SqlCondition.IsGreaterEqual] = ">=";
this[SqlCondition.IsLess] = "<";
this[SqlCondition.IsGreater] = ">";
this[SqlCondition.Like] = "LIKE";
}
public DbExpression(DbColumn column, DbFieldEntry fieldvalue, SqlCondition condition)
{
mColumn = column;
mFieldvalue = fieldvalue;
mCondition = condition;
this[SqlCondition.IsEqual] = "=";
this[SqlCondition.IsLessEqual] = "<=";
this[SqlCondition.IsGreaterEqual] = ">=";
this[SqlCondition.IsLess] = "<";
this[SqlCondition.IsGreater] = ">";
this[SqlCondition.Like] = "LIKE";
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE {0} SET", DbMgr.FieldAlias(mTable));
int column_counter = 0;
foreach (string columnname in mColumns.Keys)
{
DbElement fieldvalue = mColumns[columnname];
if (fieldvalue is DbFieldEntry)
{
DbFieldEntry _fieldvalue = fieldvalue as DbFieldEntry;
if (!_fieldvalue.IsValidValue)
{
continue;
}
if (_fieldvalue.SkipOnUpdate)
{
continue;
}
}
if (column_counter == 0)
{
sb.AppendFormat(" {0} = {1}", DbMgr.FieldAlias(columnname), fieldvalue);
}
else
{
sb.AppendFormat(", {0} = {1}", DbMgr.FieldAlias(columnname), fieldvalue);
}
column_counter++;
}
string where_text = WhereText;
if (where_text != "")
{
sb.AppendFormat(" WHERE {0}", where_text);
}
return(sb.ToString());
}
public DbInsertStatement InsertColumn(string columnname, DbElement fieldvalue)
{
mColumns[columnname] = fieldvalue;
return(this);
}
public DbUpdateStatement UpdateColumn(string columnname, DbElement fieldvalue)
{
mColumns[columnname] = fieldvalue;
return(this);
}
