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