/// <summary>
        /// 根据userId查询用户服务码
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public static IEnumerable <BankMRActivityCodeRecord> GetBankMRActivityCodeRecordByUserId(Guid userId)
        {
            IEnumerable <BankMRActivityCodeRecord> result = null;

            try
            {
                TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectBankMRActivityCodeRecordByUserId(conn, userId));
            }
            catch (Exception ex)
            {
                Logger.Error(ex.Message, ex);
            };

            return(result);
        }