private DataTable DoQuery(string query, Hashtable parameters)
{
DataTable dt = new DataTable();
MySqlHandler dbHandler = null;
try
{
dbHandler = new MySqlHandler(ConstDef.WEDO_DB_URL, dbPort, ConstDef.WEDO_DB, ConstDef.WEDO_DB_USER, ConstDef.WEDO_DB_PASSWORD);
dbHandler.Open();
dbHandler.SetQuery(query);
if (parameters != null)
{
foreach (string key in parameters.Keys)
{
dbHandler.Parameters(key, (string)parameters[key]);
}
}
dt = dbHandler.DoQuery();
}
catch (Exception e)
{
Logger.error("쿼리실행에러 : " + e.ToString());
throw new Exception("쿼리실행에러");
}
finally
{
dbHandler.Close();
}
return(dt);
}
private DataTable DoQuery(string query, Hashtable parameters)
{
DataTable dt = new DataTable();
MySqlHandler dbHandler = null;
try
{
dbHandler = new MySqlHandler(ConstDef.WEDO_DB_URL, dbPort, ConstDef.WEDO_DB, ConstDef.WEDO_DB_USER, ConstDef.WEDO_DB_PASSWORD);
dbHandler.Open();
dbHandler.SetQuery(query);
if (parameters != null)
{
foreach (string key in parameters.Keys)
{
dbHandler.Parameters(key, (string)parameters[key]);
}
}
dt = dbHandler.DoQuery();
}
catch (Exception e)
{
Logger.error("쿼리실행에러 : " + e.ToString());
throw new Exception("쿼리실행에러");
}
finally
{
dbHandler.Close();
}
return dt;
}
