Exemplo n.º 1
0
 /// <summary>
 /// 执行SQL语句,返回DataTable
 /// </summary>
 /// <param name="sql">SQL语句或命令(为了Oracle上能够使用,表的别名前不要加AS)</param>
 /// <param name="value">参数值列表</param>
 /// <returns>DataTable</returns>
 public DataTable ExecuteDataTableParams(string sql, params object[] value)
 {
     try
     {
         return(_db.ExecuteDataTableParams(sql, value));
     }
     catch (Exception ex)
     {
         throw new Exception(
                   $"查询失败!\r\n数据库:{DbType}。\r\nSQL语句:{sql}。\r\n参数列表{_db.ShowParamsList(_db.GetParamsList(value))}。\r\n{ex.ToString()}");
     }
 }