C# IDataReader.GetGuid方法代码示例

        /// <summary>
        /// Gets a column value by the name
        /// </summary>
        /// <param name="mapping"></param>
        /// <param name="dataReader"></param>
        /// <returns></returns>
        public override object GetValueByName(ResultProperty mapping, IDataReader dataReader)
        {
            int index = dataReader.GetOrdinal(mapping.ColumnName);

            if (dataReader.IsDBNull(index))
            {
                return DBNull.Value;
            }
            return new Guid?( dataReader.GetGuid(index) );
        }

		/// <summary>
		/// 
		/// </summary>
		/// <param name="rs"></param>
		/// <param name="index"></param>
		/// <returns></returns>
		public override object Get(IDataReader rs, int index)
		{
            if (rs.GetFieldType(index) == typeof(Guid))
            {
                return rs.GetGuid(index);
            }
            else
            {
                return new Guid(Convert.ToString(rs[index]));
            }
		}

        /// <summary>
        /// Initializes a new instance of the <see cref="Log"/> class.
        /// </summary>
        /// <param name="reader">The reader.</param>
        internal Log(IDataReader reader)
        {
            int logGroupColumn = reader.GetOrdinal("LogGroup");
            int logLevelColumn = reader.GetOrdinal("LogLevel");
            int messageColumn = reader.GetOrdinal("Message");
            int stackTraceColumn = reader.GetOrdinal("StackTrace");
            int logDateTimeColumn = reader.GetOrdinal("LogDateTime");

            LogGroup = reader.GetGuid(logGroupColumn);
            LogLevel = (LogLevel)reader.GetInt32(logLevelColumn);
            Message = reader.GetString(messageColumn);
            StackTrace = reader.GetString(stackTraceColumn);
            LogDateTime = reader.GetDateTime(logDateTimeColumn);
        }

        public override object GetValue(IDataReader reader, int columnIndex, object[] values)
        {
            if (values != null)
            {
                if (values[columnIndex] == DBNull.Value)
                    return null;
            }
            else
            {
                if (reader.IsDBNull(columnIndex))
                    return null;
            }

            return reader.GetGuid(columnIndex);
        }

        private MembershipUser GetUserFromDataReader(IDataReader dataReader)
        {
            MembershipUser membershipUser = null;

            try
            {
                Guid providerUserKey = dataReader.GetGuid(1);
                string username = dataReader.GetString(3);
                string email = dataReader.GetString(5);
                string passwordQuestion = dataReader.GetValue(6) is DBNull ? null : dataReader.GetString(6);
                string comment = dataReader.GetValue(8) is DBNull ? null : dataReader.GetString(8);
                DateTime lastActivityDate = dataReader.GetDateTime(9);
                DateTime lastLoginDate = dataReader.GetDateTime(10);
                DateTime lastPasswordChangedDate = dataReader.GetDateTime(11);
                bool isApproved = dataReader.GetBoolean(16);
                bool isLockedOut = dataReader.GetBoolean(17);
                DateTime lastLockedOutDate = dataReader.GetDateTime(18);
                DateTime creationDate = dataReader.GetDateTime(19);

                membershipUser = new MembershipUser(Name, username, providerUserKey, email, passwordQuestion, comment,
                                                    isApproved, isLockedOut, creationDate, lastLoginDate,
                                                    lastActivityDate, lastPasswordChangedDate, lastLockedOutDate);
            }
            catch (Exception)
            {
            }

            return membershipUser;
        }

        public FileOrganizationResult GetResult(IDataReader reader)
        {
            var index = 0;

            var result = new FileOrganizationResult
            {
                Id = reader.GetGuid(0).ToString("N")
            };

            index++;
            if (!reader.IsDBNull(index))
            {
                result.OriginalPath = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                result.TargetPath = reader.GetString(index);
            }

            index++;
            result.FileSize = reader.GetInt64(index);

            index++;
            result.Date = reader.GetDateTime(index).ToUniversalTime();

            index++;
            result.Status = (FileSortingStatus)Enum.Parse(typeof(FileSortingStatus), reader.GetString(index), true);

            index++;
            result.Type = (FileOrganizerType)Enum.Parse(typeof(FileOrganizerType), reader.GetString(index), true);

            index++;
            if (!reader.IsDBNull(index))
            {
                result.StatusMessage = reader.GetString(index);
            }

            result.OriginalFileName = Path.GetFileName(result.OriginalPath);

            index++;
            if (!reader.IsDBNull(index))
            {
                result.ExtractedName = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                result.ExtractedYear = reader.GetInt32(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                result.ExtractedSeasonNumber = reader.GetInt32(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                result.ExtractedEpisodeNumber = reader.GetInt32(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                result.ExtractedEndingEpisodeNumber = reader.GetInt32(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                result.DuplicatePaths = reader.GetString(index).Split('|').Where(i => !string.IsNullOrEmpty(i)).ToList();
            }

            return result;
        }

        private static Message PopulateMail(IDataReader dataReader)
        {
            Message mail = new Message();
            mail.UID = dataReader.GetGuid(0);
            if (dataReader.IsDBNull(1))
                mail.System = null;
            else
                mail.System = dataReader.GetGuid(1);
            mail.From = dataReader.GetString(2);
            mail.To = dataReader.GetString(3);
            mail.CC = dataReader.IsDBNull(4) ? null : dataReader.GetString(4);
            mail.BCC = dataReader.IsDBNull(5) ? null : dataReader.GetString(5);
            mail.ReplyTo = dataReader.IsDBNull(6) ? null : dataReader.GetString(6);
            mail.Sender = dataReader.IsDBNull(7) ? null : dataReader.GetString(7);
            mail.Priority = (MailPriority)dataReader.GetInt32(8);
            mail.Subject = dataReader.GetString(9);
            mail.Body = dataReader.IsDBNull(10) ? null : dataReader.GetString(10);
            mail.CreateTime = dataReader.GetDateTime(11);
            mail.Status = dataReader.GetInt32(12);

            return mail;
        }

        private ActivityLogEntry GetEntry(IDataReader reader)
        {
            var index = 0;

            var info = new ActivityLogEntry
            {
                Id = reader.GetGuid(index).ToString("N")
            };

            index++;
            if (!reader.IsDBNull(index))
            {
                info.Name = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                info.Overview = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                info.ShortOverview = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                info.Type = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                info.ItemId = reader.GetString(index);
            }

            index++;
            if (!reader.IsDBNull(index))
            {
                info.UserId = reader.GetString(index);
            }

            index++;
            info.Date = reader.GetDateTime(index).ToUniversalTime();

            index++;
            if (!reader.IsDBNull(index))
            {
                info.Severity = (LogSeverity)Enum.Parse(typeof(LogSeverity), reader.GetString(index), true);
            }

            return info;
        }

        public static string GetGuidValue(
            IDataReader rs,
            string fieldName)
        {
            int col = rs.GetOrdinal(fieldName);

            return rs.IsDBNull(col) ? null : rs.GetGuid(col).ToString();
        }

        private AuthenticationInfo Get(IDataReader reader)
        {
            var info = new AuthenticationInfo
            {
                Id = reader.GetGuid(0).ToString("N"),
                AccessToken = reader.GetString(1)
            };

            if (!reader.IsDBNull(2))
            {
                info.DeviceId = reader.GetString(2);
            }

            if (!reader.IsDBNull(3))
            {
                info.AppName = reader.GetString(3);
            }

            if (!reader.IsDBNull(4))
            {
                info.AppVersion = reader.GetString(4);
            }

            if (!reader.IsDBNull(5))
            {
                info.DeviceName = reader.GetString(5);
            }

            if (!reader.IsDBNull(6))
            {
                info.UserId = reader.GetString(6);
            }

            info.IsActive = reader.GetBoolean(7);
            info.DateCreated = reader.GetDateTime(8).ToUniversalTime();

            if (!reader.IsDBNull(9))
            {
                info.DateRevoked = reader.GetDateTime(9).ToUniversalTime();
            }

            return info;
        }

        public Guid GetGuid(IDataReader reader, bool allowNulls, Guid missingColumnValue)
        {
            InitColumn(reader, true);

            if (Ordinal == ColumnNotFound)
            {
                return missingColumnValue;
            }

            if (allowNulls && reader.IsDBNull(Ordinal))
            {
                return Guid.Empty;
            }
            else
            {
                return reader.GetGuid(Ordinal);
            }
        }

        private SyncJobItem GetJobItem(IDataReader reader)
        {
            var info = new SyncJobItem
            {
                Id = reader.GetGuid(0).ToString("N"),
                ItemId = reader.GetString(1)
            };

            if (!reader.IsDBNull(2))
            {
                info.ItemName = reader.GetString(2);
            }

            if (!reader.IsDBNull(3))
            {
                info.MediaSourceId = reader.GetString(3);
            }

            info.JobId = reader.GetString(4);

            if (!reader.IsDBNull(5))
            {
                info.OutputPath = reader.GetString(5);
            }

            if (!reader.IsDBNull(6))
            {
                info.Status = (SyncJobItemStatus)Enum.Parse(typeof(SyncJobItemStatus), reader.GetString(6), true);
            }

            info.TargetId = reader.GetString(7);

            info.DateCreated = reader.GetDateTime(8);

            if (!reader.IsDBNull(9))
            {
                info.Progress = reader.GetDouble(9);
            }

            return info;
        }

        private SyncJob GetJob(IDataReader reader)
        {
            var info = new SyncJob
            {
                Id = reader.GetGuid(0).ToString("N"),
                TargetId = reader.GetString(1),
                Name = reader.GetString(2)
            };

            if (!reader.IsDBNull(3))
            {
                info.Quality = (SyncQuality)Enum.Parse(typeof(SyncQuality), reader.GetString(3), true);
            }

            if (!reader.IsDBNull(4))
            {
                info.Status = (SyncJobStatus)Enum.Parse(typeof(SyncJobStatus), reader.GetString(4), true);
            }

            if (!reader.IsDBNull(5))
            {
                info.Progress = reader.GetDouble(5);
            }

            if (!reader.IsDBNull(6))
            {
                info.UserId = reader.GetString(6);
            }

            if (!reader.IsDBNull(7))
            {
                info.RequestedItemIds = reader.GetString(7).Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList();
            }

            if (!reader.IsDBNull(8))
            {
                info.Category = (SyncCategory)Enum.Parse(typeof(SyncCategory), reader.GetString(8), true);
            }

            if (!reader.IsDBNull(9))
            {
                info.ParentId = reader.GetString(9);
            }

            if (!reader.IsDBNull(10))
            {
                info.UnwatchedOnly = reader.GetBoolean(10);
            }

            if (!reader.IsDBNull(11))
            {
                info.ItemLimit = reader.GetInt32(11);
            }

            info.SyncNewContent = reader.GetBoolean(12);

            info.DateCreated = reader.GetDateTime(13).ToUniversalTime();
            info.DateLastModified = reader.GetDateTime(14).ToUniversalTime();
            info.ItemCount = reader.GetInt32(15);

            return info;
        }

 /// <summary>
 /// Gets a column value by the index
 /// </summary>
 /// <param name="mapping"></param>
 /// <param name="dataReader"></param>
 /// <returns></returns>
 public override object GetValueByIndex(ResultProperty mapping, IDataReader dataReader)
 {
     if (dataReader.IsDBNull(mapping.ColumnIndex))
     {
         return DBNull.Value;
     }
     return new Guid?( dataReader.GetGuid(mapping.ColumnIndex) );
 }

 /// <summary> Capture the column value for the current row </summary>
 /// <param name="reader"></param>
 /// <param name="columnIndex"></param>
 /// <returns></returns>
 public static Guid? ReadGuid(IDataReader reader, int columnIndex)
 {
     return reader.IsDBNull(columnIndex) ? null : (Guid?)reader.GetGuid(columnIndex);
 }