/// <summary>
/// 执行带返回参数的存储过程
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters">存储过程参数</param>
/// <returns>返回值字典集合</returns>
public IDictionary <string, object> ExecuteProcedure(string sql, DataParameters parameters = null)
{
try
{
Connection.Execute(sql, parameters?.GetDynamicParameters(), Transaction, null, CommandType.StoredProcedure);
return(parameters.GetOutput());
}
catch (Exception e)
{
Rollback();//异常时候回滚,防止数据库锁死
throw new DataException(e.Message);
}
}
