C# DbDataReader.GetBoolean方法代码示例

        private BasicOutboundInvoice ReadOutboundInvoiceFromDataReader(DbDataReader reader)
        {
            int outboundInvoiceId = reader.GetInt32(0);
            string customerName = reader.GetString(1);
            string invoiceAddressPaper = reader.GetString(2);
            string invoiceAddressMail = reader.GetString(3);
            int currencyId = reader.GetInt32(4);
            // double amount = reader.GetDouble(5);
            int organizationId = reader.GetInt32(6);
            int budgetId = reader.GetInt32(7);
            DateTime createdDateTime = reader.GetDateTime(8);
            int createdByPersonId = reader.GetInt32(9);
            DateTime dueDate = reader.GetDateTime(10);
            int reminderCount = reader.GetInt32(11);
            string reference = reader.GetString(12);
            bool domestic = reader.GetBoolean(13);
            bool open = reader.GetBoolean(14);
            bool sent = reader.GetBoolean(15);
            string securityCode = reader.GetString(16);
            string theirReference = reader.GetString(17);

            return new BasicOutboundInvoice(outboundInvoiceId, customerName, invoiceAddressPaper, invoiceAddressMail,
                                            currencyId, organizationId, budgetId, createdDateTime,
                                            createdByPersonId, dueDate, reminderCount, reference, domestic, open, sent, securityCode, theirReference);
        }

 public static bool? GetBoolean(DbDataReader reader, int index)
 {
     if (reader.IsDBNull(index))
         return null;
     else
         return reader.GetBoolean(index);
 }

        public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
        {
            var persistenceId = reader.GetString(0);
            var sequenceNr = reader.GetInt64(1);
            var isDeleted = reader.GetBoolean(2);
            var payload = GetPayload(reader);

            return new Persistent(payload, sequenceNr, persistenceId, isDeleted, sender);
        }

        private static BasicOrganization ReadOrganizationFromDataReader (DbDataReader reader)
        {
            int organizationId = reader.GetInt32(0);
            int parentOrganizationId = reader.GetInt32(1);
            string name = reader.GetString(2);
            string nameInternational = reader.GetString(3);
            string nameShort = reader.GetString(4);
            string domain = reader.GetString(5);
            string mailPrefix = reader.GetString(6);
            int anchorGeographyId = reader.GetInt32(7);
            bool acceptsMembers = reader.GetBoolean(8);
            bool autoAssignNewMembers = reader.GetBoolean(9);
            int defaultCountryId = reader.GetInt32(10);

            return new BasicOrganization(organizationId, parentOrganizationId, name, nameInternational, nameShort,
                                         domain, mailPrefix, anchorGeographyId, acceptsMembers, autoAssignNewMembers,
                                         defaultCountryId);
        }

        private BasicOutboundMailRecipient ReadOutboundMailRecipientFromDataReader(DbDataReader reader)
        {
            int outboundMailRecipientId = reader.GetInt32(0);
            int outboundMailId = reader.GetInt32(1);
            int personId = reader.GetInt32(2);
            bool asOfficer = reader.GetBoolean(3);
            int personType = reader.GetInt32(4);

            return new BasicOutboundMailRecipient(outboundMailRecipientId, outboundMailId, personId, asOfficer, personType);
        }

        static private BasicChurnDataPoint ReadChurnDataPointFromDataReader (DbDataReader reader)
        {
            int personId = reader.GetInt32(0);
            int organizationId = reader.GetInt32(1);
            bool churn = reader.GetBoolean(2);
            DateTime decisionDateTime = reader.GetDateTime(3);
            DateTime expiryDateTime = reader.GetDateTime(4);

            return new BasicChurnDataPoint(churn ? ChurnDataType.Churn : ChurnDataType.Retention, decisionDateTime,
                                           expiryDateTime, personId, organizationId);
        }

        private BasicInternalPoll ReadInternalPollFromDataReader(DbDataReader reader)
        {
            int internalPollId = reader.GetInt32(0);
            int organizationId = reader.GetInt32(1);
            int geographyId = reader.GetInt32(2);
            string name = reader.GetString(3);
            bool runningOpen = reader.GetBoolean(4);
            bool votingOpen = reader.GetBoolean(5);
            int maxVoteLength = reader.GetInt32(6);
            int createdByPersonId = reader.GetInt32(7);
            DateTime runningOpens = reader.GetDateTime(8);
            DateTime runningCloses = reader.GetDateTime(9);
            DateTime votingOpens = reader.GetDateTime(10);
            DateTime votingCloses = reader.GetDateTime(11);
            int resultsTypeId = reader.GetInt32(12);

            InternalPollResultsType resultsType = (InternalPollResultsType) resultsTypeId;

            return new BasicInternalPoll(internalPollId, createdByPersonId, organizationId, geographyId, name, runningOpen, votingOpen, maxVoteLength, runningOpens, runningCloses, votingOpens, votingCloses, resultsType);
        }

        public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
        {
            var persistenceId = reader.GetString(PersistenceIdIndex);
            var sequenceNr = reader.GetInt64(SequenceNrIndex);
            var isDeleted = reader.GetBoolean(IsDeletedIndex);
            var manifest = reader.GetString(ManifestIndex);

            // timestamp is SQL-journal specific field, it's not a part of casual Persistent instance  
            var payload = GetPayload(reader, manifest);

            return new Persistent(payload, sequenceNr, persistenceId, manifest, isDeleted, sender);
        }

        private BasicInboundInvoice ReadInboundInvoiceFromDataReader(DbDataReader reader)
        {
            int inboundInvoiceId = reader.GetInt32(0);
            int organizationId = reader.GetInt32(1);
            DateTime createdDateTime = reader.GetDateTime(2);
            int createdByPersonId = reader.GetInt32(3);
            DateTime dueDate = reader.GetDateTime(4);
            Int64 amountCents = reader.GetInt64(5);
            int budgetId = reader.GetInt32(6);
            bool attested = reader.GetBoolean(7);
            bool open = reader.GetBoolean(8);
            string supplier = reader.GetString(9);
            string payToAccount = reader.GetString(10);
            string ocr = reader.GetString(11);
            string invoiceReference = reader.GetString(12);
            DateTime closedDateTime = reader.GetDateTime(13);
            int closedByPersonId = reader.GetInt32(14);

            return new BasicInboundInvoice(inboundInvoiceId, organizationId, createdDateTime, dueDate,
                                           amountCents, budgetId, supplier, payToAccount, ocr, invoiceReference,
                                           attested, open, closedDateTime, closedByPersonId);
        }

        private BasicPayrollAdjustment ReadPayrollAdjustmentFromDataReader(DbDataReader reader)
        {
            int payrollAdjustmentId = reader.GetInt32(0);
            int payrollAdjustmentTypeId = reader.GetInt32(1);
            int payrollItemId = reader.GetInt32(2);
            Int64 amountCents = reader.GetInt64(3);
            string description = reader.GetString(4);
            bool open = reader.GetBoolean(5);
            int salaryId = reader.GetInt32(6);

            return new BasicPayrollAdjustment(payrollAdjustmentId, payrollItemId,
                                              (PayrollAdjustmentType) payrollAdjustmentTypeId,
                                              amountCents, description, open, salaryId);
        }

        private BasicPWEvent ReadPWEventFromDataReader (DbDataReader reader)
        {
            int eventId = reader.GetInt32(0);
            EventType eventType = (EventType)Enum.Parse(typeof(EventType), reader.GetString(1));
            EventSource eventSource = (EventSource)Enum.Parse(typeof(EventSource), reader.GetString(2));
            int actingPersonId = reader.GetInt32(3);
            int affectedPersonId = reader.GetInt32(4);
            DateTime eventDateTime = reader.GetDateTime(5);
            DateTime processedDateTime = reader.GetDateTime(6);
            bool open = reader.GetBoolean(7);
            int organizationId = reader.GetInt32(8);
            int geographyId = reader.GetInt32(9);
            int parameterInt = reader.GetInt32(10);
            string parameterText = reader.GetString(11);

            return new BasicPWEvent(eventId, eventDateTime, open, processedDateTime, eventType, eventSource, actingPersonId,
                affectedPersonId, organizationId, geographyId, parameterInt, parameterText);
        }

        private BasicPayrollItem ReadPayrollItemFromDataReader(DbDataReader reader)
        {
            int payrollItemId = reader.GetInt32(0);
            int personId = reader.GetInt32(1);
            int organizationId = reader.GetInt32(2);
            int countryId = reader.GetInt32(3);
            DateTime employedDate = reader.GetDateTime(4);
            int reportsToPersonId = reader.GetInt32(5);
            Int64 baseSalaryCents = reader.GetInt64(6);
            int budgetId = reader.GetInt32(7);
            bool open = reader.GetBoolean(8);
            DateTime terminatedDate = reader.GetDateTime(9);
            int subtractiveTaxLevelId = reader.GetInt32(10);
            double additiveTaxLevel = reader.GetDouble(11);

            return new BasicPayrollItem(payrollItemId, personId, organizationId, countryId, employedDate,
                reportsToPersonId, baseSalaryCents, budgetId, open, terminatedDate, subtractiveTaxLevelId, additiveTaxLevel);

        }

		MembershipUser GetUserFromReader (DbDataReader reader)
		{
			return new MembershipUser (this.Name, /* XXX is this right?  */
						   reader.GetString (0), /* name */
						   reader.GetGuid (1), /* providerUserKey */
						   reader.IsDBNull (2) ? null : reader.GetString (2), /* email */
						   reader.IsDBNull (3) ? null : reader.GetString (3), /* passwordQuestion */
						   reader.IsDBNull (4) ? null : reader.GetString (4), /* comment */
						   reader.GetBoolean (5), /* isApproved */
						   reader.GetBoolean (6), /* isLockedOut */
						   reader.GetDateTime (7).ToLocalTime (), /* creationDate */
						   reader.GetDateTime (8).ToLocalTime (), /* lastLoginDate */
						   reader.GetDateTime (9).ToLocalTime (), /* lastActivityDate */
						   reader.GetDateTime (10).ToLocalTime (), /* lastPasswordChangedDate */
						   reader.GetDateTime (11).ToLocalTime () /* lastLockoutDate */);
		}

 protected override object ReadInternal(DbDataReader reader, int ordinal, SqlRandomTableColumn columnInfo, Type asType)
 {
     ValidateReadType(typeof(Boolean), asType);
     if (reader.IsDBNull(ordinal))
         return DBNull.Value;
     return reader.GetBoolean(ordinal);
 }

        private BasicFinancialAccount ReadFinancialAccountFromDataReader (DbDataReader reader)
        {
            int accountId = reader.GetInt32(0);
            string name = reader.GetString(1);
            int organizationId = reader.GetInt32(2);
            var accountType = (FinancialAccountType) reader.GetInt32(3);
            int parentFinancialAccountId = reader.GetInt32(4);
            int ownerPersonId = reader.GetInt32(5);
            bool open = reader.GetBoolean(6);
            int openedYear = reader.GetInt32(7);
            int closedYear = reader.GetInt32(8);
            bool expensable = reader.GetBoolean(9);
            bool administrative = reader.GetBoolean(10);

            return new BasicFinancialAccount(accountId, name, accountType, organizationId, parentFinancialAccountId, ownerPersonId, open, openedYear, closedYear, expensable, administrative);
        }