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; }