/// <summary> /// 执行SQL语句,返回DataTable /// </summary> /// <param name="sql">SQL语句(为了Oracle上能够使用,表的别名前不要加AS)</param> /// <param name="value">The value.</param> /// <returns>DataTable</returns> /// <exception cref="Exception"></exception> public DataTable ExecuteDataTable(string sql, params object[] value) { try { if (value.Length > 0) { return(ExecuteDataTableParams(sql, value)); } else { return(_db.ExecuteDataTable(sql)); } } catch (Exception ex) { throw new Exception($"查询失败!\r\nSQL语句为:{sql}。\r\n{ex.ToString()}"); } }