private int DoExecute(string query, Hashtable parameters)
{
int result = 0;
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]);
}
}
result = dbHandler.DoExecute();
}
catch (Exception e)
{
Logger.error("트랜잭션 실행에러 : " + e.ToString());
throw new Exception("트랜잭션 실행에러");
}
finally
{
dbHandler.Close();
}
return(result);
}
private int DoExecute(string query, Hashtable parameters)
{
int result = 0;
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]);
}
}
result = dbHandler.DoExecute();
}
catch (Exception e)
{
Logger.error("트랜잭션 실행에러 : " + e.ToString());
throw new Exception("트랜잭션 실행에러");
}
finally
{
dbHandler.Close();
}
return result;
}
