public static struturaExecSQL execReader(string sql, List <MySqlParameter> parameters)
{
Close();
db = dbMySQL();
struturaExecSQL result = new struturaExecSQL();
reader = null;
try
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, db);
try { cmd.Parameters.Clear(); } catch { }
if (parameters != null)
{
foreach (var item in parameters)
{
MySqlParameter par = new MySqlParameter(item.ParameterName, item.MySqlDbType);
par.Value = item.Value;
cmd.Parameters.Add(par);
}
}
reader = cmd.ExecuteReader();
}
catch (Exception ex)
{
result.erro = true;
result.mensagem = ex.Message;
result.mensagemDetalhada = string.Empty;
result.Reader = null;
Console.WriteLine(ex.Message);
if (ex.InnerException != null && ex.InnerException.Message != null)
{
result.mensagemDetalhada = ex.InnerException.Message;
Console.WriteLine(ex.InnerException.Message);
}
}
finally
{
if (parameters != null)
{
parameters.Clear();
}
}
result.Reader = reader;
return(result);
}
public static String consultavalor(string tabela, string coluna, string filtro = "")
{
MySQLDB.validainjecaoSQL(tabela);
MySQLDB.validainjecaoSQL(coluna);
String result = string.Empty;
try
{
string strSql = new StringBuilder("SELECT ").Append(coluna).Append(" FROM ").Append(tabela).ToString();
if (!String.IsNullOrWhiteSpace(filtro))
{
strSql = new StringBuilder(strSql).Append(" WHERE ").Append(filtro).ToString();
}
strSql = new StringBuilder(strSql).Append(" LIMIT 1 ").ToString();
//Parametros
//List<MySqlParameter> prm = new List<MySqlParameter>();
//prm.Add(new MySqlParameter("@IDGROWLER", IdGrowler));
struturaExecSQL resultSQL = MySQLDB.execReader(strSql);
if (!resultSQL.erro)
{
System.Data.Common.DbDataReader rs = resultSQL.Reader;
while (rs.Read())
{
result = rs[0].ToString().ToString();
break;
}
}
}
catch (Exception ex)
{
result = "ERRO";
throw ex;
}
finally
{
MySQLDB.Close();
}
return(result);
}
public static struturaExecSQL execSQL(string sql, List <MySqlParameter> parameters)
{
//Int64 result = -1;
struturaExecSQL result = new struturaExecSQL();
int linafe = 0;
db = null;
try
{
db = dbMySQL();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, db);
try { cmd.Parameters.Clear(); } catch { }
forceCloserReader();
if (parameters != null)
{
foreach (var item in parameters)
{
MySqlParameter par = new MySqlParameter(item.ParameterName, item.MySqlDbType);
par.Value = item.Value;
cmd.Parameters.Add(par);
}
}
linafe = cmd.ExecuteNonQuery();
result.linhasafetadas = linafe; //"0;OK;" + linafe.ToString();
result.erro = false;
result.mensagem = string.Empty;
}
catch (Exception ex)
{
result.linhasafetadas = 0; //"0;OK;" + linafe.ToString();
result.erro = true;
result.mensagem = ex.Message;
result.mensagemDetalhada = string.Empty;
//"1;ERRO:" + ex.Message + ";0";
Console.WriteLine(ex.Message);
if (ex.InnerException != null && ex.InnerException.Message != null)
{
result.mensagemDetalhada = ex.InnerException.Message;
Console.WriteLine(ex.InnerException.Message);
}
}
finally
{
if (parameters != null)
{
parameters.Clear();
}
try
{
if (db != null && db.State == System.Data.ConnectionState.Open)
{
Close();
}
}
catch (Exception) { }
}
return(result);
}
