/// <summary> /// execHashJson: 普通执行Sql语句 /// </summary> /// <param name="sql">要执行的sql语句</param> /// <returns></returns> public override ArrayList execJsonList(string sql) { ArrayList list = null; try { DBUtil.onExecSqlBefore(_CLASS, "execJsonList", sql); using (MySqlConnection sqlConn = new MySqlConnection(dbInfo.toMyConnectionString())) { sqlConn.Open(); MySqlCommand sqlComm = sqlConn.CreateCommand(); sqlComm.CommandText = sql; using (IDataReader dr = sqlComm.ExecuteReader(CommandBehavior.Default)) { list = DBUtil.DataReaderToJsonList(dr); dr.Close(); } sqlConn.Close(); } } catch (Exception ex) { DBUtil.onExecSqlError(_CLASS, "execJsonList", sql, ex.Message); } return(list); }
/// <summary> /// execJson: 执行sql语句并得到第一行数据的Json格式数据 /// </summary> /// <param name="sql">要执行的sql语句</param> /// <returns>HashJson</returns> public ArrayList execJsonList(string sql) { ArrayList list = null; try { DBUtil.onExecSqlBefore(_CLASS, "execJsonList", sql); cmd.CommandText = @sql; state = ConnectionState.Executing; using (MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.Default)) { list = DBUtil.DataReaderToJsonList(dr); } } catch (Exception e) { DBUtil.onExecSqlError(_CLASS, "execJsonList", sql, e.Message); } return(list); }