C# DbDataReader.GetInt64方法代码示例

 public WorkoutPlan(DbDataReader reader)
 {
     _id = reader.GetInt64(0);
     _title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1);
     _period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2);
     _creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3);
 }

        public SelectedSnapshot Map(DbDataReader reader)
        {
            var persistenceId = reader.GetString(0);
            var sequenceNr = reader.GetInt64(1);
            var timestamp = new DateTime(reader.GetInt64(2));

            var metadata = new SnapshotMetadata(persistenceId, sequenceNr, timestamp);
            var snapshot = GetSnapshot(reader);

            return new SelectedSnapshot(metadata, snapshot);
        }

        private BasicOutboundInvoiceItem ReadOutboundInvoiceItemFromDataReader (DbDataReader reader)
        {
            int outboundInvoiceItemId = reader.GetInt32(0);
            int outboundInvoiceId = reader.GetInt32(1);
            string description = reader.GetString(2);
            Int64 amountCents = reader.GetInt64(3);

            return new BasicOutboundInvoiceItem(outboundInvoiceItemId, outboundInvoiceId, description, amountCents);
        }

        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);
        }

        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 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 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);

        }

        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 void mapValues(DbDataReader reader, object record)
        {
            foreach (var accessor in this.accessors) {
                var index = reader.GetOrdinal(accessor.Name);

                if (reader.IsDBNull(index)) {
                    continue;
                }

                if (accessor.PropertyType == typeof(string)) {
                    accessor.Set(record, reader.GetString(index));
                } else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) {
                    accessor.Set(record, reader.GetInt32(index));
                } else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) {
                    accessor.Set(record, reader.GetInt64(index));
                } else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) {
                    accessor.Set(record, reader.GetDateTime(index));
                } else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) {
                    accessor.Set(record, reader.GetChar(index));
                }
            }
        }

 /// <summary>
 /// Конструктор класса WorkType
 /// </summary>
 public WorkType(DbDataReader reader)
 {
     this._id = reader.GetInt16(0);
     this._sportTypeId = reader.GetByte(1);
     this._userId = reader.GetInt64(2);
     this._count = reader.GetInt32(3);
     this._value = reader.GetString(4);
 }

        private void ProcessRecord(DbDataReader record, DbOperation dbOperation)
#endif
        {
            var id = record.GetInt64(0);
            ScaleoutMessage message = SqlPayload.FromBytes(record);

            _logger.LogVerbose(String.Format("{0}SqlReceiver last payload ID={1}, new payload ID={2}", _loggerPrefix, _lastPayloadId, id));

            if (id > _lastPayloadId + 1)
            {
                _logger.LogError(String.Format("{0}Missed message(s) from SQL Server. Expected payload ID {1} but got {2}.", _loggerPrefix, _lastPayloadId + 1, id));
            }
            else if (id <= _lastPayloadId)
            {
                _logger.LogInformation(String.Format("{0}Duplicate message(s) or payload ID reset from SQL Server. Last payload ID {1}, this payload ID {2}", _loggerPrefix, _lastPayloadId, id));
            }

            _lastPayloadId = id;

            // Update the Parameter with the new payload ID
            dbOperation.Parameters[0].Value = _lastPayloadId;

            _logger.LogVerbose(String.Format("{0}Updated receive reader initial payload ID parameter={1}", _loggerPrefix, _dbOperation.Parameters[0].Value));

            _logger.LogVerbose(String.Format("{0}Payload {1} containing {2} message(s) received", _loggerPrefix, id, message.Messages.Count));

            Received((ulong)id, message);
        }

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

 /// <summary>
 /// Конструктор класса Workout
 /// </summary>
 public Workout(DbDataReader reader)
 {
     this._id = reader.GetValue(0).ToString() == "" ? (long)0 : reader.GetInt64(0);
     this._date = reader.GetValue(1).ToString() == "" ? (long)0 : reader.GetInt64(1);
     this._timeBegin = reader.GetValue(2).ToString() == "" ? (long)0 : reader.GetInt64(2);
     this._timeEnd = reader.GetValue(3).ToString() == "" ? (long)0 : reader.GetInt64(3);
     this._warmUp = reader.GetValue(4).ToString() == "" ? (byte)0 : reader.GetByte(4);
     this._musclesGroupId = reader.GetValue(5).ToString() == "" ? (Int16)0 : reader.GetInt16(5);
     this._workoutPlanId = reader.GetValue(6).ToString() == "" ? (long)0 : reader.GetInt64(6);
     this._workoutTypeId = reader.GetValue(7).ToString() == "" ? (Int16)0 : reader.GetInt16(7);
     this._athleteId = reader.GetValue(8).ToString() == "" ? (long)0 : reader.GetInt64(8);
     this._createDate = reader.GetValue(9).ToString() == "" ? (long)0 : reader.GetInt64(9);
     this._workoutPlanTypeId = reader.GetValue(10).ToString() == "" ? (Int16)0 : reader.GetInt16(10);
 }

        private BasicFinancialTransactionRow ReadFinancialTransactionRowFromDataReader(DbDataReader reader)
        {
            int rowId = reader.GetInt32(0);
            int accountId = reader.GetInt32(1);
            int transactionId = reader.GetInt32(2);
            Int64 amountCents = reader.GetInt64(3);
            DateTime createdDateTime = reader.GetDateTime(4);
            int createdByPersonId = reader.GetInt32(5);

            return new BasicFinancialTransactionRow(rowId, accountId, transactionId, amountCents, createdDateTime, createdByPersonId);
        }

        private BasicFinancialAccountRow ReadFinancialAccountRowFromDataReader (DbDataReader reader)
        {
            int accountId = reader.GetInt32(0);
            int transactionId = reader.GetInt32(1);
            DateTime transactionDateTime = reader.GetDateTime(2);
            string comment = reader.GetString(3);
            Int64 amountCents = reader.GetInt64(4);
            DateTime rowDateTime = reader.GetDateTime(5);
            int rowCreatedByPersonId = reader.GetInt32(6);

            return new BasicFinancialAccountRow(accountId, transactionId, transactionDateTime, comment, amountCents, rowDateTime, rowCreatedByPersonId);
        }