Exemplo n.º 1
0
 /// <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()}");
     }
 }