public MySqlCommand(MySqlCommandType Type)
{
this.Type = Type;
switch (Type)
{
case MySqlCommandType.SELECT:
{
_command = new StringBuilder("SELECT * FROM <R>");
break;
}
case MySqlCommandType.UPDATE:
{
_command = new StringBuilder("UPDATE <R> SET ");
break;
}
case MySqlCommandType.INSERT:
{
Fields = new Dictionary <byte, string>(20);
longValues = new Dictionary <byte, long>(20);
ulongValues = new Dictionary <byte, ulong>(20);
decimalValues = new Dictionary <byte, decimal>(20);
boolValues = new Dictionary <byte, bool>(20);
stringValues = new Dictionary <byte, string>(20);
lastpair = 0;
_command = new StringBuilder("INSERT INTO <R> (<F>) VALUES (<V>)");
break;
}
case MySqlCommandType.DELETE:
{
_command = new StringBuilder("DELETE FROM <R> WHERE <C> = <V>");
break;
}
case MySqlCommandType.COUNT:
{
_command = new StringBuilder("SELECT count(*) FROM <R>");
break;
}
case MySqlCommandType.CLEAR:
{
_command = new StringBuilder("DELETE FROM <R>");
break;
}
}
}
public MySqlCommand(MySqlCommandType Type)
{
this.Type = Type;
switch (Type)
{
case MySqlCommandType.SELECT:
{
_command = new StringBuilder("SELECT * FROM <R>");
break;
}
case MySqlCommandType.C:
{
_command = new StringBuilder("DELETE FROM <R>");
break;
}
case MySqlCommandType.UPDATE:
{
_command = new StringBuilder("UPDATE <R> SET ");
break;
}
case MySqlCommandType.INSERT:
{
insertFields = new Dictionary <byte, string>();
insertValues = new Dictionary <byte, string>();
lastpair = 0;
_command = new StringBuilder("INSERT INTO <R> (<F>) VALUES (<V>)");
break;
}
case MySqlCommandType.DELETE:
{
_command = new StringBuilder("DELETE FROM <R> WHERE <C> = <V>");
break;
}
case MySqlCommandType.COUNT:
{
_command = new StringBuilder("SELECT count(<V>) FROM <R>");
break;
}
}
}
public MySqlCommand(MySqlCommandType Type)
{
this.Type = Type;
switch (Type)
{
case MySqlCommandType.SELECT:
{
_command = new StringBuilder("SELECT * FROM <R>");
break;
}
case MySqlCommandType.UPDATE:
{
_command = new StringBuilder("UPDATE <R> SET ");
break;
}
case MySqlCommandType.INSERT:
{
Fields = new Dictionary<byte, string>(20);
longValues = new Dictionary<byte, long>(20);
ulongValues = new Dictionary<byte, ulong>(20);
boolValues = new Dictionary<byte, bool>(20);
stringValues = new Dictionary<byte, string>(20);
lastpair = 0;
_command = new StringBuilder("INSERT INTO <R> (<F>) VALUES (<V>)");
break;
}
case MySqlCommandType.DELETE:
{
_command = new StringBuilder("DELETE FROM <R> WHERE <C> = <V>");
break;
}
case MySqlCommandType.COUNT:
{
_command = new StringBuilder("SELECT count(<V>) FROM <R>");
break;
}
}
}
