public Data select(String query, Data data)
{
cmd = null;
Data result = new Data();
cmd = new MySqlCommand(query, connect);
String key = null;
MySqlDbType types = MySqlDbType.VarChar;
int size = -1;
Object[] keys = data.getKeys();
Object value = null;
int now = 0;
if (keys != null)
{
int length = keys.Length;
for (int i = 0; i < length; i++)
{
key = "@" + keys[i].ToString();
value = data.getValue(keys[i]);
size = data.getSize(keys[i]);
types = data.getType(keys[i]);
if (size > 0)
{
cmd.Parameters.Add(key, types);
}
else
{
cmd.Parameters.Add(key, types, size);
}
cmd.Parameters[key].Value = value;
}
}
read = cmd.ExecuteReader();
try
{
while (read.Read())
{
int readCount = read.FieldCount;
for (int i = 0; i < readCount; i++)
{
result.add(now, read.GetName(i), read.GetValue(i));
}
++now;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
errorMsg = e.Message;
}
finally
{
if (cmd != null)
{
cmd.Parameters.Clear();
}
if (read != null)
{
read.Close();
}
}
return result;
}
//==============================================MySQL Commands===========================================//
public int insert(string query, Data data)
{
cmd = null;
int result = 0;
cmd = new MySqlCommand(query, connect);
string key = null;
MySqlDbType types = MySqlDbType.VarChar;
int size = -1;
Object[] keys = data.getKeys();
object value = null;
int length = keys.Length;
if (keys != null)
{
for (int i = 0; i < length; i++)
{
key = "@" + keys[i].ToString();
value = data.getValue(keys[i]);
size = data.getSize(keys[i]);
types = data.getType(keys[i]);
if (size > 0)
{
cmd.Parameters.Add(key, types);
}
else
{
cmd.Parameters.Add(key, types, size);
}
cmd.Parameters[key].Value = value;
}
}
result = cmd.ExecuteNonQuery();
cmd.BeginExecuteNonQuery();
return result;
}
