public static MysqlDatas query(string query, Dictionary <string, object> parameters)
{
Mysql ins = Mysql.getInstance();
ins.mysqlConn.Open();
MySqlCommand cmd = ins.prepare(query, ins.mysqlConn, parameters);
MySqlDataReader reader = cmd.ExecuteReader();
MysqlDatas list = ins.addToCollection(reader);
ins.mysqlConn.Close();
return(list);
}
public MysqlDatas addToCollection(MySqlDataReader reader)
{
MysqlDatas datas = new MysqlDatas();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
datas.hasRows = reader.HasRows;
//string key = null;
while (reader.Read())
{
Dictionary <string, object> dict = new Dictionary <string, object>();
for (int i = 0; i < reader.FieldCount; i++)
{
if (!dict.Keys.Contains(reader.GetName(i)))
{
dict.Add(reader.GetName(i), reader.GetValue(i));
}
}
datas.datas.Add(dict);
}
return(datas);
}
