ADO.NET中ExcuteNonQuery获取存储过程Return返回值

        /// <summary>
        /// 获取当月用户已投票数量
        /// </summary>
        /// <param name="userId">用户Id</param>
        /// <returns></returns>
        public int GetBookPinkTicket(long userId)
        {
            IDataParameter[] paramArray = new IDataParameter[] { 
                this.AdoHelper.GetReturnParameter(), 
                this.AdoHelper.GetParameter("inintuserid", DbType.Int64, userId) 
            };
            try
            {
               this.AdoHelper.ExecuteNonQuery(this.ConnectionString, CommandType.StoredProcedure, "fn_ticket_logcnt_get", paramArray);
               return Field.GetReturnPram(paramArray[0]);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
原文地址:https://www.cnblogs.com/zxx193/p/3421850.html